Hi all, I have a scheduled process which runs at 12AM everyday.In that proc

sanketh over 10 years ago

Hi all,
I have a scheduled process which runs at 12AM everyday.In that process I am getting following error.Also I have attached stack trace if that helps.

Problem: An invalid expression has been encountered in a task.

Details: ERROR:An error occurred while evaluating expression: myfunc() (Expression evaluation error in rule 'myfunc()' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Cannot open connection) (Data Outputs)

Recommended Action: Check the expression including any function requirements and resume.

stack trace.txt

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

Actually if you dig deeper into the stack trace the relevant two "Caused by" clauses are:

Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

and

Caused by: javax.resource.ResourceException: No matching credentials in Subject!

Note how the first one states the connection cannot be opened but it doesn't tell you why, it's at this point where you need to go down lower into the stack trace to the next "Caused by" to find out the root cause which in this case is not the pool being exhausted but an issue with the credentials probably an expired password.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

Actually if you dig deeper into the stack trace the relevant two "Caused by" clauses are:

Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

and

Caused by: javax.resource.ResourceException: No matching credentials in Subject!

Note how the first one states the connection cannot be opened but it doesn't tell you why, it's at this point where you need to go down lower into the stack trace to the next "Caused by" to find out the root cause which in this case is not the pool being exhausted but an issue with the credentials probably an expired password.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data