Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts
Our customer has upgraded v2022.05 to v2023.11 and encountered the problem below:
In 2022.05, when the following warning occurred, CDC task continued without any errors.
[TARGET_LOAD ]I: Load finished for table 'ADM'.'XXXXX' (Id = 1). 85627944 rows received. 0 rows skipped. Volume transferred 98611582288. (streamcomponent.c:3976)
[TARGET_LOAD ]I: TPT statistics for table 'REP.YYYYY': Operator=LOAD, CPU time=1115.296875, Received Rows=85627944, Sent Rows=85627944, Applied Rows=85627917 (teradata_tpt_engine.cpp:778)
[TARGET_LOAD ]W: Not all rows have been loaded successfully for 'REP'.'YYYYY' due to possible 'TPT LOAD' errors. Consult Target 'xxxx_E?' / 'xxxx_L?' Error / Log tables contents. (teradata_tpt_engine.cpp:786)
[TARGET_LOAD ]I: teradata_terminate_tpt(...) successfully applied conn->Terminate() method for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_tpt_engine.cpp:839)
[TASK_MANAGER ]I: Loading finished for table 'ADM'.'XXXXX' (Id = 1) by subtask 1. 85627944 records transferred. (replicationtask.c:3012)
[TARGET_LOAD ]I: teradata_stop_imp(...) stopping task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:857)
[TARGET_LOAD ]I: teradata_free(...) freeing resources for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:878)
[TARGET_LOAD ]I: teradata_disconnect(...) disconnecting for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:92)
[TARGET_LOAD ]I: teradata_disconnect(...) disconnecting Data Connection succeeded for task identified by '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:104)
[TARGET_LOAD ]I: teradata_disconnect(...) No active Lookup Connection to disconnect from was detected for task identified by '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:122)
[TASK_MANAGER ]I: Subtask #1 ended (replicationtask_util.c:591)
However the behavior has changed after upgrading to v2023.11.
After the same warning occurred, it is detected as an error and the table is suspended.
[TARGET_LOAD ]I: Load finished for table 'ADM'.'XXXXX' (Id = 1). 85986652 rows received. 0 rows skipped. Volume transferred 99014228864. (streamcomponent.c:4076)
[TARGET_LOAD ]I: TPT statistics for table 'REP.YYYYY': Operator=LOAD, CPU time=1126.937500, Received Rows=85986652, Sent Rows=85986652, Applied Rows=85986625 (teradata_tpt_engine.cpp:781)
[TARGET_LOAD ]W: Not all rows have been loaded successfully for 'REP'.'YYYYY' due to possible 'TPT LOAD' errors. Consult Target 'xxxx_E?' / 'xxxx_L?' Error / Log tables contents. (teradata_tpt_engine.cpp:789)
[TARGET_LOAD ]I: teradata_terminate_tpt(...) successfully applied conn->Terminate() method for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_tpt_engine.cpp:846)
[TARGET_LOAD ]E: TPT data acquisition failed [1020403] (teradata_endpoint_imp.c:1480)
[TARGET_LOAD ]E: Handling End of table 'REP'.'YYYYY' loading failed by subtask 1 thread 1 [1025000] (endpointshell.c:3069)
[TASK_MANAGER ]W: Table 'ADM'.'XXXXX' (subtask 1 thread 1) is suspended. TPT data acquisition failed; Handling End of table 'REP'.'YYYYY' loading failed by subtask 1 thread 1 (replicationtask.c:3208)
Is there any options to ignore the warnings/errors and continue the task like v2022.05?
Any advice would be appreciated.
Regards,
Kyoko Tajima
Hi,
I am wondering when I have a source lookup on a column in a table, then I also have a filter on the table. What comes first? Are the records filtered then the source lookup occurs? or does the source lookup occur then the rows are filtered?
Regards,
Mo
Hello,
The Paris Olympics are in 426 days!
In the meantime, we have just developed a mashup made with #Qlik and #Talend to analyze data from all the Olympic Games since 1896️ : 51 editions, 223 countries, 729 events, +19k medals, + 140k athletes…
link : https://www.acssi.fr/jo2024/
In progress : English language, font optimization, new Data, optimizations, addition of Winter Olympics data for the last 2 editions, Paris Olympics calendar, live statistics of the Paris Olympics...
Do not hesitate to share your feedback and your ideas with us so that we can evolve the web site.
Many Thanks,
Olivier
Qlik Sense Enterprise on Windows #sport #talend
As we have many many apps, there is a server going to be decommissioned. I found the related data connection name.
How I can search across all apps if that Data Connection been used?
Thanks in advance.
I have Project and time slot in seperate tables.
I want to schedule time slot for group of projects based on certain condition.
If 1. Project review is 1st review schedule 45 mins
2. Project review is not 1st review schedule 15 mins
Schedule Time (9:00 am to 11:300 am) for every monday.
Project Data:
Project ID, Review, Date, Region, Time Slot, Status
A, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,
A, 2st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,
A, 3st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,
A, 4st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,
B, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,
B, 2st Review, 5/20/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,
C, 1st Review, 5/13/2024, AP,<Fill the Time slot> , <USED- if alloted, Otherwise BLANK>,
C, 2nd Review, 5/13/2024, AP, <Fill the Time slot> , <USED- if alloted, Otherwise BLANK>
Timeslot Table
5/13/2024 | 09:00 - 09:15 |
5/13/2024 | 09:15 - 09:30 |
5/13/2024 | 09:30 - 09:45 |
5/13/2024 | 09:45 - 10:00 |
5/13/2024 | 10:00 - 10:15 |
5/13/2024 | 10:15 - 10:30 |
5/13/2024 | 10:30 - 10:45 |
5/13/2024 | 10:45 - 11:00 |
5/13/2024 | 11:00 - 11:15 |
5/13/2024 | 11:15 - 11:30 |
5/20/2024 | 09:00 - 09:15 |
5/20/2024 | 09:15 - 09:30 |
5/20/2024 | 09:30 - 09:45 |
5/20/2024 | 09:45 - 10:00 |
5/20/2024 | 10:00 - 10:15 |
5/20/2024 | 10:15 - 10:30 |
5/20/2024 | 10:30 - 10:45 |
5/20/2024 | 10:45 - 11:00 |
5/20/2024 | 11:00 - 11:15 |
5/20/2024 | 11:15 - 11:30 |
Output:
Project ID, Review, Date, Region, Time Slot, Status
A, 1st Review, 5/13/2024, AP,9:00 - 9:45 , USED,
A, 2nd Review, 5/13/2024, AP,9:45 - 10:00 , USED,
B, 1st Review, 5/13/2024, AP,10:00 - 10:45, USED,
C, 1st Review, 5/13/2024, AP,10:45 - 11:30, USED,
C, 2nd Review, 5/13/2024, AP, No Slot available, Not Confirmed,
@Dataintellinalytics
I am trying to create a pivot table that shows "Current Sales" and "Previous Month Sales" for each "month year"
Data:
SalesDate | Product | Amount |
10/1/2023 | Chair | 50 |
15/1/2023 | Fan | 100 |
24/2/2023 | Chair | 82 |
23/2/2023 | Fan | 72 |
14/3/2023 | Chair | 132 |
13/3/2023 | Fan | 56 |
10/1/2024 | Chair | 50 |
15/1/2024 | Fan | 100 |
24/2/2024 | Chair | 82 |
23/2/2024 | Fan | 72 |
14/3/2024 | Chair | 132 |
13/3/2024 | Fan | 56 |
Expected outcome in Pivot Table
Product | Jan-23 | Feb-23 | Mar-23 | Jan-24 | Feb-24 | Mar-24 | ||||||
Current Month | Previous Month | Current Month | Previous Month | Current Month | Previous Month | Current Month | Previous Month | Current Month | Previous Month | Current Month | Previous Month | |
Chair | 50 | 0 | 82 | 50 | 132 | 82 | 50 | 0 | 82 | 50 | 132 | 82 |
Fan | 100 | 0 | 72 | 100 | 56 | 72 | 100 | 0 | 72 | 100 | 56 | 72 |
Hope you can help me to solve this requirement 🙂
Thank you very much for your assistance!
Hi guys,
I just wanted to know the extent of Machine Learning, predictive analytics, different data analysis algorithms we can run or integrate with Qlik tool for a proposal we received from client. If anyone can help, TIA
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.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
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!