When you try to load a Teradata table into CAS, an error might occur when the following is true:
- You use either the LOAD statement with the CASUTIL procedure or the LOADTABLE action with the CAS procedure.
- You use the DATATRANSFERMODE=PARALLEL option either in the CASLIB statement, in the PROC CASUTIL, or in CAS code.
- The Teradata table is larger than the memory that is available.
With PROC CASUTIL, the error might look similar to the following:
ERROR: General error in UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp: SQLSTATE U1030: DS2 program failed on execution. TKTSExecute returned
0x80fff802.
ERROR: General error in UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp: SQLSTATE U1030: DS2 program failed on execution. TKTSExecute returned
0x80fff802.
NOTE: The tcpSockWrite call failed. The system error is 'The connection was reset by a peer.'.
ERROR: Socket write failed with code 104.
ERROR: tscass3/transmit: Send Msg failed: stmt = 7fffb5e28fe0 conn = 7fff9e15bc40 port = 5571 rc = 8BFFD007.
ERROR: Grid BulkOperations error.
ERROR: Unable to add rows to table.
ERROR: The tcpSockWrite call failed. The system error is 'Broken pipe'.
ERROR: Socket write failed with code 32.
...more rows
ERROR: Function failed. No space left on device
ERROR: The action stopped due to errors.
With the CAS procedure, the error might look similar to the following:
ERROR: General error in UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp: SQLSTATE U1030: DS2 program failed on execution. TKTSExecute returned 0x80fff802.
ERROR: General error in UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp: SQLSTATE U1030: DS2 program failed on execution. TKTSExecute returned 0x80fff802.
NOTE: The tcpSockWrite call failed. The system error is 'The connection was reset by a peer.'.
ERROR: Socket write failed with code 104.
ERROR: tscass3/transmit: Send Msg failed: stmt = 7fff570c0a60 conn = 7fff4e30b340 port = 5571 rc = 8BFFD007.
ERROR: Grid BulkOperations error.
ERROR: Unable to add rows to table.
ERROR: The tcpSockWrite call failed. The system error is 'Broken pipe'.
NOTE: The tcpSockWrite call failed. The system error is 'The connection was reset by a peer.'.
ERROR: Socket write failed with code 104.
ERROR: tscass3/transmit: Send Msg failed: stmt = 7fff4cc438e0 conn = 7fff5dd98580 port = 5571 rc = 8BFFD007.
ERROR: Grid BulkOperations error.
ERROR: Unable to add rows to table.
... more rows
ERROR: Socket write failed with code 32.
NOTE: Action failed during Embedded Process processing. Not retrying action due to dataTransferMode setting of parallel.
ERROR: Function failed. No space left on device
ERROR: Table 'xxxx' could not be loaded.
ERROR: Failure opening table 'xxxx': A table could not be loaded.
ERROR: FedSQL internal error Code: 0x4821BE77EB144DEF. Refer to FedSQL documentation for resolving internal errors.
ERROR: Error occurred during Post Optimization.
ERROR: The action stopped due to errors.
ERROR: The FedSQL action was not successful.
CAS detects an out-of-space condition but does not notify the SAS® Embedded Process. When the SAS Embedded Process tries to write the contents of the Teradata table, the error occurs due to the closed socket.
The only workaround is to add enough memory to store the Teradata table in CAS.