SQL Error is displayed: OpenAccessException

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 login no longer has permission to access the Panatracker database.

Solution

Grant the appropriate database permissions:

  1. Open SQL Server Management Studio.
  2. Locate the Panatracker SQL login.
  3. Ensure the Panatracker login is a member of the db_owner database role for the Panatracker database.
  4. Additionally, ensure the Panatracker login is a member of the DYNGRP database role for any company databases you're using with PanatrackerGP.
  5. Apply the changes.

    • Related Articles

    • 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 ...

    • 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. ...

    • 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 ...

    • GZip magic Number Error

      Symptom "The Magic number in GZip header is not correct" message is displayed. Cause This rare error indicates that the IIS process on the server may have become corrupted. Solution Restart IIS on the server where PanatrackerGP is hosted: From the ...

    • 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 ...