Question

4
Replies
45
Views
Surya Prakash Muppa Member since 2015 4 posts
Prime Inc
Posted: 4 months ago
Last activity: 4 months ago

Can we restart BIX process if a failure happens. Restart from where it was failed initially

Hi All,

 

We're using BIX to write data into DB table  for reporting purpose in our application.  We've enabled filter criteria only "Use last updated time as start" checkbox. We didn't have any other filters on extract rule. 

We've configured Extract rule in Job Scheduler thru pxExtractDataWithArgs OOTB activity. It runs every day night at 12AM. 

For some reasons if there is failure in BIX process. Let's say if we get 5000 records for the criteria and system able to insert 2500 records which is 50% of the whole. After 2500 record if in case BIX failes. Is there a way to restart the BIX from where it was failed meaning from 2501 record. Currently what happening is whenever there is a failure we troubleshoot the issue and re-run the extract it again starting to insert from first record. This results in duplicating the first 50% of records because they are already being inserted into table for the first initial failed execution.  Because of this duplication and not able to restart where it was failed. We're having some manual work to eliminate the duplicate records from target DB table.  I'd like to know if there is any way to avoid these and option to restart.  Version Details :

Pega - 8.3.0 BIX - 8.3 DB(Vendor Type) - MSSQL Server - Hosted on Tomcat(On-Premises)  

Thanks!

 

***Edited by Moderator Marissa to update Platform Capability tags****

Pega Business Intelligence Exchange 8.3 System Administration Healthcare and Life Sciences Senior System Architect
Share this page LinkedIn