Symptom:
There is a constraint error with some of our older SQL tables for Manufacturing automation. If that constraint error exists, the following messages will be received when automation for MO Receipt Entry runs in GP:
(Panatrack) GPS Error: 65
(Panatrack) SQL Error: 547
(Panatrack) ODBC Error: 23000
Solution:
This error has been corrected in the Automation Integration scripts Build 1.2 from Implementation Specialists. Going forward, new clients won’t receive these error messages for this particular reason. If existing clients receive this error, the script to correct it is “DropConstraints.sql” (attached). Run this in the Company database.
Verify that the constraint was removed from the PTAUTO01 table in the company database. If not, drop the constraint manually using SQL Server Management Studio. (Right click on constraint and run “Drop”)