Upon further review, here is a more complete picture of what is going on:
Node 0 has a rejected buffer write warning, followed by a Error Code = 350. Nodes 0-7 each process 100,000 records and then fail. The Error Code 350 is repeated, then a return code of 311. The final error message is an error code 305.
The following are the Messages from the TD docs (Messages / Chap 19 Network-Attached CLIv2 Messages):
350 Request size exceeds maximum.
Explanation: The length of the request exceeds the
maximum supported length.
Notes: None
Remedy: Reduce the length of the request.
311 NOACTIVE No active sessions.
Explanation: DBCHWAT could not find any active
sessions.
Remedy: No action required.
305 NOREQUEST Specified request does not
exist.
Explanation: The request could not be found.
Remedy: Check the request id.
The data going into the target table has the following schema:
Code: Select all
record
( SERVICINGUID: int32;
UNIQUEADDRESSID_ORIG: nullable int32;
UNIQUEADDRESSID_SERVICING: nullable int32;
LOAN_NUM_EXPANDED: nullable string[max=10];
ALLTEL_CLIENT: nullable string[max=3];
LOAN_ID: nullable string[max=12];
ORIGADDRESSVALIDATEDFLAG: nullable string[max=1];
SERVICINGADDRESSVALIDATEDFLAG: nullable string[max=1];
UNIQUEADDRESSID: nullable int32;
LOANNUM: nullable string[max=10];
)
The table definition is the following:
Code: Select all
CREATE SET TABLE adwdm_place.homemortgagecrossreference ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
SERVICINGUID INTEGER NOT NULL,
UNIQUEADDRESSID_ORIG INTEGER,
UNIQUEADDRESSID_SERVICING INTEGER,
LOAN_NUM_EXPANDED VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
ALLTEL_CLIENT VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,
LOAN_ID VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
ORIGADDRESSVALIDATEDFLAG VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
SERVICINGADDRESSVALIDATEDFLAG VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
UNIQUEADDRESSID INTEGER,
LOANNUM VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
LOAD_TS TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6))
UNIQUE PRIMARY INDEX UPI_HOMEMORTGAGECROSSREFERENCE ( SERVICINGUID );
The logs for the job show a successful run with a volume under 50K. It also shows the failed execution with a high volume around 8.5M.
Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.