Products | Versions |
---|---|
TIBCO Cloud Integration - Connect ( Scribe ) | - |
If you are running a Replication Services (RS) Solution using Microsoft SQL Server as the target and you see the error below, you may have a configuration issue with your SQL user.
Row Error - "Error in call CreateTableForReplication
When reviewing Execution History in TIBCO Scribe® Online, you may see some row errors with the following message "Error in call CreateTableForReplication". This can be an indication of a configuration problem.
The user that is configured when setting up the SQL Server Connection must be a database owner for the target SQL Server replication database. TIBCO Scribe® Online needs full control over the replication database because it has to retrieve schema information, create tables, and read and write record data.
If the SQL user is not the database owner, TIBCO Scribe® Online has trouble reading the schema and fails to determine that the tables are already created. TIBCO Scribe® Online attempts to create them again causing this row error message.