Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading sales figures from a data set that now includes obsolete items. How do I prevent the items from loading in the script where the item number is 'Obsolete'
Sales_Data:
LOAD
Store_Number,
Item_Number,
Item_Category,
Thanks!
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
Hi Team
We are getting below error in a 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 'Task Name'.
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
We have a large 120M row app that we need to break up into analytics and detail. We're loading the detail as usual and in the analytics we use binary load from the analytics qvf and drop the fields. Now we need to create a bookmark on the analytics side then have a way for the detail app to use the same bookmark or at least copy the bookmark. The analytic fields are a proper subset of the detail app.
We tried ODAG last year but its interface was very cumbersome and (sorry but) the scripting requirements were even worse. The idea we're using above is very fast and requires the least amount of scripting.
We also tried document chaining by passing current selections in the detail app url but that proved to be unreliable as it worked only sometimes.
We're investigating API but not having much luck. I thought there would be something like
detailapp = qlik.app(detail guid)
detailapp.bookmark.create(name,this.currentselections,ignorelayout)
These are client-managed apps. We are not looking for a cloud solution
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.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!