Input data tool error "Accessor is invalid"
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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… 🙂
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
