Environment:
Windows Server 2008 R2 x64
MS SQL 2008 R2
Splunk 6.1.4 win x64
DBX 1.1.4
When trying to add a tail input from a database using a SQL Query statement I get an error...
Encountered the following error while trying to save: In handler 'dbx-monitors': Unable to xml-parse the following data: Failed to validate: com.splunk.config.SplunkConfigurationException: Error validating dbmonTail for monitor=dbmon-tail://SrvDb/... See splunkd.log for full data.
The SQL Query work like a charm when running it manually with the dbquery command.
SELECT RecordLog.RecordID , CallLog.StartTime, CallLog.StopTime, RecordLog.UserName AS Name, CallLog.UserID, CallLog.Team, RecordLog.FileName, CallLog.StopTime-CallLog.StartTime AS Duration FROM CallLog INNER JOIN RecordLog ON CallLog.ServerID = RecordLog.ServerID AND CallLog.GlobalID = RecordLog.GlobalID AND CallLog.UserID = RecordLog.UserID {{WHERE $rising_column$ > ?}}
The rising column is set to RecordLog.RecordID.
I am out of ideas and any help is welcome.
Kenan
... View more