Running the SASEPFUNC table function results in errors and causes SASĀ® Scoring Accelerator for Oracle to fail


Running the SASEPFUNC table function might result in an error. The problem occurs when the model used in the %INDOR_PUBLISH_MODEL macro contains a large number of input variables. An error similar to the following might occur:

ERROR: ORACLE execute error: ORA-00600: internal error code, arguments: [kocgpn129], [2], [], [], [], [], [], [], [], [], [], [].

or

ERROR: ORACLE prepare error: ORA-00902: invalid datatype. SQL statement: select id, EM_CLASSIFICATION , EM_EVENTPROBABILITY , EM_PROBABILITY , EM_SEGMENT from table( SASEPFUNC ( cursor(select /*+parallel(t, 1) */ * from test t), 'indb.sas_model_table', 'test', 'Future use', 'select * from test t' ) ).

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