topic database comit in Application Development and Automation Discussions

database comit

Former Member — Tue, 08 Dec 2009 15:41:06 GMT

hi,

i am using a FM : L_TO_CONFIRM

Passing parameter : I_komim = 2

This confirms Transfer ordder and creates Goods issue

After this FM i am selecting values from VBFA. Here some times data base is not updated properly. Commit work problem.

some times it works fine. some times for couple of line items its failing and later on the table is updated.

Please let me know how to correct this

I have used :

Commit work and wait

Wait for 5 seconds .....but no use .....

pls let me know how to solve it ?

-Senthil

Re: database comit

Former Member — Tue, 08 Dec 2009 16:03:24 GMT

Hi,

there are two more parameters, I_UPDATE_TASK and I_COMMIT_WORK. Pass value 'X' to both of this. I should work.

Regards

Ram

Re: database comit

Former Member — Tue, 08 Dec 2009 16:08:20 GMT

Pass I_COMMIT_WORK parameter as X and do not use seperate Commit work in your code.This flag will do the required commit.

Re: database comit

Former Member — Tue, 08 Dec 2009 16:13:36 GMT

Hi Senthil.

you mean after you call the FM: L_TO_CONFIRM, you can reading the data from VBFA and are you trying to save this VBFA data somewhere else...

if this is your issue, use the VBFA read before calling the FM L_TO_CONFIRM, and commit everything once.

because, once the COMMIT WORK is used it closes all the LUW's, so no more updates will be done within the program. so do the COMMIT as the last thing in your program.

Hope this helps.

Srini.

Re: database comit

Former Member — Tue, 08 Dec 2009 16:52:21 GMT

I am already passing i_comit_work as X.

Then also - same problem

Senthil

Re: database comit

Former Member — Tue, 08 Dec 2009 17:00:53 GMT

do not use seperate Commit work in your code.This flag will do the required commit.

Remove your own commit work in your code