Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Fatal error 5180 occurred

Author  Topic 

raam_kimi
Yak Posting Veteran

80 Posts

Posted - 2006-08-23 : 04:57:43
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

30421 Posts

Posted - 2006-08-23 : 05:13:16
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

80 Posts

Posted - 2006-08-24 : 05:56:09
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
Go to Top of Page

raam_kimi
Yak Posting Veteran

80 Posts

Posted - 2006-08-24 : 06:05:37
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

30421 Posts

Posted - 2006-08-24 : 08:53:46
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

80 Posts

Posted - 2006-08-24 : 09:40:46
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
   

- Advertisement -