SQL Anywhere Mobile - Mobilink crashes

Author

Mobilink crashes

Axel Stahl

2006-02-01, 7:24 am

Hello,

we got a serious problem at a customers installation with
following configuration:

Mobilink 9.01 Build 2085 on Windows 2000 standard server
Oracle 9i as consolidated db
Connection from remote db to Mobilink via HTTP protocol
Scripts for Up and Download are used

The Server crashes (mainly) when mor than 1 Client connects
to Mobilink. When 1 client connects there seem to be no crashes.
Are there more recent versions of Mobilink available and could someone
help me out with a link to hte updated versions (I got lost in the
EBD/Upgrade center of sybase).

Thanks in advanvce,
Axel Stahl

Reg Domaratzki $iAnywhere Solutions$

2006-02-01, 7:24 am

Try running with "-ps 0" on the MobiLink command line. We suspect there is
a mutli-threaded problem in the Oracle ODBC driver, but have never been able
to reproduce the problem. The problem seems to go away when you turn off
statement caching in the MobiLink server. There's something about the way
that MobiLink is re-using memory structures that the ODBC driver doesn't
like.

PS : You should choose more unique Subjects than the one you picked. Some
newsreaders will show this as a reply to a previous thread, and your chances
of getting your post noticed may be reduced.

--
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 filter to "Display ALL platforms IN ALL MONTHS"

"Axel Stahl" <pdg-online@gmx.de> wrote in message
news:43e08712$1@foru
ms-2-dub...
> Hello,
>
> we got a serious problem at a customers installation with
> following configuration:
>
> Mobilink 9.01 Build 2085 on Windows 2000 standard server
> Oracle 9i as consolidated db
> Connection from remote db to Mobilink via HTTP protocol
> Scripts for Up and Download are used
>
> The Server crashes (mainly) when mor than 1 Client connects
> to Mobilink. When 1 client connects there seem to be no crashes.
> Are there more recent versions of Mobilink available and could someone
> help me out with a link to hte updated versions (I got lost in the
> EBD/Upgrade center of sybase).
>
> Thanks in advanvce,
> Axel Stahl
>
>

Axel Stahl

2006-02-01, 9:26 am

Hello,

thanks for your reply, first of all sorry that I double posted it, something
was wrong with my newsreader, my article was not visible so I
re-posted it. Very sorry.

We are already running the server with the -ps 0 Parameter,
it seems to be a bit more stable, but it continues crashing
very often, when synchronising.

Are there more recent versions / fixed versions available?

Thanks for your answer and again sorry for double posting!

Axel

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
schrieb im Newsbeitrag news:43e0c42f$1@foru
ms-1-dub...
> Try running with "-ps 0" on the MobiLink command line. We suspect there
is
> a mutli-threaded problem in the Oracle ODBC driver, but have never been
able
> to reproduce the problem. The problem seems to go away when you turn off
> statement caching in the MobiLink server. There's something about the way
> that MobiLink is re-using memory structures that the ODBC driver doesn't
> like.
>
> PS : You should choose more unique Subjects than the one you picked. Some
> newsreaders will show this as a reply to a previous thread, and your
chances
> of getting your post noticed may be reduced.
>
> --
> 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 filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "Axel Stahl" <pdg-online@gmx.de> wrote in message
> news:43e08712$1@foru
ms-2-dub...
>
>

David Fishburn

2006-02-01, 11:25 am

"Axel Stahl" <pdg-online@gmx.de> wrote in news:43e0c73a$1@foru
ms-2-dub
of sybase.public.sqlanywhere.mobilink:

AS> We are already running the server with the -ps 0 Parameter,
AS> it seems to be a bit more stable, but it continues crashing
AS> very often, when synchronising.

A common mistake is people run the ML server using the ODBC driver that
comes with Oracle.

You MUST use a DSN created using the Oracle ODBC driver that is shipped
by iAnywhere Solutions.

Can you verify this and tell us what version of the iAnywhere Oracle
ODBC driver you are using? You can see this from the ODBC Administrator
GUI on the User/System/Drivers tabs.

Also, start ML using these additional switches:
-v+ -o ml.txt

And post the output. Then shutdown ML and restart it as you usually do.
I just want to see the usual startup information ML logs.

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