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

External table name is not getting generated by BIX



Specific external table name is not generated by BIX. The SQL file generated does not have the table name and is empty.

Error Messages

Not Applicable

Steps to Reproduce

1. Create an extract.
2. Include a Page property on the extract, and ensure that there are no scalar properties before that.
3. Use Generate DDL option, when the output is Database schema to generate a DDL.

Root Cause

When a page property is encountered directly in the hierarchy before a scalar property, an attempt to fetch the node name on the property is made. But, the page property does not consist a node name to fetch the table details, and the generated DDL does not have a table in the SQL.


Remove the page property from BIX rule form, and add it at the end in the BIX property selection tree after any top level scalar property.

Published April 4, 2016 - Updated October 8, 2020

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