Database failed check database & reload - AC450 PC table backup reload failed.
Hi all,
today i have done some exercise in my system for reducing ac450 controller load, resulting i am unable to load my PC table backup to controlller its failed but DB table backup loaded without any error.
before that I have deleted some DAT's (Real and Bool) which was used in datasets and not used AIC, DIC's on online builder. After that i took DB & PC table backup and I tried to reload table backups ,DB backup was loaded without any errors , after that while loading PC table backup i am getting errors related to database finally it has failed. LOAD FAILED. CHECK DATABASE AND RELOAD appeared.. error screen shots is attached.
I am unable to find the that errors in DB table backup.. i dont know how to find & resolve , morever i dont have latest application dump too.. can somebody suggest how to get over this on this problem.. table backups is attached..
please suggest..
today i have done some exercise in my system for reducing ac450 controller load, resulting i am unable to load my PC table backup to controlller its failed but DB table backup loaded without any error.
before that I have deleted some DAT's (Real and Bool) which was used in datasets and not used AIC, DIC's on online builder. After that i took DB & PC table backup and I tried to reload table backups ,DB backup was loaded without any errors , after that while loading PC table backup i am getting errors related to database finally it has failed. LOAD FAILED. CHECK DATABASE AND RELOAD appeared.. error screen shots is attached.
I am unable to find the that errors in DB table backup.. i dont know how to find & resolve , morever i dont have latest application dump too.. can somebody suggest how to get over this on this problem.. table backups is attached..
please suggest..
Asked 3 months ago
Voted best answer
3
Database Identity 110 is Logical file 110 which contains DAT elements. Approximately 20 items are missing from this table.
It seems that when you deleted the DAT Elements - You did not search for and remove Connections from the PC Program to those Database elements. The PC Programs were left with broken connections to empty space in the DB Files.
The safe way to correct this is to Restore from a DUAP and start again.
The unsafe way to correct this MAY be to create the missing data elements again after loading the DB but before loading the PC. The missing records start at LF110, LR 38 which is DAT38. There is no way to know the variant of the missing DAT except by checking code listings. I make no promises that this will actually work.
Lesson...... Don't Delete DB elements unless you are 100% sure that they are not used. In any case, deleting DAT elements will not save you any significant CPU load at all.
Second Lesson ... You started major work like this without a backup or recovery plan. There are no words.
It seems that when you deleted the DAT Elements - You did not search for and remove Connections from the PC Program to those Database elements. The PC Programs were left with broken connections to empty space in the DB Files.
The safe way to correct this is to Restore from a DUAP and start again.
The unsafe way to correct this MAY be to create the missing data elements again after loading the DB but before loading the PC. The missing records start at LF110, LR 38 which is DAT38. There is no way to know the variant of the missing DAT except by checking code listings. I make no promises that this will actually work.
Lesson...... Don't Delete DB elements unless you are 100% sure that they are not used. In any case, deleting DAT elements will not save you any significant CPU load at all.
Second Lesson ... You started major work like this without a backup or recovery plan. There are no words.
Answered 3 months ago
Answers
3
Hi
this is a really awkward situation.
From your screenshots LOTPT command complains that it cannot connect PC element to non existing DAT(R)-s.
I guess you should have firstly disconnect DATs from PC elements and then delete Dats from database.
It may happen sometimes that PC terminal keeps connection to the deleted DB element.
Just in theory, before LOTPT you may try to insert deleted DATs manually or do partial TRDBS with BA file containing just deleted DATs.
Dats should be inserted to the exactly same original positions within record 110 .
Then try to LOTPT again.
I keep fingers crossed.
Note: Do always DUAP before CPU reconfig , just to have plan B in case.
Don't use compress database. I also could not load LOTPT after compressing during LOTDB.
this is a really awkward situation.
From your screenshots LOTPT command complains that it cannot connect PC element to non existing DAT(R)-s.
I guess you should have firstly disconnect DATs from PC elements and then delete Dats from database.
It may happen sometimes that PC terminal keeps connection to the deleted DB element.
Just in theory, before LOTPT you may try to insert deleted DATs manually or do partial TRDBS with BA file containing just deleted DATs.
Dats should be inserted to the exactly same original positions within record 110 .
Then try to LOTPT again.
I keep fingers crossed.
Note: Do always DUAP before CPU reconfig , just to have plan B in case.
Don't use compress database. I also could not load LOTPT after compressing during LOTDB.
Answered 3 months ago
Add new comment