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 after moving issues to different project

web-app

One of our Gemini administrators moved some issues from one project to another. Now we get this error when tring to view the Unassigned issues in the project that received the relocated issues. We have copied the query to SQL enterprise manager and ran it and it works fine. Any ideas on what has gone wrong? I have copied the exception from the error log below.

 

Chuck

 

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  5/8/2008
Time:  1:24:52 PM
User:  N/A
Computer: EMCRS73
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/8/2008 1:24:52 PM
Event time (UTC): 5/8/2008 5:24:52 PM
Event ID: ddb12519d8584d98804bb0a60d59b666
Event sequence: 225
Event occurrence: 12
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/Root/Gemini-1-128547315262854320
    Trust level: Full
    Application Virtual Path: /Gemini
    Application Path: c:\inetpub\wwwroot\Gemini\
    Machine name: EMCRS73
 
Process information:
    Process ID: 3976
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: ADOException
    Exception message: could not execute query
[ SELECT this.issueid as issueid142, this.projid as projid142, this.projcode as projcode142, this.typedesc as typedesc142, this.prioritydesc as priority5142, this.statusdesc as statusdesc142, this.resdesc as resdesc142, this.reporteddesc as reported8142, this.vername as vername142, this.isstype as isstype142, this.isspriority as issprio11142, this.priorityseq as priorit12142, this.issstatus as issstatus142, this.issresolution as issreso14142, this.reportedby as reportedby142, this.fixedinverid as fixedin16142, this.summary as summary142, this.longdesc as longdesc142, this.created as created142, this.revised as revised142, this.issuekey as issuekey142, this.startdate as startdate142, this.duedate as duedate142, this.resolveddate as resolve24142, this.closeddate as closeddate142, this.risklevel as risklevel142, this.issuevotes as issuevotes142, this.userdata1 as userdata28142, this.userdata2 as userdata29142, this.userdata3 as userdata30142, this.percentcomplete as percent31142, this.estimatedays as estimat32142, this.estimatehours as estimat33142, this.estimateminutes as estimat34142, this.riskdesc as riskdesc142, this.isprivate as isprivate142, this.vernumber as vernumber142, this.verdesc as verdesc142, this.verorder as verorder142, this.verarchived as verarch40142, this.verreleased as verrele41142, this.tstamp as tstamp142, comments1.IssueID as IssueID4, comments1.commentid as commentid4, comments1.commentid as commentid160, comments1.UserID as UserID160, comments1.IssueID as IssueID160, comments1.ProjID as ProjID160, comments1.Comment as Comment160, comments1.UserName as UserName160, comments1.IsPrivate as IsPrivate160, comments1.IsClosing as IsClosing160, comments1.created as created160, comments1.tstamp as tstamp160, customfiel2.IssueID as IssueID5, customfiel2.customfielddataid as customfi15, customfiel2.customfielddataid as customfi1231, customfiel2.customfieldid as customfi2231, customfiel2.userid as userid231, customfiel2.projid as projid231, customfiel2.issueid as issueid231, customfiel2.fielddata as fielddata231, customfiel2.created as created231, customfiel2.tstamp as tstamp231_ FROM issuesview this_ left outer join issuecomments comments1_ on this.issueid=comments1.IssueID left outer join customfielddata customfiel2_ on this.issueid=customfiel2.IssueID WHERE this.issueid in (?) ORDER BY this.revised desc, this.issueid desc ]
Positional parameters:   0 2491
[SQL: SELECT this
.issueid as issueid142, this.projid as projid142, this.projcode as projcode142, this.typedesc as typedesc142, this.prioritydesc as priority5142, this.statusdesc as statusdesc142, this.resdesc as resdesc142, this.reporteddesc as reported8142, this.vername as vername142, this.isstype as isstype142, this.isspriority as issprio11142, this.priorityseq as priorit12142, this.issstatus as issstatus142, this.issresolution as issreso14142, this.reportedby as reportedby142, this.fixedinverid as fixedin16142, this.summary as summary142, this.longdesc as longdesc142, this.created as created142, this.revised as revised142, this.issuekey as issuekey142, this.startdate as startdate142, this.duedate as duedate142, this.resolveddate as resolve24142, this.closeddate as closeddate142, this.risklevel as risklevel142, this.issuevotes as issuevotes142, this.userdata1 as userdata28142, this.userdata2 as userdata29142, this.userdata3 as userdata30142, this.percentcomplete as percent31142, this.estimatedays as estimat32142, this.estimatehours as estimat33142, this.estimateminutes as estimat34142, this.riskdesc as riskdesc142, this.isprivate as isprivate142, this.vernumber as vernumber142, this.verdesc as verdesc142, this.verorder as verorder142, this.verarchived as verarch40142, this.verreleased as verrele41142, this.tstamp as tstamp142, comments1.IssueID as IssueID4, comments1.commentid as commentid4, comments1.commentid as commentid160, comments1.UserID as UserID160, comments1.IssueID as IssueID160, comments1.ProjID as ProjID160, comments1.Comment as Comment160, comments1.UserName as UserName160, comments1.IsPrivate as IsPrivate160, comments1.IsClosing as IsClosing160, comments1.created as created160, comments1.tstamp as tstamp160, customfiel2.IssueID as IssueID5, customfiel2.customfielddataid as customfi15, customfiel2.customfielddataid as customfi1231, customfiel2.customfieldid as customfi2231, customfiel2.userid as userid231, customfiel2.projid as projid231, customfiel2.issueid as issueid231, customfiel2.fielddata as fielddata231, customfiel2.created as created231, customfiel2.tstamp as tstamp231 FROM issuesview this_ left outer join issuecomments comments1_ on this.issueid=comments1.IssueID left outer join customfielddata customfiel2_ on this.issueid=customfiel2.IssueID WHERE this.issueid in (?) ORDER BY this.revised desc, this.issueid desc]
 
Request information:
    Request URL: http://emcrs73/Gemini/Issues.aspx?m=1&c=1&v=196
    Request path: /Gemini/Issues.aspx
    User host address: 90.21.47.13
    User: 
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
   at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes)
   at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
   at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria)
   at NHibernate.Impl.CriteriaImpl.List()
   at CounterSoft.Gemini.DataProvider.xc0186e148e957052.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, Boolean xd395797a128c659a, Int32 x397f472db7f522d1)
   at CounterSoft.Gemini.Business.x95da312ae9372c2e.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb)
   at CounterSoft.Gemini.Business.x95da312ae9372c2e.GetPagedFilteredIssues2(IssuesFilterEN ifeFilter, Int32 iStartPage, Int32 iPageSize, Int32& iTotalIssues, Int32& iStartIndex, Int32& iEndIndex)
   at CounterSoft.Gemini.Business.x95da312ae9372c2e.xa91f976c95cc24f6(IssuesFilterEN x24b748b5be295dcb, Int32 x6085dd2d6dae9673, Int32 x870a8f396af517a1, Int32& x42a948eff01be1b6, Int32& x8c5725b36c3fef30, Int32& x93a2c901eb10cf80)
   at CounterSoft.Gemini.IssuesWeb.BindData()
   at CounterSoft.Gemini.IssuesWeb.Page
Load(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 CounterSoft.Gemini.Business.BasePage.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Speedway
· 1
Speedway
Replies (6)
helpful
0
not helpful

Which version of Gemini? Any errors in the Gemini log?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Gemini Version 2.2.4

 

Errors from Gemini System Log:

force initialize loading collection 5/8/2008 2:09:14 PM SOURCE: NHibernate TARGETSITE: Void ForceInitialization() STACKTRACE: at NHibernate.Collection.AbstractPersistentCollection.ForceInitialization() at NHibernate.Impl.SessionImpl.InitializeNonLazyCollections() at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, Type optionalEntityName, Object optionalIdentifier, IEntityPersister persister)


Speedway
· 1
Speedway
helpful
0
not helpful

Thanks, can you backup the database and try delete the issues? If so, does it help?

Otherwise, upgrade to 2.2.7, this should sort it.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Did the upgrade to 2.2.7

 

Error has changed to:

 

No row with the given identifier exists: 83, of class: CounterSoft.Gemini.Commons.VersionEN 5/8/2008 4:02:15 PM SOURCE: NHibernate TARGETSITE: System.Object InternalLoad(System.Type, System.Object, Boolean, Boolean) STACKTRACE: at NHibernate.Impl.SessionImpl.InternalLoad(Type clazz, Object id, Boolean eager, Boolean isNullable) at NHibernate.Type.EntityType.ResolveIdentifier(Object id, ISessionImplementor session, Object owner) at NHibernate.Impl.SessionImpl.InitializeEntity(Object obj) at NHibernate.Loader.Loader.InitializeEntitiesAndCollections(IList hydratedObjects, Object resultSetId, 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) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryPa


Speedway
· 1
Speedway
helpful
0
not helpful

One or more of your issues has an illegal fixedinversion or affected version.

Check the issues and affectedversions table against the versions table.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thank you

 

There were issues that had a fixedinverid and affectededversion that linked to an invalid versionid


Speedway
· 1
Speedway