topic Re: Cannot rollback after performing command CALL TRANSACTION in Application Development and Automation Discussions

Cannot rollback after performing command CALL TRANSACTION

Former Member — Tue, 08 Oct 2013 10:31:37 GMT

Dear Everyone,

I'm facing issue relate to rollback after performing command CALL TRANSACTION, Please suggest a solution or work around

Scenario: Create a program as below:

1. Update database table Zxxxxx

2. CALL TRANSACTION 'Zxxxxx'

USING BDC_TAB

xxxx.

3. Write log of call transaction

Issue:

Scenario 1: Execute report, When cursor jump to step 3(step 1 has executed successfully, step 2 occurs error).

Scenario 2: Sever SAP shut down while report is excuting at step 3.

In 2 scenario above, I cannot rollback database table at step 1.

Please advice how to rollback database table at step 1 after step 2(CALL TRANSACTION) was executed.

Thank you very much!!!

Best regards,

DucTV

Re: Cannot rollback after performing command CALL TRANSACTION

Former Member — Tue, 08 Oct 2013 12:43:32 GMT

Hello Tran,

"CALL TRANSACTION" will leave your actual program and call a transaction independent of your running program.

So you cant make a ROLLBACK WORK after returning to your program because it is allready commited.

Regards Nico

Re: Cannot rollback after performing command CALL TRANSACTION

RaymondGiuseppi — Tue, 08 Oct 2013 13:19:29 GMT

No luck, even if CALL TRANSACTION will be executed in another luw, using it you have triggered a (an implicit) database commit, and your table is already updated in database.

You could use a Z-BAPI that has same behaviour than your Z-transaction as long as no implicit database commit are triggered.

Regards,

Raymond