Recent Discussions
-
How to add Groups/Users to admin capabilties during automated installation
The Qlik Enterprise manual states "By default, the user under whose account youinstall Enterprise Manager is associated with the Admin role". But in ... Show MoreThe Qlik Enterprise manual states "By default, the user under whose account you
install Enterprise Manager is associated with the Admin role". But in our scenario we are provisioning a server via the cloud and installing the product as part of the bootstrap process under the local Administrator account.How can we specify initial groups with access as part of the bootstrap process? Are there command line calls we can call that will add AD groups to the different Qlik roles, especially the Admin role?
-
Connecting to a PostgreSQL data base
I'm in trouble when attempting to extract data from a PostgreSQL data base. I've received the following message: "SQL##f - SqlState: S1001, ErrorCode:... Show MoreI'm in trouble when attempting to extract data from a PostgreSQL data base. I've received the following message: "SQL##f - SqlState: S1001, ErrorCode: 4, ErrorMsg: Out of memory while reading tuples." I'm using PostgreSQL30 odbc driver. But, even when using PostgreSQL35 odbc driver the same issue accurs. Anyone knows how to fix this issue?
-
Assistance with Qlik Sense
I am a student trying to access Qlik Sense, but I am encountering an issue. After logging in, I receive the message "No Tenants to manage", and I am... Show MoreI am a student trying to access Qlik Sense, but I am encountering an issue. After logging in, I receive the message "No Tenants to manage", and I am unable to proceed. I have attached a screenshot of the error for reference.
Could you please help me understand why I do not have access and how I can resolve this issue?
Thank you in advance for your support!
-
Change in column Title visualization.
How can i change a title in a visualization Dinamic Table, in irder to read it in tu line. Ie: Sell Date , must end with Sell in the upper line and d... Show MoreHow can i change a title in a visualization Dinamic Table, in irder to read it in tu line. Ie: Sell Date , must end with Sell in the upper line and date in the down line.
-
Issue with while build/publishing jobs in TAC
Summary:Steps to reproduce :1->install talend studio and configure the connection 2->Run a job , it will populate a window to download/installer if an... Show MoreSummary:
Steps to reproduce :
1->install talend studio and configure the connection
2->Run a job , it will populate a window to download/installer if any jar requires
after installing required jars , job is working fine .
and run any other job which has similar connection , it will run
3->To publish the job in tac, we should check the publish to antifactory repo in feature manager
So click Feature Manager ->it will ask to agree updates ->click on yes, update option-> It will update studio.
4->After updates it will ask to restart the studio, click on okay
When studio restarted , Run already executed job again , it will give the error as below:Execution failed :org.talend.commons.exception.PersistenceException: The Job "CDC_S_PROJ" has wrong configuration. Fix it and try again.
Error Line: 28088
Detail Message: oracle cannot be resolved to a type
[The Job "CDC_S_PROJ" has wrong configuration. Fix it and try again.
Error Line: 28088
Detail Message: oracle cannot be resolved to a type]Observation:
If we install and provide oracle jar again , current job will run but any other job which has the oracle connection as input that will not run , we have to open the job and click on apply and set the t_map mappings to execute jobs.
Means, when we install any job that is not applying on repo as expected, the same will work before click on feature Manager. -
Pagination with Multiple @odata.nextLink Values in Qlik REST Connector
Hello Qlik Community, I'm working on a REST API integration with Microsoft Dynamics Business Central where I'm using a batch transaction request to pu... Show MoreHello Qlik Community,
I'm working on a REST API integration with Microsoft Dynamics Business Central where I'm using a batch transaction request to pull multiple company data in a single query for efficiency. However, I’m running into an issue with pagination in the Qlik REST Connector.
The API returns multiple responses in a single call, and each response contains its own
@odata.nextLink
for pagination. I’ve tried different variations of the Next URL Path, but so far, I haven’t been able to successfully paginate through all the responses.Here’s an example of the API response structure:
{ "responses": [ { "body": { "data": [...], "@odata.nextLink": "https://api.businesscentral.dynamics.com/tenant/api/v2.0/companies(abe78fd7-84ab-ec11-80f1-000d3a0d0053)/generalLedgerEntries?aid=FIN&$skiptoken=900f4805-4147-ee11-be6d-6045bdd2c536" } }, { "body": { "data": [...], "@odata.nextLink": "https://api.businesscentral.dynamics.com/tenant/api/v2.0/companies(bcfcf5d3-4c90-4dff-9b29-63d2fb95a173)/generalLedgerEntries?aid=FIN&$skiptoken=d235fd2f-dc57-4186-8a67-e9430b445d7c" } } ] }
As you can see, each response in the
responses
array has its own@odata.nextLink
, which points to the next set of data for each respective company. The URL format looks like:https://api.businesscentral.dynamics.com/<TENANT>/api/v2.0/companies(<COMPANY_ID>)/generalLedgerEntries?aid=FIN&$skiptoken=<TOKEN>
Where
<TENANT>
is the tenant identifier,<COMPANY_ID>
is a unique company ID for each company in the request, and<TOKEN>
is a dynamic pagination token.My Question:
- Does the Qlik REST Connector support multiple iterations of the
@odata.nextLink
(one for each response object) during pagination in a batch transaction request? - If so, how do I correctly set the Next URL Path to iterate over each
@odata.nextLink
in theresponses
array?
I’ve tried the following paths without success:
root/responses/body/@odata.nextLink
root/responses/0/body/@odata.nextLink
root/responses/*/body/@odata.nextLink
(which I hoped would loop through each response)
I can get this working in Python, but I’d much rather have it built directly in Qlik. The workaround I've developed is running it in Python, converting the results to a QVD, and then uploading that into my Qlik Cloud tenant. But ideally, I want to streamline this process and avoid the need to rely on Python.
Has anyone encountered a similar issue or have any suggestions on how to approach this?
Any guidance or tips would be greatly appreciated!
Thanks in advance!
- Does the Qlik REST Connector support multiple iterations of the
-
Clientes Ativos Acumulados 12 meses
Hello, I would like your help! I am working with information on accumulated clients per month, without repeating them. In other words, within each mon... Show MoreHello, I would like your help!
I am working with information on accumulated clients per month, without repeating them. In other words, within each month, I need to accumulate active clients in the last 12 months. I would like to do this in Set Analisys, but if you have another idea, I accept doing it in the script. Below is what I'm using:
RangeSum(
Above(
Aggr(
COUNT({<
TransactionType = {'Billing'},
SiteNumber = {'3500'},
SalesOrderType = P(FilterSalesOrderType),
SalesOrderType = {'Order','Exchange of Goods'},
SalesOrderItemUnitSalesValue = {">0"},
YearMonth = YearMonth
>} DISTINCT SalesOrderCustomerCode),
YearMonth
), 0, 12
)
) -
Changing Central Node Manually, 403 Error
Hello Folks, I'm hoping to use Powershell to get my Qlik cluster to switch central nodes. Right now, I've got the following code which works correctl... Show MoreHello Folks,
I'm hoping to use Powershell to get my Qlik cluster to switch central nodes. Right now, I've got the following code which works correctly.
$hdrs = @{} $hdrs.Add("X-Qlik-xrfkey","12345678qwert2ui") $url = "https://002.megacorp.com/admin/qrs/ServerNodeConfiguration/full?xrfkey=12345678qwert2ui" $clusterNodes = Invoke-RestMethod -Uri $url -Method Get -Headers $hdrs -UseDefaultCredentials
But when I send the request to change, I get a 403. I am sending this request with RootAdmin privileges.
$destinationNodeName = '003.megacorp.com' $currentCentralNode = $clusterNodes | Where-Object { $_.isCentral -eq $true } $destinationCentralNode = $clusterNodes | Where-Object { $_.hostName -match $destinationNodeName } $destinationCentralNodeGuid = $destinationCentralNode.id $changeOverPutUrl = "https://003.megacorp.com/admin/qrs/failover/tonode/${destinationCentralNodeGuid}" Write-Host $changeOverPutUrl $response = Invoke-RestMethod -Uri $changeOverPutUrl -Method Post -Headers $hdrs -UseDefaultCredentials
When I look into the logs, I see "InvalidConnection" along with the 403 code
What might I be doing wrong?
Any help is greatly appreciated.
-
Map Object Puerto Rico Issues
I have a map object where I'm pulling in United States import data and mapping them according to the port of entry. They're coming in as a city and a ... Show MoreI have a map object where I'm pulling in United States import data and mapping them according to the port of entry. They're coming in as a city and a two letter state (like Houston, TX). If I don't put 'US' as the country then it will do thinks like show "Port Arthur, TX" in China and "St. Albans, VT" in England, but setting the country code to 'US' is not showing "San Juan, PR" on the map, neither does setting the country as 'PR'. How do I simultaneously show "San Juan, PR" while also showing the rest of the cities correctly on the map. Thank you.
-
Execute a Job in Oracle
Hello, i need a execute a oracle job in my Qlik Cloud, in my app i try this: SQLBEGIN DBMS_SCHEDULER.RUN_JOB('SOLUS_NINF.J_CARGAS_GUIAS'); but receiv... Show MoreHello, i need a execute a oracle job in my Qlik Cloud, in my app i try this:
SQL
BEGIN
DBMS_SCHEDULER.RUN_JOB('SOLUS_NINF.J_CARGAS_GUIAS');but receive this error:
Ocorreram os seguintes erros:
Internal error. (Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-06550: line 2, column 55: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := . ( % ; "))