This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I woudl love to however, the error message was not saved. My apologies. What I do is within the SQL query filter, I changed a dynamic date field that went off a system date and replaced with a hard date field. At that point, it worked fine.
I've got a similar Error Message when using Formula In-DB.
In my case I had a workflow built with non-In-DB tools and I'm trying to rebuild it with In-DB. On the Formula In-DB I'm just trying yo create some variables that are the result of subtracting 2 existing variables and the error I get is the following :
Error: Formula In-DB (314): DataWrapOCI: Unable to prepare the query: "WITH "Tool312_d163" AS (SELECT * FROM "AYX170209c38e62e18b504240c2cc5") SELECT "Name", "Year", "A", "B", ("A"-"B") AS "C" FROM "Tool312_d163"" Error: ORA-03001: unimplemented feature
I was getting the same error when trying to specify a date in a query to Oracle with the Input Data tool. Originally, I had this clause: when cm.MEMO_DATE>='20171001'. This worked in Oracle SQL Developer but not Alteryx. I found that changing the right hand side to To_Date('20171001', 'yyyymmdd') did the trick. It seems that may be a date formatting issue when sending hardcoded dates and using the Oracle To_Date function appears to ensure that it was cast as a date.