"Guess schema" error connexion - empty widow

Four Stars

"Guess schema" error connexion - empty widow

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 :

talendError.png

(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...

Forteen Stars TRF
Forteen Stars

Re: "Guess schema" error connexion - empty widow

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.


TRF
Four Stars

Re: "Guess schema" error connexion - empty widow

@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:

Sans titre.png

Thirteen Stars

Re: "Guess schema" error connexion - empty widow

@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?

Manohar B
Four Stars

Re: "Guess schema" error connexion - empty widow

@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