Question Re: Database returned the SQL code 602-. System error: BD Bad file when executing chain process in Technology Q&A

Database returned the SQL code 602-. System error: BD Bad file when executing chain process

Former Member — Tue, 07 May 2019 09:35:18 GMT

Hello,

I am new to SAP and to the forum. Now the point is that I would like to create a process chain which executes planning sequence and launch it from EPM Add On. For now, the process chain contains two elements:

1) Start (immidiate start)

2) Execute planning sequence (it contains the planning sequence that we would like to launch - process without packaging) (Att. 2)

It is valid and properly active. As a first step I would like to launch it from BW and I get an error: Database returned the SQL code 602-. Error text: P 602- POS(1) System error: BD Bad file

when searching for the solution I found https://wiki.scn.sap.com/wiki/display/MaxDB/System+errors+category+1 which suggest "Check if you can find the root page number in file knldiag or knldiag.err". Problem is that I searched the entire system on which the database is installed and I didn't found it.

Could You please help me solve that problem?

System we are using is SAP NetWeaver 7.4 SP11

Database system: MaxDB 7.9.08.23

Regards
Paweł

Re: Database returned the SQL code 602-. System error: BD Bad file when executing chain process

MichaelTe — Wed, 15 May 2019 12:19:30 GMT

Hello Pawel,

the name knldiag or knldiag.err is misleading. See this article:
https://wiki.scn.sap.com/wiki/display/MaxDB/HowTo+-+New+knldiag+Message+File+Format+in+SAP+MaxDB+7.7

So you could try this command to read the file KNLMSG:

protconv /sapdb/<sid>/data/wrk/<sid>/KnlMsg

or:

dbmcli -d <sid> -u <dbm>,<passwd> -nohold file_getfirst KNLMSG

and for the errors:

dbmcli -d <sid> -u <dbm>,<passwd> -nohold file_getfirst KNLMSGARC

Regards, Michael

Re: Database returned the SQL code 602-. System error: BD Bad file when executing chain process

Former Member — Thu, 16 May 2019 14:51:49 GMT

Hi Mike,

Thank You very much for Your answer. I was able to enter the file but in which I just have an information from the time of process chain execution:

"Thread 0x1A5 Task 35 2019-06-04 14:43:46 WNG Data 20033: Bad file for root 2832673
Thread 0x1A5 Task 35 2019-06-04 14:43:46 ERR SYSERROR 51080: -9028 BD Bad file"

Can You please provide any more help of how to solve this problem?

Looking forward hearing from You,
Paweł

Re: Database returned the SQL code 602-. System error: BD Bad file when executing chain process

MichaelTe — Fri, 17 May 2019 07:47:22 GMT

Hello Pawel,

please follow the steps in the following article to find out the object which is involved:
https://wiki.scn.sap.com/wiki/display/MaxDB/System+errors+category+1

There are also solutions for different problems with corrupt index and tables.

Please be sure to have a valid backup.

Regards, Michael