Hi All,

We restore the Baan from tapes in fail over server.

But while update the User profile we got error "Error 850 (E_BDB_FATAL_START) on ttaad400000 (Max retries (10) exceeded)"

While looking this table (ttaad400) though GTM,
I did not see any records in the table "ttaad400"( it is showing blank ), but if I press '0' (General table info) it is showing number of rows = 18.

I check through DB2 level, records are there. Why I can't see these records through Baan?

Log file and screen shot of GTM attached.

Please help.

Mraguthu

Best thing is to take a backup of the table through bdbpre , delete the table ,create it again using bdbpost

I ran into something similar situation...

14. After the installation we came upon 2 major errors. Both of these are solved by bdbpre of the data and dropping the database and re-executing db2_install6.2 and then posting the data back in.
• This session can only be started from another session
To get around this error we tested the following and determined it was DB2.
1. In GTM check table ttadv999, and go to the last record (b for bottom) and if blank then you have a problem.
2. Did the following SQL within DB2. You should use DBLOG to determine if this is a valid SQL to test.
SELECT a.t_desc,a.t_keyr,a.t_pacc FROM baan5c.tttadv999000 a WHERE a.t_pacc = 'b50cprd1' AND (a.t_keyr >= 'progttaad2500m000 00')AND (a.t_keyr <= 'progttaad2500m000 ~~') ORDER BY 3,2 OPTIMIZE FOR 2 ROWS

• 510 Database not on after starting 5 sessions ,or 10 processes on a single bshell. By starting up any 5 session any sessions or the same one, you will get this message.

Thanks for your advises.

we are able to solve this issue by above advises.