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 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 everyone,

I've tried searching for hours to answer a client's request

Is it possible to modify password policy in QlikSense Enterprise (on premise)?

Modifying minimum length, special character, number, expiration duration, etc

The client has it's own password policy, so that they need to make sure Qlik Sense Enterprise on Windows could comply with it

Please keep in mind that Qlik Sense cloud is not an option

Integration with user directory such as ActiveDirectory is not available. So it is only native Qlik user account

I'm not yet found a clear statement in the community regarding the possibility

Thank you in advance

Regards,

Ariza

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

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,

I want to download private files related to an opportunity in Salesforce. I've tried tfileFetch but it doesn't work.
I've tried using APIs but I can't make the link between the opportunity and the file to be uploaded to Salesforce.
Have you ever had this problem? Do you know how to retrieve these files? 

Thanks

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

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

Mrunal

I have a file that lands in AWS S3 several times a day. I am using Talend as my ETL tool to populate a warehouse in Snowflake and need it to watch for the file to trigger my job. I've tried tWaitForFile but can't seem to get it to connect to S3. Has anyone done this before?

I can't run the job the following error appearsI can't run the job the following error appears

Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.
Error occurred during initialization of VM
Unable to allocate tables for parallel garbage collection for the requested heap size.
Job EXPORT_TO_SKK_VIEW ended at 13:08 28/03/2024. [exit code=1]

Following are the memory settings for the VM

then suddenly a garbage collection appears as follows

So what is garbage collection?

What do I have to do?
I have added xms and xmx but the same error
How do I delete the trash that causes memory to become full like this?