000011629 - Layout tab flashes and goes blank - RSA Archer

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.

 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
FROM [dbo].[tblIVLayoutTab] lt
JOIN dbo.tblIVLayoutModule AS lm ON lt.layout_module_id = lm.layout_module_id
WHERE module_id = xxx

 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
DECLARE @ModuleId INT
SET @LayoutTabId =xxx (general)
SET @moduleId = xxx
/**************************************
--Script Name
move layout objects to available.sql

--Author
jo

--Date
20120120

--Purpose
This script moves layout objects to the available tab to allow the user edit the
module layout when too many objects
 cause a refresh overflow

--Versions Supported
SQL2005,SQL2008,SQL2008R2
5.x

--Instructions
a.  Backup the database this script will be executed on.

b.  Change the @moduleId to the module_id you wish to process.  (this can be
obtained by looking up the name of the questionnaire in tblModule)

c.  Run the entire script to update the data.

--WARNINGS
This script is irreversible and would require a database restore to recover from
errors.
There is no history of these changes that is kept.

DO NOT CHANGE ANYTHING BELOW THIS LINE.
**************************************/
DECLARE @counter INT
SET @counter =0

DECLARE @section TABLE (rowno INT IDENTITY(1,1),section_id int)
DECLARE @availableSection INT

SELECT @availableSection = layout_section_id FROM dbo.tblIVLayoutSection AS ls
JOIN dbo.tblIVLayoutTab AS lt2 ON ls.layout_tab_id = lt2.layout_tab_id
JOIN dbo.tblIVLayoutModule AS lm ON lt2.layout_module_id = lm.layout_module_id
WHERE lm.module_id = @moduleId
AND layout_tab_type_id = 3
--518

INSERT INTO @section (section_id)
SELECT ls.layout_section_id
FROM dbo.tblIVLayoutSection AS ls
WHERE ls.layout_tab_id = @layoutTabId
ORDER BY ls.order_num DESC

WHILE (SELECT COUNT(lo.layout_obj_id) FROM dbo.tblIVLayoutObject lo
JOIN @section s ON lo.layout_section_id = s.section_id) > 130

BEGIN
SET @counter = @counter +1

SELECT layout_section_name, layout_obj_name
FROM dbo.tblIVLayoutObject AS lo
JOIN dbo.tblIVLayoutSection AS ls ON lo.layout_section_id = ls.layout_section_id
JOIN @section AS s ON section_id = ls.layout_section_id
WHERE rowno = @counter

UPDATE lo
SET layout_section_id = @availableSection
FROM dbo.tblIVLayoutObject AS lo
JOIN @section AS s ON section_id = lo.layout_section_id
WHERE rowno = @counter

END

GO