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'

web-app

I upgraded my database to 3.1.1 and after configuring the web.config file, i logged in ok.  I view the projects ok.  Until I click on a component, i got this error:


Invalid column name 'statusseq'. body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

Server Error in '/Gemini' Application.

Invalid column name 'statusseq'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'statusseq'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[SqlException (0x80131904): Invalid column name 'statusseq'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
   NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +35
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +239
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +203
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +70
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +165

[ADOException: could not execute query [ SELECT this.issueid as issueid199, this.projectid as projectid199, this.projectcode as projectc3199, this.typedesc as typedesc199, this.prioritydesc as priority5199, this.severitydesc as severity6199, this.statusdesc as statusdesc199, this.resdesc as resdesc199, this.reporteddesc as reported9199, this.versionname as version10199, this.issuetypeid as issuety11199, this.issuepriorityid as issuepr12199, this.issueseverityid as issuese13199, this.priorityseq as priorit14199, this.severityseq as severit15199, this.statusseq as statusseq199, this.issuestatusid as issuest17199, this.issueresolutionid as issuere18199, this.reportedby as reportedby199, this.fixedinversionid as fixedin20199, this.summary as summary199, this.longdesc as longdesc199, this.created as created199, this.revised as revised199, this.issuekey as issuekey199, this.versionnumber as version26199, this.versiondesc as version27199, this.versionorder as version28199, this.versionarchived as version29199, this.versionreleased as version30199, this.startdate as startdate199, this.duedate as duedate199, this.resolveddate as resolve33199, this.closeddate as closeddate199, this.issuerisklevelid as issueri35199, this.issuevotes as issuevotes199, this.userdata1 as userdata37199, this.userdata2 as userdata38199, this.userdata3 as userdata39199, this.percentcomplete as percent40199, this.estimatedays as estimat41199, this.estimatehours as estimat42199, this.estimateminutes as estimat43199, this.riskdesc as riskdesc199, this.visibility as visibility199, this.visibilitymembertype as visibil46199, this.parentissueid as parenti47199, this.tstamp as tstamp199, comments1.IssueID as IssueID11, comments1.commentid as commentid11, comments1.commentid as commentid200, comments1.userid as userid200, comments1.issueid as issueid200, comments1.projectid as projectid200, comments1.comment as comment200, comments1.username as username200, comments1.isclosing as isclosing200, comments1.visibility as visibility200, comments1.visibilitymembertype as visibili9200, comments1.created as created200, comments1.tstamp as tstamp200, customfiel2.IssueID as IssueID12, customfiel2.customfielddataid as customfi112, customfiel2.customfielddataid as customfi1471, customfiel2.customfieldid as customfi2471, customfiel2.userid as userid471, customfiel2.projectid as projectid471, customfiel2.issueid as issueid471, customfiel2.fielddata as fielddata471, customfiel2.created as created471, customfiel2.tstamp as tstamp471, timeentrie3.IssueID as IssueID13, timeentrie3.entryID as entryID13, timeentrie3.entryID as entryID252, timeentrie3.projectid as projectid252, timeentrie3.issueid as issueid252, timeentrie3.userid as userid252, timeentrie3.hours as hours252, timeentrie3.minutes as minutes252, timeentrie3.comment as comment252, timeentrie3.timeentrydate as timeentr8252, timeentrie3.created as created252, timeentrie3.tstamp as tstamp252, affectedve6.IssueID as IssueID14, affectedve6.affectedversionid as affected114, affectedve6.affectedversionid as affected1223, affectedve6.issueid as issueid223, affectedve6.versionid as versionid223, affectedve6.created as created223, affectedve6.tstamp as tstamp223, versionen12.versionid as versionid34, versionen12.projectid as projectid34, versionen12.versionnumber as versionn334, versionen12.versionname as versionn434, versionen12.versiondesc as versiond534, versionen12.versionreleased as versionr634, versionen12.versionorder as versiono734, versionen12.versionarchived as versiona834, versionen12.created as created34, versionen12.tstamp as tstamp34, resources4.IssueID as IssueID15, resources4.issueresourceid as issueres115, resources4.issueresourceid as issueres1235, resources4.issueid as issueid235, resources4.userid as userid235, resources4.created as created235, resources4.tstamp as tstamp235, useren14.userid as userid116, useren14.username as username116, useren14.firstname as firstname116, useren14.surname as surname116, useren14.pwd as pwd116, useren14.emailaddress as emailadd6116, useren14.roles as roles116, useren14.created as created116, useren14.lastupdated as lastupda9116, useren14.ResetPWD as ResetPWD116, useren14.active as active116, useren14.comment as comment116, useren14.apikey as apikey116, useren14.tstamp as tstamp116, useren14.firstname + ' ' + useren14.surname as formula56, components5.IssueID as IssueID16, components5.issuecomponentid as issuecom116, components5.issuecomponentid as issuecom1247, components5.issueid as issueid247, components5.componentid as componen3247, components5.created as created247, components5.tstamp as tstamp247, componente16.componentid as componen188, componente16.projectid as projectid88, componente16.componentname as componen388, componente16.componentdesc as componen488, componente16.componentreadonly as componen588, componente16.userid as userid88, componente16.parentcomponentid as parentco788, componente16.created as created88, componente16.tstamp as tstamp88_ FROM geminiissuesview this left outer join geminiissuecomments comments1 on this.issueid=comments1.IssueID left outer join geminicustomfielddata customfiel2 on this.issueid=customfiel2.IssueID left outer join geminitimetracking timeentrie3 on this.issueid=timeentrie3.IssueID left outer join geminiaffectedversions affectedve6 on this.issueid=affectedve6.IssueID left outer join geminiversions versionen12 on affectedve6.versionid=versionen12.versionid left outer join geminiissueresources resources4 on this.issueid=resources4.IssueID left outer join geminiusers useren14 on resources4.userid=useren14.userid left outer join geminiissuecomponents components5 on this.issueid=components5.IssueID left outer join geminicomponents componente16 on components5.componentid=componente16.componentid WHERE ((this.visibilitymembertype=2 and :VisibilityFilter.UserID in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = this.visibility)) or (this.visibilitymembertype=3 and :VisibilityFilter.UserID in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = this.visibility))) AND this.issueid in (?) ORDER BY this.revised desc, this.issueid desc ] Positional parameters: #0>3477 [SQL: SELECT this.issueid as issueid199, this.projectid as projectid199, this.projectcode as projectc3199, this.typedesc as typedesc199, this.prioritydesc as priority5199, this.severitydesc as severity6199, this.statusdesc as statusdesc199, this.resdesc as resdesc199, this.reporteddesc as reported9199, this.versionname as version10199, this.issuetypeid as issuety11199, this.issuepriorityid as issuepr12199, this.issueseverityid as issuese13199, this.priorityseq as priorit14199, this.severityseq as severit15199, this.statusseq as statusseq199, this.issuestatusid as issuest17199, this.issueresolutionid as issuere18199, this.reportedby as reportedby199, this.fixedinversionid as fixedin20199, this.summary as summary199, this.longdesc as longdesc199, this.created as created199, this.revised as revised199, this.issuekey as issuekey199, this.versionnumber as version26199, this.versiondesc as version27199, this.versionorder as version28199, this.versionarchived as version29199, this.versionreleased as version30199, this.startdate as startdate199, this.duedate as duedate199, this.resolveddate as resolve33199, this.closeddate as closeddate199, this.issuerisklevelid as issueri35199, this.issuevotes as issuevotes199, this.userdata1 as userdata37199, this.userdata2 as userdata38199, this.userdata3 as userdata39199, this.percentcomplete as percent40199, this.estimatedays as estimat41199, this.estimatehours as estimat42199, this.estimateminutes as estimat43199, this.riskdesc as riskdesc199, this.visibility as visibility199, this.visibilitymembertype as visibil46199, this.parentissueid as parenti47199, this.tstamp as tstamp199, comments1.IssueID as IssueID11, comments1.commentid as commentid11, comments1.commentid as commentid200, comments1.userid as userid200, comments1.issueid as issueid200, comments1.projectid as projectid200, comments1.comment as comment200, comments1.username as username200, comments1.isclosing as isclosing200, comments1.visibility as visibility200, comments1.visibilitymembertype as visibili9200, comments1.created as created200, comments1.tstamp as tstamp200, customfiel2.IssueID as IssueID12, customfiel2.customfielddataid as customfi112, customfiel2.customfielddataid as customfi1471, customfiel2.customfieldid as customfi2471, customfiel2.userid as userid471, customfiel2.projectid as projectid471, customfiel2.issueid as issueid471, customfiel2.fielddata as fielddata471, customfiel2.created as created471, customfiel2.tstamp as tstamp471, timeentrie3.IssueID as IssueID13, timeentrie3.entryID as entryID13, timeentrie3.entryID as entryID252, timeentrie3.projectid as projectid252, timeentrie3.issueid as issueid252, timeentrie3.userid as userid252, timeentrie3.hours as hours252, timeentrie3.minutes as minutes252, timeentrie3.comment as comment252, timeentrie3.timeentrydate as timeentr8252, timeentrie3.created as created252, timeentrie3.tstamp as tstamp252, affectedve6.IssueID as IssueID14, affectedve6.affectedversionid as affected114, affectedve6.affectedversionid as affected1223, affectedve6.issueid as issueid223, affectedve6.versionid as versionid223, affectedve6.created as created223, affectedve6.tstamp as tstamp223, versionen12.versionid as versionid34, versionen12.projectid as projectid34, versionen12.versionnumber as versionn334, versionen12.versionname as versionn434, versionen12.versiondesc as versiond534, versionen12.versionreleased as versionr634, versionen12.versionorder as versiono734, versionen12.versionarchived as versiona834, versionen12.created as created34, versionen12.tstamp as tstamp34, resources4.IssueID as IssueID15, resources4.issueresourceid as issueres115, resources4.issueresourceid as issueres1235, resources4.issueid as issueid235, resources4.userid as userid235, resources4.created as created235, resources4.tstamp as tstamp235, useren14.userid as userid116, useren14.username as username116, useren14.firstname as firstname116, useren14.surname as surname116, useren14.pwd as pwd116, useren14.emailaddress as emailadd6116, useren14.roles as roles116, useren14.created as created116, useren14.lastupdated as lastupda9116, useren14.ResetPWD as ResetPWD116, useren14.active as active116, useren14.comment as comment116, useren14.apikey as apikey116, useren14.tstamp as tstamp116, useren14.firstname + ' ' + useren14.surname as formula56, components5.IssueID as IssueID16, components5.issuecomponentid as issuecom116, components5.issuecomponentid as issuecom1247, components5.issueid as issueid247, components5.componentid as componen3247, components5.created as created247, components5.tstamp as tstamp247, componente16.componentid as componen188, componente16.projectid as projectid88, componente16.componentname as componen388, componente16.componentdesc as componen488, componente16.componentreadonly as componen588, componente16.userid as userid88, componente16.parentcomponentid as parentco788, componente16.created as created88, componente16.tstamp as tstamp88 FROM geminiissuesview this left outer join geminiissuecomments comments1 on this.issueid=comments1.IssueID left outer join geminicustomfielddata customfiel2 on this.issueid=customfiel2.IssueID left outer join geminitimetracking timeentrie3 on this.issueid=timeentrie3.IssueID left outer join geminiaffectedversions affectedve6 on this.issueid=affectedve6.IssueID left outer join geminiversions versionen12 on affectedve6.versionid=versionen12.versionid left outer join geminiissueresources resources4 on this.issueid=resources4.IssueID left outer join geminiusers useren14 on resources4.userid=useren14.userid left outer join geminiissuecomponents components5 on this.issueid=components5.IssueID left outer join geminicomponents componente16 on components5.componentid=componente16.componentid WHERE ((this.visibilitymembertype=2 and :VisibilityFilter.UserID in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = this.visibility)) or (this.visibilitymembertype=3 and :VisibilityFilter.UserID in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = this.visibility))) AND this.issueid in (?) ORDER BY this.revised desc, this.issueid desc]] NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +259 NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +18 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet1 querySpaces, IType[] resultTypes) +81 NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +332 NHibernate.Impl.CriteriaImpl.List(IList results) +41 NHibernate.Impl.CriteriaImpl.List() +35 CounterSoft.Gemini.DataProvider.xc0186e148e957052.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, Int32[] xbcd492679797b57e, UserEN xfd92dbe2fa4bcb5a, ArrayList x858fc38c4382ab28, Object[] x41e32780e09d58f5) +213 CounterSoft.Gemini.Business.x95da312ae9372c2e.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, ArrayList x41ed9424bcef4dac) +874 CounterSoft.Gemini.Business.x95da312ae9372c2e.xa91f976c95cc24f6(IssuesFilterEN x24b748b5be295dcb, Int32 x6085dd2d6dae9673, Int32 x870a8f396af517a1, Int32&amp; x42a948eff01be1b6, Int32&amp; x8c5725b36c3fef30, Int32&amp; x93a2c901eb10cf80) +62 CounterSoft.Gemini.Web.Controls.IssuesGridUC.BindData() +1552 CounterSoft.Gemini.Web.Controls.IssuesGridUC.Page_Load(Object sender, EventArgs e) +34 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627 </pre></td></tr></tbody></table><br> <hr color="silver" size="1" width="100%"> <b>Version Information:</b>&nbsp;Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082 </font><!-- [SqlException]: Invalid column name 'statusseq'. 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, Boolean returnStream, String method, DbAsyncResult result) 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 NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) [ADOException]: could not execute query [ SELECT this_.issueid as issueid19_9_, this_.projectid as projectid19_9_, this_.projectcode as projectc3_19_9_, this_.typedesc as typedesc19_9_, this_.prioritydesc as priority5_19_9_, this_.severitydesc as severity6_19_9_, this_.statusdesc as statusdesc19_9_, this_.resdesc as resdesc19_9_, this_.reporteddesc as reported9_19_9_, this_.versionname as version10_19_9_, this_.issuetypeid as issuety11_19_9_, this_.issuepriorityid as issuepr12_19_9_, this_.issueseverityid as issuese13_19_9_, this_.priorityseq as priorit14_19_9_, this_.severityseq as severit15_19_9_, this_.statusseq as statusseq19_9_, this_.issuestatusid as issuest17_19_9_, this_.issueresolutionid as issuere18_19_9_, this_.reportedby as reportedby19_9_, this_.fixedinversionid as fixedin20_19_9_, this_.summary as summary19_9_, this_.longdesc as longdesc19_9_, this_.created as created19_9_, this_.revised as revised19_9_, this_.issuekey as issuekey19_9_, this_.versionnumber as version26_19_9_, this_.versiondesc as version27_19_9_, this_.versionorder as version28_19_9_, this_.versionarchived as version29_19_9_, this_.versionreleased as version30_19_9_, this_.startdate as startdate19_9_, this_.duedate as duedate19_9_, this_.resolveddate as resolve33_19_9_, this_.closeddate as closeddate19_9_, this_.issuerisklevelid as issueri35_19_9_, this_.issuevotes as issuevotes19_9_, this_.userdata1 as userdata37_19_9_, this_.userdata2 as userdata38_19_9_, this_.userdata3 as userdata39_19_9_, this_.percentcomplete as percent40_19_9_, this_.estimatedays as estimat41_19_9_, this_.estimatehours as estimat42_19_9_, this_.estimateminutes as estimat43_19_9_, this_.riskdesc as riskdesc19_9_, this_.visibility as visibility19_9_, this_.visibilitymembertype as visibil46_19_9_, this_.parentissueid as parenti47_19_9_, this_.tstamp as tstamp19_9_, comments1_.IssueID as IssueID11_, comments1_.commentid as commentid11_, comments1_.commentid as commentid20_0_, comments1_.userid as userid20_0_, comments1_.issueid as issueid20_0_, comments1_.projectid as projectid20_0_, comments1_.comment as comment20_0_, comments1_.username as username20_0_, comments1_.isclosing as isclosing20_0_, comments1_.visibility as visibility20_0_, comments1_.visibilitymembertype as visibili9_20_0_, comments1_.created as created20_0_, comments1_.tstamp as tstamp20_0_, customfiel2_.IssueID as IssueID12_, customfiel2_.customfielddataid as customfi1_12_, customfiel2_.customfielddataid as customfi1_47_1_, customfiel2_.customfieldid as customfi2_47_1_, customfiel2_.userid as userid47_1_, customfiel2_.projectid as projectid47_1_, customfiel2_.issueid as issueid47_1_, customfiel2_.fielddata as fielddata47_1_, customfiel2_.created as created47_1_, customfiel2_.tstamp as tstamp47_1_, timeentrie3_.IssueID as IssueID13_, timeentrie3_.entryID as entryID13_, timeentrie3_.entryID as entryID25_2_, timeentrie3_.projectid as projectid25_2_, timeentrie3_.issueid as issueid25_2_, timeentrie3_.userid as userid25_2_, timeentrie3_.hours as hours25_2_, timeentrie3_.minutes as minutes25_2_, timeentrie3_.comment as comment25_2_, timeentrie3_.timeentrydate as timeentr8_25_2_, timeentrie3_.created as created25_2_, timeentrie3_.tstamp as tstamp25_2_, affectedve6_.IssueID as IssueID14_, affectedve6_.affectedversionid as affected1_14_, affectedve6_.affectedversionid as affected1_22_3_, affectedve6_.issueid as issueid22_3_, affectedve6_.versionid as versionid22_3_, affectedve6_.created as created22_3_, affectedve6_.tstamp as tstamp22_3_, versionen12_.versionid as versionid3_4_, versionen12_.projectid as projectid3_4_, versionen12_.versionnumber as versionn3_3_4_, versionen12_.versionname as versionn4_3_4_, versionen12_.versiondesc as versiond5_3_4_, versionen12_.versionreleased as versionr6_3_4_, versionen12_.versionorder as versiono7_3_4_, versionen12_.versionarchived as versiona8_3_4_, versionen12_.created as created3_4_, versionen12_.tstamp as tstamp3_4_, resources4_.IssueID as IssueID15_, resources4_.issueresourceid as issueres1_15_, resources4_.issueresourceid as issueres1_23_5_, resources4_.issueid as issueid23_5_, resources4_.userid as userid23_5_, resources4_.created as created23_5_, resources4_.tstamp as tstamp23_5_, useren14_.userid as userid11_6_, useren14_.username as username11_6_, useren14_.firstname as firstname11_6_, useren14_.surname as surname11_6_, useren14_.pwd as pwd11_6_, useren14_.emailaddress as emailadd6_11_6_, useren14_.roles as roles11_6_, useren14_.created as created11_6_, useren14_.lastupdated as lastupda9_11_6_, useren14_.ResetPWD as ResetPWD11_6_, useren14_.active as active11_6_, useren14_.comment as comment11_6_, useren14_.apikey as apikey11_6_, useren14_.tstamp as tstamp11_6_, useren14_.firstname + ' ' + useren14_.surname as formula5_6_, components5_.IssueID as IssueID16_, components5_.issuecomponentid as issuecom1_16_, components5_.issuecomponentid as issuecom1_24_7_, components5_.issueid as issueid24_7_, components5_.componentid as componen3_24_7_, components5_.created as created24_7_, components5_.tstamp as tstamp24_7_, componente16_.componentid as componen1_8_8_, componente16_.projectid as projectid8_8_, componente16_.componentname as componen3_8_8_, componente16_.componentdesc as componen4_8_8_, componente16_.componentreadonly as componen5_8_8_, componente16_.userid as userid8_8_, componente16_.parentcomponentid as parentco7_8_8_, componente16_.created as created8_8_, componente16_.tstamp as tstamp8_8_ FROM gemini_issuesview this_ left outer join gemini_issuecomments comments1_ on this_.issueid=comments1_.IssueID left outer join gemini_customfielddata customfiel2_ on this_.issueid=customfiel2_.IssueID left outer join gemini_timetracking timeentrie3_ on this_.issueid=timeentrie3_.IssueID left outer join gemini_affectedversions affectedve6_ on this_.issueid=affectedve6_.IssueID left outer join gemini_versions versionen12_ on affectedve6_.versionid=versionen12_.versionid left outer join gemini_issueresources resources4_ on this_.issueid=resources4_.IssueID left outer join gemini_users useren14_ on resources4_.userid=useren14_.userid left outer join gemini_issuecomponents components5_ on this_.issueid=components5_.IssueID left outer join gemini_components componente16_ on components5_.componentid=componente16_.componentid WHERE ((this_.visibilitymembertype=2 and :VisibilityFilter.UserID in (select gg.userid from gemini_globalgroupmembership gg where gg.globalgroupid = this_.visibility)) or (this_.visibilitymembertype=3 and :VisibilityFilter.UserID in (select pg.userid from gemini_projectgroupmembership pg where pg.projectgroupid = this_.visibility))) AND this_.issueid in (?) ORDER BY this_.revised desc, this_.issueid desc ] Positional parameters: #0&gt;3477 [SQL: SELECT this_.issueid as issueid19_9_, this_.projectid as projectid19_9_, this_.projectcode as projectc3_19_9_, this_.typedesc as typedesc19_9_, this_.prioritydesc as priority5_19_9_, this_.severitydesc as severity6_19_9_, this_.statusdesc as statusdesc19_9_, this_.resdesc as resdesc19_9_, this_.reporteddesc as reported9_19_9_, this_.versionname as version10_19_9_, this_.issuetypeid as issuety11_19_9_, this_.issuepriorityid as issuepr12_19_9_, this_.issueseverityid as issuese13_19_9_, this_.priorityseq as priorit14_19_9_, this_.severityseq as severit15_19_9_, this_.statusseq as statusseq19_9_, this_.issuestatusid as issuest17_19_9_, this_.issueresolutionid as issuere18_19_9_, this_.reportedby as reportedby19_9_, this_.fixedinversionid as fixedin20_19_9_, this_.summary as summary19_9_, this_.longdesc as longdesc19_9_, this_.created as created19_9_, this_.revised as revised19_9_, this_.issuekey as issuekey19_9_, this_.versionnumber as version26_19_9_, this_.versiondesc as version27_19_9_, this_.versionorder as version28_19_9_, this_.versionarchived as version29_19_9_, this_.versionreleased as version30_19_9_, this_.startdate as startdate19_9_, this_.duedate as duedate19_9_, this_.resolveddate as resolve33_19_9_, this_.closeddate as closeddate19_9_, this_.issuerisklevelid as issueri35_19_9_, this_.issuevotes as issuevotes19_9_, this_.userdata1 as userdata37_19_9_, this_.userdata2 as userdata38_19_9_, this_.userdata3 as userdata39_19_9_, this_.percentcomplete as percent40_19_9_, this_.estimatedays as estimat41_19_9_, this_.estimatehours as estimat42_19_9_, this_.estimateminutes as estimat43_19_9_, this_.riskdesc as riskdesc19_9_, this_.visibility as visibility19_9_, this_.visibilitymembertype as visibil46_19_9_, this_.parentissueid as parenti47_19_9_, this_.tstamp as tstamp19_9_, comments1_.IssueID as IssueID11_, comments1_.commentid as commentid11_, comments1_.commentid as commentid20_0_, comments1_.userid as userid20_0_, comments1_.issueid as issueid20_0_, comments1_.projectid as projectid20_0_, comments1_.comment as comment20_0_, comments1_.username as username20_0_, comments1_.isclosing as isclosing20_0_, comments1_.visibility as visibility20_0_, comments1_.visibilitymembertype as visibili9_20_0_, comments1_.created as created20_0_, comments1_.tstamp as tstamp20_0_, customfiel2_.IssueID as IssueID12_, customfiel2_.customfielddataid as customfi1_12_, customfiel2_.customfielddataid as customfi1_47_1_, customfiel2_.customfieldid as customfi2_47_1_, customfiel2_.userid as userid47_1_, customfiel2_.projectid as projectid47_1_, customfiel2_.issueid as issueid47_1_, customfiel2_.fielddata as fielddata47_1_, customfiel2_.created as created47_1_, customfiel2_.tstamp as tstamp47_1_, timeentrie3_.IssueID as IssueID13_, timeentrie3_.entryID as entryID13_, timeentrie3_.entryID as entryID25_2_, timeentrie3_.projectid as projectid25_2_, timeentrie3_.issueid as issueid25_2_, timeentrie3_.userid as userid25_2_, timeentrie3_.hours as hours25_2_, timeentrie3_.minutes as minutes25_2_, timeentrie3_.comment as comment25_2_, timeentrie3_.timeentrydate as timeentr8_25_2_, timeentrie3_.created as created25_2_, timeentrie3_.tstamp as tstamp25_2_, affectedve6_.IssueID as IssueID14_, affectedve6_.affectedversionid as affected1_14_, affectedve6_.affectedversionid as affected1_22_3_, affectedve6_.issueid as issueid22_3_, affectedve6_.versionid as versionid22_3_, affectedve6_.created as created22_3_, affectedve6_.tstamp as tstamp22_3_, versionen12_.versionid as versionid3_4_, versionen12_.projectid as projectid3_4_, versionen12_.versionnumber as versionn3_3_4_, versionen12_.versionname as versionn4_3_4_, versionen12_.versiondesc as versiond5_3_4_, versionen12_.versionreleased as versionr6_3_4_, versionen12_.versionorder as versiono7_3_4_, versionen12_.versionarchived as versiona8_3_4_, versionen12_.created as created3_4_, versionen12_.tstamp as tstamp3_4_, resources4_.IssueID as IssueID15_, resources4_.issueresourceid as issueres1_15_, resources4_.issueresourceid as issueres1_23_5_, resources4_.issueid as issueid23_5_, resources4_.userid as userid23_5_, resources4_.created as created23_5_, resources4_.tstamp as tstamp23_5_, useren14_.userid as userid11_6_, useren14_.username as username11_6_, useren14_.firstname as firstname11_6_, useren14_.surname as surname11_6_, useren14_.pwd as pwd11_6_, useren14_.emailaddress as emailadd6_11_6_, useren14_.roles as roles11_6_, useren14_.created as created11_6_, useren14_.lastupdated as lastupda9_11_6_, useren14_.ResetPWD as ResetPWD11_6_, useren14_.active as active11_6_, useren14_.comment as comment11_6_, useren14_.apikey as apikey11_6_, useren14_.tstamp as tstamp11_6_, useren14_.firstname + ' ' + useren14_.surname as formula5_6_, components5_.IssueID as IssueID16_, components5_.issuecomponentid as issuecom1_16_, components5_.issuecomponentid as issuecom1_24_7_, components5_.issueid as issueid24_7_, components5_.componentid as componen3_24_7_, components5_.created as created24_7_, components5_.tstamp as tstamp24_7_, componente16_.componentid as componen1_8_8_, componente16_.projectid as projectid8_8_, componente16_.componentname as componen3_8_8_, componente16_.componentdesc as componen4_8_8_, componente16_.componentreadonly as componen5_8_8_, componente16_.userid as userid8_8_, componente16_.parentcomponentid as parentco7_8_8_, componente16_.created as created8_8_, componente16_.tstamp as tstamp8_8_ FROM gemini_issuesview this_ left outer join gemini_issuecomments comments1_ on this_.issueid=comments1_.IssueID left outer join gemini_customfielddata customfiel2_ on this_.issueid=customfiel2_.IssueID left outer join gemini_timetracking timeentrie3_ on this_.issueid=timeentrie3_.IssueID left outer join gemini_affectedversions affectedve6_ on this_.issueid=affectedve6_.IssueID left outer join gemini_versions versionen12_ on affectedve6_.versionid=versionen12_.versionid left outer join gemini_issueresources resources4_ on this_.issueid=resources4_.IssueID left outer join gemini_users useren14_ on resources4_.userid=useren14_.userid left outer join gemini_issuecomponents components5_ on this_.issueid=components5_.IssueID left outer join gemini_components componente16_ on components5_.componentid=componente16_.componentid WHERE ((this_.visibilitymembertype=2 and :VisibilityFilter.UserID in (select gg.userid from gemini_globalgroupmembership gg where gg.globalgroupid = this_.visibility)) or (this_.visibilitymembertype=3 and :VisibilityFilter.UserID in (select pg.userid from gemini_projectgroupmembership pg where pg.projectgroupid = this_.visibility))) AND this_.issueid in (?) ORDER BY this_.revised desc, this_.issueid desc] at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet1 querySpaces, IType[] resultTypes) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List() at CounterSoft.Gemini.DataProvider.xc0186e148e957052.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, Int32[] xbcd492679797b57e, UserEN xfd92dbe2fa4bcb5a, ArrayList x858fc38c4382ab28, Object[] x41e32780e09d58f5) at CounterSoft.Gemini.Business.x95da312ae9372c2e.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, ArrayList x41ed9424bcef4dac) at CounterSoft.Gemini.Business.x95da312ae9372c2e.xa91f976c95cc24f6(IssuesFilterEN x24b748b5be295dcb, Int32 x6085dd2d6dae9673, Int32 x870a8f396af517a1, Int32& x42a948eff01be1b6, Int32& x8c5725b36c3fef30, Int32& x93a2c901eb10cf80) at CounterSoft.Gemini.Web.Controls.IssuesGridUC.BindData() at CounterSoft.Gemini.Web.Controls.IssuesGridUC.PageLoad(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) [HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.issues_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) -->

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

I think i screwed up.  I tried to rerun the scripts myself and every script returned some error (it was not like that before).  Please let me know how I can start from the beginning without delete the db and restore it back.

Here is how I ran:

  1. upgrade 2.1.sql
  2. upgrade 2.2.sql
  3. createtables.sql
  4. createviews.sql
  5. createproc.sql
  6. ugprade3.0 step1
  7. upgrade3.0 step 2
  8. upgrade3.1 (I got error right here so I then tried to run createviews and createprocs instead last time and got no problem with these 2 "create" scritps.).
I purposely want to upgrade to 3.1.1 and got error at running upgrade_3.1 so I got all confused, don't know what to do.

The error I got above is using with 3.1.1 web application.


kha
· 1
kha
helpful
0
not helpful

Suggest you restore the database and run createprocs.sql and createviews.sql to upgrade from 3.1.0 to 3.1.1.


Saar Cohen
· 5000
Saar Cohen