Question Re: Process chain problem: Step completion not occuring in Technology Q&A

Process chain problem: Step completion not occuring

Former Member — Thu, 16 Aug 2012 12:57:44 GMT

Greetings!

My problem involves a datastore activation step in a process chain. The step will start and the datastore is activated successfully - all lights are green in the process monitor. However, that step in the process chain remains yellow. It's as though the notification is not 'getting back' to the chain that the step was completed successfully.

I've searched through various logs (SLG1), looked at the batch jobs in SM37, etc, and I've found no sign of any failed processes. Is there anywhere else I can look?

I'm on SAP EHP 1 for SAP NetWeaver 7.0. Oracle DB, release 11.2.0.2.0.

Thank you!

Re: Process chain problem: Step completion not occuring

Former Member — Thu, 16 Aug 2012 14:59:13 GMT

ST22 - short dumps

SM21 - system log

Re: Process chain problem: Step completion not occuring

Former Member — Thu, 16 Aug 2012 15:11:56 GMT

Thank you for the suggestion. I checked both and nothing was found.

Does documentation exist that shows the inner-workings of process chain and their process types? Perhaps something that shows how those notifications are sent back and forth? I've not been able to find any.

Thank you.

Re: Process chain problem: Step completion not occuring

Former Member — Thu, 16 Aug 2012 17:37:30 GMT

Hi Christopher,

if you believe the step is successful then use rspc_process_finish function to change the status in the process chain, so that the chain proceeds further.

Re: Process chain problem: Step completion not occuring

Former Member — Thu, 16 Aug 2012 20:05:50 GMT

That's what I've been doing to move the chain along. This problem has occurred six times to date: four times this week and twice last.

Thank you for your input!

Re: Process chain problem: Step completion not occuring

Former Member — Fri, 17 Aug 2012 07:02:11 GMT

Hi Christopher,

The event between the two steps might have been corrupted. Try to activate the chain again and trigger.

Also check if the same chain has started again when DSO activation is in progress.

Regards

Chandu

Re: Process chain problem: Step completion not occuring

Former Member — Fri, 17 Aug 2012 07:08:54 GMT

you may have "locking issues" on the DSO... and somehow it's not reported immediately

(you can check for locks in transaction SM12)

this might happen when during the activation another process is "reading" the DSO (in another transformation for example)

Re: Process chain problem: Step completion not occuring

Former Member — Mon, 20 Aug 2012 11:47:40 GMT

Thank you for the suggestion. We were not able to find any locks in the DSO nor on SM12.

This same problem has occured on another process chain with a subchain step. The subchain completed successfully, and has the status "successfully completed" on the chain tab on the step itself, but remained yellow and didn't move on.

Does anyone know of a way to monitor long running process chain steps? I believe this can be done using BWCCMS but we're not currently utilizing this feature.

Thank you for your input!

Re: Process chain problem: Step completion not occuring

Former Member — Mon, 20 Aug 2012 12:14:52 GMT

I just found this:

Within table RSPCPROCESSLOG, the record for each step has Actual State = J - Framework Error Upon Completion.

Having done some web-digging, I have not found a solution or even an explanation for this error. Anyone know what or how this is caused?

Thank you.

Re: Process chain problem: Step completion not occuring

Former Member — Mon, 20 Aug 2012 12:33:21 GMT

Hi Christopher

Did you check this note:

Note 1631909 - Chain does not become green or stops at IP for synchron. run?

Regards,

Eldo.

Re: Process chain problem: Step completion not occuring

Former Member — Thu, 23 Aug 2012 12:45:32 GMT

That looks to be our problem. However, the note fix is attached to a enchancement pack and we're not able to load that now given we're working on upgrading from 7.0 to 7.3.

I found that when this happens, the ACTUAL_STATE entry on RSPCPROCESSLOG will be 'J' while the STATE entry will be 'G' when the step did truly complete without error. We're looking into coding a program to scan for these and auto-fix where needed.

Thank you for all of your responses!

Re: Process chain problem: Step completion not occuring

Former Member — Thu, 23 Aug 2012 16:19:11 GMT

Hi Chris, What is the auto-fix you are implementing to correct these, could you let us know,,Thanks

Re: Process chain problem: Step completion not occuring

Former Member — Thu, 23 Aug 2012 16:31:44 GMT

We're in the concept phase now but my thoughts are:

Create a program and schedule it to run every 15 minutes. That program would: read table RSPCPROCESSLOG (probably by batch date) and locate entries where ACTUAL_STATE = "J" and STATE = "G". Then utilize program RSPC_PROCESS_FINISH to set that process step to green, thus allowing the process chain to continue.

But, there are a lot of scenarios to test out before implementation. My first worry is: are there any ways a step can actually fail, and still result in 'J' and 'G' entries. If yes, then we wouldn't want the program to set the step to green.

Thank you for your inquiry.

Re: Process chain problem: Step completion not occuring

Former Member — Thu, 23 Aug 2012 17:27:23 GMT

Thanks Chris, I was interested how you are changing ACTUAL_STATE thru your program to G. but, thats not the case i guess.In the table, if STATE = G then your process will already be in green.

Re: Process chain problem: Step completion not occuring

Former Member — Mon, 14 Oct 2013 11:19:03 GMT

Hi all

The process chain is out of sync.

I removed the process chain from schedule and scheduled it again.

The process chain ran successfully.

Re: Process chain problem: Step completion not occuring

former_member183290 — Tue, 15 Oct 2013 06:24:30 GMT

Hi Chris,

I have a similar unresolved issue and I have mentioned all the details below.

http://scn.sap.com/thread/3428395

We are also looking for apt note to implement and yet to raise an OSS note.

Request you to post the resolution if you get.

Thanks a lot and sorry for bothering on this.

Regards,

Vikranth