Cannot Find Table 4

Affected Software/Reports/DLL(s): Professional

Affected Software Version: 6.x+

Symptoms: When opening up a report in EQuIS Professional, the following Error(s) may occur.

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

System.IndexOutOfRangeException: Cannot find table 4.

at System.Data.DataTableCollection.get_Item(Int32 index)

at EarthSoft.Reports.OpenDialog.GetReports()

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

System.IndexOutOfRangeException: Cannot find table 4.

at System.Data.DataTableCollection.get_Item(Int32 index)

at EarthSoft.Reports.OpenDialog.cmbLookIn_InitializeRow(Object sender, InitializeRowEventArgs e)

at Infragistics.Win.UltraWinGrid.UltraCombo.FireEvent(ComboEventIds id, EventArgs e)

at Infragistics.Win.UltraWinGrid.UltraGridRow.FireInitializeRow()

at Infragistics.Win.UltraWinGrid.RowsCollection.FireInitializeRow(IList rows)

at Infragistics.Win.UltraWinGrid.RowsCollection.InitNonGroupByRows(IList fireInitializeRowOnTheseRows)

at Infragistics.Win.UltraWinGrid.RowsCollection.SyncRowsHelper(IList boundList)

at Infragistics.Win.UltraWinGrid.RowsCollection.SyncRows()

at Infragistics.Win.UltraWinGrid.RowsCollection.EnsureNotDirty()

at Infragistics.Win.UltraWinGrid.RowsCollection.get_Count()

at EarthSoft.Reports.OpenDialog.set_SelectedCategory(Category Value)

at EarthSoft.EQuIS.Forms.Application.OpenDataset(Category category)

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 or higher, follow the proper procedure for updating the EUIDs, and then update the database schema (SQL Server).