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.

Resource governor ....

9 posts in General Discussion Last posting was on 2003-09-16 13:07:05.0Z
VBM Posted on 2003-09-03 17:29:03.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
Subject: Resource governor ....
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 12.25.165.67
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f5624df$2@forums-1-dub>
Date: 3 Sep 2003 10:29:03 -0700
X-Trace: forums-1-dub 1062610143 12.25.165.67 (3 Sep 2003 10:29:03 -0700)
X-Original-Trace: 3 Sep 2003 10:29:03 -0700, 12.25.165.67
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1694
Article PK: 3916

I am using Visual studio 2003 C# and ADO.NET code and iAnywhere as back
end.....
I get the error "Resource governor for 'prepared statements' exceeded" when
I open more than one command objects and run....

any clues...?

thanks


Michel Renaud Posted on 2003-09-03 17:40:03.0Z
Sender: 7650.3f5626f3.1804289383@sybase.com
From: Michel Renaud
Newsgroups: ianywhere.public.general
Subject: Re: Resource governor ....
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f562773.7660.846930886@sybase.com>
References: <3f5624df$2@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Sep 2003 10:40:03 -0700
X-Trace: forums-1-dub 1062610803 10.22.241.41 (3 Sep 2003 10:40:03 -0700)
X-Original-Trace: 3 Sep 2003 10:40:03 -0700, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1695
Article PK: 3917


> I am using Visual studio 2003 C# and ADO.NET code and
> iAnywhere as back end.....
> I get the error "Resource governor for 'prepared
> statements' exceeded" when I open more than one command
> objects and run....
>
> any clues...?

If you're using the PC (desktop) version, download the
latest EBF from http://www.sybase.com/downloads. If, like
me, this is on the PocketPC, the EBF is not up yet (I got a
message on Aug. 15 saying it was, but it still shows as the
May 14 update - oops!)

You can do a search in this newsgroup for more details about
this specific problem.


Eric Bencina Posted on 2003-09-03 21:09:39.0Z
From: "Eric Bencina" <no_spam_ebencina@sybase.com>
Newsgroups: ianywhere.public.general
References: <3f5624df$2@forums-1-dub> <3f562773.7660.846930886@sybase.com>
Subject: Re: Resource governor ....
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
X-Original-NNTP-Posting-Host: ebencina-pc.sybase.com
Message-ID: <3f5658de$1@forums-2-dub>
X-Original-Trace: 3 Sep 2003 14:10:54 -0700, ebencina-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Sep 2003 14:07:29 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Sep 2003 14:09:39 -0700
X-Trace: forums-1-dub 1062623379 10.22.108.75 (3 Sep 2003 14:09:39 -0700)
X-Original-Trace: 3 Sep 2003 14:09:39 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1696
Article PK: 3918

You didn't mention what version of ASA that you were using, but do a search
in the online help for resource governors and you will find details on why
this error is occuring. Also look up the MAX_STATEMENT_COUNT option.

Eric Bencina

<Michel Renaud> wrote in message news:3f562773.7660.846930886@sybase.com...
> > I am using Visual studio 2003 C# and ADO.NET code and
> > iAnywhere as back end.....
> > I get the error "Resource governor for 'prepared
> > statements' exceeded" when I open more than one command
> > objects and run....
> >
> > any clues...?
>
> If you're using the PC (desktop) version, download the
> latest EBF from http://www.sybase.com/downloads. If, like
> me, this is on the PocketPC, the EBF is not up yet (I got a
> message on Aug. 15 saying it was, but it still shows as the
> May 14 update - oops!)
>
> You can do a search in this newsgroup for more details about
> this specific problem.


VBM Posted on 2003-09-04 21:20:21.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
References: <3f5624df$2@forums-1-dub> <3f562773.7660.846930886@sybase.com> <3f5658de$1@forums-2-dub>
Subject: Re: Resource governor ....
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 12.25.165.67
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f57ac95@forums-1-dub>
Date: 4 Sep 2003 14:20:21 -0700
X-Trace: forums-1-dub 1062710421 12.25.165.67 (4 Sep 2003 14:20:21 -0700)
X-Original-Trace: 4 Sep 2003 14:20:21 -0700, 12.25.165.67
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1701
Article PK: 3923

ASA 9.0

I have used following statement

Set option public.MAX_STATEMENT_COUNT = 0;
commit;

still I get error like "Database server connection limit exceeded "

any thoughts....

thanks

Eric Bencina wrote:
> You didn't mention what version of ASA that you were using, but do a
> search in the online help for resource governors and you will find
> details on why this error is occuring. Also look up the
> MAX_STATEMENT_COUNT option.
>
> Eric Bencina
>
> <Michel Renaud> wrote in message
> news:3f562773.7660.846930886@sybase.com...
>>> I am using Visual studio 2003 C# and ADO.NET code and
>>> iAnywhere as back end.....
>>> I get the error "Resource governor for 'prepared
>>> statements' exceeded" when I open more than one command
>>> objects and run....
>>>
>>> any clues...?
>>
>> If you're using the PC (desktop) version, download the
>> latest EBF from http://www.sybase.com/downloads. If, like
>> me, this is on the PocketPC, the EBF is not up yet (I got a
>> message on Aug. 15 saying it was, but it still shows as the
>> May 14 update - oops!)
>>
>> You can do a search in this newsgroup for more details about
>> this specific problem.


Glenn Paulley Posted on 2003-09-05 03:53:25.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Resource governor ....
References: <3f5624df$2@forums-1-dub> <3f562773.7660.846930886@sybase.com> <3f5658de$1@forums-2-dub> <3f57ac95@forums-1-dub>
In-Reply-To: <3f57ac95@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpn-dub-071.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-071.sybase.com
Message-ID: <3f5808b5$1@forums-1-dub>
Date: 4 Sep 2003 20:53:25 -0700
X-Trace: forums-1-dub 1062734005 10.22.120.71 (4 Sep 2003 20:53:25 -0700)
X-Original-Trace: 4 Sep 2003 20:53:25 -0700, vpn-dub-071.sybase.com
Lines: 83
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1702
Article PK: 3922

Ordinarily these are two different problems, but in your case they are
likely related.

The resource governor error, which you have worked-around by setting
MAX_STATEMENT_COUNT to 0, is to inform you that your application is
(*very* likely) unintentionally leaking database server memory by not
dropping statements. If your application continues to prepare
statements, but not free them, and does so enough times, the server will
face a critical memory shortage, with the obvious consequences.

The error below is usually caused by attempting to connect too many
clients to the server (i.e. the number of concurrent connections exceeds
your ASA license). However, the other source of this error message is
when the amount of server memory is deemed insufficient to handle an
additional (new) connection, quite likely caused by the leak described
above.

Glenn

VBM wrote:
> ASA 9.0
>
> I have used following statement
>
> Set option public.MAX_STATEMENT_COUNT = 0;
> commit;
>
> still I get error like "Database server connection limit exceeded "
>
> any thoughts....
>
> thanks
>
>
>
> Eric Bencina wrote:
>
>>You didn't mention what version of ASA that you were using, but do a
>>search in the online help for resource governors and you will find
>>details on why this error is occuring. Also look up the
>>MAX_STATEMENT_COUNT option.
>>
>>Eric Bencina
>>
>><Michel Renaud> wrote in message
>>news:3f562773.7660.846930886@sybase.com...
>>
>>>>I am using Visual studio 2003 C# and ADO.NET code and
>>>>iAnywhere as back end.....
>>>>I get the error "Resource governor for 'prepared
>>>>statements' exceeded" when I open more than one command
>>>>objects and run....
>>>>
>>>>any clues...?
>>>
>>>If you're using the PC (desktop) version, download the
>>>latest EBF from http://www.sybase.com/downloads. If, like
>>>me, this is on the PocketPC, the EBF is not up yet (I got a
>>>message on Aug. 15 saying it was, but it still shows as the
>>>May 14 update - oops!)
>>>
>>>You can do a search in this newsgroup for more details about
>>>this specific problem.
>
>
>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer


VBM Posted on 2003-09-05 16:24:16.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
References: <3f5624df$2@forums-1-dub> <3f562773.7660.846930886@sybase.com> <3f5658de$1@forums-2-dub> <3f57ac95@forums-1-dub> <3f5808b5$1@forums-1-dub>
Subject: Re: Resource governor ....
Lines: 81
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f58b905$1@forums-2-dub>
X-Original-Trace: 5 Sep 2003 09:25:41 -0700, 12.25.165.67
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Sep 2003 09:21:57 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Sep 2003 09:24:16 -0700
X-Trace: forums-1-dub 1062779056 10.22.108.75 (5 Sep 2003 09:24:16 -0700)
X-Original-Trace: 5 Sep 2003 09:24:16 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1708
Article PK: 3929

Thanks for the nice points.

One of my function is using many ADO.NETconnections and I check the code and
I am properly closing the connection at the end of the use I am using ASA
developer edition which I got FREE from ASA site. It look sthat I will need
to read more on database tuning ........I am SQL Server user so dont know
yet abt ASA settings set....

Proper guidence will be appriciated..

thanks again
Cheers !


I am using

Glenn Paulley wrote:
> Ordinarily these are two different problems, but in your case they are
> likely related.
>
> The resource governor error, which you have worked-around by setting
> MAX_STATEMENT_COUNT to 0, is to inform you that your application is
> (*very* likely) unintentionally leaking database server memory by not
> dropping statements. If your application continues to prepare
> statements, but not free them, and does so enough times, the server
> will face a critical memory shortage, with the obvious consequences.
>
> The error below is usually caused by attempting to connect too many
> clients to the server (i.e. the number of concurrent connections
> exceeds your ASA license). However, the other source of this error
> message is when the amount of server memory is deemed insufficient to
> handle an additional (new) connection, quite likely caused by the
> leak described above.
>
> Glenn
>
> VBM wrote:
>> ASA 9.0
>>
>> I have used following statement
>>
>> Set option public.MAX_STATEMENT_COUNT = 0;
>> commit;
>>
>> still I get error like "Database server connection limit exceeded "
>>
>> any thoughts....
>>
>> thanks
>>
>>
>>
>> Eric Bencina wrote:
>>
>>> You didn't mention what version of ASA that you were using, but do a
>>> search in the online help for resource governors and you will find
>>> details on why this error is occuring. Also look up the
>>> MAX_STATEMENT_COUNT option.
>>>
>>> Eric Bencina
>>>
>>> <Michel Renaud> wrote in message
>>> news:3f562773.7660.846930886@sybase.com...
>>>
>>>>> I am using Visual studio 2003 C# and ADO.NET code and
>>>>> iAnywhere as back end.....
>>>>> I get the error "Resource governor for 'prepared
>>>>> statements' exceeded" when I open more than one command
>>>>> objects and run....
>>>>>
>>>>> any clues...?
>>>>
>>>> If you're using the PC (desktop) version, download the
>>>> latest EBF from http://www.sybase.com/downloads. If, like
>>>> me, this is on the PocketPC, the EBF is not up yet (I got a
>>>> message on Aug. 15 saying it was, but it still shows as the
>>>> May 14 update - oops!)
>>>>
>>>> You can do a search in this newsgroup for more details about
>>>> this specific problem.


Glenn Paulley Posted on 2003-09-05 17:44:20.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Resource governor ....
References: <3f5624df$2@forums-1-dub> <3f562773.7660.846930886@sybase.com> <3f5658de$1@forums-2-dub> <3f57ac95@forums-1-dub> <3f5808b5$1@forums-1-dub> <3f58b905$1@forums-2-dub>
In-Reply-To: <3f58b905$1@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: paulley-xp.sybase.com
X-Original-NNTP-Posting-Host: paulley-xp.sybase.com
Message-ID: <3f58cb74$1@forums-1-dub>
Date: 5 Sep 2003 10:44:20 -0700
X-Trace: forums-1-dub 1062783860 172.31.142.134 (5 Sep 2003 10:44:20 -0700)
X-Original-Trace: 5 Sep 2003 10:44:20 -0700, paulley-xp.sybase.com
Lines: 112
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1712
Article PK: 3933

I am aware of a problem with our ADO.NET driver, where it incorrectly
attempted to DROP a statement upon closing, which could cause the error
that you're seeing. The problem I'm aware of was fixed in 8.0.2 build 4278.

What release/build are you using?

Glenn

VBM wrote:
> Thanks for the nice points.
>
> One of my function is using many ADO.NETconnections and I check the code and
> I am properly closing the connection at the end of the use I am using ASA
> developer edition which I got FREE from ASA site. It look sthat I will need
> to read more on database tuning ........I am SQL Server user so dont know
> yet abt ASA settings set....
>
> Proper guidence will be appriciated..
>
> thanks again
> Cheers !
>
>
> I am using
> Glenn Paulley wrote:
>
>>Ordinarily these are two different problems, but in your case they are
>>likely related.
>>
>>The resource governor error, which you have worked-around by setting
>>MAX_STATEMENT_COUNT to 0, is to inform you that your application is
>>(*very* likely) unintentionally leaking database server memory by not
>>dropping statements. If your application continues to prepare
>>statements, but not free them, and does so enough times, the server
>>will face a critical memory shortage, with the obvious consequences.
>>
>>The error below is usually caused by attempting to connect too many
>>clients to the server (i.e. the number of concurrent connections
>>exceeds your ASA license). However, the other source of this error
>>message is when the amount of server memory is deemed insufficient to
>>handle an additional (new) connection, quite likely caused by the
>>leak described above.
>>
>>Glenn
>>
>>VBM wrote:
>>
>>>ASA 9.0
>>>
>>>I have used following statement
>>>
>>>Set option public.MAX_STATEMENT_COUNT = 0;
>>>commit;
>>>
>>>still I get error like "Database server connection limit exceeded "
>>>
>>>any thoughts....
>>>
>>>thanks
>>>
>>>
>>>
>>>Eric Bencina wrote:
>>>
>>>
>>>>You didn't mention what version of ASA that you were using, but do a
>>>>search in the online help for resource governors and you will find
>>>>details on why this error is occuring. Also look up the
>>>>MAX_STATEMENT_COUNT option.
>>>>
>>>>Eric Bencina
>>>>
>>>><Michel Renaud> wrote in message
>>>>news:3f562773.7660.846930886@sybase.com...
>>>>
>>>>
>>>>>>I am using Visual studio 2003 C# and ADO.NET code and
>>>>>>iAnywhere as back end.....
>>>>>>I get the error "Resource governor for 'prepared
>>>>>>statements' exceeded" when I open more than one command
>>>>>>objects and run....
>>>>>>
>>>>>>any clues...?
>>>>>
>>>>>If you're using the PC (desktop) version, download the
>>>>>latest EBF from http://www.sybase.com/downloads. If, like
>>>>>me, this is on the PocketPC, the EBF is not up yet (I got a
>>>>>message on Aug. 15 saying it was, but it still shows as the
>>>>>May 14 update - oops!)
>>>>>
>>>>>You can do a search in this newsgroup for more details about
>>>>>this specific problem.
>
>
>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer


VBM Posted on 2003-09-06 00:15:26.0Z
From: "VBM" <legendnews@lycos.co.uk>
Newsgroups: ianywhere.public.general
References: <3f5624df$2@forums-1-dub> <3f562773.7660.846930886@sybase.com> <3f5658de$1@forums-2-dub> <3f57ac95@forums-1-dub> <3f5808b5$1@forums-1-dub> <3f58b905$1@forums-2-dub> <3f58cb74$1@forums-1-dub>
Subject: Re: Resource governor ....
Lines: 103
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 12.25.165.67
Message-ID: <3f592773@forums-2-dub>
X-Original-Trace: 5 Sep 2003 17:16:51 -0700, 12.25.165.67
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Sep 2003 17:13:03 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Sep 2003 17:15:26 -0700
X-Trace: forums-1-dub 1062807326 10.22.108.75 (5 Sep 2003 17:15:26 -0700)
X-Original-Trace: 5 Sep 2003 17:15:26 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1714
Article PK: 3935

I am using ASA 9.0 developer edition....also I am using iAnywhere .NET
provider ASaClient

thanks

Glenn Paulley wrote:
> I am aware of a problem with our ADO.NET driver, where it incorrectly
> attempted to DROP a statement upon closing, which could cause the
> error
> that you're seeing. The problem I'm aware of was fixed in 8.0.2 build
> 4278.
>
> What release/build are you using?
>
> Glenn
>
> VBM wrote:
>> Thanks for the nice points.
>>
>> One of my function is using many ADO.NETconnections and I check the
>> code and I am properly closing the connection at the end of the use
>> I am using ASA developer edition which I got FREE from ASA site. It
>> look sthat I will need to read more on database tuning ........I am
>> SQL Server user so dont know yet abt ASA settings set....
>>
>> Proper guidence will be appriciated..
>>
>> thanks again
>> Cheers !
>>
>>
>> I am using
>> Glenn Paulley wrote:
>>
>>> Ordinarily these are two different problems, but in your case they
>>> are likely related.
>>>
>>> The resource governor error, which you have worked-around by setting
>>> MAX_STATEMENT_COUNT to 0, is to inform you that your application is
>>> (*very* likely) unintentionally leaking database server memory by
>>> not dropping statements. If your application continues to prepare
>>> statements, but not free them, and does so enough times, the server
>>> will face a critical memory shortage, with the obvious consequences.
>>>
>>> The error below is usually caused by attempting to connect too many
>>> clients to the server (i.e. the number of concurrent connections
>>> exceeds your ASA license). However, the other source of this error
>>> message is when the amount of server memory is deemed insufficient
>>> to handle an additional (new) connection, quite likely caused by the
>>> leak described above.
>>>
>>> Glenn
>>>
>>> VBM wrote:
>>>
>>>> ASA 9.0
>>>>
>>>> I have used following statement
>>>>
>>>> Set option public.MAX_STATEMENT_COUNT = 0;
>>>> commit;
>>>>
>>>> still I get error like "Database server connection limit exceeded "
>>>>
>>>> any thoughts....
>>>>
>>>> thanks
>>>>
>>>>
>>>>
>>>> Eric Bencina wrote:
>>>>
>>>>
>>>>> You didn't mention what version of ASA that you were using, but
>>>>> do a search in the online help for resource governors and you
>>>>> will find details on why this error is occuring. Also look up the
>>>>> MAX_STATEMENT_COUNT option.
>>>>>
>>>>> Eric Bencina
>>>>>
>>>>> <Michel Renaud> wrote in message
>>>>> news:3f562773.7660.846930886@sybase.com...
>>>>>
>>>>>
>>>>>>> I am using Visual studio 2003 C# and ADO.NET code and
>>>>>>> iAnywhere as back end.....
>>>>>>> I get the error "Resource governor for 'prepared
>>>>>>> statements' exceeded" when I open more than one command
>>>>>>> objects and run....
>>>>>>>
>>>>>>> any clues...?
>>>>>>
>>>>>> If you're using the PC (desktop) version, download the
>>>>>> latest EBF from http://www.sybase.com/downloads. If, like
>>>>>> me, this is on the PocketPC, the EBF is not up yet (I got a
>>>>>> message on Aug. 15 saying it was, but it still shows as the
>>>>>> May 14 update - oops!)
>>>>>>
>>>>>> You can do a search in this newsgroup for more details about
>>>>>> this specific problem.


Glenn Paulley Posted on 2003-09-16 13:07:05.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Resource governor ....
References: <3f5624df$2@forums-1-dub> <3f562773.7660.846930886@sybase.com> <3f5658de$1@forums-2-dub> <3f57ac95@forums-1-dub> <3f5808b5$1@forums-1-dub> <3f58b905$1@forums-2-dub> <3f58cb74$1@forums-1-dub> <3f592773@forums-2-dub>
In-Reply-To: <3f592773@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: paulley-xp.sybase.com
X-Original-NNTP-Posting-Host: paulley-xp.sybase.com
Message-ID: <3f670af9$1@forums-1-dub>
Date: 16 Sep 2003 06:07:05 -0700
X-Trace: forums-1-dub 1063717625 172.31.142.134 (16 Sep 2003 06:07:05 -0700)
X-Original-Trace: 16 Sep 2003 06:07:05 -0700, paulley-xp.sybase.com
Lines: 135
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1755
Article PK: 4039

The problem I was thinking of was fixed in 9.0.0.1104 - the build number
for the developer edition is 1108, so this is likely a different problem
with similar symptoms. I suggest that you contact technical support and
open a case, so we can diagnose this in the lab and fix it.

Glenn

VBM wrote:
> I am using ASA 9.0 developer edition....also I am using iAnywhere .NET
> provider ASaClient
>
> thanks
>
>
> Glenn Paulley wrote:
>
>>I am aware of a problem with our ADO.NET driver, where it incorrectly
>>attempted to DROP a statement upon closing, which could cause the
>>error
>>that you're seeing. The problem I'm aware of was fixed in 8.0.2 build
>>4278.
>>
>>What release/build are you using?
>>
>>Glenn
>>
>>VBM wrote:
>>
>>>Thanks for the nice points.
>>>
>>>One of my function is using many ADO.NETconnections and I check the
>>>code and I am properly closing the connection at the end of the use
>>>I am using ASA developer edition which I got FREE from ASA site. It
>>>look sthat I will need to read more on database tuning ........I am
>>>SQL Server user so dont know yet abt ASA settings set....
>>>
>>>Proper guidence will be appriciated..
>>>
>>>thanks again
>>>Cheers !
>>>
>>>
>>>I am using
>>>Glenn Paulley wrote:
>>>
>>>
>>>>Ordinarily these are two different problems, but in your case they
>>>>are likely related.
>>>>
>>>>The resource governor error, which you have worked-around by setting
>>>>MAX_STATEMENT_COUNT to 0, is to inform you that your application is
>>>>(*very* likely) unintentionally leaking database server memory by
>>>>not dropping statements. If your application continues to prepare
>>>>statements, but not free them, and does so enough times, the server
>>>>will face a critical memory shortage, with the obvious consequences.
>>>>
>>>>The error below is usually caused by attempting to connect too many
>>>>clients to the server (i.e. the number of concurrent connections
>>>>exceeds your ASA license). However, the other source of this error
>>>>message is when the amount of server memory is deemed insufficient
>>>>to handle an additional (new) connection, quite likely caused by the
>>>>leak described above.
>>>>
>>>>Glenn
>>>>
>>>>VBM wrote:
>>>>
>>>>
>>>>>ASA 9.0
>>>>>
>>>>>I have used following statement
>>>>>
>>>>>Set option public.MAX_STATEMENT_COUNT = 0;
>>>>>commit;
>>>>>
>>>>>still I get error like "Database server connection limit exceeded "
>>>>>
>>>>>any thoughts....
>>>>>
>>>>>thanks
>>>>>
>>>>>
>>>>>
>>>>>Eric Bencina wrote:
>>>>>
>>>>>
>>>>>
>>>>>>You didn't mention what version of ASA that you were using, but
>>>>>>do a search in the online help for resource governors and you
>>>>>>will find details on why this error is occuring. Also look up the
>>>>>>MAX_STATEMENT_COUNT option.
>>>>>>
>>>>>>Eric Bencina
>>>>>>
>>>>>><Michel Renaud> wrote in message
>>>>>>news:3f562773.7660.846930886@sybase.com...
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>I am using Visual studio 2003 C# and ADO.NET code and
>>>>>>>>iAnywhere as back end.....
>>>>>>>>I get the error "Resource governor for 'prepared
>>>>>>>>statements' exceeded" when I open more than one command
>>>>>>>>objects and run....
>>>>>>>>
>>>>>>>>any clues...?
>>>>>>>
>>>>>>>If you're using the PC (desktop) version, download the
>>>>>>>latest EBF from http://www.sybase.com/downloads. If, like
>>>>>>>me, this is on the PocketPC, the EBF is not up yet (I got a
>>>>>>>message on Aug. 15 saying it was, but it still shows as the
>>>>>>>May 14 update - oops!)
>>>>>>>
>>>>>>>You can do a search in this newsgroup for more details about
>>>>>>>this specific problem.
>
>
>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer