Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

BIX Extract fails due to missing table name



When generating the Data Definition Language (DDL) for the Business Intelligence Exchange (BIX) extract, the table name is missing despite entering it in the Extract rule. The table name displays in the View XML of the rule in pyOutputName.
Additionally, the extract fails (due to the missing table name) when it connects to the external database to insert records.

Error Messages

Table doesn't exist in  target Database: OECMCL2BIX

Steps to Reproduce

  1. Create a DDL for a full work item (create DDL). Table name is missing only for the work item top level table.
  2. Create the DDL in the Destination schema.
  3. Create the JDBC connection pool in WebSphere.
  4. Execute the extract for the work item. The extract fails due to the missing table name.

Root Cause

A defect in Pegasystems’ code or rules.


Apply HFix-55367.

Published August 15, 2019 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us