We have gotten a couple support calls about an error occurring while running the Dynamics GP utilities after installing the payroll year-end update.
Error
The following SQL statement produced an error: exec w fDeployClrAssemblies
[Microsoft][SQL Server Native Client 10.0][SQL Server]Assembly ‘system.directoryservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.’ was not found in the SQL catalog.
This error is caused by the system.directoryservices assembly used by the workflow module. It causes the Dynamics GP utilities to shut down and not run properly.
The Fix:
To correct this issue, locate system.directoryservices in the Dynamics GP database under the Assemblies folder, which is located in the Programmability folder. Expand the Assemblies folder and you will see this assembly.
Right click on System.DirectoryServices and choose delete. This assembly will be recreated during the upgrade process. Next, restart your upgrade process by starting the Dynamics GP utilities again.
If you have questions or need some assistance, visit our support page for more help.