Cannot Find Table 4

<< Click to Display Table of Contents >>

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