No Records Processed For Replication Solution With New Source

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

  1. Make sure you have an empty target database to receive the replicated data.
  2. Create a new Replication Solution using the new source and the empty target database.