Rows won't upload - 08-26-2009 , 02:45 AM
I have a problem with a particular UltraLite database, where certain rows
from a table simply won't synchronise. The affected rows are about 21, and
rows before these 21 have uploaded successfully, and rows after these 21
have uploaded successfully. If I open the database in Sybase Central, and
update these 21 rows using Interactive SQL (Just a dummy update - set a
certain field to '123' and back to NULL), and then synchronise using the
wizard in Sybase Central, then these rows are uploaded.
We have a C#.Net application written to access this UltraLite database, and
we synchronise data in our application on a timer in the background. We
hence rely on UltraLite 11's snapshot synchronisation feature, which takes a
snapshot of data at the time a synchronisation is requested. All data
access, and the synchronisation itself, happen on different threads, and it
is entirely possible that data is being updated/inserted into the UltraLite
database whicle synchronisations are taking place.
We're using UltraLite version 22.214.171.1240, and our Mobilink server is
running the same version. Our consolidated database is running under
Microsoft SQL Server 2005.
Any help anyone could give would be greatly appreciated!
Re: Rows won't upload - 08-26-2009 , 09:48 AM
Graham Downs wrote:
1) UltraLite may have uploaded the rows, but the MobiLink server did not
apply them for some reason.
- Can you look back in the MobiLink output logs and see the
synchronization from this user where you believe the rows should have
2) UltraLite may have never uploaded the row for some reason.
- Have you tried running ulvalid against the UL database to see if there
is any corruption in the file?
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup
Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"
Re: Rows won't upload - 08-27-2009 , 02:25 AM
I tried validating the UltraLite database in Sybase Central. It reported as
What do you mean by "output logs"? If it's just the log file (text file)
that the Mobilink Service generates, then unfortunately I cannot see that
info there, because the verbosity setting on the service isn't high enough.
I did see numerous syncs from that particular user on the particular day
when the rows should have been uploaded. They all finished with
"Reg Domaratzki [Sybase iAnywhere]" <firstname.lastname (AT) ianywhere (DOT) com> wrote
in message news:4a954b3f$1 (AT) forums-1-dub (DOT) ..