Article Content
Article Number | 000011629 |
Applies To | RSA Archer 5.X |
Issue | If the layout tab flashes and goes blank , there are too many fields on the layout. In order to move the fields off the layout so that you can access the layout, you will have to move a few fields/sections off the layout by following the below steps: NOTE: Make a complete backup of the database before running the below steps. Layout tab of an application/builder goes blank in the application builder. |
Resolution | 1. Run the below script to get the module ID: select * from tblModule where module_name = ?Questionnaire/ApplicationName? 1. Run the below Query to get the layouttabid by using the result from above and note down the number for ?General?: SELECT layout_tab_id, layout_tab_name 1. Now specify the module ID and the Genera tab id in the below script. This will move the sections off the layout and will allow you to access it from the front end. DECLARE @layoutTabId INT --Author --Date --Purpose --Versions Supported --Instructions b. Change the @moduleId to the module_id you wish to process. (this can be c. Run the entire script to update the data. --WARNINGS DO NOT CHANGE ANYTHING BELOW THIS LINE. DECLARE @section TABLE (rowno INT IDENTITY(1,1),section_id int) SELECT @availableSection = layout_section_id FROM dbo.tblIVLayoutSection AS ls INSERT INTO @section (section_id) WHILE (SELECT COUNT(lo.layout_obj_id) FROM dbo.tblIVLayoutObject lo BEGIN SELECT layout_section_name, layout_obj_name UPDATE lo END GO |
Legacy Article ID | a66986 |