Cleaning Up BI Publisher Metadata

To ensure the integrity of the BI Publisher files, run the application engine program PSXPCLEAN.

This application engine program finds:

• Unreferenced objects in PSFILEDEFN.

• Template definitions and template translations for which file objects are missing.

• Inconsistencies between PSFILEDEFN and PSFILEDATA.

• Temporary BI Publisher files.

When a user runs a BI Publisher report, the system creates temporary files in the database (with a .vazip extension) and delivers the reports to the user’s browser. After the report is rendered on the user’s browser, the system deletes the temporary files in the database.

However, in some cases the user’s browser might be set to block pop-ups. In these cases the system creates the temp files in the database, but the process of rendering the reports and then removing the temp files cannot complete due to pop-ups. As a result temp files can accumulate in the database, wasting space.

The PSXPCLEAN application engine program is delivered in Report and Delete mode. To run the program in Report Only mode, open the application engine program PSXPCLEAN in Application Designer and remove the comment in the following statement in PSXPCLEAN:Main:Start PeopleCode action:

rem PSXPFILECLN_AET.REPORT_ONLY_FLAG = "Y"

You can schedule and run PSXPCLEAN using the PeopleTools, Process Scheduler, System Process Request page. You should run this program on a regular basis to keep template metadata consistent.