topic Re: Modify SAP timeout for query in SQ01 using C# in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849344#M1958073 <HTML><HEAD></HEAD><BODY><P>No, not that I know of.</P></BODY></HTML> Wed, 24 Aug 2016 06:33:36 GMT retired_member 2016-08-24T06:33:36Z Modify SAP timeout for query in SQ01 using C# https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849341#M1958070 <HTML><HEAD></HEAD><BODY><P>I am connecting to an SAP query in SQ01 from a C# console application however due to the large amount of data which needs to be fetched, I am getting a timeout exception. Is there a way to modify the time period before the timeout occurs using C#?</P><P></P><P>An alternative would be to execute the query in the background. Is there a way to do this using C#?</P></BODY></HTML> Wed, 24 Aug 2016 05:28:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849341#M1958070 Former Member 2016-08-24T05:28:08Z Re: Modify SAP timeout for query in SQ01 using C# https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849342#M1958071 <HTML><HEAD></HEAD><BODY><P>If you are allowed to, you&nbsp; can set the profile parameter rdisp/max_wprun_time&nbsp; to a higher value in TA RZ11.</P></BODY></HTML> Wed, 24 Aug 2016 06:03:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849342#M1958071 retired_member 2016-08-24T06:03:36Z Re: Modify SAP timeout for query in SQ01 using C# https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849343#M1958072 <HTML><HEAD></HEAD><BODY><P>I believe that this will change the timeout period for all SAP processes though. Is there a way to apply this timeout period for one particular query?</P></BODY></HTML> Wed, 24 Aug 2016 06:25:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849343#M1958072 Former Member 2016-08-24T06:25:38Z Re: Modify SAP timeout for query in SQ01 using C# https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849344#M1958073 <HTML><HEAD></HEAD><BODY><P>No, not that I know of.</P></BODY></HTML> Wed, 24 Aug 2016 06:33:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849344#M1958073 retired_member 2016-08-24T06:33:36Z Re: Modify SAP timeout for query in SQ01 using C# https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849345#M1958074 <HTML><HEAD></HEAD><BODY><P>Urg... it's <STRONG>NOT</STRONG> a clean and safe way but it works: add in your query the call to function 'TH_REDISPATCH'.</P><P>The function reset the timeout counter.</P><P>This FM should be used <STRONG>at your own risk</STRONG> and only if <STRONG>you are sure the report/query is correct</STRONG> otherwise you risk to keep alive forever a report/query.</P><P></P><P>Maybe you can call it every 2 minutes (saving the timestamp and checking it).</P><P></P><P>Another not too nice solution could be scheduling the query and save the result on server file (it can be done easily with specific customer function) and then your C# application read the last file generated.</P><P><BR />It's just an option but I do not know your whole scenario.</P></BODY></HTML> Wed, 24 Aug 2016 06:52:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849345#M1958074 SimoneMilesi 2016-08-24T06:52:43Z Re: Modify SAP timeout for query in SQ01 using C# https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849346#M1958075 <HTML><HEAD></HEAD><BODY><P>Thank you for your answer. I'll keep these two solutions as my last resort </P></BODY></HTML> Wed, 24 Aug 2016 06:58:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/modify-sap-timeout-for-query-in-sq01-using-c/m-p/11849346#M1958075 Former Member 2016-08-24T06:58:24Z