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.

WHAT IS THIS ERROR: 1603

6 posts in Windows NT Last posting was on 2001-05-30 09:28:26.0Z
Geoff_Smith Posted on 2001-05-29 00:25:37.0Z
From: Geoff_Smith
Date: Mon, 28 May 2001 20:25:37 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: WHAT IS THIS ERROR: 1603
Message-ID: <5DA5C2131E2B10BF0002584E85256A5B.0002587185256A5B@webforums>
Lines: 22
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:686
Article PK: 1087293

02:00000:00003:2001/05/29 09:18:48.15 server Error: 1603, Severity: 21,
State: 2
02:00000:00003:2001/05/29 09:18:48.15 server Process priority 3 invalid or
no process slots available
00:00000:00003:2001/05/29 09:18:48.79 kernel NT operating system error 8
in module 'e:\rel1192\porttree\svr\sql\nt386\ksource\proc\prcontext.c' at
line 318: Not enough storage is available to process this command.


Background:

Machine: compaq proliant 4cpu 3300M RAM

I set pagefile to 4000M
set shared mem starting address to: 23662592 from 0
set total memory to 1024000 (2000M) from 700000

Got this error and had to shutdown after 1 hour of new settings.

ANY IDEAS, I have changed the setting back to pre change (0 / 700000)

Geoff


Tony Imbierski Posted on 2001-05-30 09:28:26.0Z
Message-ID: <3B14BD3A.97282D32@sybase.com>
Date: Wed, 30 May 2001 10:28:26 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: WHAT IS THIS ERROR: 1603
References: <5DA5C2131E2B10BF0002584E85256A5B.0002587185256A5B@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 46
NNTP-Posting-Host: aja.sybase.com 158.76.131.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:674
Article PK: 1087280

It's funny how these things come up. A couple of weeks ago I answered a
question in this newsgroup about shared memory starting address. Basically, the
lower you set the starting address the more shared memory you can squeeze in.
Of course there's a downside to everything and I pointed out that -IN THEORY -
maximising shared memory in this way might cause NT problems the next time we
create a new fiber. New fibers need stack space and if you've taken all
available virtual memory for ASE's use, there may simply not be enough left
over for the new stack. I said -IN THEORY- because at that time I had never
actually seen it happen.

But this is exactly what has happened in your case! You need to raise the
starting address and lower total memory slightly to allow NT more room to
create new fibers (a new fiber is created every time someone logs in, amongst
others).

HTH,
tonyi

Geoff_Smith wrote:

> 02:00000:00003:2001/05/29 09:18:48.15 server Error: 1603, Severity: 21,
> State: 2
> 02:00000:00003:2001/05/29 09:18:48.15 server Process priority 3 invalid or
> no process slots available
> 00:00000:00003:2001/05/29 09:18:48.79 kernel NT operating system error 8
> in module 'e:\rel1192\porttree\svr\sql\nt386\ksource\proc\prcontext.c' at
> line 318: Not enough storage is available to process this command.
>
> Background:
>
> Machine: compaq proliant 4cpu 3300M RAM
>
> I set pagefile to 4000M
> set shared mem starting address to: 23662592 from 0
> set total memory to 1024000 (2000M) from 700000
>
> Got this error and had to shutdown after 1 hour of new settings.
>
> ANY IDEAS, I have changed the setting back to pre change (0 / 700000)
>
> Geoff

--
Tony Imbierski
Sybase Engineering

-- how much daylight did you save today? --


Jim Egan Posted on 2001-05-29 05:33:57.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: WHAT IS THIS ERROR: 1603
Date: Mon, 28 May 2001 23:33:57 -0600
Message-ID: <MPG.157ce2b18971f7aa98b3c3@forums.sybase.com>
References: <5DA5C2131E2B10BF0002584E85256A5B.0002587185256A5B@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 32
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:683
Article PK: 1087290


Geoff_Smith wrote...
> 02:00000:00003:2001/05/29 09:18:48.15 server Error: 1603, Severity: 21,
> State: 2
> 02:00000:00003:2001/05/29 09:18:48.15 server Process priority 3 invalid or
> no process slots available
> 00:00000:00003:2001/05/29 09:18:48.79 kernel NT operating system error 8
> in module 'e:\rel1192\porttree\svr\sql\nt386\ksource\proc\prcontext.c' at
> line 318: Not enough storage is available to process this command.
>
>
> Background:
>
> Machine: compaq proliant 4cpu 3300M RAM
>
> I set pagefile to 4000M
> set shared mem starting address to: 23662592 from 0
> set total memory to 1024000 (2000M) from 700000
>
> Got this error and had to shutdown after 1 hour of new settings.
>
> ANY IDEAS, I have changed the setting back to pre change (0 / 700000)

It may be as simple as exceeding the maximum number of allowed user connections. It may
also be that you have the memory incorrectly configured. Try going down to 1.8 GB instead
of 2 GB. Was the memory setting within the boot.ini set when you ran the database server
with 2GB of RAM?
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Sybase TechWave 2001 http://www.sybase.com/events/techwave2001
August 12th - 16th, San Diego


Geoff_Smith Posted on 2001-05-29 06:36:13.0Z
From: Geoff_Smith
Date: Tue, 29 May 2001 02:36:13 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: WHAT IS THIS ERROR: 1603
Message-ID: <936497C73E1FAF4F0024466A85256A5B.00228B6485256A5B@webforums>
References: <5DA5C2131E2B10BF0002584E85256A5B.0002587185256A5B@webforums> <MPG.157ce2b18971f7aa98b3c3@forums.sybase.com>
Lines: 20
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:681
Article PK: 1087288

Jim,

I have looked at our NT (I'm new at it) we have build 1381.
service pack 6.

The microsoft site has a reference to /maxmem for boot.ini.

But I guess what I am saying is please be specific, because I, nor our NT
person knows how to set this in boot.ini

I used the .cfg file to set total memory = 1024000 pages, and shared mem to
"23..." whatever it is.

Does this help you know where I'm at.

I was going to try a 1.8 / 1.9 G setting and see.

Thanks,

geoff


Geoff_Smith Posted on 2001-05-29 07:15:49.0Z
From: Geoff_Smith
Date: Tue, 29 May 2001 03:15:49 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: WHAT IS THIS ERROR: 1603
Message-ID: <DEB8E06DB00B2B470027E68B85256A5B.002710C685256A5B@webforums>
References: <5DA5C2131E2B10BF0002584E85256A5B.0002587185256A5B@webforums> <MPG.157ce2b18971f7aa98b3c3@forums.sybase.com> <936497C73E1FAF4F0024466A85256A5B.00228B6485256A5B@webforums>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:680
Article PK: 1087287

I think I have it (check more on microsoft site)

in boot.ini I should put a swith of like:

multi(0)disk(0)rdisk(0)partition(1)\WINNT="Windows NT Server Version 4.00"
/3GB

is that correct, because at present it looks like:

multi(0)disk(0)rdisk(0)partition(1)\WINNT="Windows NT Server Version 4.00"

Thanks for your help in advance.


Jim Egan Posted on 2001-05-29 14:49:14.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: WHAT IS THIS ERROR: 1603
Date: Tue, 29 May 2001 08:49:14 -0600
Message-ID: <MPG.157d64d5e6fba23798b3c7@forums.sybase.com>
References: <5DA5C2131E2B10BF0002584E85256A5B.0002587185256A5B@webforums> <MPG.157ce2b18971f7aa98b3c3@forums.sybase.com> <936497C73E1FAF4F0024466A85256A5B.00228B6485256A5B@webforums> <DEB8E06DB00B2B470027E68B85256A5B.002710C685256A5B@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 18
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:678
Article PK: 1087285


Geoff_Smith wrote...
> I think I have it (check more on microsoft site)
>
> in boot.ini I should put a swith of like:
>
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Windows NT Server Version 4.00"
> /3GB
>
> is that correct, because at present it looks like:
>
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Windows NT Server Version 4.00"
>
> Thanks for your help in advance.
>
>

If that is the setting that MS is recommending then use it. But I didn't think it was
valid on NT Server. Only NT Enterprise.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Sybase TechWave 2001 http://www.sybase.com/events/techwave2001
August 12th - 16th, San Diego