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.
  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.