Teradata might be intermittently suspended and result in 7504 errors when you score a model


Trying to score a model in Teradata might intermittently result in an error similar the following in the SAS log:

Failure 7504 in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0058: Insert into OUTTABLE failed: CLI Error Code 7504: in UDF/XSP/UDM SAS_SYSFNLIB .SASTblOp: SQLSTATE U1010: DS2 program failed to be prepared. TKTSPrepare returned 0x80fff802.
--------------------------------------------------------------------------
Failure 7504 in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0027: LOAD/UNLOAD shared data failed: CLI Error Code 7504: in UDF/XSP/UDM SAS_SYSFN LIB.SAS_LOAD_MODEL_FILE_A: SQLSTATE U0004: NodeId=10009 Cannot open ModelDS2 data file /opt/SAS/glopdat
--------------------------------------------------------------------------

Failure 7504 in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0030: Get Contract failed: CLI Error Code 7867: Hybrid Server is not enabled.
--------------------------------------------------------------------------
Failure 7504 in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0058: Insert into OUTTABLE failed: CLI Error Code 7503: The UDF server failed to execute UDF/XSP/UDM All.
--------------------------------------------------------------------------
Failure 7504 in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0030: Get Contract failed: CLI Error Code 7503: The UDF server failed to execute UD F/XSP/UDM SAS_SYSFNLIB.SASTBLOP_CONTRACT
Failure 7504 in UDF/XSP/UDM SAS_SYSFNLIB.SAS_SCORE_EP: SQLSTATE U0058: Insert into OUTTABLE failed, check output column names and data types: CLI Error Code 7504: in UDF/XSP/UDM SAS_SYSFNLIB.SASTblOp: SQLSTATE U1003:

This issue is addressed in the SAS® Embedded Process version sas-sepcoretera-40.130.0-date.timestamp.suse.x86_64.rpm or later. As of 2023.05, SAS Embedded Process for Teradata is delivered from a SAS® Viya® platform repository. For more information about deploying SAS Embedded Process for Teradata, including how to upgrade from a previous Teradata version, see the SAS Embedded Process Deployment Guide.

Workaround

To work around this issue, restart SAS Embedded Process.