Dynamics Community Forum Thread Details

Dynamics GP2015-Payroll-Year End-get/change operation on table 'SY_Error_Messages_MSTR cannot find the table

Initially experienced system hanging at 29% completion of W-2 wage file when running in a terminal server environment. (Actually ran this two different times of day...one was overnight). Literally was taking about 8-10 mins per W-2 to produce and they will have approx. 9,800 W-2's

GP wasn't loaded on the GP SQL Server, so we loaded it there today without loading any customizations, 3rd party products, modified forms or windows...just the regular basic GP2015 installation just to see if we could get the W-2 file to create.

After installing and running the process again, it seemed to be working...made it all the way up to 55% and then completely stopped with the following error message:

"A get/change operation on table 'SY_Error_Messages_MSTR" cannot find the table."

when clicking on "More Info" button, it said this:
"[MICROSFT][SQL Server Native Client 11.0][SQL Server]Invalid object name 'SY01700'."

I ran a query on the Dynamics database for the SY01700 table and confirmed that it in fact does exist and visually appears to be ok.

Your help is greatly appreciated.