https://communities.sas.com/t5/SAS-Customer-Intelligence/SAS-MA-Failed-Query-retry-resubmission-to-the-database/m-p/650895#M1545 <P>Hello</P><P>I had observed that whenever a database query generated by SAS gets failed, SAS MA tries to resubmit the same query. How can we control this behavior of SAS MA? Is there any setting/configuration that we can tweak to stop the retry/resubmission of the failed query. Usually the query which fails in the first instance never gets succeeded in the second attempt unless something gets changed at the database end.</P><P>Some query runs for more than 30 mins and fail and SAS MA retries the same query and fails again. This is actually causing the delays in campaign development. I dont want SAS MA to retry the failed query instead it should notify about the error to the user.</P><P>&nbsp;</P><P>/Vijay</P> Tue, 26 May 2020 19:16:24 GMT infomevijay 2020-05-26T19:16:24Z https://communities.sas.com/t5/SAS-Customer-Intelligence/SAS-MA-Failed-Query-retry-resubmission-to-the-database/m-p/650895#M1545 <P>Hello</P><P>I had observed that whenever a database query generated by SAS gets failed, SAS MA tries to resubmit the same query. How can we control this behavior of SAS MA? Is there any setting/configuration that we can tweak to stop the retry/resubmission of the failed query. Usually the query which fails in the first instance never gets succeeded in the second attempt unless something gets changed at the database end.</P><P>Some query runs for more than 30 mins and fail and SAS MA retries the same query and fails again. This is actually causing the delays in campaign development. I dont want SAS MA to retry the failed query instead it should notify about the error to the user.</P><P>&nbsp;</P><P>/Vijay</P> Tue, 26 May 2020 19:16:24 GMT https://communities.sas.com/t5/SAS-Customer-Intelligence/SAS-MA-Failed-Query-retry-resubmission-to-the-database/m-p/650895#M1545 infomevijay 2020-05-26T19:16:24Z