SA-21567

Summary

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.

Resolution

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.