April 19, 2013 at 2:26 pm
Hi there
When running an SSIS package I get the following message:
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Could not allocate space for object 'dbo.SORT temporary run storage: 140748109840384' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.".
I have checked disk space - plenty of it left
Tempdb is set to "autogrow"
Yet - still get this error.
Any ideas?
Regards
Chris
April 19, 2013 at 2:34 pm
Chris Hewitt-261101 (4/19/2013)
Hi thereWhen running an SSIS package I get the following message:
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Could not allocate space for object 'dbo.SORT temporary run storage: 140748109840384' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.".
I have checked disk space - plenty of it left
Tempdb is set to "autogrow"
Yet - still get this error.
Any ideas?
Regards
Chris
How much space is available on the drive where tempdb resides?
April 19, 2013 at 2:38 pm
You may want to look at what it is your process is doing and with how much data. If my swag is correct you need 131,081+ GB of disk space for the sort.
April 19, 2013 at 2:49 pm
Hi Lynn
17gb of disk space left, so don't surely space cannot be the issue then?
This is on a client old server - only 3.75 gb of ram. Could this be the issue?
Thanks for you help!
Regards
Chris
April 19, 2013 at 2:53 pm
Chris Hewitt-261101 (4/19/2013)
Hi Lynn17gb of disk space left, so don't surely space cannot be the issue then?
This is on a client old server - only 3.75 gb of ram. Could this be the issue?
Thanks for you help!
Regards
Chris
Based on the following:
"Could not allocate space for object 'dbo.SORT temporary run storage: 140748109840384' in database 'tempdb' because the 'PRIMARY' filegroup is full.
If 140748109840384 is the number of bytes needed, that computes to a bit under 131,082 GB of space needed.
April 19, 2013 at 3:16 pm
Mmm doesn't make sense
Seems to be happening on a table where I import 3.5 million rows, which is not a lot. Have watched tempdb space, and it remains at 8mb all the way through.
Disk space remains 17 gb
April 19, 2013 at 3:42 pm
As I said, you may want to look at the process and the data. It looks like it thinks it needs 130000 GB of disk space to run a sort.
April 19, 2013 at 3:43 pm
How does the tempdb log look?
Is it set to autogrow as well?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2013 at 3:45 pm
How much free space is in tempdb data files?
How much free space in in the tempdb log file?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2013 at 4:17 pm
Hi Lynn
Does this number definitely represent the number of bytes needed?
Chris
April 19, 2013 at 4:26 pm
Let's start with this article. I am not sure the figure correlates to bytes or bits for that matter.
http://msdn.microsoft.com/en-us/library/ms176029.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2013 at 8:49 pm
Chris Hewitt-261101 (4/19/2013)
Hi LynnDoes this number definitely represent the number of bytes needed?
Chris
As I said, I was taking a SWAG at what it meant. I wasn't have much luck with my Google-fu at the time. Still trying to find out.
I will still stand by recommendation to look at the process being run to determine if it can be improved.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply