Forum Discussion
Helper IUnable to "Apply Query Changes".
Hi Lydia
I have rebuilt the data set from the ground up starting with all of the tables from one Sql server then making changes to these before introduction the tables from another sql server.
This seems to have fixed the issue, and the report is refreshing in minutes when before just making one change in the query was taking hours to update.
Thanks for you help and comments :-)
Kind Regards
Thomas
Helper IHi
Using a 64bit version , I have set the timeout at 8 hours and there are no restricted columns ... I have cut everything back and still no luck....
Kind regards
Thomas
thomaskelly,
I would recommend you check that if you can increase query timeout or connection timeout value on MySQL server side.
Regards,
Lydia
- thomaskelly
Hi Lydia
I have rebuilt the data set from the ground up starting with all of the tables from one Sql server then making changes to these before introduction the tables from another sql server.
This seems to have fixed the issue, and the report is refreshing in minutes when before just making one change in the query was taking hours to update.
Thanks for you help and comments :-)
Kind Regards
Thomas
- vanessafvg
Community Champion
are you loading more than one query at once?
i know in the past when i have changed this setting it has helped - untick the paralell loading
