Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Errors with FORECAST and Outliers Functions in Oracle Analytics Server

Accepted answer
72
Views
2
Comments
AbeerS
AbeerS Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

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

Best Answers

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead
    edited December 2024 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.

  • SteveF-Oracle
    SteveF-Oracle Mod
    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