Support Article
BIX for History Table generate blank XML file
SA-67613
Summary
Business Intelligence Exchange (BIX) extracts created for History Tables generate a blank XML file.
Error Messages
InvalidReferenceException .pxUpdateDateTime Cannot use an unexposed property as there is no BLOB column for the class: 'History-TGB-HR_Apps-Work'
Steps to Reproduce
Create an extract for the history table with the 'Use last update time as start' option checked in the Filter criteria.
Root Cause
A defect in Pegasystems’ code or rules.
History tables do not contain a BLOB column or a pxUpdateDateTime as explicit columns. The 'Use last update time as start' option used the pxUpdateDateTime as the start during the validation phase in the code. Instead, it must use pxTimeCreated.
Resolution
Apply HFix-48319.
Published January 9, 2019 - 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.