SQL Anywhere Mobile - SQLE_COMMUNICATIONS

Author

SQLE_COMMUNICATIONS_ERROR on v9.0.2.3137

rr12

2005-09-28, 8:25 pm

The remote is UL.NET and the consolidated is ASA. Synch is via ActiveSync.

The server reports a successful synch; but the device gets a
SQLE_COMMUNICATIONS_
ERROR during or immediately after the
STATE_RECEIVING_DATA
. The SyncResult.StreamErrorCode = "NONE" and the
download rolls back.

Somehow, this is related to my upload_insert methodology; which changes the
primary key values. As I write to the consolidated table in the
upload_insert; I write the original key into a global temporary table and
then I execute a INSERT, omitting my autoincrement primary key column, which
then generates a new key. The insert works fine.

Then in the download_delete_curs
or, I select the old primary keys from the
global temporary table (Select * from todo natural join rv_todo_dels)

Then in end_download I truncate my temporary table (truncate table
rv_todo_dels). I also truncate the table on begin_synchronizatio
n just to
be sure.

The synch works fine when there are no inserts or if I leave out the
download_delete_curs
or script.

Anyone heard of this or know what I might be missing?

rr12

Greg Fenton

2005-09-28, 8:25 pm

rr12 wrote:
>
> Then in the download_delete_curs
or, I select the old primary keys from the
> global temporary table (Select * from todo natural join rv_todo_dels)
>

I strongly recommend against using "SELECT *" in download scripts
(actually, I recommend against ever using it in any source
code....defaults and all that ;-) )

For the download_delete_curs
or, you are only to send down the primary
key columns, not the entire row. Make this change and see if you get
any different behaviours.

Also, make sure you are resetting your test remote instead of trying to
synchronize the same remote. If it is in a funky state already,
resynch'ing the same db may not work although synch'ing a new database
might be fine. This is a development stage afterall :-)

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

rr12

2005-09-28, 8:25 pm

Sorry. The download_delete_curs
or was actually, "Select todo.thekey from
todo natural join rv_todo_dels"

Also, I am deleting my remote db on every test just to be sure things don't
get confused. I've also reset my db/ml servers.

rr12

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:433b15a0$1@foru
ms-2-dub...
> rr12 wrote:
>
> I strongly recommend against using "SELECT *" in download scripts
> (actually, I recommend against ever using it in any source
> code....defaults and all that ;-) )
>
> For the download_delete_curs
or, you are only to send down the primary key
> columns, not the entire row. Make this change and see if you get any
> different behaviours.
>
> Also, make sure you are resetting your test remote instead of trying to
> synchronize the same remote. If it is in a funky state already,
> resynch'ing the same db may not work although synch'ing a new database
> might be fine. This is a development stage afterall :-)
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Greg Fenton

2005-09-29, 3:24 am

rr12 wrote:
> Sorry. The download_delete_curs
or was actually, "Select todo.thekey from
> todo natural join rv_todo_dels"
>

Can you package up a simple repro and submit it either via iAnywhere
Technical Support or CaseXpress (http://case-express.sybase.com/)?

If it is simple enough, you might consider posting it here too (or first).

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

rr12

2005-10-27, 8:20 am

I've worked on this a bit and narrowed it down to the following problem:

I can't delete selected rows at all in my download_delete_curs
or. I get the
SQLE_COMMUNICATIONS_
ERROR. This occurs even after I've removed all other
sync scripts.

Even "Select thekey from todo" and "Select '101'" don't work. The only
thing that does work is "Select null"

The server log looks fine and thinks everything worked. For example, it
shows 6 rows in my table to delete; but on the remote device the
"ReceivedDeletes" only reports '1' and then an immediate
STATE_ROLLING_BACK_D
OWNLOAD .

Please help.

rr12

I've tried very simple things
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:433b9d0d@forums
-2-dub...
> rr12 wrote:
>
> Can you package up a simple repro and submit it either via iAnywhere
> Technical Support or CaseXpress (http://case-express.sybase.com/)?
>
> If it is simple enough, you might consider posting it here too (or first).
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

David Fishburn

2005-10-27, 8:20 am

"rr12" <abc@123.com> wrote in news:43421a4b$1@foru
ms-2-dub of
sybase.public.sqlanywhere.mobilink:

rr12> I've worked on this a bit and narrowed it down to the following
rr12> problem:
rr12>
rr12> I can't delete selected rows at all in my download_delete_curs
or.
I
rr12> get the SQLE_COMMUNICATIONS_
ERROR. This occurs even after I've
rr12> removed all other sync scripts.
rr12>
rr12> Even "Select thekey from todo" and "Select '101'" don't work. The
rr12> only thing that does work is "Select null"
rr12>
rr12> The server log looks fine and thinks everything worked. For
example,
rr12> it shows 6 rows in my table to delete; but on the remote device the
rr12> "ReceivedDeletes" only reports '1' and then an immediate
rr12> STATE_ROLLING_BACK_D
OWNLOAD .

Well, I looked through and I didn't see version and BUILD mentioned for:
1. The MobiLink server
2. The UltraLite client

Please provide this information with each and every new thread.

If the client isn't at the current 902 EBF, I suggest upgrading it
first, wiping out the remote, and trying this again with a fresh UL
database and the most current software.

--
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]

rr12

2005-10-27, 8:20 am

The versions were all 3137.

I've now upgraded to 3193 for everything. I still get the same result.

The platform is ActiveSync 3.8, tcpip stream, ml and db servers on win 2003
network server (not on the same machine as activesync), ppc 2002 ARM,
windows xp sp2, vb.net 2003, cf 1.0.

rr12

"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96E55AFAB7F0
fishburnsybasecom@12
7.0.0.1...
> "rr12" <abc@123.com> wrote in news:43421a4b$1@foru
ms-2-dub of
> sybase.public.sqlanywhere.mobilink:
>
> rr12> I've worked on this a bit and narrowed it down to the following
> rr12> problem:
> rr12>
> rr12> I can't delete selected rows at all in my download_delete_curs
or.
> I
> rr12> get the SQLE_COMMUNICATIONS_
ERROR. This occurs even after I've
> rr12> removed all other sync scripts.
> rr12>
> rr12> Even "Select thekey from todo" and "Select '101'" don't work. The
> rr12> only thing that does work is "Select null"
> rr12>
> rr12> The server log looks fine and thinks everything worked. For
> example,
> rr12> it shows 6 rows in my table to delete; but on the remote device the
> rr12> "ReceivedDeletes" only reports '1' and then an immediate
> rr12> STATE_ROLLING_BACK_D
OWNLOAD .
>
> Well, I looked through and I didn't see version and BUILD mentioned for:
> 1. The MobiLink server
> 2. The UltraLite client
>
> Please provide this information with each and every new thread.
>
> If the client isn't at the current 902 EBF, I suggest upgrading it
> first, wiping out the remote, and trying this again with a fresh UL
> database and the most current software.
>
> --
> 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]
>

David Fishburn

2005-10-27, 8:20 am

"rr12" <abc@123.com> wrote in news:4342b6ce$1@foru
ms-1-dub of
sybase.public.sqlanywhere.mobilink:

Then as Greg said, you need to open a case with Technical Support.
--
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