|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
WrapperRead() ??I am doing this on a dev box, preparing to do it in prod. The dev box isn't at all the capacity of the production resource. My end-to-end is below, but it keeps terminating on step 7 w/this error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentation. Connection Broken I haven't seen this before. I did all of the steps once before, just w/much smaller data volumes, so I know the tsql is functional. This is very urgent, does anybody know why this is happening and how I can get around it? 1) bcp out data 2) drop the indexes, pk's 3) truncate tables 4) alter columns/add 2 new columns 5) create pk 6) load data w/dts pkg 7) update msgID 8) make msgID NOT NULL 9) recreate indexes 10) unique constraint on msgID 11) update statistics -- Lynn See if this helps:
http://support.microsoft.com/kb/827452 -- Show quote-oj "Lynn" <L***@discussions.microsoft.com> wrote in message news:A0141D9D-AB80-4E6D-BE62-4FAE7673BBCC@microsoft.com... >I am trying to complete an end-to-end of a rather large database change(s). > I am doing this on a dev box, preparing to do it in prod. The dev box > isn't > at all the capacity of the production resource. My end-to-end is below, > but > it keeps terminating on step 7 w/this error: > > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead > (WrapperRead()). > Server: Msg 11, Level 16, State 1, Line 0 > General network error. Check your network documentation. > > Connection Broken > > I haven't seen this before. I did all of the steps once before, just > w/much > smaller data volumes, so I know the tsql is functional. This is very > urgent, > does anybody know why this is happening and how I can get around it? > > 1) bcp out data > 2) drop the indexes, pk's > 3) truncate tables > 4) alter columns/add 2 new columns > 5) create pk > 6) load data w/dts pkg > 7) update msgID > 8) make msgID NOT NULL > 9) recreate indexes > 10) unique constraint on msgID > 11) update statistics > > -- Lynn well, oj, i appreciate it, but i'm not sure that it applies as the server is
not 2003, it's windows 2000 advanced srv. -- Lynn Show quote "oj" wrote: > See if this helps: > http://support.microsoft.com/kb/827452 > > -- > -oj > > > > "Lynn" <L***@discussions.microsoft.com> wrote in message > news:A0141D9D-AB80-4E6D-BE62-4FAE7673BBCC@microsoft.com... > >I am trying to complete an end-to-end of a rather large database change(s). > > I am doing this on a dev box, preparing to do it in prod. The dev box > > isn't > > at all the capacity of the production resource. My end-to-end is below, > > but > > it keeps terminating on step 7 w/this error: > > > > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead > > (WrapperRead()). > > Server: Msg 11, Level 16, State 1, Line 0 > > General network error. Check your network documentation. > > > > Connection Broken > > > > I haven't seen this before. I did all of the steps once before, just > > w/much > > smaller data volumes, so I know the tsql is functional. This is very > > urgent, > > does anybody know why this is happening and how I can get around it? > > > > 1) bcp out data > > 2) drop the indexes, pk's > > 3) truncate tables > > 4) alter columns/add 2 new columns > > 5) create pk > > 6) load data w/dts pkg > > 7) update msgID > > 8) make msgID NOT NULL > > 9) recreate indexes > > 10) unique constraint on msgID > > 11) update statistics > > > > -- Lynn > > > Understood. But have you tried the suggested workaround.
-- Show quote-oj "Lynn" <L***@discussions.microsoft.com> wrote in message news:D51E3257-46BF-46B9-A038-1BD5F12C61E7@microsoft.com... > well, oj, i appreciate it, but i'm not sure that it applies as the server > is > not 2003, it's windows 2000 advanced srv. > -- Lynn > > > "oj" wrote: > >> See if this helps: >> http://support.microsoft.com/kb/827452 >> >> -- >> -oj >> >> >> >> "Lynn" <L***@discussions.microsoft.com> wrote in message >> news:A0141D9D-AB80-4E6D-BE62-4FAE7673BBCC@microsoft.com... >> >I am trying to complete an end-to-end of a rather large database >> >change(s). >> > I am doing this on a dev box, preparing to do it in prod. The dev box >> > isn't >> > at all the capacity of the production resource. My end-to-end is >> > below, >> > but >> > it keeps terminating on step 7 w/this error: >> > >> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead >> > (WrapperRead()). >> > Server: Msg 11, Level 16, State 1, Line 0 >> > General network error. Check your network documentation. >> > >> > Connection Broken >> > >> > I haven't seen this before. I did all of the steps once before, just >> > w/much >> > smaller data volumes, so I know the tsql is functional. This is very >> > urgent, >> > does anybody know why this is happening and how I can get around it? >> > >> > 1) bcp out data >> > 2) drop the indexes, pk's >> > 3) truncate tables >> > 4) alter columns/add 2 new columns >> > 5) create pk >> > 6) load data w/dts pkg >> > 7) update msgID >> > 8) make msgID NOT NULL >> > 9) recreate indexes >> > 10) unique constraint on msgID >> > 11) update statistics >> > >> > -- Lynn >> >> >> No, I haven't. The end-to-end I am trying to validate pre-deployment has
failed badly in a couple other areas. I've got to correct these first. Thank you, oj. -- Lynn Show quote "oj" wrote: > Understood. But have you tried the suggested workaround. > > -- > -oj > > > "Lynn" <L***@discussions.microsoft.com> wrote in message > news:D51E3257-46BF-46B9-A038-1BD5F12C61E7@microsoft.com... > > well, oj, i appreciate it, but i'm not sure that it applies as the server > > is > > not 2003, it's windows 2000 advanced srv. > > -- Lynn > > > > > > "oj" wrote: > > > >> See if this helps: > >> http://support.microsoft.com/kb/827452 > >> > >> -- > >> -oj > >> > >> > >> > >> "Lynn" <L***@discussions.microsoft.com> wrote in message > >> news:A0141D9D-AB80-4E6D-BE62-4FAE7673BBCC@microsoft.com... > >> >I am trying to complete an end-to-end of a rather large database > >> >change(s). > >> > I am doing this on a dev box, preparing to do it in prod. The dev box > >> > isn't > >> > at all the capacity of the production resource. My end-to-end is > >> > below, > >> > but > >> > it keeps terminating on step 7 w/this error: > >> > > >> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead > >> > (WrapperRead()). > >> > Server: Msg 11, Level 16, State 1, Line 0 > >> > General network error. Check your network documentation. > >> > > >> > Connection Broken > >> > > >> > I haven't seen this before. I did all of the steps once before, just > >> > w/much > >> > smaller data volumes, so I know the tsql is functional. This is very > >> > urgent, > >> > does anybody know why this is happening and how I can get around it? > >> > > >> > 1) bcp out data > >> > 2) drop the indexes, pk's > >> > 3) truncate tables > >> > 4) alter columns/add 2 new columns > >> > 5) create pk > >> > 6) load data w/dts pkg > >> > 7) update msgID > >> > 8) make msgID NOT NULL > >> > 9) recreate indexes > >> > 10) unique constraint on msgID > >> > 11) update statistics > >> > > >> > -- Lynn > >> > >> > >> > > >  |
|||||||||||||||||||||||
Other interesting topics