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.

Auditing terminated...

4 posts in Windows NT Last posting was on 2000-02-11 16:12:33.0Z
Jaime Barillas Posted on 2000-02-10 19:11:07.0Z
From: "Jaime Barillas" <jmbarillas@scotiabank.com.sv>
Subject: Auditing terminated...
Date: Thu, 10 Feb 2000 13:11:07 -0600
Lines: 14
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
Message-ID: <AOR0Ys$c$GA.306@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 206.136.173.248
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2557
Article PK: 1090011

Can someone explain me what could happened? I installed auditing two weeks
ago without problem until now, and this is in the errorlog:

01:00000:00009:2000/02/09 16:23:37.17 server AUDIT PROCESS EXCEPTION:
Received error 1204, severity 17, state 1.
01:00000:00009:2000/02/09 16:23:37.17 server ***** audproc: THE AUDIT
PROCESS IS TERMINATING. *****
01:00000:00009:2000/02/09 16:23:37.17 server ***** audproc: WARNING:
AUDITING IS NOT ENABLED. *****

Thank you.


Jason Froebe Posted on 2000-02-11 16:12:29.0Z
Message-ID: <38A434ED.827DF6C6@sybase.com>
Date: Fri, 11 Feb 2000 10:12:29 -0600
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Jaime Barillas <jmbarillas@scotiabank.com.sv>
Subject: Re: Auditing terminated...
References: <AOR0Ys$c$GA.306@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------4DDC5808C18EFBC24BDC8F18"
Newsgroups: sybase.public.sqlserver.nt
Lines: 116
NNTP-Posting-Host: jfroebe-desktop.sybase.com 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2551
Article PK: 1090002


Jaime Barillas wrote:

> Can someone explain me what could happened? I installed auditing two weeks
> ago without problem until now, and this is in the errorlog:
>
> 01:00000:00009:2000/02/09 16:23:37.17 server AUDIT PROCESS EXCEPTION:
> Received error 1204, severity 17, state 1.
> 01:00000:00009:2000/02/09 16:23:37.17 server ***** audproc: THE AUDIT
> PROCESS IS TERMINATING. *****
> 01:00000:00009:2000/02/09 16:23:37.17 server ***** audproc: WARNING:
> AUDITING IS NOT ENABLED. *****
>
> Thank you.

Hi Jaime,

Hope this helps:

j


Error 1204 19 2
SQL Server has run out of LOCKS. Re-run your command when there are
fewer active users, or ask your System Administrator to reconfigure
SQL Server with more LOCKS.

Documented in:
Page 305 of the March 1998 EMTSG
Page 2-198 of the February 1996 Errors TSG
Page 2-154 of the August 1995 Errors TSG
Page 2-124 of the February 1995 Errors TSG
Page 1-97 of the June 1994 TSG
Page 1-49 of the August 1993 TSG



Error 1204

Severity Level

19

Error Message Text

SQL Server has run out of LOCKS. Re-run your
command when there are fewer active users, or
contact a user with System Administrator (SA) role
to reconfigure Adaptive Server with more LOCKS.

Explanation

This error occurs when Adaptive Server runs out of locks. The number of
locks available is controlled by the Adaptive Server configuration
parameter number of locks.

Following is an example of the output from sp_configure, and a brief
description of the output related to locks:

1> sp_configure "number of locks"
2> go

Parameter Name Default Memory Used Config Value Run Value
----------------------- ----------- ----------- ------------ -----------
number of locks 5000 0 5000 5000


* The Default column contains the default value for number of locks,
5000.

* The Memory Used column indicates the amount of memory used
by the configured locks. Each lock requires 72 bytes of memory.

* The Config Value column contains the value to which the number of
locks configuration parameter has been set with sp_configure. If the
value has not been explicitly configured, there is a 0 in this
column and the default value is used.

* The Run Value column contains the value Adaptive Server is using.

Action

Rerun the command when there are fewer active users, or ask the
Sybase System Administrator ("sa") to reconfigure Adaptive Server for
more locks. Increasing the number of available locks impacts
performance and memory requirements.

Before making any changes to Adaptive Server, refer to the Performance
and Tuning Guide and "Configuring Memory" in the System
Administration Guide for information about how Adaptive Server uses
memory resources.

To increase the number of locks available, complete the following
steps:

1. Determine the number of locks currently configured for
Adaptive Server:

1> use master
2> go

1> sp_configure "number of locks"
2> go

If you increase the number of locks available by too many locks, the
Server may run out of memory and be unable to restart. Refer to "Adaptive
Server Does Not Start After Altering Configuration" in Chapter 1 if
you run out of memory and cannot restart Adaptive Server.

2. Choose the number of locks you want to configure and issue the
following command:

1> sp_configure "number of locks", new_value
2> go

3. Restart Adaptive Server to operate with the new values.

Additional Information

Refer to the Performance and Tuning Guide for information about locks
and other Adaptive Server resources.

Refer to "number of locks" in the System Administration Guide for
information about the number of locks configuration parameter.

Releases in Which This Error Is Raised

11.0 and later


Download VCard jfroebe.vcf


Mark A. Parsons Posted on 2000-02-11 05:51:11.0Z
Message-ID: <38A3A34F.DB4495CF@compuserve.com>
Date: Fri, 11 Feb 2000 18:51:11 +1300
From: "Mark A. Parsons" <iron_horse@compuserve.com>
Organization: Pegasys Ltd
X-Mailer: Mozilla 4.61 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Auditing terminated...
References: <AOR0Ys$c$GA.306@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 18
NNTP-Posting-Host: p449.ipa1-n8-16.iconz.net.nz 210.48.25.193
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2554
Article PK: 1090006


Jaime Barillas wrote:
>
> Can someone explain me what could happened? I installed auditing two weeks
> ago without problem until now, and this is in the errorlog:
>
> 01:00000:00009:2000/02/09 16:23:37.17 server AUDIT PROCESS EXCEPTION:
> Received error 1204, severity 17, state 1.
> 01:00000:00009:2000/02/09 16:23:37.17 server ***** audproc: THE AUDIT
> PROCESS IS TERMINATING. *****
> 01:00000:00009:2000/02/09 16:23:37.17 server ***** audproc: WARNING:
> AUDITING IS NOT ENABLED. *****
>
> Thank you.

*shrug* Has the sysaudits table(s) filled up?

What's the Troubleshooting Guide (or is it P&T now?) say about error
#1204?

--
Mark Parsons
Pegasys Ltd


Jaime Barillas Posted on 2000-02-11 16:12:33.0Z
From: "Jaime Barillas" <jmbarillas@scotiabank.com.sv>
References: <AOR0Ys$c$GA.306@forums.sybase.com> <38A3A34F.DB4495CF@compuserve.com>
Subject: RE: Auditing terminated...
Date: Fri, 11 Feb 2000 10:12:33 -0600
Lines: 31
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
Message-ID: <l8DXNtKd$GA.306@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 206.136.173.246
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2552
Article PK: 1090007

It is not related to space, because I made a database of 125Mb, and the
table is about 1Mb.
I will look up for that error.

Mark A. Parsons <iron_horse@compuserve.com> escribió en el mensaje de
noticias 38A3A34F.DB4495CF@compuserve.com...

> Jaime Barillas wrote:
> >
> > Can someone explain me what could happened? I installed auditing two
weeks
> > ago without problem until now, and this is in the errorlog:
> >
> > 01:00000:00009:2000/02/09 16:23:37.17 server AUDIT PROCESS EXCEPTION:
> > Received error 1204, severity 17, state 1.
> > 01:00000:00009:2000/02/09 16:23:37.17 server ***** audproc: THE AUDIT
> > PROCESS IS TERMINATING. *****
> > 01:00000:00009:2000/02/09 16:23:37.17 server ***** audproc: WARNING:
> > AUDITING IS NOT ENABLED. *****
> >
> > Thank you.
>
> *shrug* Has the sysaudits table(s) filled up?
>
> What's the Troubleshooting Guide (or is it P&T now?) say about error
> #1204?
>
> --
> Mark Parsons
> Pegasys Ltd