|
Home > Archive > SQL Anywhere Mobile > June 2005 > synchronize large data(blobs)
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 |
synchronize large data(blobs)
|
|
|
| Hi There!
I want to transfer a large data through the GPRS when I say
large I mean few blobs of 40-60 kb.
When I transfer one two blobs there where no problem but
when I tried to transfer 7 blobs it stacked because it took
to much time and it gave me an error :
"E. 05/22 15:25:16. <1.5> & #91;Qtek0543050172_u
]: Error: Unable
to read from the 'tcpip' network connection. Timed out
trying to read 480 bytes."
Or
"E. 05/22 15:41:08. <1.5> & #91;Qtek0543050172_u
]: Error: Unable
to read from the 'tcpip' network connection. Timed out
trying to read 2 bytes."
Should I change the communication type to HTTP or stay in
the TCPIP and if so how I keep the connection open enough
time to get all the data
I set the liveness_timeout to 0 in =96x option.
and i tried the -bc option to 1 g
Have a nice day
best regards ,
Omri Ziv
QIS ltd
| |
|
| > Hi There!
> I want to transfer a large data through the GPRS when I
> say large I mean few blobs of 40-60 kb.
>
> When I transfer one two blobs there where no problem but
> when I tried to transfer 7 blobs it stacked because it
> took to much time and it gave me an error :
>
> "E. 05/22 15:25:16. <1.5> & #91;Qtek0543050172_u
]: Error:
> Unable to read from the 'tcpip' network connection. Timed
> out trying to read 480 bytes."
>
> Or
>
> "E. 05/22 15:41:08. <1.5> & #91;Qtek0543050172_u
]: Error:
> Unable to read from the 'tcpip' network connection. Timed
> out trying to read 2 bytes."
>
>
>
> Should I change the communication type to HTTP or stay in
> the TCPIP and if so how I keep the connection open enough
> time to get all the data
>
> I set the liveness_timeout to 0 in =96x option.
> and i tried the -bc option to 1 g
>
> Have a nice day
>
>
> best regards ,
>
> Omri Ziv
>
> QIS ltd
i forgot::
i use mobililink 9.0.3044
| |
| Greg Fenton 2005-05-24, 9:24 am |
| Omri wrote:
>
> I want to transfer a large data through the GPRS when I say
> large I mean few blobs of 40-60 kb.
>
What is the remote database, UltraLite or ASA ?
If ASA, what is in the dbmlsync console log after a failed synch?
If UL, what is the value of SQLCode after your call to Synchronize() or
ULSynchronize() [or whichever function you use for the API you have
chosen] ?
Is there sufficient space on the remote device for receiving those files?
> "E. 05/22 15:41:08. <1.5> & #91;Qtek0543050172_u
]: Error: Unable
> to read from the 'tcpip' network connection. Timed out
> trying to read 2 bytes."
This typically means that the client's connection dropped during
synchronization. This could be a GPRS-provider problem, a device
problem, or something else. The answers to the above questions will
hopefully rule out an application problem.
BTW: Stick with TCPIP. Going to HTTP will likely not alleviate your
problem.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| > Omri wrote:
>
> What is the remote database, UltraLite or ASA ?
>
> If ASA, what is in the dbmlsync console log after a failed
> synch? If UL, what is the value of SQLCode after your call
> to Synchronize() or ULSynchronize() [or whichever
> function you use for the API you have chosen] ?
>
> Is there sufficient space on the remote device for
> receiving those files?
>
>
> This typically means that the client's connection dropped
> during synchronization. This could be a GPRS-provider
> problem, a device problem, or something else. The
> answers to the above questions will hopefully rule out an
> application problem.
>
> BTW: Stick with TCPIP. Going to HTTP will likely not
> alleviate your problem.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
lets be more specific :
the mobilink is 9.0.2.3044
ultralite 9.0.2
device i-mate
consolidate oracle9i
i need to broadcast (through GPRS) alot of blobs(100-200) in
the size of 40-60 kb
i tried to put them all in a table and the broadcast
(through GPRS)
from the tablr in the device to the mobilink and to the
oracle ,it gave me after 4 min aproximetly:
E. 05/31 12:56:22. <1.10> & #91;Qtek0543050172_u
]: Error:
Unable to read from the 'tcpip' network connection.
Timed
out trying to read 2 bytes.
when i tried to do it with loop one blob at a time it gave
me after
5-6 blobs the same error.
the command line of the mobilink is:
dbmlsrv9 -fr -c " dsn=blms9;pwd=blms;u
id=blms" -b
-o "c:\\temp\\mlerver.txt" -u 2g -w 10 -bc 3g -os 5m -v+
-zp
is this ok or should i change something??
thank you in advenced
Omri Ziv
| |
| Greg Fenton 2005-05-31, 9:24 am |
| Omri wrote:
> ultralite 9.0.2
What is the SQLCode after the failed synchronization?
Which UL API are you using (ESQL? C++ API? MobileVB? ...)
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
|
> Omri wrote:
i get sql_noerror
but i used the SyncProgressDialog and it gave me
Sync_dlg_err_upload_
ok and the mobilink stuck on request
i didn't find this propery anywhere what does it means and
how can i solve it??[color=darkred]
> What is the SQLCode after the failed synchronization?
> Which UL API are you using (ESQL? C++ API? MobileVB? ...)
>
> 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-05-31, 11:24 am |
| Omri wrote:
>
> i get sql_noerror
> but i used the SyncProgressDialog and it gave me
> Sync_dlg_err_upload_
ok and the mobilink stuck on request
> i didn't find this propery anywhere what does it means and
> how can i solve it??
Can you post the code for your UL app where you configure and call
synchronization? Also show us where you are getting the SQLCode.
You haven't answered some of my other questions:
- which UL API are you using (.NET? ESQL? C++? ...)
- do you have sufficient space on your device (for 200 BLOBs at 60k
means you need approximately 1.2 MB)?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| i'm using ultralite . NET and i'm sending to a regular
computer so it has enough space,
the code that i synchronize in the atattched file
have a nice day
Omri Ziv
> Omri wrote:
>
> Can you post the code for your UL app where you configure
> and call synchronization? Also show us where you are
> getting the SQLCode.
>
> You haven't answered some of my other questions:
>
> - which UL API are you using (.NET? ESQL? C++? ...)
> - do you have sufficient space on your device (for 200
> BLOBs at 60k means you need approximately 1.2 MB)?
>
> 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-06-01, 9:25 am |
| Omri wrote:
> i'm using ultralite . NET and i'm sending to a regular
> computer so it has enough space,
> the code that i synchronize in the atattched file
>
Well, I don't have any further ideas myself. Someone else might pop
into this thread, but at this point I suggest contacting iAnywhere
Technical Support.
http://www.ianywhere.com/support/co...ct_support.html
Sorry,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| hey,Don't give up i need your help!
meybe the the comand line of the mobilink need more
parameters??
dbmlsrv9 -fr -c " dsn=blms9;pwd=blms;u
id=blms" -b -o
"c:\\temp\\mlerver1.txt" -u 2g -w 10 -bc 120m -os 5m -v+
-zp
or maybe the ultralite need to reconnect again after a
while??
need help!!
Omri Ziv
> Omri wrote:
>
> Well, I don't have any further ideas myself. Someone else
> might pop into this thread, but at this point I suggest
> contacting iAnywhere Technical Support.
>
>
>
http://www.ianywhere.com/support/co...ct_support.html
>
> Sorry,
> 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-06-03, 9:24 am |
| Omri wrote:
> meybe the the comand line of the mobilink need more
> parameters??
> dbmlsrv9 -fr -c " dsn=blms9;pwd=blms;u
id=blms" -b -o
> "c:\\temp\\mlerver1.txt" -u 2g -w 10 -bc 120m -os 5m -v+
> -zp
I cannot think of any parameters that would help based on what info we
have so far. The issue here is that we don't know what the *problem*
is. Throwing extra parameters at the client or server won't magically
make the behaviour better...it might just mask the problem further.
I suggest you contact Technical Support so that they can work with you
on narrowing down the exact cause of the problem. It could have to do
with you synch scripts, with the ODBC driver you are using, with your UL
synch parms, or it could be a bug in ML and/or UL. The newsgroups
aren't a good forum for non-obvious problems like this. Tech Support
specialize in solving these types of issues (or at least reducing the
problem down to an engineering case).
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|