No Records Processed For Replication Solution With New Source
book
Article ID: KB0079036
calendar_today
Updated On:
Products
Versions
TIBCO Cloud Integration - Connect ( Scribe )
-
Description
If the source of a TIBCO Scribe Online Replication Solution is changed such that the schemas no longer match what is in the target datastore, such as from Salesforce to Microsoft Dynamics CRM, and the Replication Solution executes, zero records are processed, but no error message is generated. (D27899)
For example, if you attempt to replicate Salesforce Accounts to a database that already has Microsoft Dynamics CRM Accounts replicated, the replication fails. TIBCO Scribe Online is attempting to replicate to a database with the same table name, accounts, but different schemas. In this example, the target database is case insensitive and the table is detected, but since the schemas are different the replication fails with zero rows processed.
Issue/Introduction
If the source of a Replication Solution is changed such that the schemas no longer match what is in the target, when the Replication Solution executes, zero records are processed, but no error message is generated.
Resolution
Make sure you have an empty target database to receive the replicated data.
Create a new Replication Solution using the new source and the empty target database.