Sync Error code: 1019

[Jorge Roberto]

Hi,

I'm testing the software version 1.4.4 and on the client end I get the
error:

(I had the same problem with other table and after I remove it and
then add it again on the server, the client did create the table)

CREATE TABLE testdblocal.tblenqprosp(
EnqID int(11) DEFAULT 0 NOT NULL,
AddID int(11),
AddIDOrig int(11) DEFAULT 0,
ConID int(11) DEFAULT 0,
Product varchar(10),
SourceID int(11) DEFAULT 0,
EventID int(11) DEFAULT 0,
DateCreated DATETIME,
UserCreated varchar(20),
DateModified DATETIME,
UserModified varchar(20),
ResID int(11) DEFAULT 0,
DealerID int(11) DEFAULT 2,
Chance smallint(6) DEFAULT 0,
MonthExp DATETIME,
OrderDate DATETIME,
DateToDealer DATETIME,
FollowUp DATETIME,
Prospect varchar(3) DEFAULT '0',
Qty smallint(6) DEFAULT 1,
ToDealer bit(1) DEFAULT ,
SourceRef varchar(10),
FollowRef varchar(10),
Active varchar(3),
EnqInf varchar(1) DEFAULT '1',
PRIMARY KEY(EnqID)
) engine=innodb
Sync Error code: 1019
Sync Error Messages:
PVC-1019: Client download phase internal error
Sync Error stacktrace:
pervasync.SyncException: PVC-1019: Client download phase internal
error
at pervasync.client.SyncAgent.sync(SourceFile:607)
at pervasync.client.SyncAgent.main(SourceFile:123)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for
the right syntax to use near '' at line 22
at sun.reflect.NativeConstructorAccessorImpl.newInstance0
(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance
(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:
2642)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:
2571)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:
782)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:
625)
at pervasync.client.SyncAgent.a(SourceFile:3834)
at pervasync.client.SyncAgent.H(SourceFile:2411)
at pervasync.client.SyncAgent.sync(SourceFile:562)
... 1 more


java pervasync.client.SyncAgent total time: 1.543 seconds
Exception in thread "main" pervasync.SyncException: PVC-1019: Client
download phase internal error
at pervasync.client.SyncAgent.sync(SourceFile:607)
at pervasync.client.SyncAgent.main(SourceFile:123)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for
the right syntax to use near '' at line 22
at sun.reflect.NativeConstructorAccessorImpl.newInstance0
(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance
(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:
2642)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:
2571)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:
782)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:
625)
at pervasync.client.SyncAgent.a(SourceFile:3834)
at pervasync.client.SyncAgent.H(SourceFile:2411)
at pervasync.client.SyncAgent.sync(SourceFile:562)
... 1 more

Usage
-----
pvc.bat {sync|refresh|checkin} [{data|file} [<password>]]

Use the "sync" sub-command to do two-way sync, e.g.

pvc.bat sync

Use "refresh" and "checkin" to do one-way sync. By default
DB data are synced. Use option "file" to do file sync.
After "data" or "file", you can optionally supply the sync
user password. Stored password will be used if it is absent.

Note that the JDBC jar or Java connector jar has to be on the
CLASSPATH to run this script.

Shell script completed with error.

[pervasync]

What's the column definition and default value for column ToDealer on
central server?

[Jorge Roberto]

Hi,

here is how the colum was created:

Colum Name: ToDealer
Datatype: BIT(1)
Not Null: not selected
Auto Inc: not selected
Flags: Unsigned
Default Value: (emply)

Regards,
Jorge

[pervasync]

How did you create the table to make the default value (empty)?
Anyway, that was causing the problem. You can alter the tale to make
the defaut null or other non-empty values. Then re-publlish the table.
Also we will handle this case (empty default value) in next release --
2.0.0.

On Oct 21, 12:18 am, Jorge Roberto <jorge.roberto1...@gmail.com>
wrote:

> > central server?- Hide quoted text -
>
> - Show quoted text -

[Jorge Roberto]

Done, Change it to NULL and now it works.

Thank you.

> > - Show quoted text -- Hide quoted text -