Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 3
Registered: ‎01-17-2013

login error in Application Architecture SLX 8.0

I'm new to SalesLogix and I am getting an error when trying to login to the Application Architecture in SalesLogix 8. 

 

I forgot that the default for this one is admin with no password and tried to use 'password' and apparently did too many attempts to login and now I am locked out with this error:

 

userprofil3_.ASSETDESC as ASSETDESC12_1_, userprofil3_.ASSETID as ASSETID12_1_, userprofil3_.BIRTHDATE as BIRTHDATE12_1_, userprofil3_.CREATEDATE as CREATEDATE12_1_, userprofil3_.CREATEUSER as CREATEUSER12_1_, userprofil3_.EMPLOYEENUMBER as EMPLOYEE7_12_1_, userprofil3_.HIREDATE as HIREDATE12_1_, userprofil3_.MODIFYDATE as MODIFYDATE12_1_, userprofil3_.MODIFYUSER as MODIFYUSER12_1_, userprofil3_.NOTES as NOTES12_1_, userprofil3_.SPOUSE as SPOUSE12_1_, userprofil3_.SSN as SSN12_1_, userprofil3_.USERDATE1 as USERDATE14_12_1_, userprofil3_.USERDATE2 as USERDATE15_12_1_, userprofil3_.USERDATE3 as USERDATE16_12_1_, userprofil3_.USERDATE4 as USERDATE17_12_1_, userprofil3_.USERDATE5 as USERDATE18_12_1_, userprofil3_.USERNUM1 as USERNUM19_12_1_, userprofil3_.USERNUM2 as USERNUM20_12_1_, userprofil3_.USERNUM3 as USERNUM21_12_1_, userprofil3_.USERNUM4 as USERNUM22_12_1_, userprofil3_.USERNUM5 as USERNUM23_12_1_, userprofil3_.USERTEXT1 as USERTEXT24_12_1_, userprofil3_.USERTEXT2 as USERTEXT25_12_1_, userprofil3_.USERTEXT3 as USERTEXT26_12_1_, userprofil3_.USERTEXT4 as USERTEXT27_12_1_, userprofil3_.USERTEXT5 as USERTEXT28_12_1_ FROM USERSECURITY this_ left outer join USERINFO userinfo2_ on this_.USERID=userinfo2_.USERID left outer join USERPROFILE userprofil3_ on this_.USERID=userprofil3_.USERID WHERE upper(this_.USERCODE) = ?] (NHibernate)

------------------------------ Program Location:

   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.UniqueResult[T]()    at NHibernate.Criterion.QueryOver`1.SingleOrDefault()    at NHibernate.Criterion.QueryOver`1.NHibernate.IQueryOver<TRoot>.SingleOrDefault()    at Sage.SalesLogix.Windows.SLXAuthenticationProvider.PerformAuthentication()    at Sage.SalesLogix.Windows.SLXAuthenticationProvider.Authenticate()    at Sage.Platform.Application.ApplicationContext.Initialize(String applicationId, ApplicationConfiguration appConfig)    at Sage.Platform.Client.Windows.Program.Main(String[] args)

===================================

Invalid column name 'FAILEDATTEMPTDATE'. : Invalid column name 'LOGINATTEMPTS'. (SalesLogix OLE DB Provider)

------------------------------ Program Location:

   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)    at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)    at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)    at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)    at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)    at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)    at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader()    at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)    at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, 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.DoList(ISessionImplementor session, QueryParameters queryParameters)

 

I have tried to find information on this error, but no luck so far.   Can anyone point me in the correct direction or give me some advice on how to fix this issue?

 

Thanks so much!

 

kelly

Employee
Posts: 629
Registered: ‎04-24-2009

Re: login error in Application Architecture SLX 8.0

The FAILEDATTEMPTDATE and LOGINATTEMPTS fields are new to 8.0 for the USERSECURITY table. You are either attempting to connect to a database that has not been upgraded to 8.0 or you're database did not upgrade correctly.

 

Thanks

 

Mike