000033536 - RSA Archer Sub-Form records show red banner stating: This application is in a Development status. It is not licensed for Production

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

Article Content

Article Number000033536
Applies ToRSA Product Set: Archer
RSA Version/Condition: All
IssueHow to change the Status for a Sub-Form? 
Sub-Form records show red banner stating:
This application is in a Development status. It is not licensed for Production.
From Manage Sub-Forms, open a Sub-Form, but there is not a Status option on the General tab like an Application or Questionnaire.
Note: Questionnaire containing Sub-Form is in “Production” status too
Sample Image when creating a new Sub-Form record:
User-added image
Resolution
  1. From Manage Sub-Forms, hover the mouse over the Sub-Form Name. 
  2. In the bottom-right corner, the Id will be shown. 
  3. Run the following SQL query against the Instance database to confirm the status_id value after replacing ### with the number from step 2.
    SELECT status_id, * FROM tblModule WHERE module_id = ###

  4. If the status_id value is set to 0 (which is Development), then this confirms the issue. 
  5. To fix, run the following SQL query against the Instance database after replacing ### with the number from step 2.
    UPDATE tblModule SET status_id = 1 WHERE module_id = ###

Attachments

    Outcomes