Input data tool error "Accessor is invalid"

Question

We get an error saying

“Error: Input Data (19): Error opening table "SELECT * FROM dbo.vIWWKPDim": Microsoft SQL Server Native Client 11.0: Accessor is invalid.”

when trying to read from a particular MSSQL table. Other tables and views works fine for the exact same connection, server and database. It’s just this particular table and its view.

We can’t seem to find any resources on alteryx.com on the “Accessor is invalid” kind of error, so you are our last hope… 🙂

MarWid · Accepted Answer

After trying out a couple of more things, we found the solution ourselves.

It seems our version of alteryx (2019.4.8) can’t handle the data type VARBINARY(8000). Excluding this field from the view allows us to read from the view without an error.

ivy29gm · Accepted Answer

for everyone: We received the same error in 2022.1 and after we excluded the field with VARBINARY(8000) data type, the query ran fine. Please fix in future versions!