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!

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...

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 ...