Feeds Integrity

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

Query Description Resolution

FEED-01

Feed referencing a nonexistent feed data type.

Remove the feed referencing the nonexistent feed data type from the feed definition table.

FEED-02

Feed data type Integration Broker operations table referencing a nonexistent feed data type.

Remove the Integration Broker operations referencing the nonexistent feed data type from the feed data type Integration Broker operations table.

Run the following SQL:

DELETE FROM PSFP_DTYPE_IBSO
WHERE PTFP_DATATYPE_ID='<DATATYPEID>'

FEED-03

Default feed attributes table referencing a nonexistent feed data type.

Remove the default feed attributes referencing the nonexistent feed data type from the default feed attributes table.

Run the following SQL:

DELETE FROM PSFP_DTYPE_ATTR
WHERE PTFP_DATATYPE_ID='<DATATYPEID>'

FEED-04

Feed attributes table referencing nonexistent feed.

Remove the feed attributes referencing the nonexistent feed from the feed attributes table.

Run the following SQL:

DELETE FROM PSFP_ATTRS
WHERE PTFP_FEED_ID='<FEEDID>'

FEED-05

Feed data source settings table referencing a nonexistent feed.

Remove the data source settings referencing the nonexistent feed from the feed data source settings table.

Run the following SQL:

DELETE FROM PSFP_SETTINGS
WHERE PTFP_FEED_ID='<FEEDID>'

FEED-06

Feed data source parameters table referencing a nonexistent feed.

Remove the data source parameters referencing the nonexistent feed from the feed data source parameters table.

Run the following SQL:

DELETE FROM PSFP_PARMS
WHERE PTFP_FEED_ID='<FEEDID>'

FEED-07

Feed security table referencing a nonexistent feed.

Remove the feed security referencing the nonexistent feed from the feed security table.

Run the following SQL:

DELETE FROM PSFP_SECURITY
WHERE PTFP_FEED_ID='<FEEDID>'

FEED-08

User specified data source parameter table referencing a nonexistent feed.

Remove the user specified data source parameters referencing the nonexistent feed from the user specified data source parameter table.

Run the following SQL:

DELETE FROM PSFP_PVALS
WHERE PTFP_FEED_ID='<FEEDID>'

FEED-09

Admin personalization table referencing a nonexistent feed.

Remove admin personalization data referencing the nonexistent feed from the admin personalization table.

Run the following SQL:

DELETE FROM PSFP_ADMN_PREF
WHERE PTFP_FEED_ID='<FEEDID>'

FEED-10

User personalization table referencing a nonexistent feed.

Remove user personalization data referencing the nonexistent feed from the user personalization table

Run the following SQL:

DELETE FROM PSFP_USER_PREF
WHERE PTFP_FEED_ID='<FEEDID>'

FEED-11

  

Remove the invalid category association in the feed. Run the following SQL, depending on your database platform.

Oracle:

UPDATE PSFP_FEED
SET PTFP_CATEGORY_ID = ' '
WHERE PTFP_FEED_ID='<FEEDID>'

Non-Oracle:

UPDATE PSFP_FEED
SET PTFP_CATEGORY_ID = ''
WHERE PTFP_FEED_ID='<FEEDID>'

Note: There is a space within the quotes for an Oracle database, and no space within quotes for a non-Oracle database.

GENERICFEED-01

Integration Broker Generic Feed referencing a nonexistent Integration Broker service operation.

Remove the Integration Broker Generic Feed that references a nonexistent Integration Broker service operation.

WORKLISTFEED-01

Worklist feed referencing a nonexistent activity.

Remove the worklist feed that references a nonexistent activity.

WORKLISTFEED-02

Worklist feed referencing a nonexistent business process.

Remove the worklist feed referencing a nonexistent business process.

WORKLISTFEED-03

Worklist feed referencing a nonexistent event.

Remove the worklist feed referencing a nonexistent event.

WORKLISTFEED-04

Worklist feed referencing a nonexistent worklist name.

Remove the worklist feed referencing a nonexistent worklist name.

WORKLISTFEED-05

Worklist feed referencing a nonexistent "From" user.

Remove the worklist feed referencing a nonexistent user.

QUERYFEED-01

Query feed definition referencing a nonexistent query.

Remove the query feed referencing the nonexistent query.

QUERYFEED-02

Query feed parameter definition referencing a nonexistent query bind.

Remove the query feed parameter referencing a nonexistent query bind.

Run the following SQL:

DELETE FROM PSFP_PARMS
WHERE PTFP_FEED_ID='<FEEDID>'
AND PTFT_FIELD_NAME = ‘<FIELDNAME>’

QUERYFEED-03

Query feed entry element maps to a template that referencing a nonexistent query result column.

Remove query feed entry template referencing a nonexistent query result column.

Run the following SQL:

DELETE FROM PSFP_ATTRS
WHERE PTFP_FEED_ID='<FEEDID>'
AND PTFT_FIELD_NAME = ‘<QRYFLDNAME>’

To remove a feed shown in these audits:

  • FEED-01

  • GENERICFEED-01

  • WORKLISTFEED-01

  • WORKLISTFEED-02

  • WORKLISTFEED-03

  • WORKLISTFEED-04

  • WORKLISTFEED-05

  • QUERYFEED-01

Run the following SQL:

DELETE FROM PSFP_ADMN_PREF WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_USER_PREF WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_ATTRS WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_ATTRS_LANG WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_FEED WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_FEED_LANG WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_PARMS WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_PARMS_LANG WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_PUB_SITES WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_PVALS WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_PVALS_LANG WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_SECURITY WHERE PTFP_FEED_ID IN ('<FEEDID>');
DELETE FROM PSFP_SETTINGS WHERE PTFP_FEED_ID IN ('<FEEDID>');