Support Article
BIX validation error if same table/file mapped to two page lists
SA-24789
Summary
User has created a Business Intelligence Exchange (BIX) Extraction rule to extract data from two page lists. If the output of the extract rule is a database table or file, then mapping the same database table or file name to these page lists causes validation errors that did not occur in PRPC 6.x.
Error Messages
pyOutputName: ** Added same to table Name for two or more fields **.
Steps to Reproduce
- Create a BIX extract rule to extract data from two or more page lists.
- Map the same table name or file name to the different page lists that are being extracted.
- Try to save the rule.
Root Cause
The validation was added to avoid the data loss due to accidental overwriting of the files or data in the database tables. For example, if you have configured the same file name to extract parent and child page list records, then there are chances that one gets overwritten or appended with the contents of the other.
Resolution
Perform the following local-change:
Configure unique ‘To Table’ names for each page list. The page list records will be extracted to unique tables.
Published March 16, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.