Very Very Urgent, Please Help
- From: "DKRReddy" <dkrreddy@xxxxxxxxxxx>
- Date: Mon, 5 Sep 2005 12:26:36 -0700
Recently we have migrated the datawarehouse server to windows 2003 server
from windows 2000 server.
Since then all dts packages are getting timedout with the following error.
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Timeout expired
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
The new server is very high end server which has 8 processors and 12GB RAM,
and All dts packages are having simple deletes and data transfer tasks.
Daily updatestats was running during off hours and proper indices are
there.
Ran the checkdb on all dbs, found no errors.
I never seen these kind of erros on windows2000 and sql 2000 ee sp3.
Is there any reason that sql2000 EE SP3 is not fully supported by Windows
2003 server.
I have verified the query timeout settings on source and destination server
which is 0 (unlimited)
Please let me know if settings need to be checked.
(Migration : dettahed the databases from windows 2000 server and sql200 EE
sp3 and attached to the windows2003 server and Sql 200 EE sp3)
If any queries that were run from query analyzer are failing with the
following error afetr few minutes :
[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
.
- Follow-Ups:
- Re: Very Very Urgent, Please Help
- From: Jéjé
- Re: Very Very Urgent, Please Help
- From: DKRReddy
- Re: Very Very Urgent, Please Help
- Prev by Date: Re: Select And Insert
- Next by Date: Re: Very Very Urgent, Please Help
- Previous by thread: Re: i'm new to dw been to oltp for some time
- Next by thread: Re: Very Very Urgent, Please Help
- Index(es):
Relevant Pages
|
