Tuesday, 20 February 2018

Synchronization error due to SQL Plan Guides

Recently we had to create a plan guide in SQL Server (not a good long term solution). Everything seemed to be working fine until we had a production deployment and the database synchronization failed as shown in the screenshot below.

It seems that during synchronization a store procedure is recreated. As our plan guide was based on queries in the stored procedure, AX was unable to drop it. Only solution was to drop the plan guide (disabling the plan guide did not help) and re-create it after the synchronization.

This posting is provided "AS IS" with no warranties. Use code at your own risk.

No comments:

Post a Comment