A new blog entry has been added:

A not terminated transaction is aborted (_overloaded.exit() in object ottstp_stddll

I have a LN session , which creates a summary trasnsaction record  for every sales and field service order and position. The process tracks  the changes in order values, and writes a record to a customised table.
 Occasionly, i get one of two errors:

1 A not terminated transaction is aborted (_overloaded.exit() in object ottstp_stddll
2 Transaction is already on

Has anyone any ideas how to overcome the errors

A new blog entry has been added:

A not terminated transaction is aborted (_overloaded.exit() in object ottstp_stddll

How many inserts are you committing together? If you have a single commit in the end for all your SO+Service Lines then I would suggest you to keep committing intermediately say after every interval of 50 records.
To handle the retry.point() You can use "WITH RETRY" option of the Order by clause.
--> ORDER BY clause <order by list> [ WITH RETRY [REPEAT LAST ROW] ]

Hope this helps :)

The first error is caused if the program starts a transaction, does some update or inserts but does not commit or abort and just finishes


|Start first transaction
db.retry.point()
do.something()
stop()


the secound error is caused, if you call db.retry.point() a secound time without committing or aborting the first call/transaction.


|Start first transaction
db.retry.point()
do.something()
if did.ok then
commit.transaction()
endif
|now start a secound transaction
| this will cause error if did.ok above was false and
| therefore first transaction is still on!
db.retry.point()
do.something.else()
commit.transaction()

Hi,

Please post your questions in related forums.

Moved to correct forum - "Tools Development"

There will be many records read. The number of records inserted for each transaction, will be a maximum of 3 records. I am now looking at the WITH RETRY [REPEAT LAST ROW] .

Thank you for advice