Splunk Search

Why are the same queries getting different result?

indeed_2000
Motivator

Hi

I have exactly two SPL, same date range, one with "tracnsaction" command another wirhout it.

as you see in picture without transaction timechart show correctly but with transaction last part missed!

FYI: 1-I've check log file correctly indexed and available.

2-pair of eachtransaction availabe in log in  missing part.

what happen here? any idea?

indeed_2000_0-1653987120971.png

 

Thanks

 

Labels (4)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

transaction is limited to the number of open transactions it processes (see limits.conf) - you can override this with maxopentxns - this defaults to 5000 (hence only 4999 events). For example:

| transaction correlationfield maxopentxn=10000

 

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

transaction is limited to the number of open transactions it processes (see limits.conf) - you can override this with maxopentxns - this defaults to 5000 (hence only 4999 events). For example:

| transaction correlationfield maxopentxn=10000

 

gcusello
SplunkTrust
SplunkTrust

Hi @indeed_2000,

if you don't share your search and results I can only suppose something!

Anyway I think that the problem is that the transpose command uses as timestamp the first timestamp of the correlated events and probably all the events after 12.00 PM are in other grouped events.

But As I said it's difficoult withou  viewing your events.

To be sure, see if in the grouped events there are evevnts after 12.00 PM.

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...

IM Landing Page Filter - Now Available

We’ve added the capability for you to filter across the summary details on the main Infrastructure Monitoring ...

Dynamic Links from Alerts to IM Navigators - New in Observability Cloud

Splunk continues to improve the troubleshooting experience in Observability Cloud with this latest enhancement ...