Failed Synchronization - Mobilink and SQL Anyhwere 9.0

[Former Member]

Hi,

  Here's a blast from the past. Building a new remote for a really old system. However when running the first sync am receiving the following error, which doesn't seem to be much of an error at all.

Have tried a few things, dropping and recreating the Moblilink user, matching time zones (I am in California and the corporate database is back east in New York), retried the sync a couple of times and always it fails with the same error.

Trevin

Begin synchronization  User: ml_lc_55_new

Pub Names: corp-oos-console

Begin log scan.  Rescan = 0.

End log scan.

Connect MobiLink.

Begin upload.

End upload.

Waiting for upload acknowledgement.

Upload acknowledged.  Status = 0.

E. 06/01 08:42:27. Complete download not received from MobiLink server.

Disconnect MobiLink server.

End Synchronization.  Status = 1

Synchronization error 1.

I. 06/01 00:08:50. Synchronization Started

I. 06/01 00:08:50. Adaptive Server Anywhere MobiLink Synchronization Version 9.0.2.2451

I. 06/01 00:08:50.

I. 06/01 00:08:50. Copyright © 1989-2004 Sybase, Inc.

                   Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.

I. 06/01 00:08:50. All rights reserved. All unpublished rights reserved.

I. 06/01 00:08:50. 

I. 06/01 00:08:50. This software contains confidential and trade secret information of

I. 06/01 00:08:50. iAnywhere Solutions, Inc.

                   Use, duplication or disclosure of the software and documentation

I. 06/01 00:08:50. by the U.S. Government is subject to restrictions set forth in a license

I. 06/01 00:08:50. agreement between the Government and iAnywhere Solutions, Inc. or

I. 06/01 00:08:50. other written agreement specifying the Government's rights to use the

I. 06/01 00:08:50. software and any applicable FAR provisions, for example, FAR 52.227-19.

I. 06/01 00:08:50. 

I. 06/01 00:08:50. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA

I. 06/01 00:08:50.

I. 06/01 00:08:50. Connecting to remote database

I. 06/01 00:08:50. Loading synchronization information

I. 06/01 00:08:50. Begin synchronizing 'corp-oos-console' for MobiLink user 'ml_lc_55_new'

I. 06/01 00:08:50. Deleting restartable download file C:\DOCUME~1\XPMUser\LOCALS~1\Temp\_T4 from previous synchronization.

I. 06/01 00:08:50. COMMIT

I. 06/01 00:08:51. Log scan starting at offset 0801192337

I. 06/01 00:08:51. Processing transaction logs from directory "C:\OOSprod\Database\"

I. 06/01 00:08:51. Processing transactions from active transaction log

I. 06/01 00:08:51. Hovering at end of active log

I. 06/01 00:08:51. Connecting to MobiLink server at 'host=192.168.1.24;port=2439' using 'dbmlsock9.dll'

I. 06/01 00:08:51. Uploading header

I. 06/01 00:08:51. Begin upload

I. 06/01 00:08:51. Uploading table operations

I. 06/01 00:08:51. # rows inserted in table SalesTerritory : 0

I. 06/01 00:08:51. # rows deleted in table SalesTerritory : 0

I. 06/01 00:08:51. # rows updated in table SalesTerritory : 0

I. 06/01 00:08:51. # rows inserted in table Rep : 0

I. 06/01 00:08:51. # rows deleted in table Rep : 0

I. 06/01 00:08:51. # rows updated in table Rep : 0

I. 06/01 00:08:51. # rows inserted in table AccountGroup : 0

I. 06/01 00:08:51. # rows deleted in table AccountGroup : 0

I. 06/01 00:08:51. # rows updated in table AccountGroup : 0

I. 06/01 00:08:51. # rows inserted in table ItemBindingType : 0

I. 06/01 00:08:51. # rows deleted in table ItemBindingType : 0

I. 06/01 00:08:51. # rows updated in table ItemBindingType : 0

I. 06/01 00:08:51. # rows inserted in table AccountType : 0

I. 06/01 00:08:51. # rows deleted in table AccountType : 0

I. 06/01 00:08:51. # rows updated in table AccountType : 0

I. 06/01 00:08:51. # rows inserted in table ItemReleaseStatus : 0

I. 06/01 00:08:51. # rows deleted in table ItemReleaseStatus : 0

I. 06/01 00:08:51. # rows updated in table ItemReleaseStatus : 0

I. 06/01 00:08:51. # rows inserted in table ContactType : 0

I. 06/01 00:08:51. # rows deleted in table ContactType : 0

I. 06/01 00:08:51. # rows updated in table ContactType : 0

I. 06/01 00:08:51. # rows inserted in table AddressType : 0

I. 06/01 00:08:51. # rows deleted in table AddressType : 0

I. 06/01 00:08:51. # rows updated in table AddressType : 0

I. 06/01 00:08:51. # rows inserted in table AccountCategory : 0

I. 06/01 00:08:51. # rows deleted in table AccountCategory : 0

I. 06/01 00:08:51. # rows updated in table AccountCategory : 0

I. 06/01 00:08:51. # rows inserted in table VendorSubmitType : 0

I. 06/01 00:08:51. # rows deleted in table VendorSubmitType : 0

I. 06/01 00:08:51. # rows updated in table VendorSubmitType : 0

I. 06/01 00:08:51. # rows inserted in table ReportsLinks : 0

I. 06/01 00:08:51. # rows deleted in table ReportsLinks : 0

I. 06/01 00:08:51. # rows updated in table ReportsLinks : 0

I. 06/01 00:08:51. # rows inserted in table Territory : 0

I. 06/01 00:08:51. # rows deleted in table Territory : 0

I. 06/01 00:08:51. # rows updated in table Territory : 0

I. 06/01 00:08:51. # rows inserted in table OOSsettings : 0

I. 06/01 00:08:51. # rows deleted in table OOSsettings : 0

I. 06/01 00:08:51. # rows updated in table OOSsettings : 0

I. 06/01 00:08:51. # rows inserted in table RepType : 0

I. 06/01 00:08:51. # rows deleted in table RepType : 0

I. 06/01 00:08:51. # rows updated in table RepType : 0

I. 06/01 00:08:51. # rows inserted in table RepGroup : 0

I. 06/01 00:08:51. # rows deleted in table RepGroup : 0

I. 06/01 00:08:51. # rows updated in table RepGroup : 0

I. 06/01 00:08:51. # rows inserted in table Account : 0

I. 06/01 00:08:51. # rows deleted in table Account : 0

I. 06/01 00:08:51. # rows updated in table Account : 0

I. 06/01 00:08:51. # rows inserted in table Vendor : 0

I. 06/01 00:08:51. # rows deleted in table Vendor : 0

I. 06/01 00:08:51. # rows updated in table Vendor : 0

I. 06/01 00:08:51. # rows inserted in table Rep_Territory : 0

I. 06/01 00:08:51. # rows deleted in table Rep_Territory : 0

I. 06/01 00:08:51. # rows updated in table Rep_Territory : 0

I. 06/01 00:08:51. # rows inserted in table VendorContact : 0

I. 06/01 00:08:51. # rows deleted in table VendorContact : 0

I. 06/01 00:08:51. # rows updated in table VendorContact : 0

I. 06/01 00:08:51. # rows inserted in table VendorAddress : 0

I. 06/01 00:08:51. # rows deleted in table VendorAddress : 0

I. 06/01 00:08:51. # rows updated in table VendorAddress : 0

I. 06/01 00:08:51. # rows inserted in table VendorSubmitData : 0

I. 06/01 00:08:51. # rows deleted in table VendorSubmitData : 0

I. 06/01 00:08:51. # rows updated in table VendorSubmitData : 0

I. 06/01 00:08:51. # rows inserted in table OrderTemplate : 0

I. 06/01 00:08:51. # rows deleted in table OrderTemplate : 0

I. 06/01 00:08:51. # rows updated in table OrderTemplate : 0

I. 06/01 00:08:51. # rows inserted in table AcctOrder : 0

I. 06/01 00:08:51. # rows deleted in table AcctOrder : 0

I. 06/01 00:08:51. # rows updated in table AcctOrder : 0

I. 06/01 00:08:51. # rows inserted in table RepGrp_VendorNbr : 0

I. 06/01 00:08:51. # rows deleted in table RepGrp_VendorNbr : 0

I. 06/01 00:08:51. # rows updated in table RepGrp_VendorNbr : 0

I. 06/01 00:08:51. # rows inserted in table AccountVendor : 0

I. 06/01 00:08:51. # rows deleted in table AccountVendor : 0

I. 06/01 00:08:51. # rows updated in table AccountVendor : 0

I. 06/01 00:08:51. # rows inserted in table Rep_VendorNbr : 0

I. 06/01 00:08:51. # rows deleted in table Rep_VendorNbr : 0

I. 06/01 00:08:51. # rows updated in table Rep_VendorNbr : 0

I. 06/01 00:08:51. # rows inserted in table Publisher : 0

I. 06/01 00:08:51. # rows deleted in table Publisher : 0

I. 06/01 00:08:51. # rows updated in table Publisher : 0

I. 06/01 00:08:51. # rows inserted in table AccountContact : 0

I. 06/01 00:08:51. # rows deleted in table AccountContact : 0

I. 06/01 00:08:51. # rows updated in table AccountContact : 0

I. 06/01 00:08:51. # rows inserted in table Account_Rep : 0

I. 06/01 00:08:51. # rows deleted in table Account_Rep : 0

I. 06/01 00:08:51. # rows updated in table Account_Rep : 0

I. 06/01 00:08:51. # rows inserted in table Item : 0

I. 06/01 00:08:51. # rows deleted in table Item : 0

I. 06/01 00:08:51. # rows updated in table Item : 0

I. 06/01 00:08:51. # rows inserted in table PublisherContact : 0

I. 06/01 00:08:51. # rows deleted in table PublisherContact : 0

I. 06/01 00:08:51. # rows updated in table PublisherContact : 0

I. 06/01 00:08:51. # rows inserted in table AccoutPublisher : 0

I. 06/01 00:08:51. # rows deleted in table AccoutPublisher : 0

I. 06/01 00:08:51. # rows updated in table AccoutPublisher : 0

I. 06/01 00:08:51. # rows inserted in table OrderLineItem : 0

I. 06/01 00:08:51. # rows deleted in table OrderLineItem : 0

I. 06/01 00:08:51. # rows updated in table OrderLineItem : 0

I. 06/01 00:08:51. # rows inserted in table PublishersISBNprefix : 0

I. 06/01 00:08:51. # rows deleted in table PublishersISBNprefix : 0

I. 06/01 00:08:51. # rows updated in table PublishersISBNprefix : 0

I. 06/01 00:08:51. # rows inserted in table PublisherAddress : 0

I. 06/01 00:08:51. # rows deleted in table PublisherAddress : 0

I. 06/01 00:08:51. # rows updated in table PublisherAddress : 0

I. 06/01 00:08:51. # rows inserted in table OrderTemplateLine : 0

I. 06/01 00:08:51. # rows deleted in table OrderTemplateLine : 0

I. 06/01 00:08:51. # rows updated in table OrderTemplateLine : 0

I. 06/01 00:08:51. Log scan ended at offset 0801193341

I. 06/01 00:08:51. Waiting for MobiLink to apply upload

I. 06/01 00:09:49. The user authentication value is 1000.

I. 06/01 00:09:49. COMMIT

I. 06/01 08:42:26. Download stream: received 512 bytes from MobiLink Server.

E. 06/01 08:42:27. Complete download not received from MobiLink server.

I. 06/01 08:42:27. Writing restartable download file to C:\DOCUME~1\XPMUser\LOCALS~1\Temp\_T4.

I. 06/01 08:42:27. COMMIT

I. 06/01 08:42:27. Download stream processing failed

I. 06/01 08:42:27. End synchronizing 'corp-oos-console' for MobiLink user 'ml_lc_55_new'

I. 06/01 08:42:27. Disconnecting from MobiLink server

I. 06/01 08:42:27. Discarded memory to be recovered at next complete rescan: 0 bytes.

I. 06/01 08:42:27. Complete log scan required.

I. 06/01 08:42:27. Synchronization completed

I. 06/01 08:42:27. Disconnecting from remote database

[former_member188493]

The MobiLink client dbmlsync -o output is almost never any use, especially when the problem originates with the MobiLink server.

Try running the MobiLink server dbmlsrv9 with the -v cfhnpstu option which logs everything except row values and show us the -o output from dbmlsrv9.

(but chances are you'll see the problem right away)