topic Re: tstats where error after upgrading to Splunk 9.0.4 in Splunk Search

How can I fix tstats error after upgrading to Splunk 9.0.4?

keishsplunk — Tue, 02 May 2023 13:27:04 GMT

Hi All,

we had successfully upgraded to Splunk 9.0.4. However, we observed that when using tstats command, we are getting the below message. normal searches are all giving results as expected.

[indexer1,indexer2,indexer3,indexer4.indexer5] When used for 'tstats' searches, the 'WHERE' clause can contain only indexed fields. Ensure all fields in the 'WHERE' clause are indexed. Properly indexed fields should appear in fields.conf.

Any idea why we are getting this and how to resolve it.

Re: tstats where error after upgrading to Splunk 9.0.4

gcusello — Tue, 02 May 2023 06:35:37 GMT

Hi @keishsplunk,

I don't know if something changed in the Splunk last version, but you should try to move the fields in the WHERE condition after the tstats command when they are also the BY fields, something like this:

| tstats count WHERE index=* BY sourcetype host | search host=your_host

| tstats count WHERE index=* host=your_host BY sourcetype

Ciao.

Giuseppe

Re: How can I fix tstats error after upgrading to Splunk 9.0.4?

mika703 — Mon, 17 Jul 2023 12:53:21 GMT

We are experiencing the same issue after Upgrading from 8.2.9 to 9.0.5. Any Updates / Infos available?

Re: How can I fix tstats error after upgrading to Splunk 9.0.4?

keishsplunk — Mon, 17 Jul 2023 13:30:19 GMT

Change the SPL syntax as such -

| tstats count where index=* by sourcetype,host | search sourcetype=* host=heavy-forwarder-1

Re: How can I fix tstats error after upgrading to Splunk 9.0.4?

gcusello — Tue, 18 Jul 2023 07:03:29 GMT

Hi @keishsplunk ,

good for you, see next time!

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated 😉