Baanboard.com

Go Back   Baanboard.com > Blogs > dgbb01's blog

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

 
A not terminated transaction is aborted (_overloaded.exit() in object ottstp_stddll
By dgbb01 at 28 Aug 2015 - 09:56

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

 

0
No votes yet

by pillai.ganesh on August 30, 2015 - 5:25am
pillai.ganesh's picture
Quote:
Originally Posted by dgbb01 View Post
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

by vahdani on August 30, 2015 - 2:25pm
vahdani's picture
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

Code:
        |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.

Code:
        |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()

by bhushanchanda on September 1, 2015 - 7:48am
bhushanchanda's picture
Hi,

Please post your questions in related forums.

Moved to correct forum - "Tools Development"

by dgbb01 on September 1, 2015 - 11:25am
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


All times are GMT +2. The time now is 15:53.


©2001-2017 - Baanboard.com - Baanforums.com