topic Re: COMMIT WORK AND WAIT does not work in Application Development and Automation Discussions

COMMIT WORK AND WAIT does not work

Former Member — Thu, 22 May 2008 03:14:03 GMT

Hi Guys,

I have this code below... but it seems that the commit work and wait in bapi_transaction_commit FM does not work... because sometimes the db updates sometimes not... though no error is generated...

note that during debug mode,,, everythings fine, update to database is complete... the inconsistency only occurs during the normal run of program...

Thanks a lot!

CALL FUNCTION 'BAPI_PROCORD_COMPLETE_TECH'

IMPORTING

return = i_messages

TABLES

orders = i_orders.

IF i_messages-type NE c_error.

REFRESH i_messages3.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

wait = 'X'

IMPORTING

return = i_messages3.

ENDIF.

Re: COMMIT WORK AND WAIT does not work

Former Member — Thu, 22 May 2008 03:15:50 GMT

Hi Mark,

Try with COMMIT WORK AND WAIT 10 SECONDS

or try to increase the seconds if it still doesn't work.

Regards,

Atish

Re: COMMIT WORK AND WAIT does not work

Former Member — Thu, 22 May 2008 03:19:35 GMT

Reward points..

Re: COMMIT WORK AND WAIT does not work

Former Member — Thu, 22 May 2008 03:19:39 GMT

Hi Atish,

Thanks a lot!

I've implemented a wait up to 60 seconds and it works fine but the problem now is that the performance of the program... it runs very slow...

Is there an alternative way to synchronously update the Db without the wait up to 60 seconds addition?

Thanks a lot for all the help... its highly appreciated...

Rgds,

Mark

Re: COMMIT WORK AND WAIT does not work

Former Member — Thu, 22 May 2008 03:23:11 GMT

Hi Mark,

Don't put time like 60 seconds.

5- 10 seconds is sufficient time for DB to store it. Don't think there is any other way to do this.

Regards,

Atish

Re: COMMIT WORK AND WAIT does not work

Former Member — Thu, 22 May 2008 03:26:05 GMT

HI Atish,,

Really appreciate your quick response...

But i've put 30 seconds and the problem still persist so i tried 60 and it works fine...

my problem now is how to explain the slowness of the performance of the program sicne there is no other option but to use the wait up to...

Thanks a lot!

Re: COMMIT WORK AND WAIT does not work

Former Member — Thu, 22 May 2008 03:29:01 GMT

Hi Mark,

Is it a online program or the batch program. If it is still not working with 30 seconds then you have to increase the time and mention that cleary to the end users about the performance.

Regards,

Atish

Re: COMMIT WORK AND WAIT does not work

Former Member — Thu, 22 May 2008 03:35:35 GMT

Hi Atish...

Thanks so much...

It is an online program... So I guess,,, I really need to make it clear to the end users...

Thanks a lot!