Hi I have few queries regarding BIX extract range. Appreciate if anyone can help me with any of these questions -
1. Case A created on 3/1/2017 10:15 AM. It is update on 3/1/2017 9:00 PM and again on 3/2/2017 8:00 AM. My BIX job runs at 7:55 AM everyday and takes 20 minutes to run and say this case is exracted at 8:05 AM in that job. Will this case be extracted?
2. If I use pr_extract_time table and pyUseLastUpdated is set to true, extraction is done for cases updated/created in which time range if I run the job on 3/2/2017 7:55 AM? In pr_extract_time table only date is reflected (for above scenario 3/1/2017) and not the entire timestamp for the column pylastupdatedate.
***Updated by moderator: Lochan to add Categories***
If you turn on debug on com.pega.pegarules.data.internal.access.ExtractImpl and then run the extract you will see the actual query that is being generated and WOs found.
For the "Use Last Updated Time as Start" the starttime is set to the endtime of the last run. The end time is 5 minutes before the extraction query actually executes. If your job starts at 7:55, and running from the command line, then there will be some time to actually start the engine before it starts running the extract. For example purposes say that by 8:05 the engine is up and the extraction query is being run. The endtime will be 8:00.
The extraction is run against the current state of the instance. So if the endtime is <= 8:00 and the last time this WO was updated was 8:00 then it would get extracted.
The time in pr_extract_time table is the end time of the last run and what will be used for the start time of the next run.