SQL Anywhere Mobile - Re: Error: [-10050] Select Window problems.

Author

Re: Error: [-10050] Select Window problems.

David Fishburn

2005-03-30, 9:42 am

Jeff Norman wrote in news:421e398f.72c4.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

JN> E. 02/24 13:26:25. <1.5> [3F7B8BD28BCE0]: Error: [-10050]
JN> Select Window

I did a bit more searching around:

According to the ASA Help file:
ASA Error Messages
MobiLink Synchronization Server Error Messages
MobiLink synchronization server error messages sorted by code

....
–10050 Expecting %1!ld! columns in cursor, but found %2!ld!

So this is telling you the # of columns in the SELECT is incorrect.

When I had you run ML using -v+, the output includes the "schema
description" that the remote uploaded.

Comparing that to your SELECT we see the following:

YOURS
-----
SELECT "SITE_NAME"
, "CLIENT_ID"
, "PRECIPITATION"
, "TRIGGER_FLAG"
, "LOCATION_COMMENT"
, "LINE_BEARING"
, "LINE_LENGTH"
, "PASTURE_SIZE"
, "HISTORY_COMMENT"
, "MGMT_GOALS"
, "OTHER_GOALS"
, "ACCESSIBLE_FLAG"
, "REPRESENTATIVE_FLAG"
, "MGMT_CHANGE_FLAG"
, "CONCERN_AREA_FLAG"
, "SITE_CHOICE_COMMENT"
, "ELEVATION"
, "ASPECT"
, "DATE_PSite"
, "SLOPE"
, "SOIL_DEPTH_FLAG"
, "SOIL_ROCK_FLAG"
, "SOIL_SAND_LEVEL"
, "SOIL_CLAY_LEVEL"
, "SOIL_DRAIN_FLAG"
, "SOIL_TEXTURE"
, "RANGE_TYPE"
, "PRODUCTION_GOALS"
, "RESIDUAL_GOAL"
, "BRITTLENESS"
, "BIOME_ID"
, "READ_TAPE_DIRECTION"
, "Range_Region"
, "State"
, "DeviceID"
FROM "PERMANENT_SITE"

WHAT IS SHOULD BE
-----------------
SELECT SITE_NAME
, CLIENT_ID
, PRECIPITATION
, TRIGGER_FLAG
, LOCATION_COMMENT
, LINE_BEARING
, LINE_LENGTH
, PASTURE_SIZE
, HISTORY_COMMENT
, MGMT_GOALS
, OTHER_GOALS
, ACCESSIBLE_FLAG
, REPRESENTATIVE_FLAG
, MGMT_CHANGE_FLAG
, CONCERN_AREA_FLAG
, SITE_CHOICE_COMMENT
, ELEVATION
, ASPECT
, DATE_PSite
, SLOPE
, SOIL_DEPTH_FLAG
, SOIL_ROCK_FLAG
, SOIL_SAND_LEVEL
, SOIL_CLAY_LEVEL
, SOIL_DRAIN_FLAG
, SOIL_TEXTURE
, RANGE_TYPE
, PRODUCTION_GOALS
, RESIDUAL_GOAL
, BRITTLENESS
, SHORTLINE_PHOTO_GDI_
ID
, LONGLINE_PHOTO_GDI_I
D
, BIOME_ID
, READ_TAPE_DIRECTION
, Range_Region
, State
, DeviceID

You are missing these 2 columns from your SELECT list:
, SHORTLINE_PHOTO_GDI_
ID
, LONGLINE_PHOTO_GDI_I
D

Did you recently change the schema or something?

You should have received a more informative error message.
How did you install this and on what platform is it running on?
Did you use the ASA installer, or a homegrown one?
We suspect it cannot find the appropriate language DLL, so what language
is
your machine setup to use?

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

Jeff Norman

2005-03-30, 9:42 am

Thanks for the response Dave. I installed the Linux EBF to
get it to 9.0.1 (1989). This is a RedHat Linux system,Redhat
9, Kernel 2.4.20-6 . I also just ran the Windows EBF on my
workstation to get it to 9.0.1 (1991). Then regenerated the
UltraLite c++ API and did a full rebuild in eVC4.

I had all ready corrected the DB schema, I apoligize for
sending you the wrong info. When I was testing this, I had
deleted the download_cursor statement, and then when I
re-added it, it automatically created the wrong number of
columns. This has always been a problem so I routinely write
my own statements instead of letting sybase do it.

Anyways, I still get the same error message, I've attached
the new ml.txt for you.

Here are answers to your other questions:

How did you install this and on what platform is it running
on?
Did you use the ASA installer, or a homegrown one?
-Redhat 9, Kernel 2.4.20-6, I used the normal ASA installer
process from the CD, just ran setup.

We suspect it cannot find the appropriate language DLL, so
what language is your machine setup to use?
-It is a standard English system, I am here in Montana, USA.
If this is a problem, please help me to get it fixed, as
informative error message would be most helpful. I'm going
to get a test server system setup in Windows today to see if
I can get some more information.

Here is the actual download_cursor statement I am trying to
run:

SELECT SITE_NAME,
CLIENT_ID,
PRECIPITATION,
TRIGGER_FLAG,
LOCATION_COMMENT,
LINE_BEARING,
LINE_LENGTH,
PASTURE_SIZE,
HISTORY_COMMENT,
MGMT_GOALS,
OTHER_GOALS,
ACCESSIBLE_FLAG,
REPRESENTATIVE_FLAG,

MGMT_CHANGE_FLAG,
CONCERN_AREA_FLAG,
SITE_CHOICE_COMMENT,

ELEVATION,
ASPECT,
ASPECT_ANGLE,
DATE_PSite,
SLOPE,
SOIL_DEPTH_FLAG,
SOIL_ROCK_FLAG,
SOIL_SAND_LEVEL,
SOIL_CLAY_LEVEL,
SOIL_DRAIN_FLAG,
SOIL_TEXTURE,
RANGE_TYPE,
PRODUCTION_GOALS,
RESIDUAL_GOAL,
BRITTLENESS,
SHORTLINE_PHOTO_GDI_
ID,
LONGLINE_PHOTO_GDI_I
D,
BIOME_ID,
READ_TAPE_DIRECTION,

Range_Region,
State,
DeviceID
FROM PERMANENT_SITE
WHERE ? IS NOT NULL AND DeviceID LIKE ?

Yes, I have changed the schema resently. We have a current
version that has been in use for 2 years with 25 users
across 5 states for beta testing. They are setup to only
upload the data to the server, this new version we are
working on is to allow then to download data.

Here is the Create Table statement for the server:

CREATE TABLE "DBA"."PERMANENT_SITE" (
"SITE_NAME" varchar(32) NOT NULL,
"CLIENT_ID" varchar(16) NOT NULL,
"PRECIPITATION" varchar(32) NULL,
"TRIGGER_FLAG" bit NOT NULL,
"LOCATION_COMMENT" varchar(512) NULL,
"LINE_BEARING" integer NULL,
"LINE_LENGTH" integer NULL,
"PASTURE_SIZE" integer NULL,
"HISTORY_COMMENT" varchar(512) NULL,
"MGMT_GOALS" varchar(512) NULL,
"OTHER_GOALS" varchar(512) NULL,
"ACCESSIBLE_FLAG" bit NOT NULL,
"REPRESENTATIVE_FLAG" bit NOT NULL,
"MGMT_CHANGE_FLAG" bit NOT NULL,
"CONCERN_AREA_FLAG" bit NOT NULL,
"SITE_CHOICE_COMMENT" varchar(512) NULL,
"ELEVATION" integer NULL,
"ASPECT" varchar(2) NULL,
"ASPECT_ANGLE" double NULL,
"DATE_PSite" date NULL,
"SLOPE" varchar(32) NULL,
"SOIL_DEPTH_FLAG" varchar(5) NOT NULL,
"SOIL_ROCK_FLAG" varchar(4) NOT NULL,
"SOIL_SAND_LEVEL" varchar(4) NULL,
"SOIL_CLAY_LEVEL" varchar(4) NULL,
"SOIL_DRAIN_FLAG" bit NOT NULL,
"SOIL_TEXTURE" varchar(32) NULL,
"RANGE_TYPE" varchar(64) NULL,
"PRODUCTION_GOALS" varchar(128) NULL,
"RESIDUAL_GOAL" varchar(128) NULL,
"BRITTLENESS" integer NULL,
" SHORTLINE_PHOTO_GDI_
ID" integer NULL,
" LONGLINE_PHOTO_GDI_I
D" integer NULL,
"BIOME_ID" integer NULL,
"READ_TAPE_DIRECTION" varchar(12) NULL,
"Range_Region" varchar(64) NULL,
"State" varchar(32) NULL,
"DeviceID" varchar(32) NOT NULL,
PRIMARY KEY ( "SITE_NAME", "CLIENT_ID", "DeviceID" )
);

Here is the Create Table statement for the remote (converted
to c++ API for Ultralite PDA on PocketPC):

CREATE TABLE "DBA"."PERMANENT_SITE" (
"SITE_NAME" varchar(32) NOT NULL,
"CLIENT_ID" varchar(16) NOT NULL,
"PRECIPITATION" varchar(32) NULL,
"TRIGGER_FLAG" bit NOT NULL,
"LOCATION_COMMENT" varchar(512) NULL,
"LINE_BEARING" integer NULL,
"LINE_LENGTH" integer NULL,
"PASTURE_SIZE" integer NULL,
"HISTORY_COMMENT" varchar(512) NULL,
"MGMT_GOALS" varchar(512) NULL,
"OTHER_GOALS" varchar(512) NULL,
"ACCESSIBLE_FLAG" bit NOT NULL,
"REPRESENTATIVE_FLAG" bit NOT NULL,
"MGMT_CHANGE_FLAG" bit NOT NULL,
"CONCERN_AREA_FLAG" bit NOT NULL,
"SITE_CHOICE_COMMENT" varchar(512) NULL,
"ELEVATION" integer NULL,
"ASPECT" varchar(2) NULL,
"ASPECT_ANGLE" double NULL,
"DATE_PSite" date NULL,
"SLOPE" varchar(32) NULL,
"SOIL_DEPTH_FLAG" varchar(5) NOT NULL,
"SOIL_ROCK_FLAG" varchar(4) NOT NULL,
"SOIL_SAND_LEVEL" varchar(4) NULL,
"SOIL_CLAY_LEVEL" varchar(4) NULL,
"SOIL_DRAIN_FLAG" bit NOT NULL,
"SOIL_TEXTURE" varchar(32) NULL,
"RANGE_TYPE" varchar(64) NULL,
"PRODUCTION_GOALS" varchar(128) NULL,
"RESIDUAL_GOAL" varchar(128) NULL,
"BRITTLENESS" integer NULL,
" SHORTLINE_PHOTO_GDI_
ID" integer NULL,
" LONGLINE_PHOTO_GDI_I
D" integer NULL,
"BIOME_ID" integer NULL,
"READ_TAPE_DIRECTION" varchar(12) NULL,
"Range_Region" varchar(64) NULL,
"State" varchar(32) NULL,
"DeviceID" varchar(32) NOT NULL,
PRIMARY KEY ( "SITE_NAME", "CLIENT_ID", "DeviceID" )
);

Jeff Norman

2005-03-30, 9:42 am

OK, I fixed it. When I ran the server on my windows box, it
gave me the error found 38 columns, expecting 37, so I had a
place to start looking.

Even though the schemas are identical, there is one field
"Aspect_Angle" that I do not use in the remote, so I never
wrote an UltraLite Statement that included that field.
UltraLite is smart enought to not include that field in my
database. So I added it to a statement, and now it works
fine.

BUT, I now have the problem of not finding the correct
english DLLs to get the correct error messages. I also just
noticed that the Mobilelink Server is claiming to be running
Build 1753, so it must be pointing to the wrong one. I start
looking into that problem after lunch. Any ideas would be
most helpful.

Thank you for your time,

JEff

David Fishburn

2005-03-30, 9:43 am

Jeff Norman wrote in news:421f93c1.507.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

....
JN> BUT, I now have the problem of not finding the correct
JN> english DLLs to get the correct error messages. I also just
JN> noticed that the Mobilelink Server is claiming to be running
JN> Build 1753, so it must be pointing to the wrong one. I start
JN> looking into that problem after lunch. Any ideas would be
JN> most helpful.

Did you get any farther on this?
If not, please start a new thread.

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