executestoredprocedure() output error

Rahul Gundu over 8 years ago

I have written a stored procedure in DEV environment, and the same is deployed in TEST environment. When i call stored procedure from Appian using executestoredprocedure() function, it producing the correct result. But while calling from TEST environment, it gave an error.

Error
[success:false,error:jdbc/2B3MMDS -- service jboss.naming.context.java.jdbc.2B3MMDS]

Has anyone faced similar kind of issue?

Thanks
Rahul Gundu

Discussion posts and replies are publicly visible

0 chetany
A Score Level 1
over 8 years ago

The executestoredprocedure depends on the JNDI name.
Are you sure that on the Test environment you are passing the correct JNDI name of the data store?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rahul Gundu over 8 years ago

Yes chetan, Am using same code and the database tables and views are working properly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sumeet Khare over 8 years ago

Rahul, can you check the jboss logs for more details. It seems that either the stored procedure not been deployed correctly or something else is wrong related to that call.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sparshs over 8 years ago

User which is there in the data store 2B3MMDS are you able to run the same stored procedure through the SQL developer using the same user credentials?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rahul Gundu over 8 years ago

Thank you for your suggestions and i found the exact Issue. Please go through the below link.
forum.appian.com/.../kb-1236.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chetany
A Score Level 1
over 8 years ago

Good. This will be helpful to other developers also.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PGarg
Certified Lead Developer
over 7 years ago

@Rahul Gundu

Hi,
I am also facing the similar issue but the link that you have shared is not working anymore (Showing Page Not Found) can you please elaborate what was the exact issue and the solution.
Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Carlos Santander
A Score Level 2
over 7 years ago in reply to PGarg

Here's the updated link to KB-1236: community.appian.com/.../kb-1236-custom-expression-functions-cannot-access-admin-console-data-sources
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sureshg57 over 7 years ago

As per my understanding I think the new version of the executestoredprocedure function can access admin console settings. You can check with James Cater from Appian if that does not work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PGarg
Certified Lead Developer
over 7 years ago in reply to Carlos Santander

Thanks Carlos for the information
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel