process chain removed from scheduling

[MartinMaruskin]

Hi all,

I'm facing a problem with process chain. Chain is scheduled in the system and at the point of time that it should be running but under some circumstances chain is not to be executed. Log of process chain says:

RSPC 19 Version 'A ' of chain CHAIN1 was saved without checking

RSPC 19 Version 'A' of chain CHAIN2 was saved without checking

RSPC 26 The Chain Was Removed From Scheduling

TA SM21 says:

02:00:38 BTC 040 100 ALEREMOTE EFW > No job count can be generated for job BI_PROCESS_LOADING

02:00:38 BTC 040 100 ALEREMOTE EG7 BP_JOB_CREATE: Job cannot be generated. Reason:

02:00:38 BTC 040 100 ALEREMOTE EGA > Job BI_PROCESS_LOADING contains invalid data

In more details SM21 says:

During the values check for background processing, the attempt to generate a unique JOBCOUNT for the specified job failed because there are more than 99 entries with the same JOBNAME / JOBCOUNT ID.

It is not possible to investigate from TA SLG1 neither from bach jobs logs and CCMS monitoring. Everything looks fine.

Problems occurs an accidentally, the uploads are running daily and on some days it is working and on others not.

What could be the cause of this BW behavior?

Thanks for any ideas.

BR

m./

[Former Member]

Hi Martin

Each background job has a unique JOBCOUNT with consists of

- jobname and jobcount ID (time stamp + 2 digit ID )

the system does not take date into account, just the time, so if you have a job scheduled through process chain with periodic execution, soon enough all the unique ID (00 to 99) are all take by existing jobs and therefore there is no unique JOBCOUNT left.

therefore there should be peridic deletion of completed background jobs off the system. Speak to you BASIS team and they have a process of deleting the old completed jobs so new ID;s are available for scheduling jobs.

Hope this helps you

regards

Chandra

[Former Member]

try SM37, and select "schedule" and "release" option, check whether there are lots of invaild "BI_PROCESS_***" be scheduled.

if so, manual deleted them

keep us posted if problem sloved.

[Former Member]

1.check SM12 whether any lock regarding to process chain

2.check table "rspc_buffer", delete buffer then reschedule it

hope it's helpful

[Former Member]

when you are scheduling the process chain make sure

1) remove the process from schedule (select the process > menu > process chain > remove from schedule)

2) right click the start process > display all jobs > it should not have any, but for some reason it shows any then delete them

3) now activate the reschedule

4) right click the start process > display all jobs > it should have a job running / waiting..

Regards,

BWer

Please assign points if it is helpful.

[Former Member]

Hi martin,

Is there a job which is released when u schedule this chain? Check for a job with release status in SM37 and then look for this job's log. Pls let us know if u solve the issue

Sriram