Error in ODBC stage while accessing TD

[vinodlakshmanan]

We are using server jobs to access TeraData, but some jobs abort frequently, but run later with no problem. PFA the error snapshot:

Code: Select all

Event Id: 137558
Time    : Tue Dec 28 22:39:22 2004
Type    : WARNING
User    : dsadm
Message :
        GsirDmGeoCustomerLVinod..CREATE_ACCOUNT_CUSTOMER_HASH.IDENT1.STAGE_ACCOUNT_CUSTOMER_LINK: DSD.BCIGetNext call to SQLFetch failed.
        SQL statement:SELECT id
, parent_account_id
FROM gsir_s_p.accounts
WHERE parent_account_id IS NOT NULL
        SQLSTATE=08S01, DBMS.CODE=4
        [DataStage][SQL Client][ODBC][NCR][Unix system error]  4 Socket error - Interrupted system call

This happens on a regular basis.
What could be the reason for this. Is there some problem with the installation?

[ray.wurlod]

Is your network stable and reliable? The message suggests that there are interrupted calls to socket routines, or interrupted system calls while sockets are being used. This amounts to much the same thing. Get your network administrator to trace the source of the interrupts. For example you may have a faulty NIC in one of the machines, or the system may be generating unwanted signals (for example alerts following a powerfail condition).