Hello Splunkers,
Today I have upgraded my Splunk environment from 6.0.1 to 6.6.1. Every dashboard and Splunk query is working fine except this.
Can someone please correct why i am suddenly seeing this error after upgrade.
index=ip_lux_metadata s_event="MSG_*"
| eval q_precedence=if(s_event=="MSG_RECEIVE" AND like(s_comp_id,replace("*","[*]","%")) AND e_to=="SMC", 0, 1)
| eval q_event=if(q_precedence==0, "MSG_SEND", s_event)
| eval s_comp_id=if(e_to=="SMC", "SMC", s_comp_id)
| search s_comp_id="*"
| fillnull value="" e_id, e_ppg_id, e_crl_id, e_action
| search e_id="*" e_ppg_id="*" e_crl_id="*" e_action="*"
| eval q_proc_id = mvindex(s_proc_id, -1)
| sort q_precedence
| dedup s_proc_id
| fillnull value="%DEFAULT_STATUS%" s_proc_outcome
| eval q_time=_time
| eval q_status_time=q_time
| eval q_agent=coalesce(a_agent, s_comp_id)
%START%
| join type=outer s_proc_id [search index=ip_lux_metadata s_comp_id="*" s_proc_outcome="*" | eval q_status_time=_time | fields s_proc_id, s_proc_outcome, q_status_time]
%END%
| search s_proc_outcome="*"
| eval q_time=_time
| sort -q_time, s_comp_id, e_path
| eval q_info=q_time + "," + q_status_time + "," + q_proc_id + "," + s_event + "," + s_proc_outcome
| eval q_proc=q_time + "," + q_status_time + "," + q_proc_id + "," + s_proc_outcome
| eval q_proc_outcome=q_proc_id + "," + s_proc_outcome
| table q_info, q_proc, q_time, s_comp_id, q_event, e_action, q_proc_outcome, e_path, q_agent, e_ppg_id, e_id, e_crl_id
| eval q_event=if(q_event == "MSG_RECEIVE", "Received", "Sent")
| convert timeformat="%d/%m/%y %H:%M:%S.%3N" ctime(q_time)
| rename q_time as Time, s_comp_id as Endpoint, q_event as "Received / sent", q_agent as Agent, e_action as Action, q_proc_outcome as Status, e_path as Path, e_ppg_id as "Propagation id", e_id as "Message id", e_crl_id as "Correlation id", q_info as " ", q_proc as " "
ERROR IS
Error in 'eval' command: The expression is malformed. The factor is missing.
The search job has failed due to an error. You may be able view the job in the Job Inspector.
... View more