MS Sql error in production server: DBIF_REPO_SQL_ERROR

[Former Member]

Hi experts,

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.

Regards

Shankar PV

[Former Member]

Seems to be some sort of corruption on your db. Run DBCC Checkdb to get more information.

Sven

[Former Member]

Hi Seven,

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

unrepairable error.

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.

Regards

Shankar PV

[Former Member]

This is a serious problem! Open a call at SAP immedeately.

Sven

[Former Member]

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]

GO

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.

[Former Member]

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.

Sven