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!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars in April. This post ...