SQL Anywhere ultralite - i need better description for errorcode -78

Author

i need better description for errorcode -78

Michal Seliga

2005-12-12, 11:23 am

i use sybase ASA 7.0.4.3536, C++ api, on PalmOS, I develop with Codewarrior 9.3

our customers report errorcode -78 after they launch application. it bever
happened on pre NVFS devices, but happens quite often on Tungsten T5 or newer.

I know that asa7 doesn't oficially support nvfs devices and i don't report this
as bug. anyway could someone tell me what exactly causes this? maybe i would be
able to find any workaround (or better persuade our businessmen to think more
about upgrade to asa9 - i am developer and it is difficult for me to speak with
business people... they don't listen to my arguments.... if they would rule the
world we still use pocket calculators :-) also, when i will upgrade to asa9, can
i guarantee that this won't happen? because i would be the blamed one if upgrade
won't help

what exactly happens is that sometimes (i don't know how) when i start
application and call PalmLaunch it returnes error -78 and since then database
seems to be corrupted and it reports -78 again and again - all what helps is to
erase pdb files (and make full synchronization after next start of application)

as i said it never happened on pre-nvfs device

in docs -78 means SQLE_DYNAMIC_MEMORY_
EXHAUSTED, but there is lot of dynamic
memory available and i can't do anything with it. even softreset which should
free all lost chunks (if there are any) won't help. also it doesn't seem to rely
on dbcache usage, i added test that application won't try to launch db if there
isn't enough space in dbcache (~2mb) to store all releated pdb files and it
didn't helped, test succeeded and i got -78 anyway....

i hope someone can guide me...so far i am lost in this

thanks in advance

Michal

Stella Lai

2005-12-13, 11:23 am

For latest Palm NVFS devices, we suggest upgrading to 9.x with proper EBF.

With the 9.x EBF, you could add palm_db=CRID:n to your conneciton string.
(CRID is your application's creator ID, and n is the zero-based volume
ordinal.) By specifying the volume ordinal you could make use of the
internal drive on e.g. T5. Plus, the most important part is that the fix
would do proper commit.

In short, there is no other way to make this properly work in 7.x.

- Stella Lai
iAnywhere Solutions

"Michal Seliga" <michal.seliga@visicom.sk> wrote in message
news:439db361$1@foru
ms-1-dub...
>i use sybase ASA 7.0.4.3536, C++ api, on PalmOS, I develop with Codewarrior
>9.3
>
> our customers report errorcode -78 after they launch application. it bever
> happened on pre NVFS devices, but happens quite often on Tungsten T5 or
> newer.
>
> I know that asa7 doesn't oficially support nvfs devices and i don't report
> this
> as bug. anyway could someone tell me what exactly causes this? maybe i
> would be
> able to find any workaround (or better persuade our businessmen to think
> more
> about upgrade to asa9 - i am developer and it is difficult for me to speak
> with
> business people... they don't listen to my arguments.... if they would
> rule the
> world we still use pocket calculators :-) also, when i will upgrade to
> asa9, can
> i guarantee that this won't happen? because i would be the blamed one if
> upgrade
> won't help
>
> what exactly happens is that sometimes (i don't know how) when i start
> application and call PalmLaunch it returnes error -78 and since then
> database
> seems to be corrupted and it reports -78 again and again - all what helps
> is to
> erase pdb files (and make full synchronization after next start of
> application)
>
> as i said it never happened on pre-nvfs device
>
> in docs -78 means SQLE_DYNAMIC_MEMORY_
EXHAUSTED, but there is lot of
> dynamic
> memory available and i can't do anything with it. even softreset which
> should
> free all lost chunks (if there are any) won't help. also it doesn't seem
> to rely
> on dbcache usage, i added test that application won't try to launch db if
> there
> isn't enough space in dbcache (~2mb) to store all releated pdb files and
> it
> didn't helped, test succeeded and i got -78 anyway....
>
> i hope someone can guide me...so far i am lost in this
>
> thanks in advance
>
> Michal

Tim McClements

2005-12-16, 8:23 pm

-78 usually means a memory allocation (MemPtrNew) failed. I don't know any
reason why an application working on pre-NVFS devices would develop this
kind of problem on NVFS devices (since the heap should be still plenty big).
But, we have never run 7.x on an NVFS device, so it's hard to say what might
be happening.

You can download the free developer edition of ASA 9.x to try UL out and
confirm it works for your application.

- Tim

"Michal Seliga" <michal.seliga@visicom.sk> wrote in message
news:439db361$1@foru
ms-1-dub...
>i use sybase ASA 7.0.4.3536, C++ api, on PalmOS, I develop with Codewarrior
>9.3
>
> our customers report errorcode -78 after they launch application. it bever
> happened on pre NVFS devices, but happens quite often on Tungsten T5 or
> newer.
>
> I know that asa7 doesn't oficially support nvfs devices and i don't report
> this
> as bug. anyway could someone tell me what exactly causes this? maybe i
> would be
> able to find any workaround (or better persuade our businessmen to think
> more
> about upgrade to asa9 - i am developer and it is difficult for me to speak
> with
> business people... they don't listen to my arguments.... if they would
> rule the
> world we still use pocket calculators :-) also, when i will upgrade to
> asa9, can
> i guarantee that this won't happen? because i would be the blamed one if
> upgrade
> won't help
>
> what exactly happens is that sometimes (i don't know how) when i start
> application and call PalmLaunch it returnes error -78 and since then
> database
> seems to be corrupted and it reports -78 again and again - all what helps
> is to
> erase pdb files (and make full synchronization after next start of
> application)
>
> as i said it never happened on pre-nvfs device
>
> in docs -78 means SQLE_DYNAMIC_MEMORY_
EXHAUSTED, but there is lot of
> dynamic
> memory available and i can't do anything with it. even softreset which
> should
> free all lost chunks (if there are any) won't help. also it doesn't seem
> to rely
> on dbcache usage, i added test that application won't try to launch db if
> there
> isn't enough space in dbcache (~2mb) to store all releated pdb files and
> it
> didn't helped, test succeeded and i got -78 anyway....
>
> i hope someone can guide me...so far i am lost in this
>
> thanks in advance
>
> Michal

Michal Seliga

2005-12-19, 7:23 am

I think I know what happened
if ultralite_db_<creator>.pdb is missing for some reason (or maybe it is enough
if it is damaged) but other 3 files are available that on start of application
there will be error -78 and PalmLaunch won't work until these other 3 files
won't be erased too.

on pre nvfs devices files don't get lost, but these nvfs monsters are completely
different story.... so sometimes it happens

btw. personally i would prefer to get different error message (something about
missing or damaged file), it would help with tracking the problem... but its
only a detail

Tim McClements wrote:
> -78 usually means a memory allocation (MemPtrNew) failed. I don't know any
> reason why an application working on pre-NVFS devices would develop this
> kind of problem on NVFS devices (since the heap should be still plenty big).
> But, we have never run 7.x on an NVFS device, so it's hard to say what might
> be happening.
>
> You can download the free developer edition of ASA 9.x to try UL out and
> confirm it works for your application.
>
> - Tim
>
> "Michal Seliga" <michal.seliga@visicom.sk> wrote in message
> news:439db361$1@foru
ms-1-dub...
>
>
>
>

bakayoro

2005-12-30, 3:23 am

ASA 8.0.3 just release a patch for the NVFS. the build no. is 5307. i
m also working on the NVFS problem...

Sponsored Links