Support Article

BIX Extraction Issue

SA-36894

Summary



BIX is extracting already extracted records though "Use last updated date time as start" enabled.


Error Messages



Not Applicable


Steps to Reproduce

  1. Create a BIX extract rule and check the box "Use last updated time as start"
  2. Create one or two cases and then run the extract rule, check the target database table, you should see 2 records.
  3. 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 Cause



The table pr_extract_time is missing in customer's database. This is a known issue in PRPC 717.

Resolution



Create 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

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.