Unable to retrieve schemas from DB connection

[Anonymous]

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!

[Anonymous]

What happens when you select 1 table instead of all?

[Anonymous]

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

[Anonymous]

both are still grayed out.

[Anonymous · Accepted solution]

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 

[Anonymous]

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

[Fish3]

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.

[Kostadin]

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.

[Fish3]

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.