Support Article
BIX Extract fails due to missing table name
SA-85736
Summary
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
- Create a DDL for a full work item (create DDL). Table name is missing only for the work item top level table.
- Create the DDL in the Destination schema.
- Create the JDBC connection pool in WebSphere.
- 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.
Resolution
Apply HFix-55367.
Published August 15, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.