SQL Anywhere Mobile - Mobilink crash (9.02 2451)

Author

Mobilink crash (9.02 2451)

tomekp

2005-10-27, 8:21 am

We have a problem with mobilink (like in subject). If any script have an
error (for example too many columns in download cursor) mobilink d'nt
display this information but shut down. What is wrong ? Mobilink (sybase)
version on somethink in command line. Could you help as.

Regards
Tom

David Fishburn

2005-10-27, 8:21 am

"tomekp" <tomasz. pulawski@anicasystem
.com.pl> wrote in
news:435dea66$1@foru
ms-1-dub of sybase.public.sqlanywhere.mobilink:

t> We have a problem with mobilink (like in subject). If any script have
t> an error (for example too many columns in download cursor) mobilink
t> d'nt display this information but shut down. What is wrong ? Mobilink
t> (sybase) version on somethink in command line. Could you help as.

Try applying the current 902 EBF and see if the problem was solved.
See link below my name.

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

tomekp

2005-10-27, 8:21 am

> t> We have a problem with mobilink (like in subject). If any script have
> t> an error (for example too many columns in download cursor) mobilink
> t> d'nt display this information but shut down. What is wrong ? Mobilink
> t> (sybase) version on somethink in command line. Could you help as.
>
> Try applying the current 902 EBF and see if the problem was solved.
> See link below my name.
>
We install 9.02.3198 but problem still exists

Regards
Tom

Greg Fenton

2005-10-27, 8:21 am

tomekp wrote:
> We have a problem with mobilink (like in subject). If any script have an
> error (for example too many columns in download cursor) mobilink d'nt
> display this information but shut down. What is wrong ?

Do you have a "handle_error" event?

Can you run ML with "-v+ -o ml.out" and post the ml.out file after one
of the synchronizations where ML shuts down?

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

tomekp

2005-11-02, 9:24 am

> Do you have a "handle_error" event?
>
> Can you run ML with "-v+ -o ml.out" and post the ml.out file after one of
> the synchronizations where ML shuts down?
>

Log file:

I. 10/27 15:56:46. <1.5> [2]: download_cursor TYP_KLIENTA (open for read):
SELECT aID_TYP_KLIENTA, RTRIM(NAZWA), id_typ_ogolny
FROM TYP_KLIENTA
E. 10/27 15:56:46. <1.5> [2]: Error: [-10002] ODBC: [Microsoft][ODBC SQL
Server Driver][SQL Server]Invalid column name 'aID_TYP_KLIENTA'. (ODBC State
= 42S22, Native error code = 207)
E. 10/27 15:56:46. <1.5> [2]: Error: [-10002] ODBC: [Microsoft][ODBC SQL
Server Driver][SQL Server]Statement(s) could not be prepared. (ODBC State =
42000, Native error code = 8180)
I. 10/27 15:56:46. <1.5> [2]: Error Context:
I. 10/27 15:56:46. <1.5> [2]: User Name: 2
I. 10/27 15:56:46. <1.5> [2]: Modified User Name: 2
I. 10/27 15:56:46. <1.5> [2]: Transaction: download
I. 10/27 15:56:46. <1.5> [2]: Table Name: TYP_KLIENTA
I. 10/27 15:56:46. <1.5> [2]: Script Version: Sec PH 15
I. 10/27 15:56:46. <1.5> [2]: Script: SELECT aID_TYP_KLIENTA,
RTRIM(NAZWA), id_typ_ogolny FROM TYP_KLIENTA where data_synch >=
dateadd(hh,-1,(select data_synch from pracownik where id_pracownik = (select
id_user from ml_info where id_connection = @@spid)))
I. 10/27 15:56:46. <1.5> [2]: End of Error Context
I. 10/27 15:56:46. <1.5> [2]: handle_error <connection>
{Call
ObslugaBledow (?,?,?,?,?)}
I. 10/27 15:56:46. <1.5> [2]: The handle_error script returned 1000
I. 10/27 15:56:46. <1.5> [2]: handle_error <connection>
{Call
ObslugaBledow (?,?,?,?,?)}
I. 10/27 15:56:46. <1.5> [2]: The handle_error script returned 1000

Greg Fenton

2005-11-03, 8:29 pm

tomekp wrote:
> E. 10/27 15:56:46. <1.5> [2]: Error: [-10002] ODBC: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Invalid column name 'aID_TYP_KLIENTA'. (ODBC State
> = 42S22, Native error code = 207)

Which version of MSSQL are you using?
Which ODBC driver and version are you using?
Is it one of the supported drivers?

http://www.ianywhere.com/developer/...L_
Server

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

tomekp

2005-11-03, 8:29 pm

>
> Which version of MSSQL are you using?
> Which ODBC driver and version are you using?
> Is it one of the supported drivers?
>
> http://www.ianywhere.com/developer/...L_
Server
>

MSSQL 2000
ODBC SQL Server 2000.85.1117.00 (2004-08-04)

David Fishburn

2005-11-08, 4:14 pm

"tomekp" <tomasz. pulawski@anicasystem
.com.pl> wrote in
news:4368d0c3@forums
-1-dub of sybase.public.sqlanywhere.mobilink:

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