Alteryx Designer Desktop Discussions

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

Input data tool error "Accessor is invalid"

MarWid
5 - Atom

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… 🙂

2 REPLIES 2
MarWid
5 - Atom

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.

simon
11 - Bolide

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!

Labels
Top Solution Authors