Hi Team,

We are getting below error in a replicate task.

Could you please help us with the same.

SYS-E-HTTPFAIL, Cannot connect to sql server.
SYS,General_Exception,Cannot connect to sql server , sqlstate:08001 NativeError:-2146893016 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The received certificate has expired.

Task_Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'SQLServer_Task.
Cannot coonect to SQL Serv
RetCode: SQL_ERRO SqlState:08001 NativeError:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider:The target principal name is incorrect.

Regards,

Megha

Hi Team,

We are using MSSQL as a target. But getting error regarding ODBC drive which is already installed on replicate machine

Error:

SYS-E-HTTPFAIL, Cannot connect to sql server.
SYS,General_Exception,Cannot connect to sql server , sqlstate:08001 NativeError:-2146893016 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The received certificate has expired.

Task Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'Task Name'.
Cannot connect to SQL Serv
RetCode: SQL_ERRO SqlState:08001 NativeError:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider:The target principal name is incorrect.

Regards,

Megha

Hello,

I am desperatly trying to get a hold of the recommended courses/ learning plans to correctly prepare for the talend data integration certified Developer exam but I am having no luck with it. 

The customer care is unable o help me and keep redirecting me to the "send a request" form through which I am not having any responses. 

Can someone help please. Thanks in advance.

Hi Team

We are getting below error in a task.

Could you please help us with the same.

Task Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'Task Name'.
Cannot connect to SQL Serv
Ret Code: SQL_ERRO SqlState:08001 Native Error:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The target principal name is incorrect.

Regards,

Megha

Hello Everyone,

I've encountered an issue in Talend where I'm receiving the error message: "code of method runJobInTOS(String[]) is exceeding 65535 bytes limit." Essentially, this means that the compiled code for the Talend job has surpassed the maximum size allowed for a single method in Java, which is 65535 bytes.

My job flow includes utilizing tDBInput for SQL queries, followed by tMap for transformations, and then connecting to tFileOutputDelimited.

Here's the flow: tDBInput (Snowflake) -> row (main) -> tMap -> out1 -> tFileOutputDelimited.

Despite trying to integrate other components such as tIterateToFlow, tBufferOutput, tBufferInput, and tParallelize, I'm still encountering this issue.

It's puzzling to me why this error is occurring. The SQL query involves around 120 columns with multiple transformations.

If anyone has insights or suggestions, I would greatly appreciate the assistance.