Free Trial

Alteryx Designer Desktop Discussions

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

End of Pipe error when skipping a field using Output Data node to Oracle OCI

PaulFields2
8 - Asteroid

I have two timestamp fields in my DB table. The first CREATE_DATE is set to default to SYSDATE if no value specified on record creation. The second UPDATE_DATE has no such default and is nullable. 

 

When I create a record via the Output Data node and leave both fields NULL there's no issue, but if I specify a value for the second Timestamp UPDATE_DATE while leaving CREATE_DATE NULL, I get an end of pipe error.

 

I am also experiencing this error when I specifiy a value for both fields.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Not-a-Valid-Month-error-with-lt-2020-1...

 

Any ideas?

1 REPLY 1
TrevorS
Alteryx Alumni (Retired)

Hello @PaulFields2 

Are you able to include a copy of your workflow and some sample data so that the Community can test this?

Thanks!

TrevorS

Community Moderator
Labels
Top Solution Authors