I have an ExecuteGPTool step in my workflow that I want to run immediately after job creation. This step is running a custom script that will use the JOB_ID to select the Job AOI and use a select by location to select a feature in another feature class that contains attributes that I want to put into my jobs extended properties table(s). Once the properties are populated it then renames the job based upon those properties.
What I have found though is that this step will not execute properly while the same session of Workflow Manager that created the job is open. No matter what I have tried, I must close and reopen Workflow Manager before this step will work properly. All of the below scenarios have failed:
In all three scenarios, if I closed and reopened WMX and then ran the step, it completed successfully. Any idea what is going on?
In this case it seems when you create a job and immediately start executing there is lock put on the JTX_Jobs table and when you try to rename the job, you cannot do it due to the lock. When you restart the application the lock is released.
I suggest you submit a Technical Support ticket for information on this and any help this may require.
Hope this helps,