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.

Jaguar 3.01 memory use.

4 posts in General Discussion (old) Last posting was on 2000-03-07 14:35:38.0Z
Gilbert Posted on 2000-03-06 22:20:35.0Z
Newsgroups: sybase.public.easerver
From: "Gilbert" <tech@alvia.com>
Subject: Jaguar 3.01 memory use.
Date: Mon, 6 Mar 2000 23:20:35 +0100
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 194.179.77.6
Message-ID: <347_asvrXs7h$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27044
Article PK: 157982

Hi:

I created a Jaguar component from PB with around 50 functions.
I call them this way from Dynamo:

var comp_obj = java.CreateComponent("jagapp/n_nvo","iiop://localhost:9000", "jagadmin", "");
var ls_result = comp_obj.f_myfunction(param1,param2);
document.writeln(ls_result)

My problem is that after 5 hours, the memory used by Jaguar is around 150MB and never go down.
I made a test executing always 10 functions and the same occurs.
When I look at the Task Management of WinNT, Jaguar uses 70MB of memory but when I close it, I
figure out that it uses 150. I track the connections with dbconsol and the connection cache seems to
work as Jaguar uses only one. Does the problem is coming from Jaguar or for the fact that I use PB ?
I have a similar problem with PB7. Every time I close and reopen a nvo the memory use gains 2MB, and
then after a while, I have to close it to low down the memory use.

Any help will be greatly apreciated.
Regards
Gilbert

This is the way I setup the NVO's (The same as the SurfSideVideo sample):

n_jaguar / activate:
-------------------
long l
GetContextService("ErrorLogging", iel_jag)
l = GetContextService("TransactionServer", its_jag)
iel_jag.log("n_jaguar activate: " + string(l))
iel_jag.log(ClassName()+" activate")

n_jaguar / deactivate:
---------------------
iel_jag.log(ClassName()+" deactivate")
DISCONNECT;

n_jaguar -> function getconnection():
------------------------------------
SQLCA.DBMS = as_dbms
SQLCA.AutoCommit = False
SQLCA.DBParm = "UseContextObject='No',CacheName='"+as_cachename+"'"
CONNECT;
IF SQLCA.sqlcode <> 0 THEN
iel_jag.log(ClassName()+ " Unable to get a connection.~r~n"+&
"SQLCODE: " + String(SQLCA.sqlcode) + "~r~n"+&
"SQLDBCODE: " + String(SQLCA.sqldbcode) + "~r~n"+&
"SQLERRTEXT: " + SQLCA.sqlerrtext)
END IF
Return SQLCA.sqlcode

n_nvo inherited from n_jaguar / activate:
----------------------------------------
IF getconnection("ODBC", "MyConnCache") <> 0 THEN
Return -1
END IF


Adam Simmonds Posted on 2000-03-07 03:52:42.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 07 Mar 2000 14:52:42 +1100
From: Adam Simmonds <asimmond@mail.usyd.edu.au>
Organization: University of Syndey
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Jaguar 3.01 memory use.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 60
NNTP-Posting-Host: pc-70.sis.usyd.edu.au 129.78.248.198
Message-ID: <347_38C47D0A.3A69CF56@mail.usyd.edu.au>
References: <347_asvrXs7h$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27001
Article PK: 157944

Apparently build 7023 fixed the memeory leakage problems, I am on build 8017 and it removed all the
meory leakage problems.

Email me personally and I will forward on the EBF in zip format.

Rgds
Adam

Gilbert wrote:

> Hi:
>
> I created a Jaguar component from PB with around 50 functions.
> I call them this way from Dynamo:
>
> var comp_obj = java.CreateComponent("jagapp/n_nvo","iiop://localhost:9000", "jagadmin", "");
> var ls_result = comp_obj.f_myfunction(param1,param2);
> document.writeln(ls_result)
>
> My problem is that after 5 hours, the memory used by Jaguar is around 150MB and never go down.
> I made a test executing always 10 functions and the same occurs.
> When I look at the Task Management of WinNT, Jaguar uses 70MB of memory but when I close it, I
> figure out that it uses 150. I track the connections with dbconsol and the connection cache seems to
> work as Jaguar uses only one. Does the problem is coming from Jaguar or for the fact that I use PB ?
> I have a similar problem with PB7. Every time I close and reopen a nvo the memory use gains 2MB, and
> then after a while, I have to close it to low down the memory use.
>
> Any help will be greatly apreciated.
> Regards
> Gilbert
>
> This is the way I setup the NVO's (The same as the SurfSideVideo sample):
>
> n_jaguar / activate:
> -------------------
> long l
> GetContextService("ErrorLogging", iel_jag)
> l = GetContextService("TransactionServer", its_jag)
> iel_jag.log("n_jaguar activate: " + string(l))
> iel_jag.log(ClassName()+" activate")
>
> n_jaguar / deactivate:
> ---------------------
> iel_jag.log(ClassName()+" deactivate")
> DISCONNECT;
>
> n_jaguar -> function getconnection():
> ------------------------------------
> SQLCA.DBMS = as_dbms
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "UseContextObject='No',CacheName='"+as_cachename+"'"
> CONNECT;
> IF SQLCA.sqlcode <> 0 THEN
> iel_jag.log(ClassName()+ " Unable to get a connection.~r~n"+&
> "SQLCODE: " + String(SQLCA.sqlcode) + "~r~n"+&
> "SQLDBCODE: " + String(SQLCA.sqldbcode) + "~r~n"+&
> "SQLERRTEXT: " + SQLCA.sqlerrtext)
> END IF
> Return SQLCA.sqlcode
>
> n_nvo inherited from n_jaguar / activate:
> ----------------------------------------
> IF getconnection("ODBC", "MyConnCache") <> 0 THEN
> Return -1
> END IF


Jim O'Neil [Sybase] Posted on 2000-03-07 14:35:38.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 07 Mar 2000 09:35:38 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Jaguar 3.01 memory use.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 20
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38C513B9.BB6C803@sybase.com>
References: <347_asvrXs7h$GA.74@forums.sybase.com> <347_38C47D0A.3A69CF56@mail.usyd.edu.au>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26990
Article PK: 157934


Adam Simmonds wrote:

> Apparently build 7023 fixed the memeory leakage problems, I am on build 8017 and it removed all the
> meory leakage problems.
>
> Email me personally and I will forward on the EBF in zip format.
>
> Rgds
> Adam
>

Be VERY careful about doing so, while the fix was on the PB side that build requires that you install all
of the products from the consolidated EBF first or you run the risk of data corruption due to an issue we
had in miscalculating Modified Julian Dates. Again, all the files for that EBF are located on the SDN
site. After apply those fixes, which I believe will include build 7021 of PowerBuilder, you can apply the
7023 fix that Adam has volunteered.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


Jim O'Neil [Sybase] Posted on 2000-03-06 23:07:57.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 06 Mar 2000 18:07:57 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Jaguar 3.01 memory use.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 69
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38C43A4C.CF70C5E0@sybase.com>
References: <347_asvrXs7h$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27038
Article PK: 157977


Gilbert wrote:

> Hi:
>
> I created a Jaguar component from PB with around 50 functions.
> I call them this way from Dynamo:
>
> var comp_obj = java.CreateComponent("jagapp/n_nvo","iiop://localhost:9000", "jagadmin", "");
> var ls_result = comp_obj.f_myfunction(param1,param2);
> document.writeln(ls_result)
>
> My problem is that after 5 hours, the memory used by Jaguar is around 150MB and never go down.
> I made a test executing always 10 functions and the same occurs.
> When I look at the Task Management of WinNT, Jaguar uses 70MB of memory but when I close it, I
> figure out that it uses 150. I track the connections with dbconsol and the connection cache seems to
> work as Jaguar uses only one. Does the problem is coming from Jaguar or for the fact that I use PB ?
> I have a similar problem with PB7. Every time I close and reopen a nvo the memory use gains 2MB, and
> then after a while, I have to close it to low down the memory use.
>
> Any help will be greatly apreciated.
> Regards
> Gilbert
>
> This is the way I setup the NVO's (The same as the SurfSideVideo sample):
>
> n_jaguar / activate:
> -------------------
> long l
> GetContextService("ErrorLogging", iel_jag)
> l = GetContextService("TransactionServer", its_jag)
> iel_jag.log("n_jaguar activate: " + string(l))
> iel_jag.log(ClassName()+" activate")
>
> n_jaguar / deactivate:
> ---------------------
> iel_jag.log(ClassName()+" deactivate")
> DISCONNECT;
>
> n_jaguar -> function getconnection():
> ------------------------------------
> SQLCA.DBMS = as_dbms
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "UseContextObject='No',CacheName='"+as_cachename+"'"
> CONNECT;
> IF SQLCA.sqlcode <> 0 THEN
> iel_jag.log(ClassName()+ " Unable to get a connection.~r~n"+&
> "SQLCODE: " + String(SQLCA.sqlcode) + "~r~n"+&
> "SQLDBCODE: " + String(SQLCA.sqldbcode) + "~r~n"+&
> "SQLERRTEXT: " + SQLCA.sqlerrtext)
> END IF
> Return SQLCA.sqlcode
>
> n_nvo inherited from n_jaguar / activate:
> ----------------------------------------
> IF getconnection("ODBC", "MyConnCache") <> 0 THEN
> Return -1
> END IF

There was a memory leak whenever PB components returned strings or blobs. I can't remember if the fix
was in 3.0.1 or in the consolidated EBF (Post 3.0.1). What build are you using? if 30033, you should be
ok as far as that bug went, if 30031, you might want to apply the consolidated EBF available from SDN.
To see if there's a difference in your current environment, you could set up another function that
doesn't return the string - return an int instead for instance - and see if memory usage is similar.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc