I have the error message "Transaction rolled back, try again" when i go to add a record in a table.

I try to delete he table and create again. The error continues.
I try to use reorganize tables (ttaad4225) with "Data and indices", but the error continues.

What can I do to solve it?

Did you check baan log files for it ? what messages did you get ? especially look at DB log files. it is not clear enough. Please tell more ..

GOOD LUCK !

Only change LOG.BSHELL6.2 and I have this message:

2005-12-29[12:48:47(UTC-01:00)]:E:monica: ******* S T A R T of Error message *******
2005-12-29[12:48:47(UTC-01:00)]:E:monica: Log message called from /tmp/REL7.1D.08/mul_fun.c: #462 keyword: Process state:
2005-12-29[12:48:47(UTC-01:00)]:E:monica: Pid 3274 Uid 474 Euid 474 Gid 106 Egid 106 Pset monica@ALFA730.ALFA730:3274
2005-12-29[12:48:47(UTC-01:00)]:E:monica: user_type S language 5 user_name monica tty õ  locale ISO88591/NULL
2005-12-29[12:48:47(UTC-01:00)]:E:monica: Errno 0 bdb_errno 850 (E_BDB_FATAL_START)
2005-12-29[12:48:47(UTC-01:00)]:E:monica: FATAL ERROR: Transaction rolled back, please try again. (cagld062700)
2005-12-29[12:48:47(UTC-01:00)]:E:monica: Can not continue in ttaad4100 (<135>)
2005-12-29[12:48:47(UTC-01:00)]:E:monica:
2005-12-29[12:48:47(UTC-01:00)]:E:monica: ******* E N D of Error message *******

it looks like strange problem. You got DB-850 error. EABORTONLOCK (Automatic rollbak on deadlock. There may be corruption on your table's index and relations. I check out the error on the board. I saw so many suggestion about it
one of them: http://www.baanboard.com/baanboard/showthread.php?t=23634&highlight=error+850
Search for "error 850". Now I have no idea about it !

Good luck !

I have the error message "Transaction rolled back, try again" when i go to add a record in a table.

I try to delete he table and create again. The error continues.
I try to use reorganize tables (ttaad4225) with "Data and indices", but the error continues.

What can I do to solve it?

Hi Monica,

Did your problem solve ? why because we are facing same problem with error 850. please help me.

850 EABORT - Transaction aborted
Description:
This error indicates that the current transaction is aborted due to a lock error.
Solution:
XXXXXXXXXXXXXXX

Refer to the threads - Something's not right!! (http://www.baanboard.com/baanboard/showthread.php?t=37277&highlight=lock)

RE: Error code 107 (http://www.baanboard.com/baanboard/showthread.php?t=23839&highlight=lock)