Script to fix "Invalid column name" message in SOPicks table

Script to fix "Invalid column name" message in SOPicks table

If the message from the host is:

An error occurred while submitting transaction ID 82ea4208-1701-432a-87cb-02501cd90286.

The eConnect Transaction was submitted successfully, but transaction VER000045 encountered a problem while adding a record to the Panatracker_SOPick table for future reference.

  • Invalid column name 'TrxReference'. (ErrorCode: 207, ErrorState: 1).
  • Invalid column name 'VerifiedDate'. (ErrorCode: 207, ErrorState: 1).

Run this SQL script in your GP Company database(s):

  1. ALTER TABLE Panatracker_SOPicks ADD TrxReference char(25) null, VerifiedDate datetime null

    • Related Articles

    • Script to fix "Invalid column name" message in SOPicks table

      Error Message If the message from the host is: An error occurred while submitting transaction ID 82ea4208-1701-432a-87cb-02501cd90286. The eConnect Transaction was submitted successfully, but transaction VER000045 encountered a problem while adding a ...

    • Listing table triggers

      It's not uncommon for Dynamics GP users and partners to "tweak" GP by adding SQL triggers or custom stored procedures. As with any modification to the standard GP behavior, it can have unanticipated consequences, especially when there are ...

    • Set Device Name or ID

      Each handheld device used with PanatrackerGP needs a unique name. Name devices based on their intended location or use — for example, "WHS1" for Warehouse 1. Complete the setup for all mobile computers as soon as you receive them. Steps Open the ...

    • Error Message: "The profile has not been set for your user account." on the PanatrackerGP portal when opening a page.

      Symptom "The profile has not been set for your user account" error appears when opening a page in the PanatrackerGP portal. On earlier versions of PanatrackerGP, the error message is "Value cannot be null. Parameter name: fileOrServerOrConnection". ...

    • Error message displayed on device: ThreadAbortException: Thread was being aborted.

      Symptom "ThreadAbortException: Thread was being aborted" error appears on the handheld device. Cause This message often indicates that your SQL Server or Application server was restarting or experiencing a process failure while a transaction submit ...