Style Sheet Integrity

The following table describes the audit queries and resolutions for this area:

Query Description Resolution

STYLESHEET-1

Orphaned free form style sheet data.

Issue the following SQL to remove the orphaned rows: 

DELETE * FROM PSCONTDEFN
WHERE CONTTYPE = 9 AND
CONTNAME = %1;
DELETE * FROM PSCONTENT
WHERE CONTTYPE = 9 AND
CONTNAME = %1;
DELETE * FROM PSCONTDEFNLANG
WHERE CONTTYPE = 9 AND
CONTNAME = %1;
DELETE * FROM PSCONTENTLANG
WHERE CONTTYPE = 9 AND CONTNAME = %1;

STYLESHEET-2

Orphaned free form style sheet definitions.

Use Application Designer to delete the free form style sheet(s).

STYLESHEET-3

Parent style sheet not found.

Open the affected style sheet(s) in Application Designer. Remove the reference to the nonexistent parent in the Parent Style Sheet dropdown on the Style Sheet Properties dialog box.

STYLESHEET-04

Sub Style Sheet not found.

Use Application Designer to delete references to any missing sub style sheets.