All Apps and Add-ons

Troubleshooting ODBC driver (Windows)

rvandolson
Loves-to-Learn

Have been using the Splunk ODBC driver v3.11 (64-bit) to pull time-series event data from a saved search (report) into Excel for manipulation.  Has been working perfectly for over a month but today Excel has suddenly began complaining about missing columns when executing a refresh:

"[Expression.Error] The column 'XXXX' of the table wasn't found."

Sure enough, the preview in Power Query shows those columns missing.  Sometimes I can refresh and they'll reappear, but mostly they don't.  The search on the Splunk side runs fine and includes all the columns Excel complains about.

I've been troubleshooting by time bounding the search to see if some bad data has crept it but am not finding any pattern yet.

Is there any way to enable debug logging for the ODBC driver?  Nothing obvious jumps out at me in the Windows ODBC configuration GUI.

Open to other ideas as well - may have to switch back to a two step CSV export and subsequent load into Excel - less than ideal.

Thanks in advance!

Labels (1)
Tags (2)
0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...