topic Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field? in All Apps and Add-ons

Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

chustar — Mon, 20 Apr 2015 22:17:46 GMT

I am configuring a new Splunk instance to reference data stored in our MSSQL database.
I've configured Splunk with DB Connect v2 and it seems to be able to connect to our DB successfully.
I then tried to access the DB using the web interface. After selecting my database in the Catalog field, it says "no schema found". What is this Schema field?

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

chustar — Mon, 20 Apr 2015 22:39:57 GMT

thanks @ppablo_splunk. the new title is so much better!

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

ppablo — Mon, 20 Apr 2015 23:09:31 GMT

No problem @chustar, I hope you find an answer soon!

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

harsmarvania57 — Tue, 21 Apr 2015 06:35:32 GMT

In DB, there are schemas available and each schema have different table. So in DB you need to provide schema access & table access to user from which splunk is trying to fetch data.

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

chustar — Tue, 21 Apr 2015 16:33:19 GMT

hi @harsmarvania57, your comment helped me find an answer! thanks

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

harsmarvania57 — Tue, 21 Apr 2015 16:39:46 GMT

@chusar: Thanks, can you please accept my comment as an answer.

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

chustar — Tue, 21 Apr 2015 17:42:17 GMT

I don't think i can accept comments. Can you make it an answer instead?

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

ppablo — Wed, 22 Apr 2015 06:45:17 GMT

taken care of 🙂 cheers!

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

harsmarvania57 — Wed, 22 Apr 2015 07:30:34 GMT

@ppablo_splunk Thanks

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

n00badmin — Wed, 20 May 2015 02:08:07 GMT

Hey @chustar, can you elaborate on what you did?

I am facing the same issue..im using a different db...but perhaps it can set me on the right track

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

chustar — Wed, 20 May 2015 17:20:51 GMT

I didn't know that SQLServer has a difference between Databases and Schemas. I had to go into the server, find the user that splunk is using to sign in and give them permission to read the schema.

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

jay1077 — Mon, 26 Feb 2018 17:43:40 GMT

Don't use mysql as default DB while configuring the connection instead make a new db and new user in DB.

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

chio37 — Mon, 19 Mar 2018 03:45:34 GMT

IMPORTANT
Can someone help me to solve the problem "Cannot get schemas"?. I thing that this problem is related to permissions, but i am not sure

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

chio37 — Mon, 19 Mar 2018 03:47:49 GMT

IMPORTANT
I am having the same problem "Cannot get schemas". I think this problem is related to permissions but i am not sure

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

Shyngys_Bolatbe — Fri, 26 Oct 2018 07:28:59 GMT

Do you solve this problem?

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

flakshack — Wed, 07 Nov 2018 22:51:16 GMT

I got this error message and thought I would post my solution here in case it helps someone else.

It turns out that I had this problem, even when using an account I had configured as sysadmin on the server. For example, I could connect to the SQL server with SQL Server Management Studio with this account and could see the database and all the tables. However, when I connected with the same account in DB Connect\SQL Explorer, it would show all of the databases in the Catalog combo box, but I would get an error message for the Schema combo box, "Cannot get schemas."

I turned on DB Connect logging and would see the following error in the log file:

ERROR c.s.d.s.a.s.d.impl.DatabaseMetadataServiceImpl - Unable to get schemas metadata
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name '[my_database].sys.schemas'.

I turned out that this problem was because I was using the MS SQL Server JDBC driver version 7. When setting it up, I figured I would ignore Splunk's guidance to use version 4.1 or 4.2 and use the latest available version. Turns out this was a bad idea.

In my testing if I copy the version 4.2 driver into the folder and restart, everything works great. Then if I copy the version 7 driver into the folder and restart, I get this error message (without any changes to permissions or anything).

Anyway, hope this helps someone.

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

mikebanks — Wed, 04 Dec 2019 20:58:31 GMT

I was having the same issue and your solution did the trick.

Thanks!

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

saichandjawari — Tue, 04 Feb 2020 07:45:47 GMT

Hi @harsmarvania57 .. May I know where exactly to edit permissions to get rid of the "schema error". Thanks!

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

harsmarvania57 — Tue, 04 Feb 2020 09:17:43 GMT

Permissions on the Database side, talk with your Database Administrator.

Re: Splunk DB Connect: Why am I getting error "no schema found" after selecting my database in the Catalog field?

ellanjie — Thu, 13 Feb 2020 19:30:42 GMT

Thank you for this trick it helps me to avoid having that error. I did not ignore Splunk guidance to use the version it proposed.

I appreciate!