000013737 - Users cannot login, unable to save certain Archer Control Panel fields like default instance and database settings and allow manual login in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 22, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000013737
Applies ToRSA Product Set: Archer
IssueDefault 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



 
NotesBased on query results, Languages need to be updated.

Note in this case the languages found in the queries were 7 and 8. If the results from the select queries show other language ids, you will need to get the guide for update from the tblPlatformLanguauge table for the above query.
 
Legacy Article IDa63630

Attachments

    Outcomes