How to solve if Dynamics GP, Unknown Dictionary Error appear

Question

How to solve if Dynamics GP, Unknown Dictionary Error appear & db-server status show starting for long time ?

Answer 1

Hello IH Account 3

Follow the below steps to address the "Unknown Dictionary Error" and prolonged "Starting" status for the db-server in Dynamics GP:

1. Verify Dictionary File Paths:

• Access the Dynamics.set file using a text editor.
• Confirm the paths to dictionary files (.dic) are correct and the files exist in those locations.
• Check for typos or inconsistencies in file names or paths.

2. Rebuild Dictionary Files:

• If paths are correct but the error persists, rebuild the dictionary files using dexsql.exe:
  • Locate dexsql.exe in the Dynamics GP installation directory (usually C:\Program Files\Microsoft Dynamics\GP\SQL\Utility\0).
    • Run dexsql.exe with the command: dexsql.exe -rebuild "<path to DYNAMICS database>"
    3. Start Dynamics GP as "sa" User:
    • Attempt to launch Dynamics GP or Dynamics GP Utilities using the "sa" account.
    • If successful, rebuild the dictionary files again from within Dynamics GP Utilities.
    4. Check User Permissions:
    • Ensure users have proper Read/Write permissions to the application directory, forms, reports, and third-party dictionaries.
    5. Recreate the Dynamics.set File:
    • If issues persist, rename the current Dynamics.set file.
    • Copy the Dynamics.set file from a functioning workstation with the same modules.
    Additional Troubleshooting Steps:
    • Review Event Logs: Check Windows Event Viewer for error messages related to Dynamics GP or SQL Server.
    • Restart Services: Restart Dynamics GP services and SQL Server services.
    • Check SQL Server Health: Ensure SQL Server is running properly and has sufficient resources.
    • Address Network Issues: Verify network connectivity and firewall settings if Dynamics GP is on a network server.
• Run DEX_REQ.SQL Script: If none of the above work, run the DEX_REQ.SQL script from the Dynamics GP installation directory to recreate tables.