How to avoid Running the report has been cancelled due to the time it will take to run. Adjust the parameters of the report and retry error in AX2012
dynamics ax 2012 validate row counting before running report customer /item statistics in sales and marketing module
if total records above 1000 and less than 25000 , you will have warning as the below
if total records above 25000 , you will have error as the below
this validation related to smmreportscontroller class in method preRunValidate as the below
so , if you need to override this setting , you can change this numbers for error and warning but taking in your consideration the size of transaction and performance for servers and other factors like hardware resources for servers ,,etc
so now i will make error limit 2500000 to run this report as the below
thanks.
if total records above 1000 and less than 25000 , you will have warning as the below
if total records above 25000 , you will have error as the below
this validation related to smmreportscontroller class in method preRunValidate as the below
so , if you need to override this setting , you can change this numbers for error and warning but taking in your consideration the size of transaction and performance for servers and other factors like hardware resources for servers ,,etc
so now i will make error limit 2500000 to run this report as the below
thanks.
Nice post, thanks!!
ReplyDeleteyou are most welcome.
Deleteترجم!
ReplyDeleteشرح ممتاز
9/5000
sharah mumtaz
Excellent explanation