July 15, 2002 at 4:20 pm
We are running a DTS package which takes files from an AS400 box and loads them into a SQL 2000 database every day. Data is refreshed every day. This job runs fine only 70% of the time. recently they have been failing every day with the following error.
Is this really a network problem?
DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x3 Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 3 (3) Error string: [IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x3 Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnStart: DTSStep_DTSDataPumpTask_6 DTSRun OnError: DTSSt... Process Exit Code 10. The step failed.
Regards,
Naushi Hussain
Regards,
Naushi Hussain
July 15, 2002 at 6:45 pm
Certainly could be, or something trashing the process on one side or the other. Have your admin check routers/switches involved to see if a high number of errors, collisions, etc, reported. Ideally they should monitor while it works to see if they can see anything.
Andy
July 15, 2002 at 9:02 pm
Also consider anything that may have changed in the setup. I have not heard of bogus errors from AS400 but the latest Oracle drivers are a pain to get a good message off of. Could be network or login, or something about the data on the other side is dumping the connection like a timeout.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply