"Unable to allocate work table " message

"Unable to allocate work table " message

Post by Svempa » Fri, 16 Jun 1995 04:00:00

A stored procedure that used to work on Version 10.0.1 is now being run on
Sybase Version 10.0.2.

The error message reads:

"Unable to allocate work table for processing group by or distinct clause
during query optimization. Max limit (12) of work tables is exceeded.
Simplify the query and retry."

I confess that the query is slightly horrendous but we are trying to make
SQL do most of the work. But it worked perfectly on a different machine
running Version 10.0.1.

Any help is appreciated.

                                -- Satya

Satya                                                 Say it simply and


1. "Unable to modify table" error message

In this table:

CREATE TABLE [dbo].[asset_attribute] (
        [asset_attribute_id] [int] IDENTITY (1, 1) NOT NULL ,
        [asset_id] [int] NOT NULL ,
        [attribute_type_id] [int] NOT NULL ,
        [value] [char] (1024) NULL ,
        [sequence] [tinyint] NULL ,
        [active] [tinyint] NULL ,
        [start_date] [datetime] NULL ,
        [end_date] [datetime] NULL ,
        [data_entry_date] [datetime] NULL ,
        [last_modified_date] [datetime] NOT NULL ,
        [modifying_user] [char] (12) NOT NULL

I'm trying to insert a row into the table.  Inserting a row of any
type anywhere in the table (using Enterprise Manager) and recieve the
following error message.

Beside dropping the table and recreating it, is there any way to fix
something like this?  checkdb shows no problems.

'asset_attribute' table
- Unable to modify table.  
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
Server]SqlDumpExceptionHandler: Process 9 generated fatal exception
c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this

2. Perl Oracle Connectivity problem

3. ERROR MESSAGE: "Unable to Browse Cube..."

4. Default tran log location

5. "Unable to bind to field" message

6. how to add default to a col after the table is designed

7. "Unable to display help" error message

8. mssql7 error

9. unable to allocate XXXX bytes of shared memory ("shared pool","TEXTINDEXMETHODS"

10. max of ("...","...","..")

11. Error Message: "Higher Table Level Required"

12. "Table locked by another user" message

13. "Unknown error message number "16118".