Invalid Object Name (equis.facility_group

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 schema matching your latest build of EQuIS Professional. If the database is currently using a 5.6.x schema and the Professional version is 6 and up, follow the proper procedure for updating the EUIDs, and then contact EarthSoft Support for assistance in updating the database schema.

Invalid Object Name (equis.facility_group_members)

Invalid Object Name (equis.facility_group_members)