Scheduled sync not working

[Gene]

Hi.

I can copy data between servers, but the sychronization doesn't work. The scheduler is running, and the job executes with no visible error.

When I insert a record into a table on the source the record never appears in the table on the target. The scheduler runs the job every minute for testing purposes. I have also run the job manually from the scheduled task list. Same result. The task is running in the Administrator's context, and the event log confirms that the there are no authentication errors from task execution.

The XML file looks fine, and I was able to copy the database across when I ran it from the wizard the first time (when I setup the job initially).

I set it up for 2 way synchronization.

The servers are identical MySQL 4.1.10 running on NT. I used root and administrator access all around for testing purposes, to eliminate permissions as a possible cause.

Here's the XML (host/user/password removed for obvious reasons):

localhost

root

* 3306

ga001

administrator

*

*

22

33304

*

root

* 3306

ga001

[Ritesh]

Which version of SQLyog?

Can you mail me sample data to reproduce the error?

[Gene]

The version if SQLyog is 4.03

The problem is with the command line argument being passed to sja:

“C:Program FilesSQLyogEntsja.exe” “C:Program FilesSQLyogEntga001-sync.xml”

For unknown reason, sja will execute, but immediately exits.

Please note that the same command works perfectly if I execute it manually from a cmd console.

Gene

[Gene]

Here's the problem. I was able to capture the following output from the task execution. How do I fix this so that I can continue my evaluation for the remaining 29 days?

SQLyog Job Agent Version 4.0

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

This version of SJA has expired. To register SJA you need to purchase SQLyog from http://www.webyog.com/sqlyog/buysqlyog.html

SQLyog Job Agent Version 4.0

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

[Author]

Posts