https://community.splunk.com/t5/Other-Usage/Is-error-in-TsidxStats-only-in-Pivot-for-several-data-models/m-p/640267#M164 <P>Hello, I've starting working with data models and Pivot. They've been working for the most part, but recently, Pivot has been throwing errors for a few of the data models like this when I click on Pivot from the Data Model editor:</P> <DIV class=""> <DIV class=""> <DIV class=""> <DIV class="">The search job has failed due to an error. You may be able view the job in the Job Inspector.</DIV> <DIV class=""> <DIV class="">&nbsp;</DIV> <DIV class="">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> <DIV class=""> <DIV class=""> <DIV class=""> <DIV class="">Error in 'TsidxStats': Could not find job directory for sid: 1681752470.124849_22F608DA-1DAB-4C64-BCA3-3D6EA29D58A4</DIV> <DIV class="">&nbsp;</DIV> <DIV class="">The sid changes each time I run Pivot. I've found the tstats command in search.log, and if I run that as its own search outside of Pivot, sometimes it runs fine, sometimes it doesn't.</DIV> <DIV class="">&nbsp;</DIV> <DIV class="">This seems to have corresponded with a recent change changing our events to JSON format. Could that be the issue? No reports, dashboards, or alerts seem to have been affected by that change.&nbsp;</DIV> <DIV class="">&nbsp;</DIV> <DIV class="">Thank you in advance!</DIV> </DIV> </DIV> </DIV> Mon, 17 Apr 2023 21:17:32 GMT jasmartin 2023-04-17T21:17:32Z https://community.splunk.com/t5/Other-Usage/Is-error-in-TsidxStats-only-in-Pivot-for-several-data-models/m-p/640267#M164 <P>Hello, I've starting working with data models and Pivot. They've been working for the most part, but recently, Pivot has been throwing errors for a few of the data models like this when I click on Pivot from the Data Model editor:</P> <DIV class=""> <DIV class=""> <DIV class=""> <DIV class="">The search job has failed due to an error. You may be able view the job in the Job Inspector.</DIV> <DIV class=""> <DIV class="">&nbsp;</DIV> <DIV class="">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> <DIV class=""> <DIV class=""> <DIV class=""> <DIV class="">Error in 'TsidxStats': Could not find job directory for sid: 1681752470.124849_22F608DA-1DAB-4C64-BCA3-3D6EA29D58A4</DIV> <DIV class="">&nbsp;</DIV> <DIV class="">The sid changes each time I run Pivot. I've found the tstats command in search.log, and if I run that as its own search outside of Pivot, sometimes it runs fine, sometimes it doesn't.</DIV> <DIV class="">&nbsp;</DIV> <DIV class="">This seems to have corresponded with a recent change changing our events to JSON format. Could that be the issue? No reports, dashboards, or alerts seem to have been affected by that change.&nbsp;</DIV> <DIV class="">&nbsp;</DIV> <DIV class="">Thank you in advance!</DIV> </DIV> </DIV> </DIV> Mon, 17 Apr 2023 21:17:32 GMT https://community.splunk.com/t5/Other-Usage/Is-error-in-TsidxStats-only-in-Pivot-for-several-data-models/m-p/640267#M164 jasmartin 2023-04-17T21:17:32Z