Home > Archive > SQL Anywhere ultralite > October 2005 > windows mobile 5 activesync 4 asa 9.0.2.3137 ultraLite.net communications error









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author windows mobile 5 activesync 4 asa 9.0.2.3137 ultraLite.net communications error
Dave Joyner

2005-10-27, 7:41 am

The company bought a new ipaq with Windows Mobile 5.0, ActiveSync 4.0 and I
deployed our application to it without any problems. However, I get a
SQLE_COMMUNICATIONS_
ERROR at the end of the sync download. The exact
message is:

"Synchronization error. Data was uploaded and committed, but an error
occurred during download. SQLCode=SQLE_COMMUNI
CTIONS_ERROR"

The same code and setup are working fine for PPC 2003 and PPC 2002
ActiveSync 3.8.

Thanks
Dave Joyner



David Fishburn

2005-10-27, 7:41 am

"Dave Joyner" <d4ljoyn@yahoo.com> wrote in news:4356410c$1@foru
ms-2-dub
of sybase.public.sqlanywhere.ultralite:

DJ> The company bought a new ipaq with Windows Mobile 5.0, ActiveSync 4.0
DJ> and I deployed our application to it without any problems. However,
I
DJ> get a SQLE_COMMUNICATIONS_
ERROR at the end of the sync download. The
DJ> exact message is:
DJ>
DJ> "Synchronization error. Data was uploaded and committed, but an
error
DJ> occurred during download. SQLCode=SQLE_COMMUNI
CTIONS_ERROR"
DJ>
DJ> The same code and setup are working fine for PPC 2003 and PPC 2002
DJ> ActiveSync 3.8.

What does the MobiLink log show?

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

Dave Joyner

2005-10-27, 7:41 am

Here's the bottom of one I just ran that failed ....
.....
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: NJ
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: 08865
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: 908
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: 2132947
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: 1922-06-04 00:00:00.000000
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: 066188741
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: 3
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: F
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: download_cursor Patient (close)
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: COMMIT Transaction: end_download
I. 10/19 09:49:20. <1.5> [WM_djoyner1]: Sending the download to the remote
database.
I. 10/19 09:56:30. <1.5> [WM_djoyner1]: Creating download cache file
" f:\home\djoyner\Temp
\rd00000001"
I. 10/19 09:56:30. <1.5> [WM_djoyner1]: COMMIT Transaction:
end_synchronization
I. 10/19 09:56:30. <1.5> [WM_djoyner1]: Synchronization complete



"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96F45CFA2DCA
Efishburnsybasecom@1
27.0.0.1...
> "Dave Joyner" <d4ljoyn@yahoo.com> wrote in news:4356410c$1@foru
ms-2-dub
> of sybase.public.sqlanywhere.ultralite:
>
> DJ> The company bought a new ipaq with Windows Mobile 5.0, ActiveSync 4.0
> DJ> and I deployed our application to it without any problems. However,
> I
> DJ> get a SQLE_COMMUNICATIONS_
ERROR at the end of the sync download. The
> DJ> exact message is:
> DJ>
> DJ> "Synchronization error. Data was uploaded and committed, but an
> error
> DJ> occurred during download. SQLCode=SQLE_COMMUNI
CTIONS_ERROR"
> DJ>
> DJ> The same code and setup are working fine for PPC 2003 and PPC 2002
> DJ> ActiveSync 3.8.
>
> What does the MobiLink log show?
>
> --
> 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, 7:41 am

"Dave Joyner" <d4ljoyn@yahoo.com> wrote in news:43565266@forums
-2-dub of
sybase.public.sqlanywhere.ultralite:

....
DJ> I. 10/19 09:56:30. <1.5> [WM_djoyner1]: Creating download cache file
DJ> " f:\home\djoyner\Temp
\rd00000001"
DJ> I. 10/19 09:56:30. <1.5> [WM_djoyner1]: COMMIT Transaction:
DJ> end_synchronization
DJ> I. 10/19 09:56:30. <1.5> [WM_djoyner1]: Synchronization complete

Okay, from ML perspective it sent the data successfully.
How large is the download?
The MobiLink monitor would tell you this.

What happens if you send less data?
I am wondering if the device has lost it's connectivity to the server?
Dropped network.


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

Dave Joyner

2005-10-27, 7:41 am

I tried a smaller source database this morning. Sure enough the download
completes both from the server and device perspective. Note that the
original data source does not exceed the 64k row limit or any other
ultralite limit that I'm aware of. The problems are:

1) the same data source that fails on WM5 succeeds with PPC2003 and PPC2002
(we have several of these working)
2) it is not device specific -- I downloaded the WM5 sdk and got the
emulator running -- it behaves exactly the same as the ipaq.

So is there anything else I can do to get this thing running ?

Thanks for your time
Dave Joyner

"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96F55E696F05
0fishburnsybasecom@1
27.0.0.1...
> "Dave Joyner" <d4ljoyn@yahoo.com> wrote in news:43565266@forums
-2-dub of
> sybase.public.sqlanywhere.ultralite:
>
> ...
> DJ> I. 10/19 09:56:30. <1.5> [WM_djoyner1]: Creating download cache file
> DJ> " f:\home\djoyner\Temp
\rd00000001"
> DJ> I. 10/19 09:56:30. <1.5> [WM_djoyner1]: COMMIT Transaction:
> DJ> end_synchronization
> DJ> I. 10/19 09:56:30. <1.5> [WM_djoyner1]: Synchronization complete
>
> Okay, from ML perspective it sent the data successfully.
> How large is the download?
> The MobiLink monitor would tell you this.
>
> What happens if you send less data?
> I am wondering if the device has lost it's connectivity to the server?
> Dropped network.
>
>
> --
> 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, 7:41 am

"Dave Joyner" <d4ljoyn@yahoo.com> wrote in news:4357dd0d$1@foru
ms-2-dub
of sybase.public.sqlanywhere.ultralite:

DJ> I tried a smaller source database this morning. Sure enough the
DJ> download completes both from the server and device perspective. Note
DJ> that the original data source does not exceed the 64k row limit or
any
DJ> other ultralite limit that I'm aware of. The problems are:
DJ>
DJ> 1) the same data source that fails on WM5 succeeds with PPC2003 and
DJ> PPC2002 (we have several of these working)
DJ> 2) it is not device specific -- I downloaded the WM5 sdk and got the
DJ> emulator running -- it behaves exactly the same as the ipaq.

Hmmm, I just noticed you didn't specify version and BUILD, please
include this with each new post.

There are a number of variables, ActiveSync 4.0 vs ActiveSync 3.8.
New windows version.
Works with a smaller dataset.

Let me clarify, you indicated that you can reproduce the -85 error by
running and syncing your application in the emulator?

If so, that should be enough to submit a case with technical support.

Of course, we would need your consolidated, ML command line, possibly
your emulator session.


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

Dave Joyner

2005-10-27, 7:41 am

Hmmm I thought that 3137 was the build number, no ? That is clearly in the
subject line.

Yes. I can reproduce the problem by running the application in the WM5
emulator.

I will look into submitting a bug report.

Are WM5 and ActiveSync 4 supported ?

"David Fishburn" <fishburn_spam@off.ianywhere.com> wrote in message
news:Xns96F65ABD565E
7fishburnsybasecom@1
27.0.0.1...
> "Dave Joyner" <d4ljoyn@yahoo.com> wrote in news:4357dd0d$1@foru
ms-2-dub
> of sybase.public.sqlanywhere.ultralite:
>
> DJ> I tried a smaller source database this morning. Sure enough the
> DJ> download completes both from the server and device perspective. Note
> DJ> that the original data source does not exceed the 64k row limit or
> any
> DJ> other ultralite limit that I'm aware of. The problems are:
> DJ>
> DJ> 1) the same data source that fails on WM5 succeeds with PPC2003 and
> DJ> PPC2002 (we have several of these working)
> DJ> 2) it is not device specific -- I downloaded the WM5 sdk and got the
> DJ> emulator running -- it behaves exactly the same as the ipaq.
>
> Hmmm, I just noticed you didn't specify version and BUILD, please
> include this with each new post.
>
> There are a number of variables, ActiveSync 4.0 vs ActiveSync 3.8.
> New windows version.
> Works with a smaller dataset.
>
> Let me clarify, you indicated that you can reproduce the -85 error by
> running and syncing your application in the emulator?
>
> If so, that should be enough to submit a case with technical support.
>
> Of course, we would need your consolidated, ML command line, possibly
> your emulator session.
>
>
> --
> 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, 7:41 am

"Dave Joyner" <d4ljoyn@yahoo.com> wrote in news:435a21e3$1@foru
ms-2-dub
of sybase.public.sqlanywhere.ultralite:

DJ> Hmmm I thought that 3137 was the build number, no ? That is clearly
DJ> in the subject line.

Geez, I never read the subject line. Always miss it there ...

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





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com