Posted: 26 May 2016 17:19 EDT Last activity: 4 Oct 2018 13:54 EDT
How to get incremental data in BIX Extract without pxCommitDateTime?
I have requirement of generating daily report using BIX extract, from a Pega internal table. The table doesn't contain pxCommitDateTime column and we don't want to add it to the table. This system is already in production and is on Pega 7.1.9. I need a way to capture daily incremental data in the BIX report.
If I tick the checkbox Use last updated time as start under Filter Criteria of the Extract rule, then it throws the error "Could not process : pxCommitDateTime column does not exist in table"
How can we get this functionality without adding pxCommitDateTime column?
I see in Pega 7 help that we can use Last Extraction time in filter condition. Can you let me know how exactly to use it? The syntax for same.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Instead, if you would like to run the extract from designer studio (UI) using an agent to schedule the process, you may use the activity "pxExtractDataWithArgs", which accepts command line arguments. For the list of command line arguments that you can use, please refer BIX user guide link to which is provided below.
As per my understanding, the Real time BIX extraction using pxExtractData, pyExtractDuringSave and pxExtractDataWithArgs Activities are no more supported. Product team is planning to make them as deprecated is what I hear.
However, the functionality to support parameters or Names page property reference in BIX will be added in the future release. Please check for GRP-23096 <internal link, can be viewed by Pega employees only> in the Release Notes of future versions!
Let me know if this helps you.
Posted: 5 years ago
Updated: 5 years ago
Posted: 27 May 2016 8:28 EDT Updated: 27 May 2016 8:32 EDT
Rajiv Nistala (nistr)
Senior Manager - Engineering
Thanks Rajiv, this worked for us. We wanted to understand how does this "Last Extraction Time" being used. Saved it against .pxUpdateDateTime as we need to monitor the incremental updated case stage movement. Thanks.
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page.
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
We have also sent you a private message opening up a communication channel in case you have any further questions.