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
2 replies
Subscribers
9 subscribers
Views
1891 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
When I run a query rule to fetch data from database, I got below error. It seems
shaoyongw
over 9 years ago
When I run a query rule to fetch data from database, I got below error. It seems like the query is time out and cancelled by the system. Is there any place we can set this time out parameter ?
ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01013: user requested cancel of current operation
OriginalPostID-190457
OriginalPostID-190457
Discussion posts and replies are publicly visible
Parents
0
sikhivahans
over 9 years ago
@shaoyongw The error seems to be associated with the timeout in the query that's being made. Rather than modifying the timeout setting(Reference: conf.data.query.timeout at https://forum.appian.com/suite/help/7.11/Post-Install_Configurations.html#Query_Rule_Limits), I would like to suggest you to get the data in terms of batches. That is, make use of the startIndex and batchSize effectively, (for the first batch it should 1 - 5, for second batch it should be 6 - 10 and so on) and obtain the entire data in multiple hits.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 9 years ago
@shaoyongw The error seems to be associated with the timeout in the query that's being made. Rather than modifying the timeout setting(Reference: conf.data.query.timeout at https://forum.appian.com/suite/help/7.11/Post-Install_Configurations.html#Query_Rule_Limits), I would like to suggest you to get the data in terms of batches. That is, make use of the startIndex and batchSize effectively, (for the first batch it should 1 - 5, for second batch it should be 6 - 10 and so on) and obtain the entire data in multiple hits.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data