7.5.2 Activites and Calendar Page Error on upgraded db with many users and tons of data

[gmartinez]

We have upgraded a database to 7.5.2 WEB from 6.2 LAN. The db has alot of data, tons of users and teams as well. There are no customizations.

When we go to Activities or Calendar we get the following:

We're sorry, your request could not be completed.

More than one row with the given identifier was found: , for class: Sage.SalesLogix.Security.User

This is not happening on an Eval or Blank DB.

Here is the full stack trace:

http://slx752w:4001/SlxClient/ActivityManager.aspx More than one row with the given identifier was found: , for class: Sage.SalesLogix.Security.User at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Persister.Entity.AbstractEntityPersister.LoadByUniqueKey(String propertyName, Object uniqueKey, ISessionImplementor session) at NHibernate.Type.EntityType.LoadByUniqueKey(String entityName, String uniqueKeyPropertyName, Object key, ISessionImplementor session) at NHibernate.Type.EntityType.ResolveIdentifier(Object value, ISessionImplementor session, Object owner) at NHibernate.Engine.TwoPhaseLoad.InitializeEntity(Object entity, Boolean readOnly, ISessionImplementor session, PreLoadEvent preLoadEvent, PostLoadEvent postLoadEvent) at NHibernate.Loader.Loader.InitializeEntitiesAndCollections(IList hydratedObjects, Object resultSetId, ISessionImplementor session, Boolean readOnly) 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.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at Sage.Platform.NHibernateRepository.NHibernateRepository`1.FindAllImplGeneric() at Sage.Platform.NHibernateRepository.NHibernateRepository`1.Sage.Platform.Repository.IRepository.FindAll() at SmartParts_TaskPane_ActivityFilters.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at Sage.Platform.WebPortal.Workspaces.TaskPaneItem.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[RJLedger]

Suggest you call your BP and/or tech Support. There are a bunch of changes between 6.2.x and 7.5.2.

Did you apply every SalesLogix bundle (.sxb) required for the upgrade and follow the SalesLogix provided upgrade worksheet? 

Message Edited by RJLedger on 12-04-2009 02:47 PM

[jperona]

Gean,

I'll pass onto the team and see if we can get you a path to try.  Perhaps, run the SLXProfiler for the query

[mtamborini]

Run:
select UserName, AccountingUserID from USERINFO where AccountingUserID = ''

If there are results, run:
update USERINFO set AccountingUserID = NULL where AccountingUserID = ''


Fixed the problem in 7.5.2.