Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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