Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    1

    Unanswered: Mobilink Portable sync fails

    Hello,

    I am hoping someone can help me figure this out. Portable mobilink users are unable to sync information back to database. Using Sybase - SQL iAnywhere DBML_Sync 9.0.2.3320. simulating a server on my test workstation I was able to sync. which leads me to something on my server. Only changes have been DST time patch and OS patches. Portables were syncing up until 3 weeks ago. Connected mode works fine. The following is a log of failure.

    I. 03/16 14:38:10. <1.5> [dba]: ASA synchronization request from: dg_mobil (version: default)
    I. 03/16 14:38:10. <1.5> [dg_mobil]: ODBC isolation set to: Read Committed
    I. 03/16 14:38:10. <1.5> [dg_mobil]: COMMIT Transaction: begin_connection
    W. 03/16 14:38:10. <1.5> [dg_mobil]: Warning: [10024] Table 'TimeEvent' has no entry in the ml_table table
    I. 03/16 14:38:10. <1.5> [dg_mobil]: COMMIT Transaction: begin_synchronization
    E. 03/16 14:38:10. <1.5> [dg_mobil]: Error: [-10002] ODBC: [Sybase][ODBC Driver][Adaptive Server Anywhere]Cursor has not been declared (ODBC State = 24000, Native error code = -170)
    I. 03/16 14:38:10. <1.5> [dg_mobil]: Error Context:
    I. 03/16 14:38:10. <1.5> [dg_mobil]: User Name: dg_mobil
    I. 03/16 14:38:10. <1.5> [dg_mobil]: Modified User Name: dg_mobil
    I. 03/16 14:38:10. <1.5> [dg_mobil]: Transaction: upload
    I. 03/16 14:38:10. <1.5> [dg_mobil]: Table Name: MedTesterChecklists
    I. 03/16 14:38:10. <1.5> [dg_mobil]: Script Version: default
    I. 03/16 14:38:10. <1.5> [dg_mobil]: Script: call Portable_MedTesterCheckLists_Conflicts()
    I. 03/16 14:38:10. <1.5> [dg_mobil]: End of Error Context
    I. 03/16 14:38:10. <1.5> [dg_mobil]: The handle_error script returned 1000
    I. 03/16 14:38:10. <1.5> [dg_mobil]: COMMIT Transaction: end_upload
    W. 03/16 14:38:12. <1.5> [dg_mobil]: Warning: [10056] There is no download data script defined for table: TimeEvent. Synchronization has the risk of potentially losing download data
    I. 03/16 14:40:28. <1.5> [dg_mobil]: ROLLBACK Transaction: end_download
    I. 03/16 14:40:28. <1.5> [dg_mobil]: COMMIT Transaction: end_connection
    I. 03/16 14:40:28. <1.5> [dg_mobil]: Disconnected from consolidated database
    I. 03/16 14:40:28. <1.5> [dg_mobil]: Synchronization failed


    Thanks very much in Advance for any input. I need to resolve this asap...

    Susie

  2. #2
    Join Date
    Apr 2007
    Posts
    1
    I would check to make sure that you actually have upload and download scripts defined for the script version "default". It is claiming that you have not created them.

    To get started you might want to start the ml server with -za to generate some default scripts. Please also make sure to run dbmlsync -e "scn=on" for this first sync to send the column names to the server.

    Hope that helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •