Errors with FORECAST and Outliers Functions in Oracle Analytics Server

Question

I am encountering the following error:

"Error during query processing (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

(HY000)

State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid: ts:2024-12-30T12:26:51.565+03:00].

(HY000)

State: HY000. Code: 46240. [nQSError: 46240] Python Process exited with non 0 exit Code (HY000)

SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT

0 s_0,

CAST(NULL AS NUMERIC) s_1,

ExtractMonth(XSA('weblogic'.'appds')."Columns"."APPROVAL_DATE") s_2,

FORECAST((XSA('weblogic'.'appds')."Columns"."APPROVED_AMOUNT"),(ExtractMonth(XSA('weblogic'.'appds')."Columns"."APPROVAL_DATE")),'forecast','numPeriods=3;modelType=seasonalArima;') s_3,

FORECAST((XSA('weblogic'.'appds')."Columns"."APPROVED_AMOUNT"),(ExtractMonth(XSA('weblogic'.'appds')."Columns"."APPROVAL_DATE")),'high','numPeriods=3;modelType=seasonalArima;') s_4,

FORECAST((XSA('weblogic'.'appds')."Columns"."APPROVED_AMOUNT"),(ExtractMonth(XSA('weblogic'.'appds')."Columns"."APPROVAL_DATE")),'low','numPeriods=3;modelType=seasonalArima;') s_5,

XSA('weblogic'.'appds')."Columns"."APPROVED_AMOUNT" s_6

FROM XSA('weblogic'.'appds')

FETCH FIRST 65001 ROWS ONLY"

This error occurs when I use the Forecast and outlier functions. I am using Oracle Middleware Fusion Controls 12c, Oracle Analytics Server 7.0, and an Oracle 19c database on windows 10 64bit

Ram-Oracle · Accepted Answer

@AbeerSlamah please check the following documents and confirm if all required python libraries were installed.

Adding Forecast Statistics Errors With "NQSError: 46240 Python Process exited with non 0 exit Code" On Oracle Analytics Server (Doc ID 2890051.1)

"Python Process Exited With Non 0 Exit Code" Happens While Using Forecast (Doc ID 3024742.1)

please also check below documentation and check if we are using forecast with correct syntax

https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/enhance-visualizations-statistical-analytics.html#GUID-372B381C-A360-456B-AC05-E71F9D439812

From this document ,Using A Custom Python Script In Oracle Analytics Server With Facebook Prophet Package Fails During Data Flow Execution (Doc ID 2756309.1) ,It is pointing to check python version and environment variables.

Steve F-2 · Accepted Answer

@AbeerSlamah - If the documents posted above do not help, then please let us see the output of the following commands:

I am "assuming" you are using a Linux platform for OAS (I could not tell from the post if your OAS is windows or only your database). If not, please disregard the following.

opatch lspatches

Note: This commands assumes that 'opatch' is in your $PATH. If not provide the complete pathing to the command

cat  /etc/*release*

ls -ltr $ORACLE_HOME/bi/modules/oracle.bi.dvml/lib

(Linux 8)  dnf list installed | grep libgfortran

or

(Linux 7) yum list installed | grep libgfortran

ls -ltr /usr/lib64 | grep libgfortran