Skip to Content
0
Former Member
Feb 14, 2011 at 07:10 AM

Job cancelled after system exception ERROR_MESSAGE in DB13

1799 Views

Hello All,

When i opened the t-code DB13 i saw that this job "Mark tables requiring statistics update" is cancelled.

JOB LOG:

12.02.2011 22:00:16 Job started

12.02.2011 22:00:16 Step 001 started (program RSDBAJOB, variant &0000000000085, user ID 80000415)

12.02.2011 22:00:18 Job finished

12.02.2011 22:00:18 Job started

12.02.2011 22:00:18 Step 001 started (program RSADAUP2, variant &0000000000081, user ID 80000415)

12.02.2011 22:01:26 Error when performing the action

12.02.2011 22:01:26 Job cancelled after system exception ERROR_MESSAGE

When check for the BGD Job in SM37 for this job i found the same error in the job log with the status cancelled.

Job log overview for job: DBA!PREPUPDSTAT_____@220000/6007 / 22001700

12.02.2011 22:00:18 Job started

12.02.2011 22:00:18 Step 001 started (program RSADAUP2, variant &0000000000081, user ID 80000415)

12.02.2011 22:01:26 Error when performing the action

12.02.2011 22:01:26 Job cancelled after system exception ERROR_MESSAGE

I couldn't find any logs in SM21 of that time also no dumps in ST22.

Possible reason for this error:

I have scheduled the job Check database structure (only tables) at some other time and deleted the earlier job which was scheduled during the bussiness hours which caused performance problem.

So to avoid performance issue i scheduled this job in the mid night by cancelling the old job which was scheduled during the bussiness hours.

And from the next day i could see this error in DB13.

Rest all the backups are running fine but the only job getting cancelled is for "Mark tables requiring statistics update"

Could anyone tell me what should i do to get rid of this error?

Can i schedule this "Mark tables requiring statistics update" again by deleting the old one?

Thanks.

Regards.

Mudassir Imtiaz