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.




Error trying to click "All projects issue reporting" link

web-app

When I click the "All projects issue reporting" link on the home page, I get the following error consistently  Also get the same error when I try to click any "Road Map" link:

Error Message: No row with the given identifier exists: 8, of class: CounterSoft.Gemini.Commons.UserEN

Stack Trace:

SOURCE: NHibernate
TARGETSITE: Void ThrowIfNull(System.Object, System.Object, System.Type)
STACKTRACE:    at NHibernate.UnresolvableObjectException.ThrowIfNull(Object o, Object id, Type clazz)
   at NHibernate.Impl.SessionImpl.InternalLoad(Type clazz, Object id, Boolean eager, Boolean isNullable)
   at NHibernate.Type.EntityType.ResolveIdentifier(Object id, ISessionImplementor session)
   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.Lo
KevinBr
· 1 		KevinBr
Wednesday, March 28, 2007, 5:09:18 PM
Replies (6)
helpful
0
not helpful

Please check that you do not have user ids (8) in the issues table that does not exist in the users table.
Mark Wing
· 9108 		Mark Wing
Wednesday, March 28, 2007, 5:17:49 PM
helpful
0
not helpful

I did delete users this morning and so it would appear to be the cause.  I instead the user back into the user table with the same id of 8 and everything worked again.

Needless to say, its a pretty big bug to provide me with a delete button in the User Admin GUI and have the program break when I use it.  The Delete button shouldn't really delete the physical record, but should disable their access and prevent the user from being used for any new projects/resources, etc but still available for report history.  At a bare miminum, the User Admin GUI should check to see if deleting a user would break the program and prevent the delete if so.
KevinBr
· 1 		KevinBr
Wednesday, March 28, 2007, 11:51:49 PM
helpful
0
not helpful

This issue has been seen by other users but we can not seem to replicate it.

We can delete users with no exceptions at all.

Is it possible to get a backup of your database sent to us? (support@countersoft.com)
Saar Cohen
· 5000 		Saar Cohen
Thursday, March 29, 2007, 12:06:50 AM
helpful
0
not helpful

We think we have found the issue. It is to do with time entries.

When we delete users we do not delete their time entries as these need to be kept.

We are fixing it and a new release, 2.1.1 is due very soon.
Saar Cohen
· 5000 		Saar Cohen
Thursday, March 29, 2007, 12:36:12 AM
helpful
0
not helpful

Okay, great!  After I upgrade to the new release and know the fix is in there, I'll try to delete this user again.  If I delete userid 8, and issues are still marked as being assigned to or reportedby userid 8, what is doing to display in the GUI when I look at that issue?  Blank?

I would still like to see for some future release that when a user is "deleted", their record is not physically deleted but rather just marked as deleted and essentially hidden from most if not all of the GUI.  The "deleted" user shouldn't be able to login, or be available or visible to assigned as a resource, but still be able to display their name when viewing an old issue they were involved with.
KevinBr
· 1 		KevinBr
Thursday, March 29, 2007, 1:14:04 AM
helpful
0
not helpful

The delete function will delete the user from the table and reset the assigned to. So yes, you will see blanks.

However, we are looking into adding an "inattive" option that will do what you are describing.
Saar Cohen
· 5000 		Saar Cohen
Thursday, March 29, 2007, 8:54:58 PM