Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

retrieve crashes application on PDA

9 posts in Pocket PowerBuilder Last posting was on 2003-09-19 10:31:18.0Z
mboangher Posted on 2003-09-16 14:41:53.0Z
From: "mboangher" <mboangher@timeline.info>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: retrieve crashes application on PDA
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 213.157.178.93
Message-ID: <3f6721ab@forums-2-dub>
X-Original-Trace: 16 Sep 2003 07:43:55 -0700, 213.157.178.93
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Sep 2003 07:38:27 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Sep 2003 07:41:53 -0700
X-Trace: forums-1-dub 1063723313 10.22.108.75 (16 Sep 2003 07:41:53 -0700)
X-Original-Trace: 16 Sep 2003 07:41:53 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:472
Article PK: 267011

My configuration: Pocket PB 1.0.1, ASA 8.0.2, b 4251, running on HP iPAQ
h5450

My application has grown quite a bit, including some non-visual objects,
some shareData with datawindows etc.
I tried to keep it on the safe side as possible - using just one
transaction, no multiple retrieves, ShareData only after retrieve then
ShareDataOff before updating etc.

Now the problem I have occurs when calling a retrieve on a DataStore of one
of my nvo's.
Application looks like:
- nvo_art.ds_art.DataObject = "dw_art". This data window is not used
anywhere else in the application, but including it in one of the windows
does not change much, so this should not be the source of errors.
- On ItemChanged on a data window, I posted (thought this would be safer) a
call to n_art.ds_art.retrieve().

Calling this directly from ItemChanged event (so by pressing Enter on Soft
key) makes the application look busy forever.
If I post it, I get a general failure system error, Exception: oxc00000005,
Address:01fb8860, then the application is forced to be closed.

Also, normal retrieves on a normal dw (no ShareData etc. but with 'rows as
needed' retrieve property) fails SOMETIMES - the whole application and
device freezes, needing a soft reset. The retrieve is expected to return
about 550 articles from one table.

All this only happen on device, when I run the app from Pocket PB it works
just fine.

Does anybody else experience the same problems ?
Thanks in advance for any suggestions / workarounds ...


Reed Shilts [Sybase] Posted on 2003-09-17 12:47:31.0Z
From: "Reed Shilts [Sybase]" <reed.dot.shilts.at.sybase.dot.com>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: retrieve crashes application on PDA
Organization: Sybase
Message-ID: <o8lgmv0i0b5naqp6pj4jbmtrbk1te8r8tn@4ax.com>
References: <3f6721ab@forums-2-dub>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: rshilts.sybase.com
X-Original-NNTP-Posting-Host: rshilts.sybase.com
Date: 17 Sep 2003 05:47:31 -0700
X-Trace: forums-1-dub 1063802851 10.18.61.76 (17 Sep 2003 05:47:31 -0700)
X-Original-Trace: 17 Sep 2003 05:47:31 -0700, rshilts.sybase.com
Lines: 51
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:492
Article PK: 267026

This sounds like the classic dynamically loaded DW issue.
Deploy the PKD with the DW with the EXE.

I thought you got a different error (not a GPF) but we could have
introduced that behavior by accident (ahem).

HTH,
Reed Shilts
PPB Development Manager
<Standard-Disclaimers-Apply/>



On 16 Sep 2003 07:41:53 -0700, "mboangher" <mboangher@timeline.info>

wrote:

>My configuration: Pocket PB 1.0.1, ASA 8.0.2, b 4251, running on HP iPAQ
>h5450
>
>My application has grown quite a bit, including some non-visual objects,
>some shareData with datawindows etc.
>I tried to keep it on the safe side as possible - using just one
>transaction, no multiple retrieves, ShareData only after retrieve then
>ShareDataOff before updating etc.
>
>Now the problem I have occurs when calling a retrieve on a DataStore of one
>of my nvo's.
>Application looks like:
>- nvo_art.ds_art.DataObject = "dw_art". This data window is not used
>anywhere else in the application, but including it in one of the windows
>does not change much, so this should not be the source of errors.
>- On ItemChanged on a data window, I posted (thought this would be safer) a
>call to n_art.ds_art.retrieve().
>
>Calling this directly from ItemChanged event (so by pressing Enter on Soft
>key) makes the application look busy forever.
>If I post it, I get a general failure system error, Exception: oxc00000005,
>Address:01fb8860, then the application is forced to be closed.
>
>Also, normal retrieves on a normal dw (no ShareData etc. but with 'rows as
>needed' retrieve property) fails SOMETIMES - the whole application and
>device freezes, needing a soft reset. The retrieve is expected to return
>about 550 articles from one table.
>
>All this only happen on device, when I run the app from Pocket PB it works
>just fine.
>
>Does anybody else experience the same problems ?
>Thanks in advance for any suggestions / workarounds ...
>


mboangher Posted on 2003-09-17 13:33:28.0Z
From: "mboangher" <mboangher@timeline.info>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f6721ab@forums-2-dub> <o8lgmv0i0b5naqp6pj4jbmtrbk1te8r8tn@4ax.com>
Subject: Re: retrieve crashes application on PDA
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.157.178.93
X-Original-NNTP-Posting-Host: 213.157.178.93
Message-ID: <3f6862a8@forums-1-dub>
Date: 17 Sep 2003 06:33:28 -0700
X-Trace: forums-1-dub 1063805608 213.157.178.93 (17 Sep 2003 06:33:28 -0700)
X-Original-Trace: 17 Sep 2003 06:33:28 -0700, 213.157.178.93
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:494
Article PK: 267028

Aktually, I did deploy the pkds together with the .exe, so this isn't the
case.

Meanwhile, I intensively tested the application also with older PkB versions
while keeping the same ASA (b. 4251), as I didn't remembered such problems
before.
The conclusion is that with PB 1.0 the retrieve occasionally and quite
seldom fails (application keeps looking busy), while with PkB 1.0.1 I get a
crash with 60% chances. As mentioned before, with PkB 1.0.1, even normal
retrieves occasionally fail.

How could I get out of this ?


Reed Shilts [Sybase] Posted on 2003-09-17 14:42:55.0Z
From: "Reed Shilts [Sybase]" <reed.dot.shilts.at.sybase.dot.com>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: retrieve crashes application on PDA
Organization: Sybase
Message-ID: <iqrgmvcbov9hkq98d06v1o02cmk28corcu@4ax.com>
References: <3f6721ab@forums-2-dub> <o8lgmv0i0b5naqp6pj4jbmtrbk1te8r8tn@4ax.com> <3f6862a8@forums-1-dub>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: rshilts.sybase.com
X-Original-NNTP-Posting-Host: rshilts.sybase.com
Date: 17 Sep 2003 07:42:55 -0700
X-Trace: forums-1-dub 1063809775 10.18.61.76 (17 Sep 2003 07:42:55 -0700)
X-Original-Trace: 17 Sep 2003 07:42:55 -0700, rshilts.sybase.com
Lines: 43
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:496
Article PK: 267030

I have nothing to offer at the moment - maybe somebody else does?

I have just created CR-332467
(I really don't like GPFs in the product)

BTW - customer service hates it when development goes around
them like this - it gives people the impression that a newsgroup is
official - this is _not_ an official channel.
Also - one of the jobs of customer service is to get a reproducable
test case. Without a testcase developers are allowed to
ignore a bug...
So - All I can offer (without a testcase) is that we will try to
reproduce your issue.
Submitting a testcase with the above CR number would really
help us, otherwise we're just banging aound trying to find
the same sequence of steps you have...

Anyways - I've just assigned the bug to one of the
developers (I can do that, I'm their boss).

Regards,
Reed Shilts
PocketPB Development Manager
<Standard-Disclaimers-Apply/>


On 17 Sep 2003 06:33:28 -0700, "mboangher" <mboangher@timeline.info>

wrote:

>Aktually, I did deploy the pkds together with the .exe, so this isn't the
>case.
>
>Meanwhile, I intensively tested the application also with older PkB versions
>while keeping the same ASA (b. 4251), as I didn't remembered such problems
>before.
>The conclusion is that with PB 1.0 the retrieve occasionally and quite
>seldom fails (application keeps looking busy), while with PkB 1.0.1 I get a
>crash with 60% chances. As mentioned before, with PkB 1.0.1, even normal
>retrieves occasionally fail.
>
>How could I get out of this ?
>


mboangher Posted on 2003-09-18 12:52:18.0Z
From: "mboangher" <mboangher@timeline.info>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f6721ab@forums-2-dub> <o8lgmv0i0b5naqp6pj4jbmtrbk1te8r8tn@4ax.com> <3f6862a8@forums-1-dub> <iqrgmvcbov9hkq98d06v1o02cmk28corcu@4ax.com>
Subject: Re: retrieve crashes application on PDA
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 213.157.178.93
Message-ID: <3f69ab01@forums-2-dub>
X-Original-Trace: 18 Sep 2003 05:54:25 -0700, 213.157.178.93
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Sep 2003 05:48:39 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Sep 2003 05:52:18 -0700
X-Trace: forums-1-dub 1063889538 10.22.108.75 (18 Sep 2003 05:52:18 -0700)
X-Original-Trace: 18 Sep 2003 05:52:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:504
Article PK: 267037

Thanks for opening the case.
I was curious if anybody else experienced the same problems, so the forum
seemed more appropriate.


Reed Shilts [Sybase] Posted on 2003-09-18 21:22:11.0Z
From: "Reed Shilts [Sybase]" <reed.dot.shilts.at.sybase.dot.com>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: retrieve crashes application on PDA
Organization: Sybase
Message-ID: <p78kmvsjqb2fgv2ppmvkjjsbfq0ik8972m@4ax.com>
References: <3f6721ab@forums-2-dub> <o8lgmv0i0b5naqp6pj4jbmtrbk1te8r8tn@4ax.com>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: rshilts.sybase.com
X-Original-NNTP-Posting-Host: rshilts.sybase.com
Date: 18 Sep 2003 14:22:11 -0700
X-Trace: forums-1-dub 1063920131 10.18.61.76 (18 Sep 2003 14:22:11 -0700)
X-Original-Trace: 18 Sep 2003 14:22:11 -0700, rshilts.sybase.com
Lines: 63
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:509
Article PK: 267044

Is you application getting quite large??
Are you retrieving lots and lots of data??
I'm thinking you're running out of memory...
Just a shot...

HTH,
Reed Shilts
<Standard-Disclaimers-Apply/>

On 17 Sep 2003 05:47:31 -0700, "Reed Shilts [Sybase]"

<reed.dot.shilts.at.sybase.dot.com> wrote:

>This sounds like the classic dynamically loaded DW issue.
>Deploy the PKD with the DW with the EXE.
>
>I thought you got a different error (not a GPF) but we could have
>introduced that behavior by accident (ahem).
>
>HTH,
>Reed Shilts
>PPB Development Manager
><Standard-Disclaimers-Apply/>
>
>
>
>On 16 Sep 2003 07:41:53 -0700, "mboangher" <mboangher@timeline.info>
>wrote:
>
>>My configuration: Pocket PB 1.0.1, ASA 8.0.2, b 4251, running on HP iPAQ
>>h5450
>>
>>My application has grown quite a bit, including some non-visual objects,
>>some shareData with datawindows etc.
>>I tried to keep it on the safe side as possible - using just one
>>transaction, no multiple retrieves, ShareData only after retrieve then
>>ShareDataOff before updating etc.
>>
>>Now the problem I have occurs when calling a retrieve on a DataStore of one
>>of my nvo's.
>>Application looks like:
>>- nvo_art.ds_art.DataObject = "dw_art". This data window is not used
>>anywhere else in the application, but including it in one of the windows
>>does not change much, so this should not be the source of errors.
>>- On ItemChanged on a data window, I posted (thought this would be safer) a
>>call to n_art.ds_art.retrieve().
>>
>>Calling this directly from ItemChanged event (so by pressing Enter on Soft
>>key) makes the application look busy forever.
>>If I post it, I get a general failure system error, Exception: oxc00000005,
>>Address:01fb8860, then the application is forced to be closed.
>>
>>Also, normal retrieves on a normal dw (no ShareData etc. but with 'rows as
>>needed' retrieve property) fails SOMETIMES - the whole application and
>>device freezes, needing a soft reset. The retrieve is expected to return
>>about 550 articles from one table.
>>
>>All this only happen on device, when I run the app from Pocket PB it works
>>just fine.
>>
>>Does anybody else experience the same problems ?
>>Thanks in advance for any suggestions / workarounds ...
>>


mboangher Posted on 2003-09-19 05:58:45.0Z
From: "mboangher" <mboangher@timeline.info>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f6721ab@forums-2-dub> <o8lgmv0i0b5naqp6pj4jbmtrbk1te8r8tn@4ax.com> <p78kmvsjqb2fgv2ppmvkjjsbfq0ik8972m@4ax.com>
Subject: Re: retrieve crashes application on PDA
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.157.178.93
X-Original-NNTP-Posting-Host: 213.157.178.93
Message-ID: <3f6a9b15@forums-1-dub>
Date: 18 Sep 2003 22:58:45 -0700
X-Trace: forums-1-dub 1063951125 213.157.178.93 (18 Sep 2003 22:58:45 -0700)
X-Original-Trace: 18 Sep 2003 22:58:45 -0700, 213.157.178.93
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:511
Article PK: 267045

I was thinking about this too.
But I wouldn't say the application is that large, nor am I retrieving that
much data, but still, I might have reached a certain limit ...
Also I noticed that after adding the sync status windows, NVOs, VOs, dws
etc. generated by the wizzard, the crash happens more offen (after 3
opperations). I suppose it is not a programming bug of mine, as I succeed
making about 3 opperations, than it crashes.

I also watched the memory status (as reported from device's Memory
management): the used memory constalnly grows.
The consume looks like :
- initial : 5.61
- open application, start DB server, init, ready to use: 13.58 (!!!)
- first opperations (retrieve, update, reset): 14.65
- repeating opperations: each adds almost 0.01 !!
- if oppening another window, then closing, the used memory dramatically
increases and is not freed (apparently, from what is reported)
- soon after, the application crashes, always when retrieving ...

So it is a memory issue, after all ...


mboangher Posted on 2003-09-19 06:20:12.0Z
From: "mboangher" <mboangher@timeline.info>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f6721ab@forums-2-dub> <o8lgmv0i0b5naqp6pj4jbmtrbk1te8r8tn@4ax.com> <p78kmvsjqb2fgv2ppmvkjjsbfq0ik8972m@4ax.com>
Subject: Re: retrieve crashes application on PDA
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.157.178.93
X-Original-NNTP-Posting-Host: 213.157.178.93
Message-ID: <3f6aa01c$1@forums-1-dub>
Date: 18 Sep 2003 23:20:12 -0700
X-Trace: forums-1-dub 1063952412 213.157.178.93 (18 Sep 2003 23:20:12 -0700)
X-Original-Trace: 18 Sep 2003 23:20:12 -0700, 213.157.178.93
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:512
Article PK: 267046

Just after writing down the previous sequence it occured to me that the
opening / closing of the windows could be the real memory consumer.

Tested and here is the conclusion: if a response window is opened, which
displays (retrieves) some data, then closed, the memory is not freed.


mboangher Posted on 2003-09-19 10:31:18.0Z
From: "mboangher" <mboangher@timeline.info>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f6721ab@forums-2-dub> <o8lgmv0i0b5naqp6pj4jbmtrbk1te8r8tn@4ax.com> <p78kmvsjqb2fgv2ppmvkjjsbfq0ik8972m@4ax.com>
Subject: Re: retrieve crashes application on PDA
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: 213.157.178.93
Message-ID: <3f6adb7b@forums-2-dub>
X-Original-Trace: 19 Sep 2003 03:33:31 -0700, 213.157.178.93
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Sep 2003 03:27:36 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Sep 2003 03:31:18 -0700
X-Trace: forums-1-dub 1063967478 10.22.108.75 (19 Sep 2003 03:31:18 -0700)
X-Original-Trace: 19 Sep 2003 03:31:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:515
Article PK: 267049

After more memory tests, trying to make a reproductible case, here are some
facts:
- as posted before, by repeately opening and closing response windows which
just make a retrieve, the used memory continues to grow. The device's memory
management is though smart enought to continuously adjust the program
memory, so no crash happens. Finally, when the app reaches a minimum
operating memory level = about 1.5 M free, (just then !!!), it manages it
ok. This happens with a basic response window, with 1 dw etc.
- this conduces to the fact that either my application requests memory too
intensively (= much but also quickly)
[could be, crash happens earlier if I operate it quicker]
or I ask for a chunk too big for my opperations (seen that before on smart
devices with Java aps).

What do you think about that ?

I'll keep trying making it reproductible for you.