Alteryx Designer Desktop Discussions

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

SQL editor error

Mgstoly
7 - Meteor

I am trying to run this script but I get this error,  just not sure how to fix it.

5 REPLIES 5
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Mgstoly ,

 

you could try to remove the commented line. If this doesn't fix the problem: it seems to be an Oracle database. How do you connect (ODBC, OCI, ...)?

 

Best,

 

Roland

Greg_Murray
12 - Quasar

Try running the workflow. You can usually get a little more information about the error from the results window. Copy the red error message and drop it into notepad then scroll to the end. 

 

Also take a look at this post:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SQL-error-that-I-only-get-in-Alteryx/t...

Mgstoly
7 - Meteor

I connect via OCI,  I have other scripts that run just fine.  what do you mean by the commented line?

Mgstoly
7 - Meteor

so I added a space after select and From and it worked.  thanks!

Mgstoly
7 - Meteor

I added a space after select and from and it ran.

Labels