Error after moving issues to different project
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.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 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 |
|
Thursday, May 8, 2008, 7:59:47 PM |