Skip to main content
New Participant
Apr 4, 2025 12:22 PM UTC
Question

Execute Stored Procedure Function Failure

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

5 replies

stefanhelzle0001
Brainy
Apr 4, 2025 12:46 PM UTC

I think you should see the process failing that makes this call. Process monitoring should show this.

New Participant
Apr 4, 2025 12:49 PM UTC

Hi [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] , 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.

stefanhelzle0001
Brainy
Apr 4, 2025 1:09 PM UTC

When you call a stored procedure from a process, and it fails, that process should fail as well and show up in process monitoring.

mikes0011
Brainy
Apr 4, 2025 1:34 PM UTC

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?

The Expression Guru
karumurua531442
Participating Frequently
Apr 4, 2025 2:11 PM UTC

Hi [mention:5b46247058264419a7a0c74e4bbcdd9b:e9ed411860ed4f2ba0265705b8793d05]  could check in the database whether the stored procedure is working or not ?