cancel
Showing results for 
Search instead for 
Did you mean: 

Bad index errors in SAPDB 7.4.3

Former Member
0 Kudos
82

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

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

cheers,

-Sunil

Former Member
0 Kudos

Thanks. Where can I find this note?

Former Member
0 Kudos

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

cheers,

-Sunil