Cannot Find Table 0 or 4

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting >

Cannot Find Table 0 or 4

Affected Software/Reports/DLL(s): Professional

 

Affected Software Version: 6.x and up

 

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

 

   System.IndexOutOfRangeException: Cannot find table 0.

   or

   System.IndexOutOfRangeException: Cannot find table 4.

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

   at EarthSoft.Reports.OpenDialog.GetReports()

 

Cause/Details: This error comes down to an inability to access required tables. Causes may include:

1.the database not being properly updated to the latest schema.

2.a mismatch between the expected number of tables and the tables found, such as a table being deleted prior to logging in

3.connectivity issues preventing tables from being read

 

Resolution/Workaround: The resolution depends on the cause.

1.Update the EQuIS Database to the latest schema matching the version build of EQuIS Professional you are using. A "SCHEMA UPDATE NEEDED (see st_log)" message may appear in the top-right corner of the program.

2.For table mismatches, see Delete Tables.

3.For connectivity issues, check that connectivity is established, or consult the IT Department regarding the EQuIS Hardware and Software Requirements.