Invalid Object Name (equis.facility_group_members)

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Troubleshooting >

Invalid Object Name (equis.facility_group_members)

Affected Software/Reports/DLL(s): EQuIS Professional

 

Affected Software Version: 6.x

 

Symptoms: When opening up a report in EQuIS Professional, the Error shown below may occur.

 

An error has occurred in EarthSoft.Reports, Version=6.1.0.14021:

 

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'equis.facility_group_members'.

  at EarthSoft.Common.Data.Connection.Fill(DataSet ds, String tableName, String CommandText, IDbTransaction Transaction)

  at EarthSoft.Common.Data.Connection.Fill(DataSet ds, String tableName, String CommandText)

  at EarthSoft.Reports.OpenDialog.Setup()

ClientConnectionId:dd32af97-3fe4-4a50-90c5-a3ec1e7c90e4

 

Cause/Details: This may be a result of the database not being properly updated to the latest schema.

 

Resolution/Workaround: Update the database to the latest schema matching the version of EQuIS Professional you are using. If the database is currently using a 5.6.x schema and the Professional version is 6 and up, you will need to follow the proper procedure for updating the EUIDs, explained here, and then contact support@earthsoft.com for assistance in updating the database schema (SQL Server).