on May 19, 2017Requirement is to send proper message to end user when the stored procedure is executed successfully but records not updated in the application database.
Application Team willing to give error code and error message to handle such scenarios. Can we achieve this using output parameter successfully in SQL & Oracle based AFX Connectors?
In a different post, Dan described the functionality around the output parameter:
https://community.rsa.com/thread/191645#comment-891862
...but it's really just intended upon account creation- when the actual account created differs from what the system thought the name would be at request time.
For example, if you have fancy account name calculation logic when an account is created- your change request to create the account might think the account name is DCINNA (for example)- then in workflow, you realize that DCINNA is taken, and the account should be named DCINNA01 instead. So you'd pass DCINNA01 into AFX, and then the AFX output parameter would be responsible for updating the CR/pending account to say DCINNA01 instead of DCINNA, and the change verification process would respect that change also.
Not sure you can use the output parameter feature for that purpose.
Yes, I thought so.
Can we have this workaround, if application team maintains the error dictionary in any of the table in their database, whenever there is an error, by giving some constraint in the sql select node, we will pick the description and send it across to the end user.
it really is sad that most connectors have the return message hard coded. this is true for the database and the SSH adapters. Being able to return a message to the workflow would be awesome.
E.g. what if a provisioning command failed but it was "just" a "overloaded endpoint, try again later" or a "account sync not finished". something like that. One could then wait and loop back, retrying another time.
In a different post, Dan described the functionality around the output parameter:
https://community.rsa.com/thread/191645#comment-891862
Not sure you can use the output parameter feature for that purpose.