topic Re: Talend Data Integration 6. 0 missing DBType after clicking Guess Schema in Installing and Upgrading

Talend Data Integration 6. 0 missing DBType after clicking Guess Schema

MaxIT — Fri, 15 Nov 2024 22:42:54 GMT

Hi, I'm compelled to used TOS 6.0 installed by another company.

I've created a new project and a job loading data from MSSQL.

Using the TMSSQLInput component I've select a query from the Metadata connection and I've clicked "Guess schema".

The resulting schema is incomplete, in fact the DBType is missing for all the columns (see attached screenshot)

Any clue?

Thanks,

Max

Re: Talend Data Integration 6. 0 missing DBType after clicking Guess Schema

Anonymous — Mon, 25 Jul 2022 02:46:32 GMT

Hello,

Are you able to connect to MSSQL successfully and retrieve table schemas?

What's MSSQL DB version are you trying to connect? Does this issue repro on other build version? The latest talend open studio build version is 8.0.

Best regards

Sabrina

Re: Talend Data Integration 6. 0 missing DBType after clicking Guess Schema

Anonymous — Mon, 25 Jul 2022 05:49:20 GMT

I have exactly the same problem. Anyone got a suggestion?

Re: Talend Data Integration 6. 0 missing DBType after clicking Guess Schema

MaxIT — Mon, 25 Jul 2022 09:07:22 GMT

Hi Sabrina, I was able to connect to MSSQL and create queries in the Metadata connection. When I've tried to retrieve the table schema it run out of memory.

I'm aware of the latest available version. Unfortunately version 6.0 had been installed with the ERP and I'm not in a position to change it. I just created a new project along the existing ones.

I just wonder if it depended on the missing Talend features.

In fact I'm not able to install them due to the attached error.

Thanks,

Max

Re: Talend Data Integration 6. 0 missing DBType after clicking Guess Schema

Anonymous — Tue, 26 Jul 2022 04:27:50 GMT

Hello,

There is not caused by missing Talend feature. We assume that there might be something wrong with compatibility. What's MSSql DB are you using and what's JDK version?

Best regards

Sabrina

Re: Talend Data Integration 6. 0 missing DBType after clicking Guess Schema

Anonymous — Tue, 26 Jul 2022 04:29:23 GMT

Hello,

Please give us a little bit more information to address your issue.

On which talend build version you got this issue and what's MSSQL DB server version are you trying to connect?

Best regards

Sabrina

Re: Talend Data Integration 6. 0 missing DBType after clicking Guess Schema

MaxIT — Wed, 27 Jul 2022 12:17:22 GMT

Hi Sabrina, I'm able to connect to MSSQL version 2019.

As far as the JDK version is concerned the one on the server is jdk1.8.0_171.

I've just noticed there's no class_path in the environmental variables.

Should I add it?

Thanks, Max

Re: Talend Data Integration 6. 0 missing DBType after clicking Guess Schema

Anonymous — Thu, 28 Jul 2022 04:09:44 GMT

Hello,

As far as I known, we upgrades Libraries for Ms-SQL Server - Support for MSSQL Database 2019 starting from V 8.0.1-R2022-04. That might be the reason you are not able to retrieve the table schema of MSSQL Database 2019.

Best regards

Sabrina