Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I am currently encountering an issue when I run a Talend Job that read a query from Snowflake which is able to run in my local PC Talend but not in a Remote Engine that I have connected in Talend Portal. Here is the log:
tDBInput_1 Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
java.io.IOException: Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:138)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at fpi_dw.tcurr_0_1.TCURR.tDBInput_1Process(TCURR.java:3704)
at fpi_dw.tcurr_0_1.TCURR.tDBRow_1Process(TCURR.java:2622)
at fpi_dw.tcurr_0_1.TCURR.runJobInTOS(TCURR.java:7710)
at fpi_dw.tcurr_0_1.TCURR.main(TCURR.java:7142)
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager.<clinit>(UnsafeAllocationManager.java:27).
at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQueryInternal(SnowflakeStatementV1.java:243)
at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQuery(SnowflakeStatementV1.java:131)
at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:135)
... 5 more
From my PC, works perfectly:
Talend Portal:
Appreciate with any advice and feedback, thank you!
Hi, I'm trying to connect SharePoint via Qlik Sense. Below steps i followed,
1. Creating a new data connection.
2. Choosing the data source "Office 365 Sharepoint"
3. Then given the base URL of Office 365 Sharepoint in the baseURL.
4. Then choose the "None" from Prompt/Consent level.
5. Click on Authenticate button. Then it will take to next tab and code generated. Then copied code and paste in the respective tab. Then clicked on the Authenticate tab.
6. After that taking some time and faced the error. Below is the error message,
"error verifying: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond "Some IP (1.1.1.1:443)"
kindly suggest
Hi team
I am having confusion while switching between different branches in Talend Studio.
Could anyone please explain me the concept of "Check out as Local Branch" and switch between local branches. How this concept is working and what is happening in the background. I would also like to know what changes will be happening in the local workspace folder as well.
Thanks
Dhanoop B S
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
Hi Support Team,
I checked the status of the task in Enterprise Manager's Message Center.
When executing the 「FULL+CDC」 task, TYPE was output in the following order.
・TASK_START
・TASK_FULL_LOAD_STARTED
・TASK_FULL_LOAD_FINISHED
After stopping the task and restarting it with "Resume", the TYPE was output in the following order.
・TASK_STOP
・TASK_START
・TASK_FULL_LOAD_STARTED
Since it is 「Resume」, FULLLOAD will not be executed,
but 「TASK_FULL_LOAD_STARTED」 was displayed in the Message Center.
I have a question about the TYPE 「TASK_FULL_LOAD_STARTED」 at this time.
・Why is 「TASK_FULL_LOAD_STARTED"」 output even when I select 「Resume」?
・For what kind of operations will 「TASK_FULL_LOAD_STARTED」 be output?
Team,
I like to schedule the automation task for every 2 hours, but pre-defined list are 1 hr, 4hrs...
How to add the custom hours like 2hrs. Any hint/reference it will be helpful
Attached the screenshot for reference.
Thanks
Farsana
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
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
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!