SQL Errors while running MO Receipt Entry automation

Symptom

When MO Receipt Entry automation runs in Dynamics GP, you receive one or more of the following error messages related to a constraint error in older SQL tables for Manufacturing automation:

• (Panatrack) GPS Error: 65

GPS Error 65 dialog

• (Panatrack) SQL Error: 547

SQL Error 547 dialog

• (Panatrack) ODBC Error: 23000

ODBC Error 23000 dialog

Solution

This error has been corrected in Automation Integration scripts Build 1.2 and later. New clients will not receive these errors. For existing clients experiencing this issue:

1. Run the below DropConstraints script in the Company database.
2. Verify that the constraint was removed from the PTAUTO01 table in the company database.
3. If the constraint was not removed automatically, drop it manually using SQL Server Management Studio: - Right-click on the constraint - Select Drop

1. -- DropConstraints
   
2. DECLARE @SQL NVARCHAR(MAX) = N'';
   
3.  
4. SELECT @SQL += N'
5. ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
6. FROM SYS.OBJECTS
7. WHERE TYPE_DESC LIKE '%CONSTRAINT' AND 
8. OBJECT_NAME(OBJECT_ID) like 'CK__PTAUTO01__CHANGE__%' AND
9. OBJECT_NAME(PARENT_OBJECT_ID) = 'PTAUTO01';
10.  
11. PRINT @SQL
12. --EXECUTE(@SQL)

• Related Articles

• eConnect Errors that may be encountered when using PanatrackerGP

  "Error 1189: taSopHdrRecalc - Payment total does not match deposits+payments" Error: Payment total does not match deposits+payments entered for the document This error usually occurs when the taSopHdrIvcInsertPre stored procedure has been modified. ...

• PanatrackerGP SQL databases

  There are generally two tables for each transaction in the PanatrackerGP database. Those are typically the tables are clients want to report on. Adjustments (Add and Remove Inventory) are in the TrxAdjustment and TrxAdjustmentUnit tables. The base ...

• SQL Error is displayed: OpenAccessException

  Symptom "OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'CREATEDATABASE Panatracker'; already exists." Cause This error occurs after the Panatracker transaction database has been modified or moved. The Panatracker SQL ...

• GP Manufacturing - SQL Permissions error

  Symptom The GP Manufacturing integration (.cnk file) fails due to permissions in the PanatrackerGP database. Solution Grant the appropriate database permissions in SQL Server: Open SQL Server Management Studio. Find and double-click the user account. ...

• Automated Labels Aren't Printing

  Symptom Your automated labels have stopped printing. Solution 1. Access the PanatrackerGP Server Remote into the server hosting PanatrackerGP using an administrator account. 2. Locate the NiceLabel Application On the server, open the Start menu and ...