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?
Solved! Go to Solution.
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.
Getting this Win32 Exception with datetimeoffset data types with an OLE DB connection. If we switch to ODBC connection, no such error.
User | Count |
---|---|
19 | |
15 | |
15 | |
9 | |
8 |