BI Publisher Integrity

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

Query Description Resolution

BIP-01

Query Data Source does not exist in Query Definition table.

Remove the data source and all report definitions using the data source.

BIP-02

Data Source Definition used by a Report Definition but does not exist in Data Source Definition table.

If this error is observed after the upgrade copy process, try copying the data source object from source database. If this is not the case, remove the report definition.

BIP-03

Template Definition used by a Report Definition but does not exist in Template Definition table.

If this error is observed after the upgrade copy process, try copying the missing template definition from the source database. If this is not the case, remove the report definition.

BIP-04

Template Definition not associated with any Report Definition.

Remove the template object.

BIP-05

Template Definition associated with more than one Report Definition.

Delete all the report definitions using the template object and recreate them again from the user interface.

BIP-06

Sub-Template Definition associated with any Report Definition.

Delete all the report definitions using the template object and recreate them again from the user interface.

BIP-07

Template File does not exist in file table.

If this error is observed after the upgrade copy process, try copying the missing file definition from the source database. If this is not the case, the template definition should be deleted and recreated.

BIP-08

PDF Map File does not exist in file table.

If this error is observed after the upgrade copy process, try copying the missing file definition from the source database. If this is not the case, the template definition should be deleted and recreated.

BIP-09

XLIFF File does not exist in file table.

If this error is observed after the upgrade copy process, try copying the missing file definition from the source database. If this is not the case, the template definition should be deleted and recreated.

BIP-10

File definition not used by template file definition.

Run Application Engine program PSXPCLEAN to delete orphan file definitions.

BIP-11

File data not referenced by file definition.

Run Application Engine program PSXPCLEAN to delete orphan file definitions.

BIP-12

File definitions not referenced by file data.

Run Application Engine program PSXPCLEAN to delete orphan file definitions.