Board index » delphi » MSSQL Server error: Could not allocate a new object descriptor for required system catalog in database ... How to solve that?

Tomislav Kard

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

MSSQL Server error: Could not allocate a new object descriptor for required system catalog in database ... How to solve that?

Hi there!

I have a problem with MS SQL Server 6.5 when I start one stored
procedure. That stored procedure starts transaction and opens a cursor
on two outer joined tables and updates some total and log tables for
about 2000 records. It works for some time and then:

General SQL error
Could not allocate a new object descriptor for required system catalog
in database "9".
Another database dropped in order to open this database.
Invalid object name "MKPocD2"
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK
TRAN is missing. Previous count 1, Current count 2.

MKPocD2 is second table in outer join select for cursor.

Does anyone have idea how to solve that?

tomi.

 
Tomislav Kard

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:MSSQL Server error: Could not allocate a new object descriptor for required system catalog in database ... How to solve that?


Quote
>Does anyone have idea how to solve that?

I solved my problem.

tomi.

Other Threads

1. MSSQL error(again): Non Blob column in table required to perform operation

2. MSSQL error: Non-blob column in table required to perform operation

3. EOleException: Object Required error

4. HELP: Error: Object or Class type required

5. Project1.dpr(17):error object or class type required

6. EDB Engine Error Could Object not found object

7. Making a new Index: Invalid Index Descriptor (CDX)

8. MSSQL 6.0 and Unable to allocate sufficient memory.

9. MSSQL and Unable to allocate sufficient memory !!!

10. ORA-12663 Service required by client not available on the server