Execute SQL is not working, getting com.splunk.dbx.exception.ConfReadException : Error(s) occur when reading "MyConName" in the search window.
This was working earlier, in between we changed the login id to the instance and after that we see this error. But already saved query is working seamlessly, data is pulled to the Splunk index from DB.
I tried creating a new connection with the newly logged-in user. I gave read write permission to everyone for the config settings still getting same error.
I'm using DBConnect 3 in heavy forwarder setup of Splunk 7 in linux server.