Splunk Search

Why is there Circular dependency Issue in Data Model?

kashz
Explorer

Error: Error in 'SearchProcessor': Found circular dependency when expanding from.Network_Traffic.All_Traffic

Background: core is an index containing {ipAddress, score}.

When creating a data model with the following query:
`| union
[| from datamodel:"Network_Traffic.All_Traffic" | join type=left src_ip [search source=core | rename ipAddress AS src_ip] | rename src_ip as ip | stats latest(score) by ip | where score!="" and score!="null"]

[| from datamodel:"Network_Traffic.All_Traffic" | join type=left dest_ip [search source=core | rename ipAddress AS dest_ip] | rename dest_ip as ip | stats latest(score) by ip | where score!="" and score!="null"]`

I'm trying to lookup all ipAddress from the NetworkTraffic datamodel and map it with score from the core index.

Labels (1)
0 Karma

jordan
Loves-to-Learn

Tyr to use tstats and not "from datamodel" , also the  "Circular dependency Issue" could happened if it encounters missing tsidx data.

try using tstats with summariesonly=false

 

0 Karma
Get Updates on the Splunk Community!

Introducing Splunk Enterprise Security 8.0!

Join us on Wednesday, November 20 to learn about Splunk Enterprise Security 8.0!To enhance SOC efficiency, ...

Mastering Threat Hunting

Register to watch Mastering Threat Hunting on Monday, November 18Join us for an insightful talk where we dive ...

Upcoming Community Maintenance: 10/28

Howdy folks, just popping in to let you know that the Splunk Community site will be in read-only mode ...