Skip to Content
avatar image
Former Member

Bad index errors in SAPDB 7.4.3

I am periodically seeing the following database errors:

2008-10-03 00:48:56 --- Starting GMT

2008-10-03 00:48:56 7.4.3 Build 032-123-068-842

2008-10-09 16:54:06 0x435C ERR 54111 MOVE HGG05.1:

1[1024]->1[1024] len:-19180

2008-10-09 16:54:06 0x435C ERR 53250 B*TREE BAD INDEX 121874

(ROOT)

2008-10-09 16:54:06 0x435C ERR 51080 SYSERROR -9041 BD Index not

accessible

2008-10-15 13:33:04 0x7C2C ERR 18431 MESSAGES Could not write to

event log, rc = 31

2008-10-15 13:36:14 --- Starting GMT

2008-10-15 13:36:14 7.4.3 Build 032-123-068-842

2008-10-15 13:50:33 0xF4 ERR 18431 MESSAGES Could not write to

event log, rc = 31

2008-10-15 13:53:13 --- Starting GMT

2008-10-15 13:53:13 7.4.3 Build 032-123-068-842

2008-10-15 22:44:06 0xA40 ERR 54111 MOVE HGG05.1:

1[1024]->1[1024] len:-13824

2008-10-15 22:44:06 0xA40 ERR 53250 B*TREE BAD INDEX 916325

(ROOT)

2008-10-15 22:44:06 0xA40 ERR 51080 SYSERROR -9041 BD Index not

accessible

Does anyone know what might cause this and how to avoid it?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 17, 2008 at 01:03 PM

    have a look Note 436664 - -602 system error: BD index not accessible

    cheers,

    -Sunil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 02:46 PM

    I don't have a login number to the SAP marketplace. Is there any way I can see the contents of this note?

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 12:42 PM

    This error occurs in the context of our software application which used the SAPDB 7.4.3 database. We have recently updated our software to use MAXDB 7.6, but we still have many customers using the older version. Can you tell me if this error is something that is fixed in MAXDB 7.6? Any information anyone can give me about this error will be appreciated. Thank you.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Dick,

      I did not find any known bug matching this error.

      The problem mentioned by Sunil should have been fixed with 7.4, so the note does not fit here.

      Anyhow, to fix the bad indexes just run

      sql_recreateindex
      

      In general: 7.4 is really, really OLD. Get your customers the upgrade!

      regards,

      Lars