Using A Custom Python Script In Oracle Analytics Server With Facebook Prophet Package Fails During Data Flow Execution (Doc ID 2756309.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

• You have installed the fbprophet package via PIP within the Python environment on Oracle Analytics Server for machine learning and your augmented analytics.
  
  
• Your Python package installer shows the package (and prerequisite packages are installed).
  
  
  $ pip list
  cmdstanpy (0.4.0)
  convertdate (2.3.0)
  cycler (0.10.0)
  Cython (0.29.21)
  ephem (3.7.7.1)
  fbprophet (0.6) <=== Facebppk prophet
  h5py (2.7.0)
  holidays (0.10.3)
  Keras (2.0.2)
  kiwisolver (1.1.0)
  korean-lunar-calendar (0.2.1)
  LunarCalendar (0.0.9)
  matplotlib (3.0.3)
  numpy (1.12.1)
  pandas (0.24.2)
  pip (8.1.1)
  plotly (4.13.0)
  PyMeeus (0.3.7)
  pyparsing (2.4.7)
  pystan (2.18.0.0)<== prerequisite
  python-dateutil (2.8.1)
  pytz (2020.4)
  PyYAML (3.12)
  retrying (1.3.3)
  scikit-learn (0.18.1)
  scipy (1.0.1)
  setuptools (20.10.1)
  setuptools-git (1.2)
  six (1.11.0)
  
  
  
  
• Testing the custom python script from the Linux operating system command-line works without issue.
  
  
• When executing a data flow in Oracle Analytic Server  and calling the custom python script it errors in the UI with:
  
  "Something Went Wrong"
  
  • [nQSError: 46240] Python process exited with non 0 exit Code
    [nQSError: 43224] The Dataflow "xxxxxx" failed during execution.
    [nQSError: 43204] Asynchronous Job Manager failed to execute the asynchronous job.

   

  
   

Changes

Deploy custom Python script to call fbprophet package for time-series forecasting

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.