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
1890 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
0
harshav
over 9 years ago
Not sure of the error but the place for setting the timout parameter is
forum.appian.com/.../Post-Install_Configurations.html
But changing the default configurations is not advisable rather than changing the query itself to return the data in the specified time. Hope this would help !!!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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