SQL Anywhere ultralite - Re: Ultralite Palm hotsync errors

Author

Re: Ultralite Palm hotsync errors

2005-08-18, 8:23 pm

Hi Greg,
I was able to get rid of those errors. (I am using codewarrior). I had
to remove some tables in the publications to make it work. But now I
am getting a new error..
After I install the prc, when I try to sync, I am getting SQLCODE =
-309 error. I dont see any connection initiation in the dbml log.
Another thing that I should mention is, the segments are growing over
64K and I had to use multi-segments. I was not able to get rid of the
error after defining the macro. The only way I got it below 64K is
change the codewarrior setting "Global Optimizations". In that I moved
the slider bar to smaller code. Then the code got below 64K and I was
able to generate prc.
Thats when this error started showing up.. atleast I think so.
I greatly appreciate your help and every ones insight into this.
Thank you
SM

On 18 Aug 2005 08:40:27 -0700, Greg Fenton
<greg. fenton_NOSPAM_@ianyw
here.com> wrote:

>SM wrote:
>
>Is this a CodeWarrior environment?
>Did you make sure to re-run ulgen? If so, did it complete without errors?
>
>greg.fenton

Greg Fenton

2005-08-19, 3:23 am

SM wrote:
> After I install the prc, when I try to sync, I am getting SQLCODE =
> -309 error. I dont see any connection initiation in the dbml log.

-309 is "Memory error -- transaction rolled back".

> Another thing that I should mention is, the segments are growing over
> 64K and I had to use multi-segments. I was not able to get rid of the
> error after defining the macro.

I'm going to guess that this is related to the -309 error.

I would suggest going back and re-reading the section on building
multi-segment code in the SQLAnywhere 9.x online docs:

UltraLite C/C++ User's Guide
Developing UltraLite Applications for the Palm Computing Platform
- Building multi-segment applications

I have not had segment problems with UL on Palm in a few years now. You
should be removing any work-arounds you may have had in your code in the
past and using the info in the above documentation. If you are still
getting segments > 64k, post back details.

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

2005-08-19, 1:24 pm

Ok. I followed the same. Read the section you mentioned. I am getting
the warnings now.

Running UltraLite generator...
"C:\Program Files\Sybase\SQL Anywhere 9\win32\ulgen" -q -c
" dsn=PROJECTClh2;uid=
dba;pwd=kingpong2;" -t c++ -u pub1 -j GetCounty
-f " C:\PROJECT\palm\cpp\
PROJECTPalm\Obj\PROJ
ECTULApi.cpp"

Segment 'ULSP7' is greater than 64000 bytes, it will generate an
invalid PRC file.
Project: PROJECT.mcp, Target: PROJECT

PalmRez Warning: Output resource size is greater than ~64K size limit:
'code 7'

Project: PROJECT.mcp, Target: PROJECT

I checked the map that was getting generated. The place where I find
>64K is for the schema. Is there anyway to break that ?

Code: 00465e 66 bytes " GetColumnSize__15Sta
teIDFromCodeFUs"
Code: 0046a0 160 bytes "init_dfo_1063__FUc"
Code: 004740 50 bytes "fini_dfo_1063__Fv"

Segment: 7 69134 bytes "ULSP7"
Code: 00000c 178 bytes
" Open__24WEIGHT_LOSS_
FEED_REFUSALFP12ULCo
nnectionUs" File:
" C:\smurthy\RSVPA\pal
m\cpp\rsvpaPalm\Obj\
rsvpaULApi.cpp"
Code: 0000be 90 bytes
" Open__24WEIGHT_LOSS_
FEED_REFUSALFP12ULCo
nnection"
Code: 000118 70 bytes
" setDfxTable__24WEIGH
T_LOSS_FEED_REFUSALF
v"
Code: 00015e 208 bytes
" GetPARTICIPANT_IID__
24WEIGHT_LOSS_FEED_R
EFUSALFRlPb"
Code: 00022e 162 bytes
" SetPARTICIPANT_IID__
24WEIGHT_LOSS_FEED_R
EFUSALFl"
Code: 0002d0 218 bytes
" GetExam_DateTime__24
WEIGHT_LOSS_FEED_REF
USALFR11sqldatetimeP
b"
Code: 0003aa 190 bytes
" SetExam_DateTime__24
WEIGHT_LOSS_FEED_REF
USALF11sqldatetime"
Code: 000468 234 bytes
" GetFeed_Refusal__24W
EIGHT_LOSS_FEED_REFU
SALFRUcPb"
Code: 000552 188 bytes
" SetFeed_Refusal__24W
EIGHT_LOSS_FEED_REFU
SALFUc

I am using CW 9.3
and ASA 9.0.2.3137

(When I install the PRC I do get the -309 error.. but I guess thats
because its greater than 64K)

I apprecaite any help.
Thank you
SM

On 18 Aug 2005 19:00:24 -0700, Greg Fenton
<greg. fenton_NOSPAM_@ianyw
here.com> wrote:

>SM wrote:
>
>-309 is "Memory error -- transaction rolled back".
>
>
>I'm going to guess that this is related to the -309 error.
>
>I would suggest going back and re-reading the section on building
>multi-segment code in the SQLAnywhere 9.x online docs:
>
> UltraLite C/C++ User's Guide
> Developing UltraLite Applications for the Palm Computing Platform
> - Building multi-segment applications
>
>I have not had segment problems with UL on Palm in a few years now. You
>should be removing any work-arounds you may have had in your code in the
>past and using the info in the above documentation. If you are still
>getting segments > 64k, post back details.
>
>greg.fenton

Sponsored Links