Running the SAS_SCORE_EP stored procedure might result in Teradata execute errors and cause SASĀ® Scoring Accelerator for Teradata to fail


Running the SAS_SCORE_EP stored procedure might result in an error. The problem occurs when the model used in the %INDTD_PUBLISH_MODEL macro contains a large number of input variables. An error similar to one of the following might occur:

ERROR: Teradata execute: in UDF/XSP/UDM SAS_SYSFNLIB.sas_score_ep: SQLSTATE U0028: Prepare INQUERY failed: Error Code 3822: Cannot resolve column 'id'. Specify table or view.

Or:

ERROR: Teradata execute: in UDF/XSP/UDM SAS_SYSFNLIB.sas_score_ep: SQLSTATE U0052: INQUERY must be a valid SELECT statement.

There is no workaround other than to reduce the number of input variables when publishing the model.