Could not find stored procedure (equis.table_order)

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting >

Could not find stored procedure (equis.table_order)

Affected Software/Reports/DLL(s): Professional

 

Affected Software Version: 6.x+

 

Symptoms: When exiting EQuIS Professional, the following Error may occur.

 

An error has occurred in EarthSoft.EQuIS, Version=x.xx.xx.xxxxx:

 

System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'equis.table_order'.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

  at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

  at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

  at System.Data.SqlClient.SqlDataReader.get_MetaData()

  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

  at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

  at EarthSoft.Common.Data.SqlConnection.GetTableOrder(DataSet dataSet)

  at EarthSoft.EQuIS.Forms.Application.RemoveWorkspace()

ClientConnectionId:dd32af97-3fe4-4a50-90c5-a3ec1e7c90e4

 

Cause/Details: The database may not be properly updated to the latest schema.

 

Resolution/Workaround: Update the database to the latest schema matching the build 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, then contact EarthSoft Support for guidance updating the database schema.