Alteryx Designer Desktop Discussions

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

Input tool - You have found a bug.  Replicate, then let us know.  We shall fix it soon.

bjschwartz3
8 - Asteroid

I get the following error when trying to read in particular table from SQL.

 

Start: Designer x64: Started running at 06/08/2021 08:16:17

Error: Input Data (1): You have found a bug.  Replicate, then let us know.  We shall fix it soon.

End: Designer x64: Finished running in 1.8 seconds with 1 error

 

All I have is a single input tool trying to read in a SQL table. I can read the table in SQL server. I can read in other tables in the same DB in Alteryx but I can't read in this particular table. This table does have a different schema.

 

Any ideas on how to fix?

11 REPLIES 11
CatheyH
8 - Asteroid

Same issue here (but with Snowflake). I had simply forgotten to put in the schema: 

select *
from SchemaName.DatabaseName.TableName

 

It doesn't seem to be the same as yours, but put this here in case it helps anyone searching.

monicakim
5 - Atom

Getting this Win32 Exception with datetimeoffset data types with an OLE DB connection. If we switch to ODBC connection, no such error. 

Labels