My colleague Greg Olsen and I have been trying to publish an (admittedly massive) 6.5MB CRM solution for the past few days. Unfortunately we have been getting a very unhelpful “Generic SQL error”. We knew it was related to timeouts but after doing the usual timeout fixes (tweaking the reg file, changing the web.config etc) we were still getting the same error.
Fortunately we are not the only team to have encountered this issue and I found this blog by Darren Liu. While all the steps outlined in his blog are useful (and highly recommended if you are having timeout issue), the fix for us was editing the MSCRM_CONFIG database. To change the SqlCommandTimeout value for deployments. The default value is 30 (seconds) which is fine for small/medium size CRM solutions but for one like ours we needed a bit more of a buffer, so we upped it.
USE MSCRM_CONFIG
GO
UPDATE DeploymentProperties SET IntColumn=9000 WHERE ColumnName='SqlCommandTimeout'
Problem solved. Thanks Darren
No comments:
Post a Comment