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 issueid14_2_, this_.projid as projid14_2_, this_.projcode as projcode14_2_, this_.typedesc as typedesc14_2_, this_.prioritydesc as priority5_14_2_, this_.statusdesc as statusdesc14_2_, this_.resdesc as resdesc14_2_, this_.reporteddesc as reported8_14_2_, this_.vername as vername14_2_, this_.isstype as isstype14_2_, this_.isspriority as issprio11_14_2_, this_.priorityseq as priorit12_14_2_, this_.issstatus as issstatus14_2_, this_.issresolution as issreso14_14_2_, this_.reportedby as reportedby14_2_, this_.fixedinverid as fixedin16_14_2_, this_.summary as summary14_2_, this_.longdesc as longdesc14_2_, this_.created as created14_2_, this_.revised as revised14_2_, this_.issuekey as issuekey14_2_, this_.startdate as startdate14_2_, this_.duedate as duedate14_2_, this_.resolveddate as resolve24_14_2_, this_.closeddate as closeddate14_2_, this_.risklevel as risklevel14_2_, this_.issuevotes as issuevotes14_2_, this_.userdata1 as userdata28_14_2_, this_.userdata2 as userdata29_14_2_, this_.userdata3 as userdata30_14_2_, this_.percentcomplete as percent31_14_2_, this_.estimatedays as estimat32_14_2_, this_.estimatehours as estimat33_14_2_, this_.estimateminutes as estimat34_14_2_, this_.riskdesc as riskdesc14_2_, this_.isprivate as isprivate14_2_, this_.vernumber as vernumber14_2_, this_.verdesc as verdesc14_2_, this_.verorder as verorder14_2_, this_.verarchived as verarch40_14_2_, this_.verreleased as verrele41_14_2_, this_.tstamp as tstamp14_2_, comments1_.IssueID as IssueID__4_, comments1_.commentid as commentid4_, comments1_.commentid as commentid16_0_, comments1_.UserID as UserID16_0_, comments1_.IssueID as IssueID16_0_, comments1_.ProjID as ProjID16_0_, comments1_.Comment as Comment16_0_, comments1_.UserName as UserName16_0_, comments1_.IsPrivate as IsPrivate16_0_, comments1_.IsClosing as IsClosing16_0_, comments1_.created as created16_0_, comments1_.tstamp as tstamp16_0_, customfiel2_.IssueID as IssueID__5_, customfiel2_.customfielddataid as customfi1_5_, customfiel2_.customfielddataid as customfi1_23_1_, customfiel2_.customfieldid as customfi2_23_1_, customfiel2_.userid as userid23_1_, customfiel2_.projid as projid23_1_, customfiel2_.issueid as issueid23_1_, customfiel2_.fielddata as fielddata23_1_, customfiel2_.created as created23_1_, customfiel2_.tstamp as tstamp23_1_ 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 issueid14_2_, this_.projid as projid14_2_, this_.projcode as projcode14_2_, this_.typedesc as typedesc14_2_, this_.prioritydesc as priority5_14_2_, this_.statusdesc as statusdesc14_2_, this_.resdesc as resdesc14_2_, this_.reporteddesc as reported8_14_2_, this_.vername as vername14_2_, this_.isstype as isstype14_2_, this_.isspriority as issprio11_14_2_, this_.priorityseq as priorit12_14_2_, this_.issstatus as issstatus14_2_, this_.issresolution as issreso14_14_2_, this_.reportedby as reportedby14_2_, this_.fixedinverid as fixedin16_14_2_, this_.summary as summary14_2_, this_.longdesc as longdesc14_2_, this_.created as created14_2_, this_.revised as revised14_2_, this_.issuekey as issuekey14_2_, this_.startdate as startdate14_2_, this_.duedate as duedate14_2_, this_.resolveddate as resolve24_14_2_, this_.closeddate as closeddate14_2_, this_.risklevel as risklevel14_2_, this_.issuevotes as issuevotes14_2_, this_.userdata1 as userdata28_14_2_, this_.userdata2 as userdata29_14_2_, this_.userdata3 as userdata30_14_2_, this_.percentcomplete as percent31_14_2_, this_.estimatedays as estimat32_14_2_, this_.estimatehours as estimat33_14_2_, this_.estimateminutes as estimat34_14_2_, this_.riskdesc as riskdesc14_2_, this_.isprivate as isprivate14_2_, this_.vernumber as vernumber14_2_, this_.verdesc as verdesc14_2_, this_.verorder as verorder14_2_, this_.verarchived as verarch40_14_2_, this_.verreleased as verrele41_14_2_, this_.tstamp as tstamp14_2_, comments1_.IssueID as IssueID__4_, comments1_.commentid as commentid4_, comments1_.commentid as commentid16_0_, comments1_.UserID as UserID16_0_, comments1_.IssueID as IssueID16_0_, comments1_.ProjID as ProjID16_0_, comments1_.Comment as Comment16_0_, comments1_.UserName as UserName16_0_, comments1_.IsPrivate as IsPrivate16_0_, comments1_.IsClosing as IsClosing16_0_, comments1_.created as created16_0_, comments1_.tstamp as tstamp16_0_, customfiel2_.IssueID as IssueID__5_, customfiel2_.customfielddataid as customfi1_5_, customfiel2_.customfielddataid as customfi1_23_1_, customfiel2_.customfieldid as customfi2_23_1_, customfiel2_.userid as userid23_1_, customfiel2_.projid as projid23_1_, customfiel2_.issueid as issueid23_1_, customfiel2_.fielddata as fielddata23_1_, customfiel2_.created as created23_1_, customfiel2_.tstamp as tstamp23_1_ 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.