Troubleshooting machine learning stored procedures

This information helps you diagnose, recover from, and resolve problems that you encounter when you are using the analytic stored procedures.

If an analytic stored procedure encounters an error, an SQL error message is shown.

Some error messages contain an analytics message identifier CDFAAxxxx, where xxxx is a number in the range of 0000 - 9999 together with a specific description. Often, however, the message text of this description is truncated

For retrieving the complete message text, the latest analytic error message is stored in an SQL variable.

The following list shows the variables.

IDAX.LAST_MESSAGE: Contains the message for the CDFAAxxxx identifier that is in the SQL error message of the stored procedure.; If no SQL error occurred, or if the SQL error message does not have a CDFAAxxxx identifier, the value is NULL.; Data type: VARCHAR(32672)

IDAX.LAST_MESSAGE_CODE: Contains the number of the CDFAAxxxx message identifier, that is, the value of xxxx.; Data type: INTEGER

Example

SQL> CALL IDAX.LIST_MODELS('schem');

SQL20562N  The analytics operation could not be performed because the specified
options are not valid.  Routine name: "LIST_MODELS". Analytics message
 identifier: "CDFAA0052N".  Diagnostic details: "schem".

SQL> VALUES IDAX.LAST_MESSAGE;

1
--------------------------------------------------
CDFAA0052N  The analytics routine was not run beca
use an unsupported parameter name was specified. U
nsupported parameter name specified: "schem".

DB250000I: The command completed successfully.

SQL> VALUES IDAX.LAST_MESSAGE_CODE;

          1
-----------
         52

DB250000I: The command completed successfully.