Skip to main content
A
amitas5691
April 4, 2025
Question

Execute Stored Procedure Function Failure

  • April 4, 2025
  • 5 replies
  • 0 views

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
stefanhelzle0001
April 4, 2025

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

A
amitas5691Author
April 4, 2025

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
stefanhelzle0001
April 4, 2025

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
mikes0011
Brainy
April 4, 2025

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?

karumurua531442
karumurua531442
April 4, 2025

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

Terms & ConditionsAccessibility statement