BIX Extraction Issue
SummaryBIX is extracting already extracted records though "Use last updated date time as start" enabled.
Error MessagesNot Applicable
Steps to Reproduce
- Create a BIX extract rule and check the box "Use last updated time as start"
- Create one or two cases and then run the extract rule, check the target database table, you should see 2 records.
- Create two cases and then run the extract rule, check the target database table, you should see total of 6 records which shouldn't be, it should contain only 4 records as two new records are created and existing records are not updated.
Root CauseThe table pr_extract_time
is missing in customer's database. This is a known issue in PRPC 717.
ResolutionCreate this table manually by running the script available in <PRPC Media>\Additional_Products\BIX\schema\ <DB type>\<DB Type>_install_717.sql
Published April 21, 2017 - Updated April 25, 2017