| Author |
 Topic  |
|
|
raam_kimi
Yak Posting Veteran
India
80 Posts |
 Posted - 08/23/2006 : 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
Sweden
29138 Posts |
Posted - 08/23/2006 : 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 |
 |
|
|
raam_kimi
Yak Posting Veteran
India
80 Posts |
Posted - 08/24/2006 : 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 |
Edited by - raam_kimi on 08/24/2006 05:56:38 |
|
|
|
raam_kimi
Yak Posting Veteran
India
80 Posts |
Posted - 08/24/2006 : 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 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/24/2006 : 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 |
|
|
|
raam_kimi
Yak Posting Veteran
India
80 Posts |
Posted - 08/24/2006 : 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 |
|
|
| |
Topic |
|
Fatal error 5180 occurred
Forum Locked
