Hi. I've managed to create a publisher in a debian based server that connects to a Sql server machine
I've also managed to create a subscription in another debian server, using a MySQL database.
I'm using
When I try to pull or snaptshot, I get this error:
Problem in synchronizing data due to -- 'Line 1: Incorrect syntax near 'work'.'.
Can anyone help?
Thanks
Miguel
14:50:20,514 DEBUG [CommonMetaDataInfo] [appendPrimaryConstraints 583] Primary Key (ID )
14:50:20,526 DEBUG [CommonMetaDataInfo] [appendCheckConstraints 683] Primary Key (ID ) , Check ( ID is not null )
14:50:20,559 DEBUG [Publication] [createStructure 539] wrote XMLFile ClientSocket
14:50:40,295 DEBUG [Publication] [checkForLock 1642] locking for subscription::sub2
14:50:40,307 ERROR [SyncXMLCreator] [createXMLFile 243] Line 1: Incorrect syntax near 'work'.
java.sql.SQLException: Line 1: Incorrect syntax near 'work'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116)
at org.dbreplicator.replication.xml.SyncXMLCreator.createXMLFile(SyncXMLCreator.java:116)
at org.dbreplicator.replication.Publication.createXMLForClient(Publication.java:844)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
org.dbreplicator.replication.RepException:
Problem in synchronizing data due to -- 'Line 1: Incorrect syntax near 'work'.'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116)
at org.dbreplicator.replication.xml.SyncXMLCreator.createXMLFile(SyncXMLCreator.java:116)
at org.dbreplicator.replication.Publication.createXMLForClient(Publication.java:844)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
14:50:40,346 DEBUG [Publication] [releaseLOCK 1681] isLocked :false
I am also trying to set up a
I am also trying to set up a replication between MS SQL Server 2000 and MySQL version 5.I managed to get it to work in our test envrionment, but it doesn't work when replicating to our customer. I set up an ODBC-connection using MyODBC 3.51 and then enabled it as an ODBC-subscriber in SQL Server. When I create the subscriber, I get an 'Invalid cursor state' error in the distribution agent.
In our test envrionment, I got it to work by dropping the MSRepl7 table that SQL Server creates in the MySQL-database. I don't know why it starts to work, but I don't care ;-) However, when I try the same trick with our customer, it still gives the same error. That it is a bug in the ODBC Driver Manager, but there are also cases in which it works (as in our test case). I tried everything, changing testkings options in MySQL, SQL Server, MyODBC, installing MyODBC 5, but nothing solves this problem. I am running out of ideas, can anyone help me?
i think that you should
i think that you should change the server or contact with server person to fix the problem because its not the script problem. Though Debian is compatible with Apache server but sometimes it give a lot trouble while connecting to server.
Mahesh from Landing Page Optimization