Hi Support,

We're seeing an issue where shortly after a task starts, there's an error with the message: "The Statistics Log cannot open the file D:\Attunity\Replicate\data\logs\metrics\metricsLog.txt. Error: Access is denied.". Just after this error message appears, the task fails and the GUI console reports that the task has stopped abnormally.

I'd just like to understand if anyone else has seen this before? And if so, how they were able to resolve it. Any assistance/insight would be greatly appreciated

The Replicate version is v2023.5.0.413

Thanks,

Nak

Hello,

Similar to a post here: https://community.qlik.com/t5/New-to-Qlik-Sense/REST-connection-api-limit/m-p/2038360#M224175

We've added our REST to the shopify URL using the below method

https://xxx.myshopify.com/admin/api/2023-10/orders.json?status=any&fields=name,number,order_number,created_at,total_price,total_discounts,total_tax,cancelled_at,contact_email,currency,current_subtotal_price,current_total_discounts,current_total_price,current_total_tax,order_status_url,total_line_items_price,billing_address,customer,line_items

With a header of 'X-Shopify-Access-Token' being set and our token.

However, the API is limited by shopify and it only pulls back 250 records. If you have more than 250 orders, which we have, we need to paginate to pull all orders through.
---
Using Postman, we can achieve this as in the response headers we get;

Key = Link
Value =
"<https://xxxxxx.myshopify.com/admin/api/2023-10/orders.json?fields=name%2Cnumber%2Corder_number%2Ccreated_at%2Ctotal_price%2Ctotal_discounts%2Ctotal_tax%2Ccancelled_at%2Ccontact_email%2Ccurrency%2Ccurrent_subtotal_price%2Ccurrent_total_discounts%2Ccurrent_total_price%2Ccurrent_total_tax%2Corder_status_url%2Ctotal_line_items_price%2Cbilling_address%2Ccustomer%2Cline_items&page_info=eyJzdGF0dXMiOiJhbnkiLCJsYXN0X2lkIjo1NTMzMTIwNzU4MDY4LCJsYXN0X3ZhbHVlIjoiMjAyMy0xMC0xOSAxMToxMzowNy4xMTQyMjUiLCJkaXJlY3Rpb24iOiJuZXh0In0 >; rel="next""

So we would use that URL in the Link value and it would pull the remaining orders.

We are struggling on how we can acheive this through the Qlik Sense Data Connector?

We've tried setting up Pagination Type has 'Next URL' with 'Link' in the 'Next URL Path' and the other methods.

Are we missing something?

I am trying to create a field in a table where each row shows the total number of times a record appears in a table.

every count formula i can think of and try is giving me a value of 1 and not it's total. 

I can do this in EXCEL by saying countif(A:A, Criteria). How do i do that in QLIK?

I have configured a Qlik Cloud application to query a Databricks cloud database using "Direct Query" and a custom SQL statement.  I've simplified my application down to a single SQL statement and a single table. When the app loads, it uses my SQL statement to fetch the first batch of data, and it is successfully displayed in the table.  When I make a selection on the table, the application generates the SQL to filter the table using the selection.  Unfortunately, the SQL is not being generated properly and I get an error dialog.

Direct Query mode error: SQL Adaptor error: Connector error: ERROR [42703] [Qlik][Hardy] (80) 
Syntax or semantic analysis error thrown in server while executing query. 
Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query:
 [UNRESOLVED_COLUMN.WITH_SUGGESTION] org.apache.spark.sql.catalyst.ExtendedAnalysisException:
 [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name `DDG70`.

In Databricks, I can see the SQL that was generated and submitted.  The SQL includes a WHERE clause with "IN (DDG70)" that should be "IN ('DDG70')".

I've simplified the App to just the custom SQL and table to show the issue.

Is there a work around or fix for this?  For the complicated case, I need to use custom SQL. 

Hi Qlik Experts,

We are planning to update our existing Qlik Sense - Oracle AWS RDS connection by changing the port from 1521 to 2484 and implementing SSL.

Currently, our Qlik Sense - Oracle AWS RDS connection uses port 1521 without SSL.

Could you please provide documentation or steps for making these changes, including SSL implementation?

Thank you!

R

Hi,

How do I handle the qlik auto generated files countryAliases.qvd and countryGeo.qvd when I publish apps or copy apps to a new space? 

They seem to only(?) be generated when the data manager is executed/preparing the data and not on reload. Thus when the app is outside the shared development space it produces an error because it can't find the files or don't have access or similar.

Kind regards
Johan

Hi,

I've been a couple hours trying to fix this. This should be simple, not so **bleep** hidden or whatever...

First of all. Where is the QMC? Every topic about this subject has mentioned the QMC, but it seems to not exist in the currently SaaS version.

Basically, I have an app inside a >shared space<. I'm the tenant user, etc, so I do have available the option to publish bookmarks, but for some reason, analyzer users can only create bookmarks, not publish.

I went to to the "Administration" menu (supposely the new QMC) and tweaked the permissions in the "spaces" tab. Also went through the "users" tab, but I can't seem to find anything related to "can publish".

This guide says I need to set "can edit" under the app settings. I've set every "cans" and still no option to publish:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Share/make-public-or-private.htm

Users just want to be able to see each others bookmarks. Why is this so complicated? Moreover, if Qlik's gonna update their SaaS webpage design so frequently, at least update your documentations in time, so we don't feel stupid looking for something that is no longer available or has changed.

Does anyone know how to fix this?

I have Qlik Replicate version  May 2023 (2023.5.0.771). 

I see the early builds version 2023.11 and 2024. Which one should I apply? 

Please advise. 

I have an app with a pivot table that each row is basically it's own specific measure. Currently we set the background color for every other row which is tedious but works. But then if we want to use show if conditions for some rows that can break the manual every other row alternating color. Because each row is its own unique measure each row has a dimensionality of 0 and a RowNo of 1 so I don't think I can use either of those as a base. Are there any other options I am unaware of?