topic Re: Unable to retrieve schemas from DB connection in Talend Studio

Unable to retrieve schemas from DB connection

Anonymous — Sat, 16 Nov 2024 09:46:15 GMT

Hello,

I am trying to retrieve schemas from the DB that I connected to but when I selected all the schemas, the "Next"/"Finish" are both grayed out. Help please!

Re: Unable to retrieve schemas from DB connection

Anonymous — Tue, 16 May 2017 23:16:25 GMT

What happens when you select 1 table instead of all?

Re: Unable to retrieve schemas from DB connection

Anonymous — Wed, 17 May 2017 04:23:05 GMT

Hello,

If no schema is visible on the list, please click the "Check connection" button below the list to verify the database connection status.

Best regards

Sabrina

Re: Unable to retrieve schemas from DB connection

Anonymous — Wed, 17 May 2017 15:09:51 GMT

both are still grayed out.

Re: Unable to retrieve schemas from DB connection

Anonymous — Wed, 17 May 2017 15:17:50 GMT

What version are you using? An old "feature" of Talend would mean you had to resize the window a few times to get past this. Grab a corner of the box and resize it to a fraction of the current size. Then expand it again. Do this a few times and usually this will eventually get past it....if this is the same issue. I think it was caused by a GUI issue. I haven't seen it for a while though

Re: Unable to retrieve schemas from DB connection

Anonymous — Wed, 17 May 2017 15:55:18 GMT

It worked! I resized the window and expanded it then closed it out and re-opened the GUI.

Re: Unable to retrieve schemas from DB connection

Fish3 — Fri, 11 Oct 2019 15:30:48 GMT

Wasn't able to get this to work with 7.2.1 Open Studio. No luck at all.

Since this is the number one google for this question, I'll reference it in a new discussion.

Re: Unable to retrieve schemas from DB connection

Kostadin — Thu, 23 Jan 2020 11:50:46 GMT

I had the same problem. Resizing did not work for me. But I found a workaround that helped me.
Click "Retrieve Schema".
Click "Next" button.
Expand the database only clicking the ">" symbol(do not click on the square).
Click on one of the last elements of the schemas that can not be expanded any further.
In my case this enables the "Next" Button.
Then I clicked the "Select All" button.

Re: Unable to retrieve schemas from DB connection

Fish3 — Thu, 23 Jan 2020 14:12:42 GMT

Thanks for the reply! Yes, I found that this works, but only if the ">" symbol has some type of sub-elements under it. Without those, when I clicked on the ">" symbol, it disappears, but the next never showed.