Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,088 members
  • 7,863 online
  • 1,994,648 posts
  • 149,469 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Enterprise Manager

    About TYPE output to Enterprise Manager's Message Center

    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 f... Show More

    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?

    Show Less
  • forum

    Alerting

    To schedule custom hours in Automation

    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 hin... Show More

    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

    Show Less
  • forum

    App Development

    Preventing an obsolete item from loading in QlikView script

    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 num... Show More

    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!

    Show Less
  • forum

    Qlik Replicate

    ODBC driver issue -SQL Server as Target

    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,Gene... Show More

    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

    Show Less
  • forum

    Qlik Replicate

    Getting error of ODBC drive-MSSQL as a target

    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,... Show More

    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

    Show Less
  • forum

    Design and Development

    Preparation for Talend Data Integration Certified Developer Exam

    Hello, I am desperatly trying to get a hold of the recommended courses/ learning plans to correctly prepare for the talend data integration certified ... Show More

    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.

    Show Less
  • forum

    Qlik Replicate

    SQL Server Target issue

    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:Creat... Show More

    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

    Show Less
  • forum

    Qlik Replicate

    SQL Server as target

    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_Excepti... Show More

    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

    Show Less
  • forum

    Integration, Extension & APIs

    Cross application communication (share bookmarks)

    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... Show More

    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

    Show Less
  • forum

    Qlik Replicate

    Check Qlik Replicate Version 7.0 compatibility with Kafka version 7.5.3 ?

    Hi, Need help with checking about if Qlik Replicate Version 7.0 is compatible with Kafka version 7.5.3 ?
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!