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.

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!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...