Hello,
The following error appears when I try to excecute the function fn!executestoredprocedure()
LOG TomCat: ERROR com.appiancorp.ps.function.ExecuteStoredProcedureFunction - Error executing
What can be happening?
Discussion posts and replies are publicly visible
It would be helpful if you could share your stored procedure call here. Also, are you able to execute the stored procedure directly in the DB?
It could be that you are not including the schema in the call, etc.
Yes, it is possible to execute the SP from the Database and the JDCB is correct, we can query the entities.
Procedure has no inputs!
I'm not sure where "Hipotecario" is coming from in this case, per your error message.
Is the same error presented when you execute this in an expression rule (to directly see the results)?
Also, I would suggest for the procedureName input, utilizing "schema.procedure" instead of just "procedure".
Please find below image & link.
docs.appian.com/.../fnc_system_a_executestoredprocedureforquery.html
Hipotecario is the JDBC, It's used correctly by the Data Store, I don't have issues about it. I will try to excecute utilizing "Schema", Anyway, the problem perhaps is that it can't access or identify the "JDBC Connection" in this case "Hipotecario"