SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Fatal error 5180 occurred
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

raam_kimi
Yak Posting Veteran

India
80 Posts

Posted - 08/23/2006 :  04:57:43  Show Profile
HI All
I got the problem when i am trying to insert the data into DB for volume testing... nearly 7 million records am going to insert.

it successfully inserted nearly 7 lack records.. after that it throws
an following error..

Server: Msg 21, Level 22, State 1, Line 2
Warning: Fatal error 5180 occurred at Aug 23 2006 11:35AM

Connection Broken


I am not able to proceed further.. am using front end .net application for doing this bulk insert....

afer that i am trying to use query the DB in query analizer, it throws an same error...

i am stuck here.. not able to do anything on this DB..

could anyone help me out


=====================
Ram

Live while u r Alive

SwePeso
Patron Saint of Lost Yaks

Sweden
30281 Posts

Posted - 08/23/2006 :  05:13:16  Show Profile  Visit SwePeso's Homepage
How do you insert them? Sending dynamiq SQL queries or are you using command object?
If so, how are you using command object?

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

raam_kimi
Yak Posting Veteran

India
80 Posts

Posted - 08/24/2006 :  05:56:09  Show Profile
Hi Peter,
Am using dynamic sql queries. And i passed the datas as XML stream and do the bulk insert. And i didnt insert all those items in a single shot.

I make them as a batch, each batch contains 10000 items, and i did the insertion.


During this, My SP can use these data to populate 4 different tables, 3 of the table caontains same amount of data, and remaining one contains only the small amount of data.

And i got this error for only one table. Datas can be inserted into Remaining tables as good. i can access them in query analyzer but i cant access that particular table..

was this the problem with DB settings? or my code causes the DB Down?



=====================
Ram

Live while u r Alive

Edited by - raam_kimi on 08/24/2006 05:56:38
Go to Top of Page

raam_kimi
Yak Posting Veteran

India
80 Posts

Posted - 08/24/2006 :  06:05:37  Show Profile
Yes peter i am using command object in my .Net front end. and i use the storeprocedure commandtype. And passing the dataset as XML to SP, split it in SQL and do the insert..

=====================
Ram

Live while u r Alive
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30281 Posts

Posted - 08/24/2006 :  08:53:46  Show Profile  Visit SwePeso's Homepage
It seems some buffer is filled and then crashes some subsystem.
The server worked to hard, I think.

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

raam_kimi
Yak Posting Veteran

India
80 Posts

Posted - 08/24/2006 :  09:40:46  Show Profile
yes peter it seems so, i got the error msg thats states like FCB like file corrupted.. i cant remember the exact msg..



=====================
Ram

Live while u r Alive
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000