topic Re: Background job in Application Development and Automation Discussions

Background job

Former Member — Wed, 27 Aug 2008 10:33:08 GMT

Hi experts,

I have a un usual problem.

i have a program Z_XYZ ... it updates entries in a DB table.

If i run the program directly .. it works and the fields are populated.....

But if i schedule the program as a background job All the step in the job are successful.

Problem--> but the DB table is not updated with the entries ..

can any one suggest what can be the problem.?

Thanks in advance

Re: Background job

Former Member — Wed, 27 Aug 2008 10:36:23 GMT

Hi,

I think database commit is not happening in that case.

you write commit work in the program and then try.

Regards

Sandipan

Re: Background job

Former Member — Wed, 27 Aug 2008 10:37:59 GMT

I have Database commit in my program already....

Re: Background job

Former Member — Wed, 27 Aug 2008 10:42:45 GMT

Are you population any file to internal table than you are updating from that iternal table?

if yes than file must be on application server in case of background

Re: Background job

Former Member — Wed, 27 Aug 2008 10:46:46 GMT

no there is no file.... it is a simple update statement..... i tried debugging the background job by using JDBG.... there are no errors and the fields are populated in the Database.....but they are not getting reflected in the database table... it is very starnge......

this problem dose not occure if i directly run the program.....in foreground

Re: Background job

Former Member — Wed, 27 Aug 2008 10:49:55 GMT

i tried debugging the background job by using JDBG

Are you doing exit from debugging? pls try once without debugging and let program execute in whole manner.

Re: Background job

Former Member — Wed, 27 Aug 2008 10:50:47 GMT

can u paste your code here?

Re: Background job

Former Member — Wed, 27 Aug 2008 10:55:42 GMT

no first i executed teh program first without debugging... and then tried to debugg to find the problem....

unfortunately i am not able to ....

here is the lines of code..

loop at gt_xyz.

Update zeabl set pid = gt_xyz-pid

where ABC = gt_xyz-abc and pqr = gt_xyz-pqr and ZW = gt_xyz-zw .

endloop.

commit work.

Re: Background job

Former Member — Wed, 27 Aug 2008 10:57:02 GMT

loop at gt_xyz.
Update zeabl set pid = gt_xyz-pid
where ABC = gt_xyz-abc and pqr = gt_xyz-pqr and ZW = gt_xyz-zw .
commit work."<---see here
endloop.

Edited by: Amit Gujargoud on Aug 27, 2008 12:57 PM

Re: Background job

Former Member — Wed, 27 Aug 2008 11:00:29 GMT

hi amit

i tried the comit work placing u suggested ... but the problem still persists....

Re: Background job

Former Member — Wed, 27 Aug 2008 11:04:11 GMT

it is working perfectly for me....even without a commit work....in both foreground and background mode

here is the code i wrote - no commits...no issues.

loop at itab.

update zuser set STCOD = 'ABCD' where bname = itab-bname.

endloop.

Edited by: Priyank Jain on Aug 27, 2008 7:07 AM

Re: Background job

Former Member — Wed, 27 Aug 2008 11:08:50 GMT

I know it is really a strange problem i m encountering.... since it a very simple update statment and should not cause any problem... in forground it works perfectly fine..... even when i debug it in back ground mode every thing works out well....even the update statment is executed ... and the fields are populated.......

but when i run it in background and without debug mode .... nothing is populated...

Re: Background job

Former Member — Wed, 27 Aug 2008 11:43:34 GMT

solved the problem .....

Re: Background job

Former Member — Wed, 27 Aug 2008 11:49:41 GMT

solved the problem .....

Can you please tell us what we were missing?so that we will be take care in future with same problem.

Amit.

Re: Background job

Former Member — Thu, 11 Sep 2008 10:31:38 GMT

hi ,

I am facing the same problem. Please tell me how to solve ythis.

regs

madhu