Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

0683p000009Lx5L.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...

Labels (1)
4 Replies
TRF
Champion II
Champion II

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.

Anonymous
Not applicable
Author

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

0683p000009LwsN.png

manodwhb
Champion II
Champion II

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

Anonymous
Not applicable
Author

@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