We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

PostgreSQL to Oracle ORA-01891 OCIBulk

rhipp87
8 - Asteroid

I've had a flow running for several months and it suddenly stopped working. The Output is an Oracle Bulk connection and it now presents 

Error: Output Data (96): DataWrapOCIBulk: Unable to Initialize DirectPath: OCIDirPathPrepare Error: ORA-01891: Datetime/Interval internal error

 

rhipp87_0-1683852553272.png

There is not an issue when the output is an OCI connection.

rhipp87_1-1683852697397.png

 

Someone else mentioned this in another post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Errors-using-Output-Data-to-Or...

 

But it does not explain why it worked for 5 months without an issue. Does anyone else have experience with this?

 

0 REPLIES 0
Labels
Top Solution Authors