SQL Anywhere Mobile - Timing Issue

Author

Timing Issue

Donna Osburn

2005-07-19, 8:25 pm

Adaptive Server Anywhere MobiLink Version 9.0.1.1751
I'm having a timing issue on synchronization. I have a
Consolidated table HHSpecialListData that has 39 records in
it. The first time i synced the table down to the remote,
only 13 records went to the remote because of a data issue.
I fixed the data issue and reset the time stamp on the table
to the current time so that the data would be synced at the
next sync. However, the remaining records will NOT go to
the remote. I am at a loss for how to get those additional
records on the remote. If i take the exact translated sql
data from the mobilink verbose log and run it in the
consolidated QA i get all 39 records. I cannot figure out
what is stopping the additional records from being synced to
the remote. Any help would be appreciated. Oh - if i start
with a blank remote database, all 39 records sync correctly
to the remote.
Thanks
Donna
I. 07/18 11:57:35. <1.5> [BG06]: download_cursor
HHSpecialListData (open for read):
SELECT SLD.fihhspltpk, SLD.fihhitemfk,
SLD.fispcdfk
FROM HHSpecialListData SLD
INNER JOIN HHSPecialListCD SLC ON
SLC.fispcdfk = SLD.fispcdfk
AND SLC.flstatus = 1
INNER JOIN HHLoadListData LL ON
LL.fihhitemfk = SLD.fihhitemfk AND LL.flstatus = 1
INNER JOIN TMPLastDownload TLD ON
TLD.fispid = @@spid
WHERE ? IS NOT NULL AND (SLC.ftcreate >
TLD.ftlasttime OR SLD.ftcreate > TLD.ftlasttime) AND
LL.fchhcd = ? AND SLC.fchhcd = LL.fchhcd ;

I. 07/18 11:57:35. <1.5> [BG06]: Translated SQL:
SELECT SLD.fihhspltpk, SLD.fihhitemfk,
SLD.fispcdfk
FROM HHSpecialListData SLD
INNER JOIN HHSPecialListCD SLC ON
SLC.fispcdfk = SLD.fispcdfk
AND SLC.flstatus = 1
INNER JOIN HHLoadListData LL ON
LL.fihhitemfk = SLD.fihhitemfk AND LL.flstatus = 1
INNER JOIN TMPLastDownload TLD ON
TLD.fispid = @@spid
WHERE ? IS NOT NULL AND (SLC.ftcreate >
TLD.ftlasttime OR SLD.ftcreate > TLD.ftlasttime) AND
LL.fchhcd = ? AND SLC.fchhcd = LL.fchhcd ;

David Fishburn

2005-07-20, 11:23 am

Donna Osburn wrote in news:42dd593f.3596.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

DO> Adaptive Server Anywhere MobiLink Version 9.0.1.1751
DO> I'm having a timing issue on synchronization. I have a
DO> Consolidated table HHSpecialListData that has 39 records in
DO> it. The first time i synced the table down to the remote,
DO> only 13 records went to the remote because of a data issue.
DO> I fixed the data issue and reset the time stamp on the table
DO> to the current time so that the data would be synced at the
DO> next sync. However, the remaining records will NOT go to
DO> the remote. I am at a loss for how to get those additional
DO> records on the remote. If i take the exact translated sql
DO> data from the mobilink verbose log and run it in the
DO> consolidated QA i get all 39 records. I cannot figure out
DO> what is stopping the additional records from being synced to
DO> the remote. Any help would be appreciated. Oh - if i start
DO> with a blank remote database, all 39 records sync correctly
DO> to the remote.

Well what you have shown doesn't give us enough information to help you.

In this case I would want you to start ML using -v+ -o ml.txt.
I am hoping the verbose output will *also* display your last_download
timestamp. I am pretty sure it does this in the 902 release, and I think
it
does it in the 901 release.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Donna Osburn

2005-07-20, 1:23 pm

About 4 hours after i posted this - i found that the 39
records were dutifully being sent by mobilink to the remote.
however, they contained foriegn keys to records in another
table that had not been sent to the remote and becuase of
foreign key constraints, it could not add the records.
(which makes me feel better to at least understand what
happened)

My bigger issue i have to figure out is why only some of the
main items went down instead of all of them. I'll keep
puzzling on it. Thanks
Donna

> Donna Osburn wrote in
> news:42dd593f.3596.1681692777@sybase.com of
> sybase.public.sqlanywhere.mobilink:
>
> DO> Adaptive Server Anywhere MobiLink Version 9.0.1.1751
> DO> I'm having a timing issue on synchronization. I have
> a DO> Consolidated table HHSpecialListData that has 39
> records in DO> it. The first time i synced the table down
> to the remote, DO> only 13 records went to the remote
> because of a data issue. DO> I fixed the data issue and
> reset the time stamp on the table DO> to the current time
> so that the data would be synced at the DO> next sync.
> However, the remaining records will NOT go to DO> the
> remote. I am at a loss for how to get those additional
> DO> records on the remote. If i take the exact translated
> sql DO> data from the mobilink verbose log and run it in
> the DO> consolidated QA i get all 39 records. I cannot
> figure out DO> what is stopping the additional records
> from being synced to DO> the remote. Any help would be
> appreciated. Oh - if i start DO> with a blank remote
> database, all 39 records sync correctly DO> to the remote.
>
> Well what you have shown doesn't give us enough
> information to help you.
>
> In this case I would want you to start ML using -v+ -o
> ml.txt. I am hoping the verbose output will *also* display
> your last_download timestamp. I am pretty sure it does
> this in the 902 release, and I think it
> does it in the 901 release.
>
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD
> number with EACH post (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
>
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
>

Sponsored Links