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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Self-Healing Pipeline Is Now Generally Available: AI-Powered CIM Compliance

Maintaining data integrity across security and analytics pipelines is an ongoing challenge. Data ...

Meet Splunk Observability Studio: AI-Assisted OpenTelemetry Instrumentation Without ...

Instrumentation is usually the last step or even an afterthought when building out a project. The feature ...

Federated Search for Cisco Security and Analytics Logging (SAL) is now GA on Splunk ...

Federated Search for Cisco  Security Analytics and Logging (SAL) is now generally available as part of the ...