Bad index errors in SAPDB 7.4.3

[Former Member]

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?

[Former Member]

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.

[lbreddemann]

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

[Former Member]

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

Thanks.

[Former Member]

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

cheers,

-Sunil

[Former Member]

Thanks. Where can I find this note?

[Former Member]

login to SAP marketplace using service.sap.com/notes and login with your S number.

cheers,

-Sunil