dear all,

please help me.
I have error like this.
1. process 5-fatal error:error 606(reference does not exist) on tttxt001800 in commit_trans
2. process 5-fatal error:can not continue in tiitm0101m000 in DLL:ottstpstandard (get.company).

please help me.

thank you very much.

rgds,
Robby

Hi Robby,
Do mention what you were doing at the time you got this error message (were you saving, inserting etc). Apart from that, check in the Application Log of the Event Viewer. It might tell you more about this error like the tables involved and the fields.

sk

Hi sukesh75.

This problem show up when I'm insert text for Purchase Text.

Thanks

Dear sukesh75.
what should I do for fix this problem ?
If I know error involve tabels or fields.

thank you

Is this happening for all items or just one item? From your error message it shows missing reference in txt001 table which could mean that the txtp field in itm001 might be pointing to a text number that doesnt exist in txt001. The application log would help prove that theory. Try running Re-organize Tables on ti itm 001 table (and/or tt txt 001 table)..

sk

dear sukesh75.

this only happen for one time data (Purchase Type).
there are another solutions because as far I know re-organiza tables should run only one single user.
in my company transaction almost running 24 hours.

thanks

What does it show in the Application Log of Even Viewer?

Based on the above information you would have to run a query to see whats missing in txt001. Do you get this error if you are entering Item Text or Sales Text?

sk

dear sukesh,

this is information from application log.
---
Env BaaN (D:\Baan)
Prog msql7_srv file \db\lib\dbs\dbs_rowact.c # 3827
Keyword Reference
Username irma type N language 2
Process 0x1460
Lasterror 0
Errno 0
bdberrno 0
Message Reference in tttxt001800 does not exist, key `24959`


Env BaaN (D:\Baan)
Prog bshell file \logic\mir\mir\bdb_fun.c # 1127
Keyword DB error
Username irma type N language 2
Process 0x1240
Lasterror 0
Errno 0
bdberrno 520 (Error during buffered updates)
Message Error 606 (Reference does not exist) on tttxt001800 in commit_trans
---

what query that should I run ?
this error I have when I klik Text for Puchase Text ?

thank you very much

Hi,
Run a query on itm001 table to pick up the item code where the field txtp (since it only happens when you click on purchase text) is equal to 24959. The aim is to find if this code (24959) exists in the txtp field of the item master table which is missing in the txt001 table.

sk

dear sukesh75.

in table txt001 there is no data for tiitm001 for 24959.
so what should I do ?

thank you very much.

Robby,
That's quite evident from the error messages. What i had asked was to run a query on table itm001 and find out which itemcode has the value 24959 in the field txtp (Purchase Text). Once you find that item code, take off that value from the txtp field and replace it with 0.

sk

dear sukesh

are there any problem if I replace that value from 24959 become 0 ?

thanks

The ideal way would have been the reorganizing of table ti itm001. Since that's not possible, this would be the other way around. The only concern would be if this field txtb is considered in any of the 12 hash fields in itm001 table (which i am not sure of). But then you could put it (24959) back if any problem arises.

sk

dear sukesh75.

I'm try to make field txtp tobe 0 (zero) but it can't.
this error show up.
- fatal error : error 606 (reference does not exist) on tttxt001800 in db_update
- fatal error : can not continue in ttaad4100 (<85>)
- error : ttaad4100 : a not terminated transaction is aborted.

what happen ?

thanks

dear sukesh75.

I'm try to make field txtp tobe 0 (zero) but it can't.
this error show up.
- fatal error : error 606 (reference does not exist) on tttxt001800 in db_update
- fatal error : can not continue in ttaad4100 (<85>)
- error : ttaad4100 : a not terminated transaction is aborted.

what happen ?

thanks

Hello,

if you know the article which causes the problem, have a look at :

Field tiitm001.txta , tiitm001.txts and tiitm001.txtp
These three fields are refered to tttxt001.

Check the text number in the three tiitm001 fields and check if this textnumbers are existing in tttxt001.


Regards

Hi Robby,
I was away on my weekend so i couldn't reply earlier. Do what was suggested in the post above and make sure that the text number is not present in txt001 at all.

Furthermore, you could check if this text number is present in either txt002 or txt010.

sk