I am running the session Archive Projects in one of my baan company. We have to archive total 3 companies. In two companies I have successfully ran archive projects session. While in the one company left, when ever I run this session it gives a fatal error stating "can't delete record as references exist on tisfc001, fatal error on db.next(delayed)". I have analyzed the data and the reference exists on only two tables i.e. ticst001 and ticst002 which are being handled by the "Archive Projects" session. The data from these table w.r.t. production order is deleted prior to tisfc001.

Can someone throw some light on the error being encountered as this is really delaying my project? :confused:

Regards
Davendra Bhatnagar

If you look in the log file pertaining to your database (for example, for oracle the name of the file is log.oracle8 in $BSE/log) just after the error occurs, you will find the specific reference that is causing the fatal error. From there, you can decide on how to fix the data.

Thanks Shah for your valuable comments. I had already checked log.bshell6.1 & log.oracle. log.oracle contains no entry for the said error. I could find the production order by placing the object in debug mode. There are many such production order that are causing the error 606 and references for those production orders exist only in ticst001 & ticst002 which are being taken care by the session "Archive Projects" only.