| Issue | After updating Archer or performing a new install they are unable to log in to Archer with any account including sysadmin account and get the following error in Archer w3wp logs.
E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
<System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
<EventID>0</EventID>
<Type>3</Type>
<SubType Name="Error">0</SubType>
<Level>2</Level>
<TimeCreated SystemTime="2020-04-28T17:05:28.9187584Z" />
<Source Name="Archer.Web" />
<Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />
<Execution ProcessName="w3wp" ProcessID="856" ThreadID="16" />
<AssemblyVersion>6.7.201.1004</AssemblyVersion>
<Channel />
<Computer>XXXXXXX</Computer>
</System>
<ApplicationData>
<TraceData>
<DataItem>
<TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
<TraceIdentifier>Archer.Web</TraceIdentifier>
<LogReferenceId>042820-170528-9177</LogReferenceId>
<Description>Login failed for user ''DOMAIN\XXServerNameXX'.
SQL statement: usp_get_ldap_config_list </Description>
<AppDomain>/LM/W3SVC/1/ROOT-1-132325671033049729</AppDomain>
<Exception>
<ExceptionType>ArcherTech.Kernel.Providers.Data.ArcherDbException, ArcherTech.Kernel.Providers, Version=6.7.201.1004, Culture=neutral, PublicKeyToken=null</ExceptionType>
<Message>Login failed for user 'DOMAIN\XXServerNameXX'.
SQL statement: usp_get_ldap_config_list </Message>
<Source>ArcherTech.Kernel.Providers</Source>
<StackTrace> at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.WrapDatabaseCall(DbCommand command, Action methodToWrap)
at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.ExecuteReader(DbCommand command)
at ArcherTech.Kernel.DataSource.Db.DataSourceBase.PopulateIds[T](DbCommand command, Func`2 mapDelegate)
at ArcherTech.Kernel.DataSource.Db.UserDataSource.GetAllDomainIds()
at ArcherTech.Kernel.Brokers.SessionlessBroker.GetDomains(Boolean filterDeletedDomains)
at ArcherTech.Kernel.Utility.ManagerHelper.WrapCode[T](ManagerEventIdentifier managerEventId, String instance, ManagerMethodWrapper`1 wrapped)
at ArcherTech.Kernel.Managers.UserManager.GetDomains(String instanceName, Boolean filterDeletedDomains)
at ArcherTech.Web.Modules.Foundation.Views.DefaultPresenter.LoadDomainList()
at ArcherTech.Web.Modules.Foundation.Views.DefaultPresenter.OnViewLoaded()
at ArcherTech.Web.ArcherTechPage`2.OnLoad(EventArgs e)
at Security2000.Default.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</StackTrace>
</Exception>
</TraceRecord>
</DataItem>
</TraceData>
</ApplicationData>
</E2ETraceEvent>
|
on Jul 1, 2020