5 Replies Latest reply: Oct 29, 2009 3:22 PM by Sven Otromke RSS

MS Sql error in production server: DBIF_REPO_SQL_ERROR

Shankar PV
Currently Being Moderated

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

  • Re: MS Sql error in production server: DBIF_REPO_SQL_ERROR
    Sven Otromke
    Currently Being Moderated

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

     

    Sven

    • Re: MS Sql error in production server: DBIF_REPO_SQL_ERROR
      Shankar PV
      Currently Being Moderated

      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

Actions