Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
12 replies
Subscribers
7 subscribers
Views
7854 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi all, I have a scheduled process which runs at 12AM everyday.In that proc
sanketh
over 9 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
OriginalPostID-148555
OriginalPostID-148555
Discussion posts and replies are publicly visible
Parents
0
sikhivahans
over 8 years ago
@nikolasm To the best of my knowledge, I believe that it is due to exhausted connection pooling which is being suggested by Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection. If it is so, then some design considerations should be made when Appian is talking to database, either it could be a read/ write/ delete operation. For example, batching technique (by making use of pagination) in processes/ expressions/ interfaces, querying the data and holding them in PVs and passing the data as argument to SAIL form (when you want to query huge data sets), making use of load() effectively as much as possible etc are some of the ways to deal with this issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 8 years ago
@nikolasm To the best of my knowledge, I believe that it is due to exhausted connection pooling which is being suggested by Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection. If it is so, then some design considerations should be made when Appian is talking to database, either it could be a read/ write/ delete operation. For example, batching technique (by making use of pagination) in processes/ expressions/ interfaces, querying the data and holding them in PVs and passing the data as argument to SAIL form (when you want to query huge data sets), making use of load() effectively as much as possible etc are some of the ways to deal with this issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data