dbTalk Databases Forums  

How to record failed upload in an version 11 consolidated database?

sybase.public.sqlanywhere.mobilink sybase.public.sqlanywhere.mobilink


Discuss How to record failed upload in an version 11 consolidated database? in the sybase.public.sqlanywhere.mobilink forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MiFi42
 
Posts: n/a

Default How to record failed upload in an version 11 consolidated database? - 07-28-2010 , 05:46 AM






Hi,

we successfully use the begin_synchronization, end_synchronization and
report_error script events to log the activity of UltraLite clients in
our own audit tables in the consolidated database. Works fine.

Unfortunately, there seems to be an error situation that doesn't
trigger any script event. When the progress counter in the UltraLite
and in the consolidated do not match (which happens when you restore
the disks of the device), the following error occurs on the UltraLite:

SQL Anywhere UltraLite Database Synchronize Utility Version
11.0.1.2405
Sync failed: Synchronization server failed to commit the upload
Results of this synchronization:
Failed with error: SQLE_UPLOAD_FAILED_AT_SERVER (SQLCODE -794)
Download timestamp: 2010-07-28 12:03:46.282000
Upload failed
No ignored rows
No part download remaining
Authentication value: 0 (0x0)

This is what I expected. Here is what you find in the MobiLink log
file:

I. 2010-07-28 11:30:26. <9> Request from "UL 11.0.1.2405" for: remote
ID: d383010c-25d7-4fec-8f48-72eb03ff507b, user name: rdbs01, version:
AurubisPostenMobile_001
I. 2010-07-28 11:30:26. <9> The current synchronization is using a
connection with SPID '5'
I. 2010-07-28 11:30:26. <9> authenticate_user <connection> (no script)
I. 2010-07-28 11:30:26. <9> authenticate_user_hashed <connection> (no
script)
I. 2010-07-28 11:30:26. <9> authenticate_parameters <connection> (no
script)
I. 2010-07-28 11:30:26. <9> modify_user <connection> (no script)
W. 2010-07-28 11:30:26. <9> [10012] The consolidated and remote
databases disagree on when the last synchronization took place. The
remote is being asked to send a new upload that starts at the last
known synchronization point
I. 2010-07-28 11:30:26. <9> Progress offsets for the publications that
are explicitly involved in the current synchronization
I. 2010-07-28 11:30:26. <9> Subscription id 2: consolidated progress 4
and remote progress 3
I. 2010-07-28 11:30:26. <9> Synchronization failed

Again, as expected. What puzzles me is the fact that the report_error
script is not triggered. How do I know in my consolidated database
that something went wrong?

TIA,

Michael Fischer

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.