SA-25722

Summary

Developer has configured a declare index to trigger when a property is inserted or updated into the database. Sporadically, when the bulk transfer is been performed, one out of ten records is failing to get inserted into the database.

Error Messages

Not Applicable.

Steps to Reproduce

1. Set a declare index rule to trigger when a property (Page list) is updated or inserted.
2. This Index rule is set to insert a new instance into a data table.
3. Check to see if the table is getting inserted with a new instance every time the rule is triggered.

Root Cause

The issue is due to the index value not being properly incremented for every new insert. 

Resolution

Configure "pzreindex=true". This ensures that all indexes on the work object are populated correctly. That is,Setting pzReindex to True will do a force re-indexing and the existing index values are ignored.