I'm working on automating integrating new Clients and instances and use Qcommand Execute to send the xml Requests to Commserve.
Now I found out that the exitCode of this Activity comes back with success / 0 even if the REquest did nothing or did fail with an Error or Warning.
That fact would only be stated in the xml Response <errorCode> Element.
<errorString>Failed to create SQL Instance [ZFSTI0]. SQL services may be offline or User authentication failed.</errorString>
Any recommendations on how to parse and check that Info the easy way? Could put a XPathQuery-Activity after each Execute-Block and check the output of that in a Transition or Desicion-Block, but that would double the Workflow size unnecessarily.
Thinking of using OnComplete Script to extract and check the error/warningCode and maybe overrule the exitCode of the Activity, but not sure if that is the best way to go.
Thanks in advance