Support Article
Unable to create Business Intelligence Exchange extract rules
SA-53523
Summary
Unable to create Business Intelligence Exchange (BIX) extract rules in the Pega Sales Automation application.
Error Messages
Not Applicable.
Steps to Reproduce
- Run the Application wizard to build a new application on Pega Sales Automation 7.21
- Review the work tables that are created in the database
Root Cause
A defect in Pegasystems’ code or rules. The pxCommitDateTime and pxSaveDateTime fields were not present in the out-of-the-box Pega Sales Automation tables. As a result, the new application tables also did not have these fields.
Resolution
Perform the following local-change:- Add the pxCommitDateTime and pxSaveDateTime columns in the database tables
- Resave the class rule and Data-Admin-DB-Table instances for tables so the columns are populated for new work objects
- Resave the existing work objects to update the data
Published July 23, 2018 - 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.