topic Re: Insert / commit in Application Development and Automation Discussions

Insert / commit

Former Member — Tue, 15 Jul 2014 08:28:41 GMT

Hello all,

I have written a Z-Programm that generates CO-PA line items and I have written a function module that inserts the document numbers of the generated line items into a Z table.

At the end of the function module i have the coding in file attached.

When I run my Programm I generate like 100 documents, but some documents don't get inserted into my z-table.

How can this be ?

Kind regards,

Max

Re: Insert / commit

former_member201275 — Tue, 15 Jul 2014 08:32:18 GMT

Doesn't help when you don't post your complete code, i can only see snip of this i.e. commit work section?

Re: Insert / commit

FredericGirod — Tue, 15 Jul 2014 08:32:54 GMT

Hi,

why didn't use COMMIT WORK AND WAIT ?

regards

Fred

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 08:42:41 GMT

Hi guys,

sorry but I am not allowed to post coding from a customer System.

What does commit work and wait do ?

Thanks !

Max

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 08:45:33 GMT

Hi,

Check the Primary key combination in your Z-table.

Also use commit work and wait.

Regards

Sajid

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 08:47:16 GMT

Hi,

Commit work and wait, will wait until everything is updated to the Database(in one sentence).

For more info.

ABAP Keyword Documentation

Regards

Sajid

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 08:55:54 GMT

Hi Max

your posted code is little strange:

why do you insert the COMMIT in a do cycle?

I don't know if the COMMIT and WAIT can halp you, because (I suppose) you don't have any saving proccess running in update task,

So only the COMMIT should be enough.

I don't believe the problema is here, probably yuo have a problem with duplicated key, but I can't be sure without to see how you save the data.

Max

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 08:56:04 GMT

Well, the insert generally works, but some doc numbers are not inserted. So Primary key can not be an issue.

Commit work and wait didnt' solve the issue.

I generated 22 documents but only 20 document numbers got inserted into my z table.

Thanks for all of your replies !

Re: Insert / commit

FredericGirod — Tue, 15 Jul 2014 08:59:22 GMT

Are you sure the 22 documents have differents primary keys ?

Fred

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 09:04:16 GMT

If have read in documentation that if commit work Fails the sy-subrc is 4.

So I made this Loop in order to be sure commit has been performed before leaving the function module.

You are right, I am not running any processes in update task.

Also duplicate keys are no issue as the document numbers generated by CO-PA are distinct

Regards,

Max

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 09:06:26 GMT

Yes, document numbers 3071 - 3092.

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 09:12:32 GMT

the COMMIT is not your problem

You need to post how you save the data in your Z-TABLE: it's not easy to help you without to know it

Max

Re: Insert / commit

Former Member — Tue, 15 Jul 2014 09:21:41 GMT

This may sound ridicolous, but I fail to copy & paste my coding into this Formular. When I try to do so, nothing happens 😞

Regards

Max

Re: Insert / commit

former_member201275 — Tue, 15 Jul 2014 09:22:33 GMT

You are not allowed to post coding from, but you did post the commit work section? Would help if you could at least post the relevant sections then, otherwise we can spend days guessing what is the problem.