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.
| 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 throwsan following error.. Server: Msg 21, Level 22, State 1, Line 2Warning: Fatal error 5180 occurred at Aug 23 2006 11:35AMConnection BrokenI 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=====================RamLive 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 LarssonHelsingborg, Sweden |
 |
|
|
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?=====================RamLive while u r Alive |
|
|
|
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..=====================RamLive while u r Alive |
|
|
|
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 LarssonHelsingborg, Sweden |
|
|
|
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.. =====================RamLive while u r Alive |
|
|
|
|
|
|
|
|
Fatal error 5180 occurred