Error in ODBC stage while accessing TD
Posted: Wed Dec 29, 2004 12:27 am
We are using server jobs to access TeraData, but some jobs abort frequently, but run later with no problem. PFA the error snapshot:
This happens on a regular basis.
What could be the reason for this. Is there some problem with the installation?
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
What could be the reason for this. Is there some problem with the installation?