Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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