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

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

Article Content

Article Number000013737
Applies ToDefaultplatformlanguage and DefaultSolutionLangauge GUID and few other properties were not populated during the migration and update of databases. These settings are usually critical for Archer and ACP configuration to function correctly.
IssueUsers cannot login, unable to save certain Archer Control Panel fields like default instance and database settings and allow manual login
<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
    <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
        <EventID>3</EventID>
        <Type>3</Type>
        <SubType Name="Error">0</SubType>
        <Level>2</Level>
        <TimeCreated SystemTime="2013-12-25T16:19:59.0503867Z" />
        <Source Name="Archer.NET" />
        <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />
        <Execution ProcessName="w3wp" ProcessID="4448" ThreadID="16" />
        <Channel />
        <Computer>GRCAPWXR02</Computer>
    </System>
    <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>
 
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 in query results, the 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 guids for update from the tblPlatformLanguauge table for the above query.
 
Legacy Article IDa63630

Attachments

    Outcomes