/
Unable to open table: U37_Widget Basic#2147217865

AGRIS Customer Documentation

Unable to open table: U37_Widget Basic#2147217865

 Problem

After upgrading AGIRS I try to run a report, but get the following error.

image-20240621-171007.png

 Solution

  1. Have all users logout of Agris

  2. Get on the Database server and open up services

  3. Find the Actian/PSQL service (This is usually the first service) and stop it. (This will end any active connection to the database)

  4. Open file explorer and browse out to (C:\Apps\AGRIS) and go into the DDF’s folder

  5. Copy the DDF files into the numbered dataset having the issue.

  6. Start back the Actian/PSQL service and login to AGRIS

  7. Rerun the report that was causing the error and the issue should be resolved.

 

This will require all users to be out of Agris and have the ability to connect to the Database server

 Related articles

Filter by label

There are no items with the selected labels at this time.

Related content

Basic 2147217900 Error after Upgrading AGRIS
Basic 2147217900 Error after Upgrading AGRIS
More like this
Unable to open table: W78_AUDIT_TKTS
Unable to open table: W78_AUDIT_TKTS
More like this
I/O Error: PSQL 2
More like this
Basic 2147217900 Error Encountered While Working in AGRIS
Basic 2147217900 Error Encountered While Working in AGRIS
More like this
Error Message: Basic #63 or Basic #9 Applying AGRIS License File (Bad record number)
Error Message: Basic #63 or Basic #9 Applying AGRIS License File (Bad record number)
More like this
Basic#- 2147024816 The File Exists
Basic#- 2147024816 The File Exists
More like this

3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2011 - 2024 Cultura Technologies LLC. All Rights Reserved Worldwide.  Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.