000034249 - From Manage Sub-Forms, the RSA Archer Sub-Form Name is not clickable and unable to open Sub-Form after upgrade to 6x

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

Article Content

Article Number000034249
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: All
IssueFrom the Manage Sub-Forms list, the Sub-Form Name appears without an underline and is not clickable in 6x after an upgrade. The Edit button is missing from Actions column.
User-added image
CauseThe Sub-Forms are marked as "unlicensed" in the Instance database. (sytem=1 in tblModule) This did not affect anything in 5x but affects packaging in 6x.
Sub-Forms do not need to be licensed and all of them should be available for Edit.
Resolution
  1. Open SQL Server Management Studio and run the following SQL query to identify/confirm the Sub-Forms affected:
    SELECT * FROM tblModule WHERE module_type_id = 5 AND system <> 0

  2. Perform a SQL Backup of the Instance database.
  3. Run the following SQL statement to correct the Sub-Forms:
    UPDATE tblModule SET system = 0 WHERE module_type_id = 5 and system=1

  4. View the Manage Subforms workspace and verify that all subforms are fixed.
NotesThis will also resolve some packaging issues that get a licensing error.

Attachments

    Outcomes