Execution is failing using Jupyter notebook but works if it's executed as Python recipe
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.
Answers
-
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.
