Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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
Top Solution Authors