Error 80040e14
From: M.L. (ML_at_discussions.microsoft.com)
Date: 11/25/04
- Next message: DBLIB Worm: "Call dbcursorfetchex() by multiple threads will hang! Why?"
- Previous message: mttc: "Re: Backup job for schema only"
- Next in thread: Mike Epprecht (SQL MVP): "RE: Error 80040e14"
- Reply: Mike Epprecht (SQL MVP): "RE: Error 80040e14"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 25 Nov 2004 03:43:03 -0800
Hi NG,
I hope very much someone can help me or at least point me in the right
direction here. I have a simple Stored Procedure and all it does is it adds 4
different indexes to a rather large table which is built daily. It has been
running for 6 months now without problems, but today I found this error
message in the log:
---- error message from log-file-------begin
Step 'DTSStep_DTSExecuteSQLTask_1' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:The statement has been terminated. (Microsoft OLE DB
Provider for SQL Server (80040e14): Could not allocate space for object
'_cc_SkuDump' in database 'CDS' because the 'PRIMARY' filegroup is full.)
(Microsoft OLE DB Provider for SQL Server (80040e14): Warning! The maximum
key length is 900 bytes. The index 'cluster_SkuDump' has maximum length of
2765 bytes. For some combination of large values, the insert/update operation
will fail.)
Step Error code: 80040E14
Step Error Help File:
Step Error Help Context ID:0
---- error message from log-file-------end
So what is wrong and how can I remedy it? Thanks a lot in advance!
/M.L.
- Next message: DBLIB Worm: "Call dbcursorfetchex() by multiple threads will hang! Why?"
- Previous message: mttc: "Re: Backup job for schema only"
- Next in thread: Mike Epprecht (SQL MVP): "RE: Error 80040e14"
- Reply: Mike Epprecht (SQL MVP): "RE: Error 80040e14"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
