SQLBuilder Dialog doesn't start

[ettore1]

Hi all, I have designed a job including a tOracleInput component. When I click on the three-dots button right the Query panel in the Component view, a progress dialog appears for a while, then it vanish and the expected SQLBuilder Dialog doesn't appear.

I have the same issue in a fresh reinstallation.

No relevant messages in <workspace>/.metadata/.log file.

My version is:

Talend Open Studio for ESB

Version: 7.3.1.20200219_1233

JDK: java version "1.8.0_201"

Any idea for a solution?

Tks in advance!

[Anonymous]

Hi eapolloni

Which operating system? We need to test and check if it is a bug.

Regards
Shong

[ettore1]

Windows 10 - vers. 1909 (build SO 18363.720)

Tks

[UseThat]

Hi,

We have same problem with sqlBuilder. It doens't want to open from component.

Our version: TOS_ESB-20200219_1130-V7.3.1

Windows Server 2012 R2 Standard

java 1.8.0_161

Regards,

Mateusz

[ygao1]

i try this on windows 10 and windows 2012R2 use build TOS_ESB-20200219_1130-V7.3.1, and it works well on my side

[UseThat]

What version of java do you have? Is our version is correct? We have java 1.8.0_161

[Anonymous]

@UseThat, Talend studio requires Java version minimum 1.8.0_161, if you have multiple java version installations on your machine, open <workspace>/.metadata/.log and check if it uses the right java version to launch studio. If you can't still open the SQL Builder, have a try to upgrade java version and try it again.

Regards
Shong

[ettore1]

It seems that @UseThat has exactly the java mininum version, as far as I understand.
However, as stated at the begininning of this thread I have an upgraded version (JDK: java version "1.8.0_201"), but SQLBuilder doesn't start yet, and in <workspace>/.metadata/.log there is no error logged

[UseThat]

@shong @ygao 

I found the problem. To repet this you have to create tDBConnection set to Microsoft SQL Server:

Then I created tDBInput and try to run sql builder with component set like this:

And now after clicking to open sql builder it doesn't open.

Also I found solution to fix this problem by my site i have to uncheck Use an existing connection and get all data from Preprty Type like this:

And now i can open builder:

And now after back to use existing connection on compnent it start works.

Regards,

Mateusz

[ettore1]

Hi @UseThat , thanks a lot for your suggestion. I have an Oracle DB and unfortunately the SQL Builder windows still doesn't open. But now I have a clue to investigate in further detail ...! As soon as I have SQL Server Database I'll try your suggestion with it as well.