Issue | Default platform language and Default Solution Langauge GUID and few other properties were not populated during the migration and update of databases. These settings are usually critical for RSA Archer and ACP configuration to function correctly. Users cannot login, unable to save certain Archer Control Panel fields like default instance and database settings and allow manual login
{Code} <ApplicationData> <TraceData> <DataItem> <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"> <TraceIdentifier>Archer.NET</TraceIdentifier> <Description>No Licensed Platform langauges available, cannot continue with login</Description> <AppDomain>/LM/W3SVC/1/ROOT/RSAarcher-1-130324619671521972</AppDomain> <Exception> <ExceptionType>System.InvalidOperationException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>No Licensed Platform langauges available, cannot continue with login</Message> <Source>ArcherTech.Kernel</Source> <StackTrace> at ArcherTech.Kernel.Brokers.AuthenticationHelper.LoadLanguageAndPlatformLanguage(InternalSessionContext internalSessionContext, UserConfig userConfig) at ArcherTech.Kernel.Brokers.SessionContextBroker.LoadExtendedSessionContext(String instanceName, String sessionToken, ISessionContextDataSource sessionContextDataSource) at ArcherTech.Kernel.Brokers.SessionContextBroker.Create(String instanceName, UserLogin userLogin, Boolean isImpersonating) at ArcherTech.Kernel.Brokers.AuthenticationBroker.Login(AuthenticationRequest request)</StackTrace> </Exception> </TraceRecord> </DataItem> </TraceData> </ApplicationData> </E2ETraceEvent> {Code}
|
Resolution | -- Run against Archer INSTANCE database. Checks for language licensing.
select t.license_object_name, o.* from tblLicensedObject o join tblLicensedObjectType t on o.license_object_type_id = t.license_object_type_id where o.license_object_type_id in (7,8) order by guid -- Run against Archer CONFIGURATION database. Checks for language licensing.
select * from tblProperty where property_key like '%languageguid%' order by property_value
-- Run this on the Archer INSTANCE database. Updates language license information.
INSERT INTO tblLicensedObject values(1,NULL,'87556750-B54E-4AD0-A4FE-0D64B1E8DC5C',7,'2020-01-01 00:00:00.000','2012-07-09 16:21:09.373',184), (1,NULL,'9088EF11-366B-47BD-8462-A7A5CB0F753B',8,'2020-01-01 00:00:00.000','2012-07-09 16:21:09.373',184)If other languages, look forthe guids in
|