topic Re: Data is not created in Application Development and Automation Discussions

Data is not created

Former Member — Mon, 05 Dec 2011 16:47:57 GMT

Hello,

I created a program that creates dispute cases from text file. But only first record is saved successfully in the system (in table). When I create a breakpoint in any place in the program and then press f8 all the rest records are saved as well.

Do you know the reason? Can you provide me with a solution please?

Regards,

Alex

Re: Data is not created

Former Member — Mon, 05 Dec 2011 19:43:57 GMT

I think u r using call transaction, if so then change the update mode to synchronous.

Re: Data is not created

Former Member — Mon, 05 Dec 2011 20:44:00 GMT

It will be extremely hard for anyone to help based on this ambiguous post. If, however, you post the code that does the database update, or the BDC session, if that's what you're using, we might be able to point out the error(s).

Re: Data is not created

Former Member — Tue, 06 Dec 2011 12:27:57 GMT

I use a report with the following logic for creating dispute case

loop
  queue locks
  create case
  update db
  dequeue locks
  commit work
endloop

and after the 1st loop run (on the second) queue entry is still locked. But when I use a breakpoint it's getting released, because of time delay during program stop on breakpoint.

So I have to make dequeue lock entry in time when program runs.

Regards,

Alex.

Edited by: Aliaksei Klimovich on Dec 6, 2011 3:28 PM

Re: Data is not created

Former Member — Tue, 06 Dec 2011 12:36:52 GMT

Hi,

Could you try with this small difference:

loop

queue locks

create case

update db

commit work and wait

dequeue locks

endloop

Also, use the parameter _WAIT of your enqueue function...

Kr,

Manu.

Edited by: Manu D'Haeyer on Dec 6, 2011 1:44 PM

Re: Data is not created

Former Member — Thu, 08 Dec 2011 19:25:50 GMT

Intead of updating one row at a time you can update the entiere records in a single go

Re: Data is not created

Former Member — Thu, 08 Dec 2011 22:10:25 GMT

hi,

Commit should be put before deque and wait for some time.

When you put a break point, the time spent for updating is actually more than that if execute directly.

Therefore more time is needed for the DB updation to complete and also depends on whether it's synchronous or not.

Regards

Vindy