Error: 5180, Severity: 22, State: 1 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error: 5180, Severity: 22, State: 1

Hi, <br /><br />My VB program is kicking off stored procudures on the sql server. I am gettign the following error in my application:<br /><br />Run-time error’-2147467259(80004005)’:<br />[Microsoft][ODBC SQL Server Driver][SQL Server]Location <img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />age.cpp:2609<br />Expression SpaceNeeded &lt;=SpaceContig && SpaceNeeded &lt;=space_usable<br />SPID:51<br />Process ID:736<br /><br />The Error log in SQl Reads:<br />2005-05-20 14:41:33.43 spid51 Error: 5180, Severity: 22, State: 1<br />2005-05-20 14:41:33.43 spid51 Could not open FCB for invalid file ID 13364 in database ‘RSG VPoS Datamart’..<br />2005-05-20 14:41:34.28 spid51 Using ‘sqlimage.dll’ version ‘4.0.5’<br />Dump thread – spid = 51, PSS = 0x42ceb218, EC = 0x42ceb528<br />Stack Dump being sent to C:program FilesMicrosoft SQL ServerMSSQLlogSQL00039.dmp<br /><br />The SQL Statement:<br />Update dbo.agg_week_store_prod Set xVAT = Value * 0.8510638 <br />where product_key in (select product_index From product, tax_code Where <br />vat_code_key = tax_code_index and tax_code.tax_code = ‘1’) set nocount off <br /><br />This is running on SQL server 2000 with service pack3.<br /><br />Any Help would be appreciated.<br /><br />Thanks<br /><br />Dave
I think the error u got is bcoz of the transaction you are doing.
It appears that the transaction log is full and its not getting the space to grow as it require to update the table.

I suppose the same ‘space unavilability’ problem. You can read dump file for more information.. if possible past it in the forum..we can help more after reading contents from it: – C:program FilesMicrosoft SQL ServerMSSQLlogSQL00039.dmp Deepak Kumar –An eye for an eye and everyone shall be blind
Hi,
My settings for the transaction log are unrestricted file growth.
Is there anything else i can do, to stop me from running out of space? Dave
Hi Dave,
U need to take the full backup of transaction log so that it will be shrink and will leave space to the system if there.

]]>