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.




How to remove extra users?

admin

We are still in the trial of the 3-user version. Someone has added more than the permitted number of users.

It now looks as if some changes can no longer be made. This means that we can't delete the extra users.

How do we do that?

OldGrantonian
· 200
OldGrantonian
Replies (8)
helpful
0
not helpful

Go to Customize -> People -> Users and delete the extra users.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

As I mentioned in my original post, we can't delete the users.

The popup dialog asks "Delete X from Gemini Yes/No?"

When I click "Yes", nothing actually happens.

If I close and re-open Gemini, the users are still not deleted.


OldGrantonian
· 200
OldGrantonian
helpful
0
not helpful

That's fine as the user is associated with items. They should be marked as inactive which is not counted towards the license.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

How do I find out what items, or modifications, or whatever, are associated with the extra users?

We don't have many items in the database, so I can delete any associated items, then re-insert them after the extra users have been deleted.


OldGrantonian
· 200
OldGrantonian
helpful
0
not helpful

Use the filter to check which items they have created or are assigned to.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

The filters show something that is obvious: no items have been assigned. That's because I'm still gathering legacy stuff from Excel spreadsheets on SharePoint sites.

For created items, I know that each item has a "History" that shows who created the item. But do I need to open 120 items, or can I create a filter to catch ALL items? If "Yes", how do I do that?

AFAIK, all items were created by "Manager Person".


OldGrantonian
· 200
OldGrantonian
helpful
0
not helpful

Check the system log for errors please.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

If I try to delete one of the extra users, I get the following error in the system log:

The DELETE statement conflicted with the REFERENCE constraint "geminiprojectaudituseridfk". The conflict occurred in database "Gemini", table "dbo.geminiprojectaudit", column 'userid'. The statement has been terminated.[SQL: SQL not available] NHibernate at NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps) at NHibernate.AdoNet.AbstractBatcher.ExecuteBatch() at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) at NHibernate.Impl.SessionImpl.Flush() at Countersoft.Foundation.Data.Repository2.Evict(T entity) at Countersoft.Foundation.Data.Repository2.Delete(Int32 id) at Countersoft.Gemini.Infrastructure.Managers.BaseManager4.Delete(Int32 id) at Countersoft.Gemini.Models.Admin.PeopleUsersModelBuilder.DeleteAction(Int32 id) at Countersoft.Gemini.Controllers.Ajax.AjaxAdminController.DeleteAction(String tab, String subTab, Int32 id) at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.<>cDisplayClass39.b33() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass4f.b49() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass37.b36(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass25.<>cDisplayClass2a.b20() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass25.b22(IAsyncResult asyncResult) at System.Web.Mvc.Controller.<>cDisplayClass1d.b18(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.Mvc.MvcHandler.<>cDisplayClass8.b3(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.<>cDisplayClass4.b3(IAsyncResult ar) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


OldGrantonian
· 200
OldGrantonian