topic Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection. in Security

com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

pradeep_securep — Tue, 29 Sep 2020 23:35:14 GMT

I am getting the error message "com.splunk.dbx.exception.NotFoundException: Can not find object Connection_Name of type connection." when query the database via db connect. The connection "Connection_Name" is a validated connection.

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

jherraghty — Fri, 05 Apr 2019 19:40:00 GMT

I have the exact same thing. My production box is fine. My dev/test box is not. I built a dev/test box, loaded splunk DB connect on it, same drivers, same JDK etc. The connector is good enough to log on to a MySQL DB, it can read schemas, it knows what tables are there, but it cannot select any records. On executing the run command from splunk -> splunk DB Connect -> Data Lab -> Sql Explorer etc. I get this error "com.splunk.dbx.exception.NotFoundException: Can not find object [MyConnection] of type connection."

I'm running splunk 6.6.3, dbConnect 3.1.1 in production, and Splunk 7.2.3, dbConnect 3.1.4 on my problem dev/test box. It's not perms on Mysql, they are both using the same mysql Driver and the same jre. A mystery so far.

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

zerocool443 — Mon, 08 Apr 2019 21:06:53 GMT

Same issue while running dbx queries. Connection object works fine. Can explore catalog but unable to retreive result.

Please share if some bug/solution found.

Thanks

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

sochsenbein — Thu, 13 Jun 2019 22:14:18 GMT

@zerocool443 I'm experiencing the same issue when hard coding the query into the source of the dashboard. My dashboard has two reports running the exact same query (minus some filtering on the first one). The first report has a reference from the dashboard while the second has the SPL hard coded since it uses tokens to pass into the stored procedure. The user sees the first report just fine, but gets this error on the second. Interestingly enough, another co-worker and I can see both reports just fine. Curious it might be a permissions issue (even though both reports use the same connection), so I set the connection to global and readable by everyone, to no avail. Any update on your issue?

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

jimbolya11 — Fri, 28 Jun 2019 12:38:13 GMT

i have same issue
com.splunk.dbx.exception.NotFoundException

can't seem to find an answer to this

splunk sees the tables but i can query them

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

sochsenbein — Wed, 30 Sep 2020 01:04:51 GMT

I had a handful of users having this issue on a dashboard where the dbxquery's stored procedure took a parameter. After checking their roles, I found they were just "user", they were not part of the "db_connect_user" role. After I added them, they could then see the report just fine.

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

jimbolya11 — Fri, 28 Jun 2019 18:18:32 GMT

where do you find the user roles?

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

jimbolya11 — Fri, 28 Jun 2019 18:18:48 GMT

where do you find those user roles?

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

sochsenbein — Fri, 28 Jun 2019 22:02:37 GMT

Settings >> Access Control, note that you probably need to be an Admin or at least a Power User to view it, docs should say.

Re: com.splunk.dbx.exception.NotFoundException: Can not find object Connection Name of type connection.

jimbolya11 — Wed, 30 Sep 2020 01:08:12 GMT

Nope - using dev license ...added admin to db_connect_user role...
Same results.