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

Unable to create Business Intelligence Exchange extract rules



Unable to create Business Intelligence Exchange (BIX) extract rules in the Pega Sales Automation application.

Error Messages

Not Applicable.

Steps to Reproduce

  1. Run the Application wizard to build a new application on Pega Sales Automation 7.21
  2. 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.


Perform the following local-change:
  1. Add the pxCommitDateTime and pxSaveDateTime columns in the database tables
  2. Resave the class rule and Data-Admin-DB-Table instances for tables so the columns are populated for new work objects
  3. Resave the existing work objects to update the data
Alternatively, update to Pega Sales Automation tables 7.22.


Published July 23, 2018 - Updated December 2, 2021

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