When I run a query rule to fetch data from database, I got below error. It seems

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
  • @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.
Reply
  • @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.
Children
No Data