000030062 - In RSA Archer 5.5 SP2, an Unexpected Error occurs when clicking the Navigation Menu tab from a Module in Application Builder

Document created by RSA Customer Support Employee on Aug 30, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000030062
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5 SP2 and newer
 
IssueAll Navigation Menu options for a particular module will stop functioning and throw an error: "An Unexpected Error Has Occurred..."
Error occurs when clicking the Navigation Menu tab from a Module in Application Builder
User-added image


The following exception is from the W3WP log:
<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
  <ApplicationData>
    <TraceData>
      <DataItem>
        <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
          <TraceIdentifier>Archer.Web</TraceIdentifier>
          <LogReferenceId>XXXXXX-XXXXXX-XXXX</LogReferenceId>
          <Description>[Arg_NullReferenceException]Arguments: Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30514.00&File=mscorlib.dll&Key=Arg_NullReferenceException</Description>
          <AppDomain>/LM/W3SVC/1/ROOT/RSAarcher-1-130677022254641842</AppDomain>
          <ContextData>
            <BaseUrl>XXXXXXXXXXXXX</BaseUrl>
            <PageId>module</PageId>
          </ContextData>
          <Exception>
            <ExceptionType>ArcherTech.Web.UI.ArcherException, ArcherTech.Web, Version=5.5.20001.1005, Culture=neutral, PublicKeyToken=null</ExceptionType>
            <Message>[Arg_NullReferenceException]Arguments: Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30514.00&File=mscorlib.dll&Key=Arg_NullReferenceException</Message>
            <Source>
            </Source>
            <StackTrace>
              at ArcherTech.SL.Common.DependencyManager.<>c_DisplayClassc.<OnCompleted>b_a()</StackTrace>
          </Exception>
        </TraceRecord>
      </DataItem>
    </TraceData>
  </ApplicationData>
</E2ETraceEvent>
CauseThe Navigation Menu item(s) is corrupt or pointing to reports that do not exist.
Resolution

The following SQL query will find/confirm the issue:


SELECT mt.module_name, ft.field_name, nmlt.nav_menu_link_type_name, mnmc.* FROM dbo.tblModuleNavMenuConfig AS mnmc
JOIN dbo.tblModuleTranslation AS mt ON mt.module_id = mnmc.module_id AND mt.is_default = 1
JOIN dbo.tblNavMenuLinkType AS nmlt ON nmlt.nav_menu_link_type_id = mnmc.nav_menu_link_type_id
LEFT JOIN dbo.tblReportBase AS rb ON mnmc.report_id = rb.report_base_id
LEFT JOIN dbo.tblFieldTranslation AS ft ON ft.field_id = mnmc.field_id AND ft.is_default = 1
WHERE rb.report_base_id IS NULL AND mnmc.report_id IS NOT NULL


The following SQL command will remove the incorrect references.  NOTE: Backup your Instance database before using and test in a lower environment.


UPDATE mnmc SET mnmc.report_id = NULL
FROM dbo.tblModuleNavMenuConfig AS mnmc
LEFT JOIN dbo.tblReportBase AS rb ON mnmc.report_id = rb.report_base_id
WHERE rb.report_base_id IS NULL AND mnmc.report_id IS NOT NULL

Attachments

    Outcomes