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.




changing to custom status gives unexpected row count error

web-app

Hi,

We just migrated our old gemini to the new 2.1. I used the sql script process to do the upgrade because our system was older then even 1.7.

In the old database we had created a custom status type of "completed" which is set to go before closed. When ever any user changes a ticket to the "completed" status we get this error, but the status does get changed.

I do not  see any duplicate rows...? I only have one status set as the last one...

Any ideas????

Server Error in '/Gemini' Application.

Unexpected row count: 2; expected: 1

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: NHibernate.AdoNet.TooManyRowsAffectedException: Unexpected row count: 2; expected: 1

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:

[TooManyRowsAffectedException: Unexpected row count: 2; expected: 1]
   CounterSoft.Gemini.DataProvider.BaseProvider.x097cc82acf165ae9(BaseEN x6fcb9c1c812a0558) +61
   CounterSoft.Gemini.DataProvider.IssueProvider.xe6c068ecd01330f5(IssueEN x22c77d60925997e9) +72
   CounterSoft.Gemini.Business.x95da312ae9372c2e.xe5c7612fb35da3f2(Int32 x663e02d322c995c9, Int32 xe45a6f32b1c688f5, Int32 xdf6548ad179b4d83, Int32 xa8708020b9a21a3a) +435
   CounterSoft.Gemini.ViewIssue.lnkUpdateStatus_Click(Object sender, EventArgs e) +91
   System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +107
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

digitalmek
· 1
digitalmek
Replies (4)
helpful
0
not helpful

Do you have SQL triggers on the tables?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

no triggers that I can see -- that was the first thing I checked based on another post that was about triggers...

I have found some additional information since this afternoon:

When I am under "viewissue.aspx" and I do "customize" I see two "Status" selections under the feilds I am able to choose.

When I go back to the viewissue.aspx page, I get two columns called status - one with the row id of the status, the other with the word version...

I can't see any duplicates in the database itself...not sure where else to look...

 

This only happens when the status of "completed" is chosen. no other status produces the error.

once you set the ticket to "completed", you get the error. if you refresh you find that the status has been sucessfully set to "completed", when you try to change it to anything else, you get the error, when you refresh the new status is present, changing to any other status at this point gives no error...

"Completed" it is one we had in our old database, and had to recreate in the upgraded one, it has the same unique line id as the old one (8) and the same word (completed). it has some work flow rules, but I have tried messing around with them to no avail...

It seems to me like somewhere in the code or a stored procedure somewhere is enumerating my status twice instead of once and throwing the error. I would be happy to add "nocount" but I see no triggers and don't know where else to add it....

 

I have a few screen shots of the duplicate "status' feilds but I can't seem to attach them...

 

 

 


digitalmek
· 1
digitalmek
helpful
0
not helpful

Can yo please send images and database tables (status tables) to support@countersoft.com?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

thanks - I have just sent them now...

 


digitalmek
· 1
digitalmek