I am getting this error in my production server.
Environment : OS - Windows 2008, Database: MSsql 2005 sp2, ECC6.0
when the job SAP_COLLECTOR_FOR_PERFMONITOR executes the dump occurs with the following error.
DBIF_REPO_SQL_ERROR, SQL error 0 occurred when accessing program "CX_SY_OPEN_SQL_DB=============CP "
and also i am not able to open db13 with ends up with abap dump.
In the sql server log i found this error too.
Database ID 5, Page (1:4804273) is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.
Please help me on this.
I Backup and restore the production DB onto another server and tried the dbcc check commands
with all options REPAIR_FAST, REPAIR_REBUILD, REPAIR_ALLOW_DATA_LOSS. But no use of those. still getting the same error.
Msg 7985, Level 16, State 2, Line 1
System table pre-checks: Object ID 4. Could not read and latch page
(1:4804273) with latch type SH. Check statement terminated due to
Msg 5233, Level 16, State 98, Line 1
Table error: alloc unit ID 262144, page (1:4804273). The test (IS_OFF
(BUF_IOERR, pBUF->bstat)) failed. The values are 79824905 and -6.
CHECKDB found 0 allocation errors and 1 consistency errors not associated
with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'PRD'.
Since the server is up and end users are working for the past two days, I am not in a position to restore that consistent backup which is three days old.
Please guide me.
I raised the Message with SAP and they asked to do the H/W audit. My H/W vendor executed the diagnostic reports and given the report as "NO H/W ISSUE".
That we already get into know when i did the system refresh, (I Mean i moved the database to another machine there also i am getting those same error).
As per the DBCC checkdb log we found 1 consistency errors in database 'PRD', and we found that the table too 'DB6PMPROT'.
Since its the table for the the records of DB13, i can lose this table data. So I tried to delete the data from the table, tried to truncate the table
and also tried deleting using the commands
1. DELETE FROM [PRD].[prd].[DB6PMPROT]
2. TRUNCATE TABLE [PRD].[prd].[DB6PMPROT]
3. USE [PRD]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID
(N'[prd].[DB6PMPROT]') AND type in (N'U'))
DROP TABLE [prd].[DB6PMPROT]
4. DROP TABLE [PRD].[prd].[DB6PMPROT]
For all the above mentioned commands the result is below
Msg 829, Level 21, State 1, Line 3
Database ID 5, Page (1:4804273) is marked RestorePending, which may
indicate disk corruption. To recover from this state, perform a restore.
Since the data in this table is not necessary, we need to drop and
recreate the table.
If you have a non-corrupt backup you might want to try a [PAGE RESTORE|http://msdn.microsoft.com/en-us/library/ms175168%28SQL.90%29.aspx] on your production copy database. Other than that I would do what SAP tells you to do.