Number of records does not match-For BIX extracting same class
SummaryA developer is extracting 500 properties from the same class. Three extract rules have been created on the same class that output to different tables, each has "Use last update time as start" enabled.
Logically, any update on the case will insert a record into all three tables. When they run extracts using the
Business Intelligence Exchange (BIX) command line process, they see that the total number of records in all the three tables differ.
Steps to Reproduce
- Create three extract rules in the same class and enable "Use last update time as start".
- Run BIX extract on all of them.
- Check the count of records in each table after the extraction process.
Root CauseA software use or operation error. As the extract rules are using "Use last update time as start", the filters used for the database queries are slightly different for each extract as they are running sequentially, not simultaneously. Thus, the start time and end time filters used for the database queries will always be different and may end up extracting different work objects.
To avoid this and always have the extracts pull the same data, developers should use command line parameters (like –u and –U) for this requirement.
This will require the use of tools outside of Pega (such as a script) to update the values being passed for the parameters as required.
Published August 2, 2016 - Updated August 11, 2016