Hi All,
We are getting below error in tomcat logs but unable to find out the root cause since process ID is not there. Please suggest how we can rectify this?
ERROR com.appiancorp.storedprocedure.fn.ExecuteStoredProcedureFunction - Error executing stored procedure for data source [jdbc/businessds] com.appiancorp.storedprocedure.exceptions.MissingInputsException
Thanks,
Amita
Discussion posts and replies are publicly visible
I think you should see the process failing that makes this call. Process monitoring should show this.
Hi Stefan Helzle , We saw this error in tomcat logs so based on the timing there are around 1000+ process instances running at same time so it's a bit difficult to understand which process exactly is causing this. Is there any way by which we can get to know the process ID where this issue is occuring.
When you call a stored procedure from a process, and it fails, that process should fail as well and show up in process monitoring.
How do you know this error is referring to a stored procedure being called in a process, versus in an interface or an expression rule? how many different places in your system are calling the stored procedure execution smart service function, for instance, as opposed to the in-process smart service node?
Hi amitas5691 could check in the database whether the stored procedure is working or not ?