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.




Corrupted project after batch edit.

web-app

This morning, one of our users did a batch edito of 4 issues where he changed the priority and risk level.

Upon committing the changes to Gemini an error message was display.  Now, we are unable to view any issues (as a list or in detail) for that project within Gemini.

Looking at the error log, every time someone tries to view issues for the project, an error is logged as follows:

"No row with the given identifier exists: -100, of class: CounterSoft.Gemini.Commons.ComponentEN

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.LoadCollection(ISessionImplementor session, Object id, IType type)
   at NHibernate.Loader.Collection.CollectionLoader.Initialize(Object id, ISessionImplemen"

We have been unable to see what might be causing this in the database so far.  The issue data itself seems to be intact.  Any suggestions would be appreciated.
mintGem
· 1 		mintGem
Monday, September 3, 2007, 7:17:00 AM
Replies (2)
helpful
0
not helpful

We have managed to fix the problem (hopefully).  Somehow, in the [issuecomponent] table, a record was added where the issueid was correct, but the componentid was "-100" (which of course doesn't exist in the [components] table).

To fix the problem, I changed the componentid to something valid.  This done, I was then able to view and edit issues in the project again via the Gemini WebUI.  All seems OK now.

Would appreciate it if someone could try to find out how this might have occured in the first place, and whether there might be something else that might also be corrupt that I haven't seen.

Thanks
mintGem
· 1 		mintGem
Monday, September 3, 2007, 7:36:23 AM
helpful
0
not helpful

This is an issue with 2.2.  Please upgrade to 2.2.1.

See: http://community.countersoft.com/forums/thread/5429.aspx
Mark Wing
· 9108 		Mark Wing
Monday, September 3, 2007, 10:19:45 AM