Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Super Contributor
Posts: 29
Registered: ‎05-01-2009

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

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)
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

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

[ Edited ]

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
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Moderator
Posts: 440
Registered: ‎05-07-2008

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

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

John Perona

Director, Infor CRM Development

Infor CRM

Infor CRM

Bronze Super Contributor
Posts: 176
Registered: ‎04-28-2009

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

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.
---------------------------
Ambit AG, Switzerland