topic Re: DELETE from database table not working in background in Application Development and Automation Discussions

DELETE from database table not working in background

former_member852447 — Tue, 07 Jun 2011 20:37:54 GMT

Hello experts,

Using syntax DELETE database table where..........commit work works fine in the foreground but will not work in the background. Tried inserting WAIT FOR.....did not help

Anybody had this issue before.

Any ideas appreciated.

Re: DELETE from database table not working in background

Former Member — Tue, 07 Jun 2011 21:04:41 GMT


> ...will not work in the background.

What exactly does "will not work" mean?

Rob

Re: DELETE from database table not working in background

former_member852447 — Tue, 07 Jun 2011 21:14:39 GMT

hello Rob,

'will not work' means it does the delete the content from the database table. When run in the foreground the deletion takes place...have checked the DELETE syntax over and over again and using COMMIT WORK and WAIT.

Re: DELETE from database table not working in background

Former Member — Tue, 07 Jun 2011 21:30:00 GMT

DELETE works in the background. The error lies elsewhere.

Rob

Re: DELETE from database table not working in background

andrs_sarcevic — Tue, 07 Jun 2011 22:47:27 GMT

Have you checked your "where" clause?

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 06:06:18 GMT

Hi,

Try with a single record in back ground which record is available in database table. If it is working fine then your where condition is problem.

Example:

delete mara where matnr = '10000011'.

commit work.

Ram.

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 06:10:30 GMT

Hi,

There is no restriction on Delete to not work in background.

Please check your where clause, or delete statement.Error lies somewhere else.

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 06:35:11 GMT

Hi,

Try debugging the completed job in SM37 using jdbg.

Go to SM37 and display the jobs. Select your job and enter 'JDBG' in command area. Keep on pressing F7 till you reach code in your program.

Then step by step analyse the program and check the conditions given to DELETE statement.

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 11:15:01 GMT

Hi David,

After the delete statement.

Use this:

Commit Work and WAIT.

The program will not go further until the commit has happened. This will ensure that the table entries get deleted.

Let me know if it worked.

Cheers,

Saurabh Mathuria

Re: DELETE from database table not working in background

Lukas_Weigelt — Wed, 08 Jun 2011 11:59:34 GMT

Hi,

I'm confused with your terms "foreground" and "background". Foreground means you execute a report and background, you run a job or?...

Might be an authority issue, whereas I've never seen one with DML-statements.

In my opinion: Run ST01, Run your background-whatever_it_is, check ST01 log for SQL or Authority errors.

regards, Lukas

Re: DELETE from database table not working in background

former_member212713 — Wed, 08 Jun 2011 12:16:36 GMT

Hi David;

Can you write your code with little up and down rows?

Maybe your code has small problem.

Best ragards.

Re: DELETE from database table not working in background

former_member852447 — Wed, 08 Jun 2011 16:14:31 GMT

Hello All,

I checked my code over and over again and there is only one way to do it. The existing code posts correctly in dialogue mode (from the screen). However when I executed it in the background the same issue.

I debugged the completed background job from SM37 using transaction JDBG (thank you Vinraaj) and F7 until my program appeared and debugged again. The code was correctly executing.

However when I hit F7 multiple times and the completed program executed again (without my debugging thru single step) from the output in SM37 , the output was correct. (my code executed correcly)

Has anybody encountered this issue before, could this be a SAP issue. It is not an authorization problem. I am in a developmet system and have SAP all.

Any suggestions would be helpful.

Re: DELETE from database table not working in background

former_member201275 — Wed, 08 Jun 2011 16:18:41 GMT

when you run in foreground it works because you have authorization. However, when you run in background it doesn't use your userid it will be a generic background id (refer your security team they will know). I would say it is this id that needs the authorization update.

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 19:35:56 GMT

Can you paste your code and is your program dialog screen - module pool ? How are you running it in background ?

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 19:50:04 GMT

An obvious question - what is sy-subrc after the delete in the background?

Rob

Re: DELETE from database table not working in background

former_member852447 — Wed, 08 Jun 2011 20:38:01 GMT

Hello Rob,

When I run the completed program in the background using JDBG sy-subrc = 0 after the delete. This indicates that the code is correct. If the code was incorrect it would not work running it from the screen, right.

I am awaiting an answer from the security person as to the authorisation for batch and background. There might be some restrictions on DELETE and COMMIT WORK and WAIT.

Thanks for the input

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 20:57:55 GMT

If sy-subrc = 0, then the delete was done. How do you know it wasn't?

Rob

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 21:19:40 GMT

hi, can you try SM13 to see if there's any error in DB update??

Re: DELETE from database table not working in background

Former Member — Wed, 08 Jun 2011 21:29:31 GMT

Also check if any other program or same program is creating entries after delete.

Re: DELETE from database table not working in background

andrs_sarcevic — Wed, 08 Jun 2011 23:34:03 GMT

I just had a requirement to create a simple FM containing only a DELETE statement. This FM executes as part of an event in background mode. Works beautifully! No commit work whatsoever...

A security problem with the user that runs background processes seems likely, as suggested above.

...And let us know what was the problem!