Error executing query. Timeout expired.

Message: Error executing query. ERROR [HYT00] [Informix .NET provider]Timeout expired.

ERROR [HY008] [Informix .NET provider][Informix]Statement interrupted by user.


Stack: [1] Error executing query.

   at sshcp_assignment_iris_lib.ServiceAPIController.Flows.FuncActionGetWelcomeLetterDetails3.datasetGetClientBuInitsByClNum(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, Int64 qplocl_num, String qpstbus_unit)

   at sshcp_assignment_iris_lib.ServiceAPIController.Flows.ActionGetWelcomeLetterDetails3(HeContext heContext, Int64 inParamCl_num, String inParamCompanyCode, STHCP_WELCOME_LETTER_DETAILS_STRUCTUREStructure& outParamWelcomeLetterDetails)

   at sshcp_assignment_iris_lib.ServiceAPIController.ServiceAPIGetWelcomeLetterDetails3()


[2] ERROR [HYT00] [Informix .NET provider]Timeout expired.

ERROR [HY008] [Informix .NET provider][Informix]Statement interrupted by user.

   at IBM.Data.Informix.IfxConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)

   at IBM.Data.Informix.IfxDataReader.IfxRowSet.Fetch()

   at IBM.Data.Informix.IfxDataReader.Read()

   at OutSystems.Internal.Db.DatabaseAccess.ExecuteWithoutRequestTimeout[T](Func`1 action)

   at OutSystems.HubEdition.RuntimePlatform.Db.OSList`1.set_Reader(IDataReader value)

   at OutSystems.Internal.Db.DatabaseAccessProvider`1.ExecuteQuery[T](Command cmd, GenericRecordList`1 rl, String description, Boolean transformParameters, Boolean skipLog)

   at sshcp_assignment_iris_lib.ServiceAPIController.Flows.FuncActionGetWelcomeLetterDetails3.datasetGetClientBuInitsByClNum(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, Int64 qplocl_num, String qpstbus_unit)


Here, GetClientBuInitsByClNum is an aggregate with 5 filters with no joins.

This aggregate has also become a SLOWSQL with almost average time to 16751 ms

This aggregate is in loop.

Please help to resolve it.

Hello Nagesh,

Can you show me how you're implementing? 

Jorge Rodrigues


Hello,

Did you try to increase the timeout property of your query? Could you share the query?


Regards,

NC

Hi @Nagesh Soradge

 r u using any external database ? because even i faced the same problem, and here is the solution

if  yes you need to increse database resources,


Suppose if you are not using any external DB, then try to icrease the time out property , and sujestion put a break point on your query try to debug it and see wre its failing,


alternate solution: if its still getting time out u need to wake up the timmer if its not meet your condition, in this way you achive


cheers

shree