Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

IDR failed to import SCN into the Delta configuration exported from another configuration
Problem Description
In Informatica Data Replication (IDR), while exporting the SCN from the initial sync configuration and importing the SCN number to the delta sync configuration (other than first configuration), the following error is displayed:

SMErr​or 15: Server Manager error

 imageerror.png

Cause
Exporting SCNs from one configuration generates csv file with SCNs and the target connection information with IDs. This information is specific to every configuration. So, there was mismatch in connection and id.
Solution
Exporting SCNs from one configuration and importing into another configuration requires manual editing of the csv file. 

Do as follows:

1. Export SCNs from config A (InitialSync config).

2. Export SCNs from config B (DeltaSync config – replication config).

3. Open both csv files. Use the values for connection name and id from the config B for csv from config A. 

Look for the values like:

#tgt name:<connection_name>

#id: <id>                      


For the fan-out config there will be entries for both targets. 

4. After editing id values for csv file you can use edited values with SCNs from config A for config B.

More Information
Applies To
Product: Universal Data Replication
Problem Type: Performance
User Type: Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:8/28/2019 9:25 AMID:534850
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)