How the Queue Collision Report Is Created
When you select the Collision option from the Resolver Reports Menu window, and there are records in the distribution queue, the Collision Report is created.
When you execute the report, the distribution queue of the local database is read and the following searches are conducted to determine if there are any collisions:
• For insert operations, the remote base table is searched using the table key. If found, both records are displayed in the report.
• For update operations, the remote shadow table is searched using the replicated transaction key of the previous operation that manipulated the row. If not found, the collision is displayed with the local replicated transaction key. If the table key exists in the remote table, both records are displayed.
• For delete operations, the remote shadow table is searched using the replicated transaction key of the previous operation that manipulated the row. If not found, the collision is displayed with the local replicated transaction key.