Categories
- All Categories
- 162 Oracle Analytics News
- 29 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Errors with FORECAST and Outliers Functions in Oracle Analytics 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
-
@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
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.
1 -
@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
1
