This error is related to sqlserver and I've been googling for a solution and think it's related to your timeout settings. You can set the query timout to 0 in the management console if you have access to it. Right click on the sqlserver instance and select properties. Then set the timout to 0.
Hope this helps you for now, I'm also very curious about the amount of member properties since you shouldn't have got this error in the first place and I never seen this error before with 10.000 + records.
Please let me know if the timout setting fixed the error.
Thanks for your help, unfortunately the site is hosted in a shared hosting environment, and I do not have access to that setting at all. At the moment it's set to 300 seconds.
I think I can set teh timout in code as well, so I'll send you an update later today. I'm a little worried about the performance on the shared hosting server when it says it needs more than 300 seconds to complete for just 2000 members. How many properties did you define?
Expensive Query
I have around 2000 records to export and this is the error message I got.
Hi Vincent,
This error is related to sqlserver and I've been googling for a solution and think it's related to your timeout settings. You can set the query timout to 0 in the management console if you have access to it. Right click on the sqlserver instance and select properties. Then set the timout to 0.
Hope this helps you for now, I'm also very curious about the amount of member properties since you shouldn't have got this error in the first place and I never seen this error before with 10.000 + records.
Please let me know if the timout setting fixed the error.
Cheers,
Richard
Thanks for your help, unfortunately the site is hosted in a shared hosting environment, and I do not have access to that setting at all. At the moment it's set to 300 seconds.
I think I can set teh timout in code as well, so I'll send you an update later today. I'm a little worried about the performance on the shared hosting server when it says it needs more than 300 seconds to complete for just 2000 members. How many properties did you define?
18 fields altogether including the default ones.
Hi Vincent,
I just send you the hotfix, please let me know if it solved your issue.
Cheers,
Richard
is working on a reply...