Execution is failing using Jupyter notebook but works if it's executed as Python recipe

Options
ifotopoulos
ifotopoulos Registered Posts: 9 ✭✭✭✭

I have the following pipeline:

If I execute the python code using a Jupyter notebook view, I'm getting the following error in the final step that I write the results back to the Oracle DB:


Exception: An error occurred during dataset write (vJtTAiJlje): SQLSyntaxErrorException: ORA-01031: insufficient privileges

On the other hand If I save it back to recipe and execute it as a Python Recipe, everything works as expected.

Tagged:

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer Posts: 753 Dataiker
    Options
    It's difficult to say much without any details, but this looks like a fully Oracle-related issue. The error message you get is a purely Oracle message.

    You can check into the "backend.log" file (Administration > Maintenance > Log files) which may contain additional information about what write exactly was attempted and why it failed.
Setup Info
    Tags
      Help me…