Related Content Integrity

The following table describes the audit queries and resolutions for the PeopleSoft Related Content:

Query Description Resolution

RELCONTENT-01

This audit verifies that the PSVERSION table contains the entries for the Related Content managed objects.

Run the VERSION Application Engine program to reset the PSVERSION and PSLOCK entry.

RELCONTENT-02

This audit verifies that the PSLOCK table contains the entries for the Related Content managed objects.

Run the VERSION Application Engine program to reset the PSVERSION and PSLOCK entry.

RELCONTENT-03

This audit lists all the missing service definitions required by the service configuration.

Use the Application Designer to import the missing Related Content Definitions into the target database.

RELCONTENT-04

This audit lists all the missing menu entries required by service configuration.

Sign on to PeopleTools using the browser, and make a change on the PeopleTools, and then Portal, and then Related Content Service, and then Manage Related Content Service and add missing menu metadata.

RELCONTENT-05

This audit lists all mapped fields that are not part of any service configuration.

Delete orphaned mapped fields with this SQL:

DELETE FROM PSPTCS_MAPFLDS A
WHERE A.PTCS_SERVICEID NOT IN
(SELECT B.PTCS_SERVICEID
FROM PSPTCSSRVCONF B)

RELCONTENT-06

This audit lists all the root folders that are not part of any menu.

Delete orphan folders:

DELETE FROM PSPTCS_MNUFLDRS A
WHERE A.PTCS_FOLDERID = A.PTCS_PRNT_FOLDERID
AND NOT EXISTS
(SELECT B.PTCS_FOLDERID  FROM  PSPTCS_MNULINKS B
WHERE A.PORTAL_NAME = B.PORTAL_NAME
AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME
AND A.PTCS_MENUID = B.PTCS_MENUID
AND A.PTCS_FOLDERID = B.PTCS_FOLDERID)

RELCONTENT-07

This audit lists all the menus with no folders.

Delete empty menus using this SQL:

DELETE FROM PSPTCS_MENU_TBL A
WHERE NOT EXISTS
(SELECT 'X'  FROM PSPTCS_MNUFLDRS B
WHERE A.PORTAL_NAME = B.PORTAL_NAME
AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME
AND A.PTCS_MENUID = B.PTCS_MENUID)

RELCONTENT-08

This audit lists all the missing application packages of service definitions.

Re-import the missing application packages using Application Designer.

RELCONTENT-09

This audit lists all the orphaned links.

Delete the orphaned links using this SQL:

DELETE FROM PSPTCS_MNULINKS A
WHERE A.PTCS_FOLDERID NOT IN
(SELECT B.PTCS_FOLDERID
FROM PSPTCS_MNUFLDRS B
WHERE A.PORTAL_NAME = B.PORTAL_NAME
AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME
AND A.PTCS_MENUID = B.PTCS_MENUID)

RELCONTENT-10

This audit lists all the orphaned folders.

Delete folders using this SQL:

DELETE FROM PSPTCS_MNUFLDRS A
WHERE A.PTCS_MENUID NOT IN
(SELECT B.PTCS_MENUID
FROM PSPTCS_MENU_TBL B
WHERE A.PORTAL_NAME = B.PORTAL_NAME
AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME)

RELCONTENT-11

This audit lists all menu entries pointing to nonexistent service configurations.

Delete menu entries, using this SQL:

DELETE FROM PSPTCS_MNULINKS A
WHERE NOT EXISTS
(SELECT 'X'
FROM PSPTCSSRVCONF B
WHERE A.PORTAL_NAME = B.PORTAL_NAME
AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME
AND A.PTCS_SERVICEID = B.PTCS_SERVICEID
AND A.PTCS_INSTANCEID = B.PTCS_INSTANCEID)

RELCONTENT-12

This audit lists missing application package PeopleCode for service definitions.

Use the Application Designer to re-import the missing application packages.

RELCONTENT-13

This audit lists all the menu links that are referring to service definitions that are not present in the database. This scenario occurs:

  • If service definitions are deleted but not the services using these service definitions.

  • While importing from a database project the service definition entries are missed out. In this case, importing the missing service definitions will resolve the issue.

Use the RCF_SERVICE_DEFINITIONS application data set to move a new service definition which is not included in a project.

Delete the orphaned menu links and folders using the following SQL:

DELETE FROM PSPTCSSRVCONF A 
WHERE A.PORTAL_NAME = <PORTAL_NAME> AND
A.PTCS_SERVICEID = <SERVICE_DEFN_ID>
DELETE FROM PSPTCS_MNULINKS A 
WHERE A.PORTAL_NAME = <PORTAL_NAME> AND
 A.PTCS_SERVICEID = <SERVICE_DEFN_ID>

RELCONTENT-14

This audit lists the menu links and folders which have no association to any menu layout because the related content framework objects were not deleted and exist with inconsistencies in the database. The audit may also lists menu links and folders if the corresponding menu layouts are not copied to the project in the database.

Move the related Menu Layouts using the RCF_MENU_LAYOUTS application data sets. These Menu links do not appear on the Contextual menu.

Delete the menu links and folders which have no association with any menu layout, using the following SQL:

DELETE FROM PSPTCS_MNULINKS A  
WHERE A.PORTAL_NAME     = <PORTAL_NAME>
AND  A.PORTAL_OBJNAME  = <PORTAL_OBJNAME>
AND  A.PTCS_MENUID     = <MENUID>

RELCONTENT-15

This audit lists all the Related Content Services that are not attached to any Content Reference. This can occur if the parent content reference is deleted from the Structure and Content page or a new content reference is created but not copied to the target database.

Find and delete orphaned related content data using the following SQL:

SELECT * FROM PSPTCS_SRVCFG AWHERE  A.PORTAL_NAME <> '_PTCS_PTPG' AND  NOT EXISTS (SELECT 'X' FROM PSPRSMDEFNWHEREPORTAL_REFTYPE  ='C' ANDPORTAL_NAME     = A.PORTAL_NAME ANDPORTAL_OBJNAME = A.PORTAL_OBJNAME)

If a new content reference is not copied to the target database then move the content reference using correct mechanism.