I’m trying to pass parameters into a stored procedure in a sub workflow.
I’m lost because the whole purpose of setting links is to allow dynamic links.
I’m sure I’m doing something incorrect, but I’m not sure what it’s asking me to do and why.
Any help is appreciated.
That message is to create the output schema. Enter any random text for each variable to complete the schema. Need not be valid data.
thanks Brian, I’ll mess with that.
Since you’re verse in Service Connect, maybe you can help with another issue.
On my top level workflow, I’m making a call to a sub workflow and cycling the row element of the data coming in.
The sub workflow is inserting records into a database. This works correctly, however it is not inserting the data (creates blank record) and only cycled once. I’ve been trying to replicate my process like other functioning workflows that we have, but I must be missing something critical.
First thing that comes to mind is when defining the Cycling XPath, verify that the Row and not the RowSet is mapped to the XPath.
That doesn’t appear to be the case, but good suggestion.
Do you have Document Tracking turned on for the Workflow? That should provide some insight.
So i’m having trouble getting this to cycle at all. It appears the data is all present at the time of the sub workflow call, but the sub workflow does not cycle per node at all.
I’m at a loss, and I’m sure there is something small I am missing. I’ve had our resident service connect expert AND an Epicor consultant look at the workflow and neither of them can figure out why this thing isn’t cycling…
Verify that your Sub-Workflow incoming schema is set to the schema generated when setting up Cycling.
I have verified that the incoming schema to the sub workflow is the one that I generated when cycling. No change to the behavior of the workflow…
solved it by recreating all of my schemas and walking through the steps you outlined. Thank you Brian. Service Connect is sure a frustrating tool!!!
