000037526 - RSA Archer: Dashboard missing in UI

Document created by RSA Customer Support Employee on Jun 4, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037526
Applies ToRSA Product Set: Archer
RSA Product/Service Type: RSA Archer (On-Premise)
RSA Version/Condition: 6.2x - 6.5.3
 
IssueDashboard does not show up in the user interface after an upgrade and was not deleted. This happens for any user, including system administrators
Attempting to create new dashboard results in duplicate name error. 
This is caused by dashboard deprecation in 6.2-6.5.3 (This was reported as fixed in 6.5.0.4)

 
CauseDefect, ARCHER-64594
Deprecated Dashboards Removed From UI on Save

This issue was caused by the new entity model created for the V2 API not including the deprecated or keep licensed flags. These flags were not included because they did not need to be passed to the UI. Because of this, when the entity model for the solution detail was converted to the model used by the core on a solution save, those properties were not there and were defaulted to false.
 
ResolutionTo confirm the flags, execute the following query in the Archer instance database.
 

select * from tbldashboard


In the results, look for is_deprecated and keep_licensed flags to have a value of 0
Also, note the GUID

Insert the GUID in the script below, with the one for the missing dashboard, and execute it.
 

UPDATE TBLDASHBOARD 
SET 
IS_DEPRECATED = 1, 
KEEP_LICENSED = 1 
WHERE GUID = 'INSERTGUIDHERE'


Manual database backup prior to all direct database changes is highly recommended.

Attachments

    Outcomes