topic Re: "Guess schema" error connexion - empty widow in Talend Studio

"Guess schema" error connexion - empty widow

Anonymous — Wed, 23 May 2018 08:17:25 GMT

Hi,

i have a really problem with the button "Guess schema" of all database module.

When i click on the button, i have an empty widow "connection error" like this :

(is it in french because i'm french ^^)

I try with MySQL and AS/400 database in local server and of my company's server, doesn't work for both...

Can anyone know where it came from and how to fix it? especially since using a registered schema the query works, so it's not a user restriction...

Re: "Guess schema" error connexion - empty widow

TRF — Wed, 23 May 2018 11:14:51 GMT

How is the component configured, using context variable or not?

If so, remember that at design time, you cannot use context variables which are setted at runtime.

Replace variables by constant values and retry.

If not... share your component settings.

Re: "Guess schema" error connexion - empty widow

Anonymous — Wed, 23 May 2018 13:02:06 GMT

@TRF,

No, I don't use context variables, moreover I specify that yesterday everything worked correctly...
Here is a screenshot of my MySQL input component settings:

Re: "Guess schema" error connexion - empty widow

manodwhb — Wed, 23 May 2018 13:36:07 GMT

@Minos,can you cretate metadata for that table ,drag that table from metadata into job and change to Built in and keep the columns,which you want.

Can you try this?

Re: "Guess schema" error connexion - empty widow

Anonymous — Wed, 23 May 2018 14:00:49 GMT

@manodwhb,

Okey, i try in other computer of my company and it's work perfectly...

Finally I switched pc and it works... I don't know why \o/

Thanks, and if it starts again I'll try with the metadata