mysql to ms sql replication error

1 view
Skip to first unread message

jrider

unread,
Aug 1, 2007, 9:43:09 PM8/1/07
to daffodil-replicator-enterprise
Hi
I have Replicator setup with 2 datasources.
1 to MySQL 5, and 1 to MS SQL Server 2000.
I can setup the data sources and a 1 to 1 subscription between the 2
data sources with MySQL being the source and MS SQL Server as the
destination.
The first time that I execute the subscription, it works. Any changes
to the data in MySQL are properly replicated to MS SQL Server.
But the next time I try to execute the subscription, I get an error.
This is the error from the log
2007-08-01 18:19:24.109

DataBase Access Error due to :'No value specified for parameter 2'.

com.daffodilwoods.replicator.e.b.f(Unknown
Source)com.daffodilwoods.replicator.j.g.b(Unknown
Source)com.daffodilwoods.replicator.dataSources.JDBCDataSource.mergeDataChanges(Unknown
Source)com.daffodilwoods.replicator.dataSources.c.mergeDataChanges(Unknown
Source)com.daffodilwoods.replicator.server.jobs.OneToOneJob.runjob(Unknown
Source)com.daffodilwoods.replicator.server.jobs.OneToOneJob.run(Unknown
Source)com.daffodilwoods.replicator.server.subscription.Subscription.synchronize(Unknown
Source)com.daffodilwoods.replicator.server.Replicator.doSubscription(Unknown
Source)com.daffodilwoods.repconsole.f.run(Unknown Source)

The only thing that I can think of that is out of the ordinary, is
that this table has a composite key. Here is the table definition.
CREATE TABLE `labels` (
`labelKey` varchar(50) collate latin1_general_ci NOT
NULL,
`code` varchar(50) collate latin1_general_ci NOT
NULL,
`label` varchar(500) collate latin1_general_ci default
NULL,
`sort` int(10) default
NULL,
PRIMARY KEY
(`labelKey`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci

Any help would greatly be appreciated.

Cheers,
Jason

Reply all
Reply to author
Forward
0 new messages