When trying to change record in tiitm001 using GTM(ttaad4100) , when I do Control Z to save, it gives me error 606 - fatal error as follows :
Fatal error : Error 606 (Reference does not exist on tiitm001 in db_update
Cannot continue in ttaad4100

What is the problem ? How to get rid of this error ?
Is there any document available on BaanIVc4 errors?

Thanks
skamat

This means that there is a bad reference between this table and another table : you can find the key and the referenced table in the log file (log.oraclex if you use oracle). Then you can improve the data.

Eventually you can have this error if the reference counters are not correct, this is another possibility. There is a session in tools, DB management, to correct this (Reorganize table, check field repair reference counter).

Hi skamat,

This message is due to Referential integrity (foreign key constraint) mismatch between this table and another table. pls check ur event viewer. it will explain u more.

It is SQL 7 Server DB. Let me check if I can solve it.

Thanks
skamat

hi ,

Along with the above proposed solutions u can also try this one :-

In the table defination of tiitm001 u can find the reference's for all fields.
Just check yr data that u trying to update thru GTM, if it is present in the Master (reference table) mentioned for the fields having reference.

Can you be more specific on what change (in which field) did you actually make in the table. Then you can check in table def what table is being referenced. Possibly there is no match in the refered table for the value entered

You can find further info in Document QG1201 Solution # 1497

Hi Ratnakar,

Sorry for troubling you again and thanks for your support.
I searched for QG1201 in baanboard.com and on support.baan.com but did not find that document on both sites.
Where can i get it ?

Regards
skamat

Dear skamat

Please check yr mailbox

Regards
Ratnakar

Hi Ratnakar,

Sorry for troubling you again and thanks for your support.
I searched for QG1201 in baanboard.com and on support.baan.com but did not find that document on both sites.
Where can i get it ?

Regards
skamat

Hi,
enclosed you'll find the dicument.

Regards

Hi,
enclosed you'll find the dicument.

Regards
bdittmar :
Thank you for your document.It's just a light in the dark.

Hi,
First try to re-organize tiitm001 table keeping the repair reference counter as YES. Pl do this when no one is working and using this table.

Vishal