Data is not created

[Former Member]

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

[Former Member]

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

[Former Member]

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).

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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