Redbrick List Forum

Re: ERR502U - anyone have any better ideas about this,messages and

Posted By:
Date:

Bridget,

Something else you might look at is the location of your query tempspace
directory. The default location is generally not where you want it to be.

Check your rbw.config file -- these are the rows pertaining to those
parameters. I've only changed the last entry to point to an area with
plenty of space.

# Query Temporary Space parameters
# Always specify QUERY_MEMORY_LIMIT before
# QUERY_TEMPSPACE_MAXSPILLSIZE in this configuration file
# Specify multiple DIRECTORYs by having multiple
# TUNE QUERY_TEMPSPACE_DIRECTORY entries
#TUNE QUERY_MEMORY_LIMIT 50M
#TUNE QUERY_TEMPSPACE_MAXSPILLSIZE 1G
TUNE QUERY_TEMPSPACE_DIRECTORY /rb5/temp_qspace


Jim Cotter
USDA - NASS
Data Warehouse Section
(202) 720-2751
Jim_Cotter@nass.usda.gov




"lingyun " <lingyun.jin@wcom.com>
Sent by: forum.subscriber@iiug.org
02/12/03 09:49 AM


To: redbrick-list@iiug.org
cc:
Subject: Re: ERR502U - anyone have any better ideas about this,messages and [22]


Hmmmm, "It takes about 30 minutes before it falls over", Is it a simply
select query?
Then it maybe because the memory problem, Why don't you try to put more
restriction in the where clause of
the same query, and watch it whether it can finish in 30 minutes, and
how is the memory performance.

Lingyun


"Bridget.Man...." wrote:
>
> Hi all,
>
> I am running a query that gets the following error message
> DB:HOSTDW ERR502U: User SYSTEM received: ** FATAL ** (132) Internal
error
> in function: 'queue is full in flush partition'.
>
> The messages and codes manual has no more info. Anyone have any idea
about
> what the cause is.
>
> The error occurs every time the query is run. It takes about 30 minutes
> before it falls over.
>
> Bridget Mansfield
> ______________________
> DBA - Business Intelligence
> 09-355-7967
> 021-522-181
>
>
-----------------------------------------------------------------------------------------------
> Have you seen our website?.... http://www.vodafone.co.nz
>
> CAUTION: This correspondence is confidential and intended for the named
recipient(s) only.
> If you are not the named recipient and receive this correspondence in
error, you must not copy,
> distribute or take any action in reliance on it and you should delete it
from your system and
> notify the sender immediately. Thank you.
>
> Unless otherwise stated, any views or opinions expressed are solely
those of the author and do
> not represent those of Vodafone New Zealand Limited.
>
> Vodafone New Zealand Limited
> 21 Pitt Street, Private Bag 92161, Auckland, 1020, New Zealand
> Telephone + 64 9 357 5100
> Facsimile + 64 9 377 0962

Messages In This Thread

• Re: ERR502U - anyone have any better ideas about this,messages and
  lingyun -- Wednesday, 12 February 2003, at 9:49 a.m.
  • Re: ERR502U - anyone have any better ideas about this,messages and
    Jim_Cotter@nass.usda.gov -- Wednesday, 12 February 2003, at 10:28 a.m.

Redbrick List Forum is maintained by Administrator with WebBBS 5.12.