editing issue (including custom fields)

web-app

Dear support, we have a problem with particualr issue(s), unable to edit - update ( unrelated to version of Gemini - we are using 3.1.1(Build 2212) or 3.7( latest)) Attached is error from Gemini log:

Internal Query Processor Error: The query processor encountered an unexpected error during execution. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) at NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) at NHibernate.Persister.Entity.AbstractEntityPersister.Delete(Object id, Object version, Int32 j, Object obj, SqlCommandInfo sql, ISessionImplementor session, Object[] loadedState)

and error from windows LOG:

Event code: 3005 Event message: An unhandled exception has occurred. Event time: 6/22/2010 12:33:50 PM Event time (UTC): 6/22/2010 10:33:50 AM Event ID: 25c6116574af4e48bb5764798a9be4a6 Event sequence: 25 Event occurrence: 1 Event detail code: 0

Application information: Application domain: /LM/W3SVC/2/ROOT/Gemini-1-129216763398760655 Trust level: Full Application Virtual Path: /Gemini Application Path: C:\Program Files (x86)\CounterSoft\CounterSoft Gemini Issue Tracker\Gemini Web Application\ Machine name: UCMS0-1027

Process information: Process ID: 3892 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE

Exception information: Exception type: GenericADOException Exception message: could not delete: [CounterSoft.Gemini.Commons.Entity.IssueComponentEN#9529][SQL: DELETE FROM gemini_issuecomponents WHERE issuecomponentid = ?]

Request information: Request URL: https://10.255.250.27:8089/gemini/issue/Issue.aspx?ID=3874&PROJID=20 Request path: /gemini/issue/Issue.aspx User host address: 10.255.251.25 User: nesha.besirevic Is authenticated: True Authentication Type: Forms Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information: Thread ID: 10 Thread account name: NT AUTHORITY\NETWORK SERVICE Is impersonating: False Stack trace: at CounterSoft.Gemini.DataProvider.xc0186e148e957052.x866c830be02497b1(Int32 x663e02d322c995c9) at CounterSoft.Gemini.Business.x95da312ae9372c2e.x3b4f005d8d7ca70c(Int32 x663e02d322c995c9, IssueComponentEN[] x8b5f7395e70920d3) at CounterSoft.Gemini.Business.x95da312ae9372c2e.xe6c068ecd01330f5(IssueEN x22c77d60925997e9, Int32 xdf6548ad179b4d83, Boolean xcbecc09e33c13ebd) at CounterSoft.Gemini.Web.Controls.IssueUC.UpdateIssue() at CounterSoft.Gemini.Web.Controls.IssueUC.btnAction_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

Event Xml: 1309 3 3 0x80000000000000 13865 Application UCMS0-1027.ad.quinyx.com 3005 An unhandled exception has occurred. 6/22/2010 12:33:50 PM 6/22/2010 10:33:50 AM 25c6116574af4e48bb5764798a9be4a6 25 1 0 /LM/W3SVC/2/ROOT/Gemini-1-129216763398760655 Full /Gemini C:\Program Files (x86)\CounterSoft\CounterSoft Gemini Issue Tracker\Gemini Web Application\ UCMS0-1027 3892 w3wp.exe NT AUTHORITY\NETWORK SERVICE GenericADOException could not delete: [CounterSoft.Gemini.Commons.Entity.IssueComponentEN#9529][SQL: DELETE FROM geminiissuecomponents WHERE issuecomponentid = ?] https://10.255.250.27:8089/gemini/issue/Issue.aspx?ID=3874&PROJID=20 /gemini/issue/Issue.aspx 10.255.251.25 nesha.besirevic True Forms NT AUTHORITY\NETWORK SERVICE 10 NT AUTHORITY\NETWORK SERVICE False at CounterSoft.Gemini.DataProvider.xc0186e148e957052.x866c830be02497b1(Int32 x663e02d322c995c9) at CounterSoft.Gemini.Business.x95da312ae9372c2e.x3b4f005d8d7ca70c(Int32 x663e02d322c995c9, IssueComponentEN[] x8b5f7395e70920d3) at CounterSoft.Gemini.Business.x95da312ae9372c2e.xe6c068ecd01330f5(IssueEN x22c77d60925997e9, Int32 xdf6548ad179b4d83, Boolean xcbecc09e33c13ebd) at CounterSoft.Gemini.Web.Controls.IssueUC.UpdateIssue() at CounterSoft.Gemini.Web.Controls.IssueUC.btnActionClick(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Strange is that most issues can be updated

I hope receiving some tips....

nesha · 1
Tuesday, June 22, 2010, 12:50:13 PM

Replies (6)

Which version of SQL server are you running? Is it possible for you to run SQL profiler to catch the exact SQL that the delete is running?

Mark Wing · 9108
Tuesday, June 22, 2010, 1:16:52 PM

V3.1.1 runs on Win 2003 latest SP with SQL 2005 latest SP V3.7 runs on Windows 2008 latest SP with SQL 2008 latest SP

I would like to include whole trace file ( but I cannot find a way to upload :( )

nesha · 1
Tuesday, June 22, 2010, 2:31:36 PM

Please send all files to support at countersoft dot com

Mark Wing · 9108
Tuesday, June 22, 2010, 2:39:26 PM

Some catched trace:

exec spexecutesql N'SELECT issuecomme0.issueid as issueid1, issuecomme0.commentid as commentid1, issuecomme0.commentid as commentid390, issuecomme0.userid as userid390, issuecomme0.issueid as issueid390, issuecomme0.projectid as projectid390, issuecomme0.comment as comment390, issuecomme0.username as username390, issuecomme0.isclosing as isclosing390, issuecomme0.visibility as visibility390, issuecomme0.visibilitymembertype as visibili9390, issuecomme0.created as created390, issuecomme0.tstamp as tstamp390_ FROM geminiissuecomments issuecomme0 WHERE issuecomme0_.issueid=@p0',N'@p0 int',@p0=3874

and

exec spexecutesql N'UPDATE geminiissues SET projectid = @p0, issuetypeid = @p1, issuepriorityid = @p2, issueseverityid = @p3, issuestatusid = @p4, issueresolutionid = @p5, reportedby = @p6, fixedinversionid = @p7, summary = @p8, longdesc = @p9, revised = @p10, startdate = @p11, duedate = @p12, resolveddate = @p13, closeddate = @p14, issuerisklevelid = @p15, userdata1 = @p16, userdata2 = @p17, userdata3 = @p18, percentcomplete = @p19, estimatedays = @p20, estimatehours = @p21, estimateminutes = @p22, visibility = @p23, visibilitymembertype = @p24, parentissueid = @p25, originatortype = @p26, originatorreply = @p27, originatordata = @p28, originatorprocessed = @p29 WHERE issueid = @p30',N'@p0 int,@p1 int,@p2 int,@p3 int,@p4 int,@p5 int,@p6 int,@p7 int,@p8 nvarchar(39),@p9 nvarchar(409),@p10 datetime,@p11 datetime,@p12 datetime,@p13 datetime,@p14 datetime,@p15 int,@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(4000),@p19 int,@p20 int,@p21 int,@p22 int,@p23 int,@p24 int,@p25 int,@p26 int,@p27 int,@p28 nvarchar(4000),@p29 datetime,@p30 int',@p0=20,@p1=24,@p2=1,@p3=5,@p4=11,@p5=15,@p6=99,@p7=NULL,@p8=N'Automatic Names Declination - Hungarian',@p9=N'Functionality is required to automatically generate declination forms for names of people for languages that have case declination. This is Hungarian specific',@p10='2010-06-22 14:36:18',@p11='2010-06-01 00:00:00',@p12=NULL,@p13=NULL,@p14=NULL,@p15=1,@p16=N'',@p17=N'',@p18=N'',@p19=0,@p20=0,@p21=0,@p22=0,@p23=1,@p24=2,@p25=NULL,@p26=0,@p27=0,@p28=NULL,@p29=NULL,@p30=3874

and

exec spexecutesql N'DELETE FROM geminiaffectedversions WHERE affectedversionid = @p0',N'@p0 int',@p0=3060

nesha · 1
Tuesday, June 22, 2010, 2:43:18 PM

Trace is send on email as requested

nesha · 1
Tuesday, June 22, 2010, 2:54:27 PM

Thanks a lot Finally we sorted out issue following your advices - database tables were corrupted

nesha · 1
Tuesday, June 22, 2010, 6:13:43 PM

Gemini Community Support Site

editing issue (including custom fields)