Article Number | 000034249 |
Applies To | RSA Product Set: Archer RSA Product/Service Type: Archer RSA Version/Condition: All |
Issue | From 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.
 |
Cause | The 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 | - 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 - Perform a SQL Backup of the Instance database.
- Run the following SQL statement to correct the Sub-Forms:
UPDATE tblModule SET system = 0 WHERE module_type_id = 5 and system=1 - View the Manage Subforms workspace and verify that all subforms are fixed.
|
Notes | This will also resolve some packaging issues that get a licensing error. |