Home Home
  login

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Invalid column name 'statusseq'.GEM-1749 - Issue Status Ordering

desktop
add-ons

Hi,

today I updated my Gemini installation from 3.1.0 to 3.1.1. Unfortunately, the issue lists do not work anymore. There is an error logged in the system log: "Invalid column name 'statusseq'."

Neither the sample database contains this field in the SQL create script nor is there an update script for version 3.1.1.

I also tried the SQL Profiler to find out, to which table I've to add this field, but could find one. It seems there is an ORM bug and it is releated to the newly introduced feature requested with issue "GEM-1749 - Issue Status Ordering".

Here is the stack trace:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior

How can I solve the problem? Currently, my Gemini installation is unusable.

--
Kind regards,
Mathias

tolot27
· 1
tolot27
Replies (2)
helpful
0
not helpful

Please make sure you run createviews.sql and createprocs.sql


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Hi,

okay, that did solve the problem.

Thanks!

--
Kind regards,
Mathias


tolot27
· 1
tolot27