Invalid Object Name (equis.facility_group_members)

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting > Reporting Errors >

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=


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()



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 for assistance in updating the database schema.