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.




Error when upgrading from 4.1 to 4.2

install

after upgrading from 4.1 to 4.2 I get the following error when going to /project/Project.aspx?Tab=Schedule&PROJID=3 and /project/Project.aspx?Tab=Issues&m=1&PROJID=3

Before upgrading converse was installed (3 weeks before). I've tried to reinstall converse afterwards without any luck

Please advice

Kind regards

from errorlog

Invalid column name 'popmailboxid'. at System.Data.SqlClient.SqlConnection.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)

from Browser

Invalid column name 'popmailboxid'. 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 'popmailboxid'.

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 'popmailboxid'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1099 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +58 System.Data.SqlClient.SqlDataReader.get_MetaData() +112 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6291924 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6292993 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +211 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +21 NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +815 NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +568 NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +261 NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +105 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +201

[GenericADOException: could not execute query [ SELECT this.issueid as issueid429, this.projectid as projectid429, this.projectcode as projectc3429, this.projectname as projectn4429, this.typedesc as typedesc429, this.prioritydesc as priority6429, this.severitydesc as severity7429, this.statusdesc as statusdesc429, this.resdesc as resdesc429, this.reporteddesc as reporte10429, this.versionname as version11429, this.issuetypeid as issuety12429, this.issuepriorityid as issuepr13429, this.issueseverityid as issuese14429, this.priorityseq as priorit15429, this.severityseq as severit16429, this.statusseq as statusseq429, this.issuestatusid as issuest18429, this.issueresolutionid as issuere19429, this.reportedby as reportedby429, this.fixedinversionid as fixedin21429, this.summary as summary429, this.longdesc as longdesc429, this.created as created429, this.revised as revised429, this.issuekey as issuekey429, this.versionnumber as version27429, this.versiondesc as version28429, this.versionorder as version29429, this.versionarchived as version30429, this.versionreleased as version31429, this.startdate as startdate429, this.duedate as duedate429, this.resolveddate as resolve34429, this.closeddate as closeddate429, this.issuerisklevelid as issueri36429, this.issuevotes as issuevotes429, this.userdata1 as userdata38429, this.userdata2 as userdata39429, this.userdata3 as userdata40429, this.percentcomplete as percent41429, this.estimatedays as estimat42429, this.estimatehours as estimat43429, this.estimateminutes as estimat44429, this.riskdesc as riskdesc429, this.visibility as visibility429, this.visibilitymembertype as visibil47429, this.parentissueid as parenti48429, this.originatortype as origina49429, this.originatorreply as origina50429, this.originatordata as origina51429, this.originatorprocessed as origina52429, this.isparent as isparent429, this.hierarchykey as hierarc54429, this.repeated as repeated429, this.popmailboxid as popmail56429, this.tstamp as tstamp429, (this.estimatehours * 60 + this.estimateminutes) as formula159, comments1.issueid as issueid11, comments1.commentid as commentid11, comments1.commentid as commentid430, comments1.userid as userid430, comments1.issueid as issueid430, comments1.projectid as projectid430, comments1.comment as comment430, comments1.username as username430, comments1.isclosing as isclosing430, comments1.visibility as visibility430, comments1.visibilitymembertype as visibili9430, comments1.created as created430, comments1.tstamp as tstamp430, customfiel2.issueid as issueid12, customfiel2.customfielddataid as customfi112, customfiel2.customfielddataid as customfi1141, customfiel2.customfieldid as customfi2141, customfiel2.userid as userid141, customfiel2.projectid as projectid141, customfiel2.issueid as issueid141, customfiel2.fielddata as fielddata141, customfiel2.numericdata as numericd7141, customfiel2.datedata as datedata141, customfiel2.created as created141, customfiel2.tstamp as tstamp141, timeentrie3.issueid as issueid13, timeentrie3.entryid as entryid13, timeentrie3.entryid as entryid482, timeentrie3.projectid as projectid482, timeentrie3.issueid as issueid482, timeentrie3.userid as userid482, timeentrie3.timetypeid as timetypeid482, timeentrie3.hours as hours482, timeentrie3.minutes as minutes482, timeentrie3.comment as comment482, timeentrie3.timeentrydate as timeentr9482, timeentrie3.created as created482, timeentrie3.tstamp as tstamp482, affectedve6.issueid as issueid14, affectedve6.affectedversionid as affected114, affectedve6.affectedversionid as affected1453, affectedve6.issueid as issueid453, affectedve6.versionid as versionid453, affectedve6.created as created453, affectedve6.tstamp as tstamp453, versionen12.versionid as versionid294, versionen12.projectid as projectid294, versionen12.versionnumber as versionn3294, versionen12.versionname as versionn4294, versionen12.versiondesc as versiond5294, versionen12.versionreleased as versionr6294, versionen12.versionorder as versiono7294, versionen12.versionarchived as versiona8294, versionen12.startdate as startdate294, versionen12.releasedate as release10294, versionen12.parentversionid as parentv11294, versionen12.created as created294, versionen12.tstamp as tstamp294, resources4.issueid as issueid15, resources4.issueresourceid as issueres115, resources4.issueresourceid as issueres1465, resources4.issueid as issueid465, resources4.userid as userid465, resources4.created as created465, resources4.tstamp as tstamp465, useren14.userid as userid386, useren14.username as username386, useren14.firstname as firstname386, useren14.surname as surname386, useren14.pwd as pwd386, useren14.emailaddress as emailadd6386, useren14.roles as roles386, useren14.created as created386, useren14.lastupdated as lastupda9386, useren14.resetpwd as resetpwd386, useren14.active as active386, useren14.comment as comment386, useren14.apikey as apikey386, useren14.logindate as logindate386, useren14.previouslogindate as previou15386, useren14.tstamp as tstamp386, useren14.firstname + ' ' + useren14.surname as formula146, components5.issueid as issueid16, components5.issuecomponentid as issuecom116, components5.issuecomponentid as issuecom1477, components5.issueid as issueid477, components5.componentid as componen3477, components5.created as created477, components5.tstamp as tstamp477, componente16.componentid as componen1358, componente16.projectid as projectid358, componente16.componentname as componen3358, componente16.componentdesc as componen4358, componente16.componentreadonly as componen5358, componente16.userid as userid358, componente16.parentcomponentid as parentco7358, componente16.componentorder as componen8358, componente16.created as created358, componente16.tstamp as tstamp358_ 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 @p17 in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = this.visibility)) or (this.visibilitymembertype=3 and @p18 in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = this.visibility))) and (this.projectid in (@p19) and (this.reportedby = @p20 or @p21 in (select ir.userid from geminiissueresources ir where ir.issueid = this.issueid)) or this.projectid in (@p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42) ) AND this.projectid in (@p0) and this.startdate >= @p1 and not (this.issuestatusid in (@p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16)) ORDER BY this.revised asc ] Positional parameters: #0>3 #1>10/31/2011 12:00:00 AM #2>11 #3>7 #4>10 #5>53 #6>54 #7>71 #8>33 #9>55 #10>47 #11>35 #12>58 #13>76 #14>61 #15>36 #16>27 [SQL: SELECT this.issueid as issueid429, this.projectid as projectid429, this.projectcode as projectc3429, this.projectname as projectn4429, this.typedesc as typedesc429, this.prioritydesc as priority6429, this.severitydesc as severity7429, this.statusdesc as statusdesc429, this.resdesc as resdesc429, this.reporteddesc as reporte10429, this.versionname as version11429, this.issuetypeid as issuety12429, this.issuepriorityid as issuepr13429, this.issueseverityid as issuese14429, this.priorityseq as priorit15429, this.severityseq as severit16429, this.statusseq as statusseq429, this.issuestatusid as issuest18429, this.issueresolutionid as issuere19429, this.reportedby as reportedby429, this.fixedinversionid as fixedin21429, this.summary as summary429, this.longdesc as longdesc429, this.created as created429, this.revised as revised429, this.issuekey as issuekey429, this.versionnumber as version27429, this.versiondesc as version28429, this.versionorder as version29429, this.versionarchived as version30429, this.versionreleased as version31429, this.startdate as startdate429, this.duedate as duedate429, this.resolveddate as resolve34429, this.closeddate as closeddate429, this.issuerisklevelid as issueri36429, this.issuevotes as issuevotes429, this.userdata1 as userdata38429, this.userdata2 as userdata39429, this.userdata3 as userdata40429, this.percentcomplete as percent41429, this.estimatedays as estimat42429, this.estimatehours as estimat43429, this.estimateminutes as estimat44429, this.riskdesc as riskdesc429, this.visibility as visibility429, this.visibilitymembertype as visibil47429, this.parentissueid as parenti48429, this.originatortype as origina49429, this.originatorreply as origina50429, this.originatordata as origina51429, this.originatorprocessed as origina52429, this.isparent as isparent429, this.hierarchykey as hierarc54429, this.repeated as repeated429, this.popmailboxid as popmail56429, this.tstamp as tstamp429, (this.estimatehours * 60 + this.estimateminutes) as formula159, comments1.issueid as issueid11, comments1.commentid as commentid11, comments1.commentid as commentid430, comments1.userid as userid430, comments1.issueid as issueid430, comments1.projectid as projectid430, comments1.comment as comment430, comments1.username as username430, comments1.isclosing as isclosing430, comments1.visibility as visibility430, comments1.visibilitymembertype as visibili9430, comments1.created as created430, comments1.tstamp as tstamp430, customfiel2.issueid as issueid12, customfiel2.customfielddataid as customfi112, customfiel2.customfielddataid as customfi1141, customfiel2.customfieldid as customfi2141, customfiel2.userid as userid141, customfiel2.projectid as projectid141, customfiel2.issueid as issueid141, customfiel2.fielddata as fielddata141, customfiel2.numericdata as numericd7141, customfiel2.datedata as datedata141, customfiel2.created as created141, customfiel2.tstamp as tstamp141, timeentrie3.issueid as issueid13, timeentrie3.entryid as entryid13, timeentrie3.entryid as entryid482, timeentrie3.projectid as projectid482, timeentrie3.issueid as issueid482, timeentrie3.userid as userid482, timeentrie3.timetypeid as timetypeid482, timeentrie3.hours as hours482, timeentrie3.minutes as minutes482, timeentrie3.comment as comment482, timeentrie3.timeentrydate as timeentr9482, timeentrie3.created as created482, timeentrie3.tstamp as tstamp482, affectedve6.issueid as issueid14, affectedve6.affectedversionid as affected114, affectedve6.affectedversionid as affected1453, affectedve6.issueid as issueid453, affectedve6.versionid as versionid453, affectedve6.created as created453, affectedve6.tstamp as tstamp453, versionen12.versionid as versionid294, versionen12.projectid as projectid294, versionen12.versionnumber as versionn3294, versionen12.versionname as versionn4294, versionen12.versiondesc as versiond5294, versionen12.versionreleased as versionr6294, versionen12.versionorder as versiono7294, versionen12.versionarchived as versiona8294, versionen12.startdate as startdate294, versionen12.releasedate as release10294, versionen12.parentversionid as parentv11294, versionen12.created as created294, versionen12.tstamp as tstamp294, resources4.issueid as issueid15, resources4.issueresourceid as issueres115, resources4.issueresourceid as issueres1465, resources4.issueid as issueid465, resources4.userid as userid465, resources4.created as created465, resources4.tstamp as tstamp465, useren14.userid as userid386, useren14.username as username386, useren14.firstname as firstname386, useren14.surname as surname386, useren14.pwd as pwd386, useren14.emailaddress as emailadd6386, useren14.roles as roles386, useren14.created as created386, useren14.lastupdated as lastupda9386, useren14.resetpwd as resetpwd386, useren14.active as active386, useren14.comment as comment386, useren14.apikey as apikey386, useren14.logindate as logindate386, useren14.previouslogindate as previou15386, useren14.tstamp as tstamp386, useren14.firstname + ' ' + useren14.surname as formula146, components5.issueid as issueid16, components5.issuecomponentid as issuecom116, components5.issuecomponentid as issuecom1477, components5.issueid as issueid477, components5.componentid as componen3477, components5.created as created477, components5.tstamp as tstamp477, componente16.componentid as componen1358, componente16.projectid as projectid358, componente16.componentname as componen3358, componente16.componentdesc as componen4358, componente16.componentreadonly as componen5358, componente16.userid as userid358, componente16.parentcomponentid as parentco7358, componente16.componentorder as componen8358, componente16.created as created358, componente16.tstamp as tstamp358 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 @p17 in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = this.visibility)) or (this.visibilitymembertype=3 and @p18 in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = this.visibility))) and (this.projectid in (@p19) and (this.reportedby = @p20 or @p21 in (select ir.userid from geminiissueresources ir where ir.issueid = this.issueid)) or this.projectid in (@p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42) ) AND this.projectid in (@p0) and this.startdate >= @p1 and not (this.issuestatusid in (@p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16)) ORDER BY this.revised asc]] NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +606 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet1 querySpaces, IType[] resultTypes) +136 NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +729 NHibernate.Impl.CriteriaImpl.List(IList results) +63 NHibernate.Impl.CriteriaImpl.List() +46 CounterSoft.Gemini.DataProvider.xc0186e148e957052.GetFilteredIssues(IssuesFilterEN ifeFilter, Int32[] closedStatus, UserEN user, List1 customFields, Object[] expressions) +518 CounterSoft.Gemini.Business.x95da312ae9372c2e.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, List`1 x41ed9424bcef4dac, UserEN xfd92dbe2fa4bcb5a) +1508 CounterSoft.Gemini.Business.x95da312ae9372c2e.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, UserEN xfd92dbe2fa4bcb5a) +850 CounterSoft.Gemini.Presenter.ProjectPresenter.GetAppointments(Int32 projectId, Int32 userId, DateTime startDate, DateTime endDate) +284 CounterSoft.Gemini.Web.Project.ProjectScheduleTab.InitializeAppointments() +134 CounterSoft.Gemini.Web.Project.ProjectScheduleTab.PageLoad(Object sender, EventArgs e) +437 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42 System.Web.UI.Control.OnLoad(EventArgs e) +132 System.Web.UI.Control.LoadRecursive() +66 System.Web.UI.Control.LoadRecursive() +191 System.Web.UI.Control.LoadRecursive() +191 System.Web.UI.Control.LoadRecursive() +191 System.Web.UI.Control.LoadRecursive() +191 System.Web.UI.Control.LoadRecursive() +191 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

Modist
· 1
Modist
Replies (1)
helpful
0
not helpful
ANSWER

newer mind - found answer in http://support.geminiplatform.com/questions/4030/upgrading-4-1-to-4-2-exception

Please close


Modist
· 1
Modist