Invalid Object Name (equis.facility_group_members)
Copyright © 2020 EarthSoft, Inc • Modified: 21 Feb 2020
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=22.214.171.12421:
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)
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 firstname.lastname@example.org for assistance in updating the database schema (SQL Server).