SQL Anywhere Mobile - ASA 9.0.1.1841

Author

ASA 9.0.1.1841

Kevin Dunn

2005-07-18, 7:23 am

During an user's synchronization attempt on their end they received a message stating:

Remote User: upload
I. 07/17 04:51:28. Warning: uploaded rows were ignored due to missing scripts in the consolidated.

Consolidated DB:
W. 07/17 05:44:42. <2.1> [tblack]: Warning: [10044] A row in table 'ist_billing_ind_hou
rs_remarks' could not be updated because it no longer exists in the consolidated database
W. 07/17 05:44:42. <2.1> [tblack]: Warning: [10040] 1 row(s) were ignored in updating table ist_billing_ind_hour
s_remarks

Is the remote user's message and the consolidated message saying the same thing?

--
Kevin Dunn
Email: kevin.dunn@spsinc.com
Home Email: kdunn2@carolina.rr.com
H: 704-263-2450
W: 704-544-5501 ext 295

Greg Fenton

2005-07-19, 3:24 am

Kevin Dunn wrote:
>
> Remote User: upload
> I. 07/17 04:51:28. Warning: uploaded rows were ignored due to missing
> scripts in the consolidated.
>

I believe this indicates that rows were uploaded for a table but there
was no corresponding upload_insert, upload_update or upload_delete
script for that table. Can you check the rest of the ML server log to
see if there is a message to that effect?

> Consolidated DB:
> W. 07/17 05:44:42. <2.1> [tblack]: Warning: [10044] A row in table
> 'ist_billing_ind_hou
rs_remarks' could not be updated because it no
> longer exists in the consolidated database
> W. 07/17 05:44:42. <2.1> [tblack]: Warning: [10040] 1 row(s) were
> ignored in updating table ist_billing_ind_hour
s_remarks

I don't think this is related. This is saying that an UPDATE was sent
by the remote, but that a row with that same primary key was not found
by your upload_update (or upload_fetch if you have one) script.

> Is the remote user's message and the consolidated message saying the
> same thing?

Again, I don't believe that they are. If they are related, I'd consider
this a bug ("missing scripts" vs. "missing row").

If you don't find a corresponding message in the ML server log but you
can reproduce this, please let us know (post back or open a case with
iAnywhere Technical Support or via CaseXpress (http://casexpress.sybase.com)

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Reg Domaratzki $iAnywhere Solutions$

2005-07-19, 9:24 am

The times on the two errors are also very different. I'm not convinced that
the message on the consolidated corresponds to the message in this dbmlsync
output.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42dc7169$1@foru
ms-1-dub...
> Kevin Dunn wrote:
>
> I believe this indicates that rows were uploaded for a table but there
> was no corresponding upload_insert, upload_update or upload_delete
> script for that table. Can you check the rest of the ML server log to
> see if there is a message to that effect?
>
>
>
> I don't think this is related. This is saying that an UPDATE was sent
> by the remote, but that a row with that same primary key was not found
> by your upload_update (or upload_fetch if you have one) script.
>
>
>
> Again, I don't believe that they are. If they are related, I'd consider
> this a bug ("missing scripts" vs. "missing row").
>
> If you don't find a corresponding message in the ML server log but you
> can reproduce this, please let us know (post back or open a case with
> iAnywhere Technical Support or via CaseXpress
(

>
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> [url]http://www.ianywhere.com/developer/" target="_blank">http://casexpress.sybase.com[/ url]....com/developer/

Kevin Dunn

2005-07-19, 11:24 am

I just did a test where I deleted a row in the consolidated database and
then updated the same row on a remote database and the messages were the
same as the ones below. Just a little misleading, it might be looking for
an error handling script.

--
Kevin Dunn
Email: kevin.dunn@spsinc.com
Home Email: kdunn2@carolina.rr.com
H: 704-263-2450
W: 704-544-5501 ext 295
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42dc7169$1@foru
ms-1-dub...
> Kevin Dunn wrote:
>
> I believe this indicates that rows were uploaded for a table but there was
> no corresponding upload_insert, upload_update or upload_delete script for
> that table. Can you check the rest of the ML server log to see if there
> is a message to that effect?
>
>
>
> I don't think this is related. This is saying that an UPDATE was sent by
> the remote, but that a row with that same primary key was not found by
> your upload_update (or upload_fetch if you have one) script.
>
>
>
> Again, I don't believe that they are. If they are related, I'd consider
> this a bug ("missing scripts" vs. "missing row").
>
> If you don't find a corresponding message in the ML server log but you can
> reproduce this, please let us know (post back or open a case with
> iAnywhere Technical Support or via CaseXpress
> (http://casexpress.sybase.com)
>
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Sponsored Links