nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error Opening SELECT in Data Stream Out Tool

unknown

Hello Everyone,

I have an error with the Data Stream Out Tool when trying to bring the In-Database workflow out to Alteryx Designer. Can someone help me please to understand the Error and how to fix it ? I attached here the screenshot of the error from my computer.

Thank you in advance

Armand

DataStreamOutError.PNG

In Database

In-Database

Accepted answers

OllieClarke

Hey @Inactive User

Your error is in the in-db filter tool. The In-DB tools require you to write formulae in the syntax/language of the database to which you're connecting

DATETIMEDIFF(DateTimeNow(),[TSMAJ],'days') > 90

This is how you would do the filter in Alteryx.

If you're connecting to a Microsoft SQL Server, this would have to be:

DATEDIFF(day,"TSMAJ",GETDATE()) > 90

This is why your workflow was erroring.

The syntax/functions will change depending on your database and the language it uses.

Hope that helps,

Ollie

apathetichell

DATEDIFF(current_date(),"TSMAJ")>90

(use '90' if 90 isn't a number.

But I believe HIVE uses CURRENT_DATE - not current_date() for the current date. These are not Alteryx issues - basically however you'd construct this Query in your usual SQL you should do that in the Alteryx In-DB tools. You can parameterize using "FIELDNAME" - not [FIELDNAME] like you would on canvas.

All comments

OllieClarke

Hi @Inactive User

The In-DB tool errors are a little different to normal tools. They only arise at a point where the query is sent - this could be an output/stream out or a browse.
In your case something has gone wrong before the stream out, but the error is showing at the point that alteryx realises. If I were you, I'd select all the in-db tools, and press ctrl+shift+b to add a browse tool to all of them. Then run your workflow and see which browse tools error - that should help identify where the cause of the error is.

Hope that helps,

Ollie

apathetichell

you should post the full error message too - cut and paste the exact error message into word or notepad - not much any one can tell from that snippet.

unknown

Hi @OllieClarke

Thanks so much for your reply and your trick. I am trying to find out where the cause of the error is. I identify that the errors are located in some browse tools which I put in the attached .txt file here and the screenshot of the workflow. I will appreciate any suggestion to fix the errors. Thanks

Best regards

Armand

BrowseToolsErrorsReports.txt

BrowseToolsErrorsReports2.PNG

BrowseToolsErrorsReports3.PNG

BrowseToolsErrorsReports4.PNG

BrowseToolsErrorsReports1.PNG

unknown

Hello @apathetichell

Yes, you are right. I put the queries from the browse tools where the errors are located into a .txt file and the screenshot of the workflow for each of the identified browse tool that I attached into my reply to @OllieClarke . I will appreciate any suggestion to fix the problem. Thanks in advance.

Best regards
Armand

apathetichell

DATEDIFF(current_date(),"TSMAJ")>90

(use '90' if 90 isn't a number.

unknown

Hello @apathetichell,

Thanks for your help. Finally, after following your tips, the formula works. The issue is now fixed.

Best regards

Armand

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703