Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 211,605 members
  • 4,830 online
  • 1,985,349 posts
  • 148,608 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Replication Slot size increasing rapidly for postgresql

    Hi Team, So here is the scenario,    We have created Full Load and Apply Changes task for source POSTGRESQL and target SYNAPSE. Task was running smoot... Show More

    Hi Team,

    So here is the scenario, 

     

    We have created Full Load and Apply Changes task for source POSTGRESQL and target SYNAPSE.

    Task was running smoothly, but suddenly the replication slot started to grew in GBs/min.

     

    checked logs at verbose level,

    I saw this "wal_table_filter_reptask(...) Table tablename does not match task's capture pattern" .

    the tablename mentioned above is not there in the selected table for replication, why is this table present in the logs ?

    What is causing the latency or replication slot growth  ? 

    Any suggestions what parameter needs to be checked at source and target end  ?

     

    Thank you !!

     

    Show Less
  • forum

    Design and Development

    Crash when editing tFileOutputMSXML tree configuration

    Hello,When editing the XML Tree of the component tFileOutputMSXML, after adding a few sub element to the rootTag Talend crashTalend versions :Talend C... Show More

    Hello,

    When editing the XML Tree of the component tFileOutputMSXML, after adding a few sub element to the rootTag Talend crash

    Talend versions :
    Talend Cloud Data Management Platform R2024-01 
    TOS_DI-20211109_1610-V8.0.1

    System : Linux 6.7.4-arch1-1

    Crash log attached

    Has anyone else encountered this?

    Show Less
  • forum

    Installing and Upgrading

    tPop Authentication Mode Microsoft Exchange compile error

    Hello,​i tried to use TOS 8 with the tPop component from github to get Authentication Mode to Microsoft Exchange. I can choose it in the component and... Show More

    Hello,

    i tried to use TOS 8 with the tPop component from github to get Authentication Mode to Microsoft Exchange. I can choose it in the component and filled in my tenant id, application id and client secret value, but during compile i get this error below: What to do?

    Kind Regards

    Holger

    org.talend.designer.runprocess.ProcessorException: Job compile errors 

    At least job "Fetch_EMail" has a compile errors, please fix and export again.

    Error Line: 1419

    Detail Message: com.microsoft.aad.msal4j.ClientCredentialParameters cannot be resolved to a type

    There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

    at org.talend.designer.runprocess.JobErrorsChecker.checkLastGenerationHasCompilationError(JobErrorsChecker.java:359)

    at org.talend.designer.runprocess.DefaultRunProcessService.checkLastGenerationHasCompilationError(DefaultRunProcessService.java:534)

    at org.talend.designer.runprocess.RunProcessService.checkLastGenerationHasCompilationError(RunProcessService.java:318)

    at org.talend.designer.runprocess.ProcessorUtilities.generateBuildInfo(ProcessorUtilities.java:826)

    at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:706)

    at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:2029)

    at org.talend.designer.runprocess.RunProcessContext$2.run(RunProcessContext.java:663)

    at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:436)

    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:352)

    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:468)

    at org.eclipse.ui.internal.progress.ProgressMonitorJobsDialog.run(ProgressMonitorJobsDialog.java:228)

    at org.eclipse.ui.internal.progress.ProgressManager.run(ProgressManager.java:984)

    at org.talend.designer.runprocess.RunProcessContext.exec(RunProcessContext.java:610)

    at org.talend.designer.runprocess.ui.ProcessComposite.exec(ProcessComposite.java:1447)

    at org.talend.designer.runprocess.ui.views.ProcessView$RunAction.run(ProcessView.java:736)

    at org.talend.designer.runprocess.ui.actions.RunProcessAction.run(RunProcessAction.java:63)

    at org.talend.designer.core.debug.JobLaunchConfigurationDelegate$1$1.run(JobLaunchConfigurationDelegate.java:98)

    at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)

    at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:185)

    at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4179)

    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3839)

    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1157)

    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)

    at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)

    at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:644)

    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:551)

    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:156)

    at org.talend.rcp.intro.Application.start(Application.java:303)

    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)

    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)

    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)

    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)

    at java.base/java.lang.reflect.Method.invoke(Method.java:577)

    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:654)

    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)

    at org.eclipse.equinox.launcher.Main.run(Main.java:1462)

    Show Less
  • forum

    Qlik Replicate

    Manage Endpoint Connections are not reachable after upgrading Qlik

    As the subject stated, after upgrading Qlik Replicate from version 2022.11.0.394 to 2023.5.0.322, nobody on our team can reach endpoint connections an... Show More

    As the subject stated, after upgrading Qlik Replicate from version 2022.11.0.394 to 2023.5.0.322, nobody on our team can reach endpoint connections anymore. Does anyone have a clue what happened?

    Show Less
  • forum

    Qlik Cloud Data Integration

    Section access works from CSV but not QVD

    I have an app that generates a CSV for Section Access.  I load from that CSV into my Qlik apps and all works as expected. I am now attempting to autom... Show More

    I have an app that generates a CSV for Section Access.  I load from that CSV into my Qlik apps and all works as expected.

    I am now attempting to automate the SA file creation by reading and combining data form OKTA and our HR system and creating tables in BigQuery.  I have a second Qlik app that reads that data and creates a Section Access QVD.


    When I load the CSV and QVD side by side to compare the results, they are identical.

    However, when I load from CSV, it works.  When I load from QVD, it fails.

     

    Anyone else experience this? Data in both look the same.  Data types look the same.

     

    Show Less
  • forum

    Qlik Cloud Data Integration

    How can I build a job of the results I get in Talend Open Studio and get the sam...

    I created a job that calls SP in Talend Open Studio client, and the job was successfully loaded into the DATABASE. However, when I build this job and ... Show More

    I created a job that calls SP in Talend Open Studio client, and the job was successfully loaded into the DATABASE.

    However, when I build this job and run the .sh file on the linux server, there is no error, but it is not loaded into the DB.

     

    mkLEE_0-1708335223096.png

     

    mkLEE_1-1708335239499.png

     

    Show Less
  • forum

    Qlik Enterprise Manager

    Is it possible to connect Qlik Sense with Oracle Fusion Cloud?

    Hi We are currently reviewing our Oracle setup and using Qlik Sense as a reporting tool for it, has anyone got a Qlik Sense data connection to Oracle ... Show More

    Hi

    We are currently reviewing our Oracle setup and using Qlik Sense as a reporting tool for it, has anyone got a Qlik Sense data connection to Oracle Fusion in the cloud?

    Our present arrangement is that Qlik Sense connects to the Oracle database that we host on-site via Oracle Connector.

    Whether we go to a cloud-based Fusion service, data will be housed off-site, and I'm not sure if the host would enable the Oracle connection method, therefore getting the required extracts could be a major problem.

    Thanks

    Akhtar

    Show Less
  • forum

    Qlik Enterprise Manager

    QEM - LISTING THE DEFINED TASKS

    Hello Community, I have a question about customizing the task list in the QEM UI. We have a large number of tasks (around 500), but we only want to di... Show More

    Hello Community,

    I have a question about customizing the task list in the QEM UI. We have a large number of tasks (around 500),

    but we only want to display a select few (about 10-15) on the UI. Is there a feature in QEM that allows us to do this? Any guidance would be greatly appreciated.

     

    Thank you

    Show Less
  • forum

    New to Qlik Sense

    I NEED TO ADAPT THE DVD using the inline below

      Data:Load FirstSortedValue(Mesano, -Data) as Mesano, Codigocontabancaria, Date(Max(Data)) as Data, FirstSortedValue(Codigo, -Data) as Co... Show More

     

    Data:
    Load
    FirstSortedValue(Mesano, -Data) as Mesano,
    Codigocontabancaria,
    Date(Max(Data)) as Data,
    FirstSortedValue(Codigo, -Data) as Codigo,
    FirstSortedValue(Balance, -Data) as Balance
    Group By Codigocontabancaria;
    Load
    Mesano,
    Codigocontabancaria,
    Data,
    Max(Codigo) as Codigo,
    FirstSortedValue(Balance, -Codigo) as Balance
    Inline [
    Mesano, Codigocontabancaria, Data, Codigo, Balance
    "dez 2023", 107, "31/12/2023", 351289, 1638.05
    "dez 2023", 107, "31/12/2023", 351288, -8361.95
    "dez 2023", 108, "20/12/2023", 349958, 1638.05
    "dez 2023", 108, "20/12/2023", 349957, -3641.95
    "dez 2023", 108, "14/12/2023", 348936, 1638.05
    "dez 2023", 106, "14/12/2023", 348935, 601.86
    "dez 2023", 106, "13/12/2023", 348793, 1638.05
    ]
    Group By Mesano, Codigocontabancaria, Data;

    I NEED TO ADAPT THE DVD using the inline below ........................
    Dados:
    LOAD
    CODIGOCONTABANCARIA AS Codigocontabancaria,
    DATA AS Data,
    MonthName(DATA) as Mesano,
    CODIGO AS Codigo,

    Balance

    FROM
    [C:\Users\vasco\Desktop\ProcessedData.qvd]
    (qvd);

    Show Less
  • forum

    Design and Development

    Convert Epoch to UTC and then to SE or NZ timezone in tMap

    In an example I have an epoch of 1708444826969 that I need convert into a UTC date and then to NZ and SE formats.   And I have done this so far Conver... Show More

    In an example I have an epoch of 1708444826969 that I need convert into a UTC date and then to NZ and SE formats.

     

    And I have done this so far

    Convert epoch to long.

    Long.parseLong(row4.time) as Var.epoch  where row4.time is my epoch string

    Convert that to UTC.

    TalendDate.formatDateInUTC("yyyy-MM-dd HH:mm:ss",new java.util.Date(Var.epoch)) as Var.utc

    which returns 2024-02-20 16:00:26 which seems correct.

     

    Now I want to convert that UTC to NZ and SE date/times

     

    I've tried this and its not working?

    TalendDate.formatDateLocale("yyyy-MM-dd HH:mm:ss",TalendDate.parseDateInUTC("yyyy-MM-dd HH:mm:ss",Var.utc) ,"SE")

     

    Any help would be appricated.

     

    Bob 

     

     

     

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!