Performance Data Warehouse database does not generate tables or views after the IBM BPM V7.5.0 Fix Pack 1 update

Troubleshooting

Problem

Update Tracking Definitions does not generate expected tables and views in the Performance Data Warehouse database after you apply IBM Business Process Manager Standard Fix Pack 1. Errors are not visible in the standard logs to indicate why the tables and views were not generated.

Environment

This issue applies to any IBM Business Process Manager V7.5 environment that is updated with Fix Pack 1 after initial installation.

Diagnosing The Problem

Examine the 00Static.xml file for your Performance Data Warehouse, which is located in the following directory:

<install_root>\BPM\v7.5\BPM\Lombardi\performance-data-warehouse\ configTemplates\system

Determine whether there is a <automatic-schema-management> configuration flag in the file and whether it is set to <true>.

Resolving The Problem

If you originally created your profiles in IBM Business Process Manager V7.5 and you subsequently apply Fix Pack 1, you must complete the manual steps in the Profile upgrade instructions for V7.5.0 Fix Pack 1 (V7.5.0.1) IBM Business Process Manager product installations with existing profiles technote after Installation Manager has run the update.

As part of these manual steps, the <automatic-schema-management> configuration flag is added to the 00Static.xml file for the Performance Data Warehouse.

This value should normally be set to <true>.

However, if the configuration flag is missing from 00Static.xml file, the Performance Data Warehouse assumes a value of <false>, which results in apparently successful send definitions. Although errors are not generated in the standard log files, the schema changes to tables and views do not occur.

After you complete the manual steps in the technote, verify that the 00Static.xml file now contains the <automatic-schema-management> configuration tag.

Related Information

Fix Pack 1 manual steps

[{"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Installation \/ Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Installation \/ Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"","label":"Linux zSeries"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"7.5.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

BPM

Was this topic helpful?

Document Information

Modified date:
15 June 2018

UID

swg21567240

Tips