The job started at 2:08:56 PM, ran till 4:39:20 PM and then aborted on the following errors:
Code: Select all
CUSTOMER_FACT_0000_HASH..TFM1: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
CUSTOMER_FACT_0000_HASH..TFM1: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
CUSTOMER_FACT_0000_HASH..TFM1: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
CUSTOMER_FACT_0000_HASH..TFM1: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
CUSTOMER_FACT_0000_HASH..TFM1: SQLFetch: Error retrieving results from server.
CUSTOMER_FACT_0000_HASH..TFM1: [Microsoft][ODBC SQL Server Driver]Communication link failure
SQLTransact: Error committing transaction.
OS Server - Windows Server 2003 DataCentre Edition
Database - MS SQL Server 2000
The job reads from a MSSQL Server database and writes to a hashfile.
A DRS Stage is being used to read from the database with the array size set at 1,000,000.
This job has run successfully once before, writing out +13,000,000 rows to the hashfile.
Is this a DataStage error, or is it a DataBase error? The DataStage engine and the DataBase server are sitting on the same box.
This was not the only job involved. The other jobs are setup on more or less the same principle. The all failed at different times, but with the same message.
Thanx,