Troubleshooting analytic 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.
- IDAX.LAST_MESSAGE_CODE
- Contains the number of the CDFAAxxxx message identifier, that is, the value of xxxx.
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.