Hi,

I´ve recently tried to upgrade Qlik Data Movement Gateway to the latest version.

After the upgrade the repagent service has failed to start. I have followed the upgrade instrutions here: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/dm-gateway-upgrading.htm 
and also retryed the upgade 3times (i took a snapshot of the server before the upgrade). 

But the outcome has always been the same, "failed to start service". 

I found this article: https://community.qlik.com/t5/Qlik-Cloud-Data-Integration/Data-Movement-Gateway-Service-Failed-to-start-after-upgrade/td-p/2163218?lightbox-message-images-2163218=127389i7DABB819A273EF54

With another user having the same issue. But the only solution wihtin that post is to install Data movement on Red Hat rather then CentOS as I´m currently running. 

I can´t see that CentOS not should be supported by Qlik Data Movement according to the documentation. 

Hi,

In the example of getting the impersonation access token data-get-access-token is associated with the function that fetches the access token.
If I already have the access token because I fetched it earlier, how would I format it so that it fits the variable or if I have to, set it in the function getAccessToken()?

Hello,

I have a issue with these data, i need to create Cumple? field, the rules is with the same id_vehiculo, with different CodTransito and PuntoCobro, the difference between fechahora(1) and fechahora(2) is <= 20 minutes

How can i do these?

In URL/Expression window I have this (simplified url) and this works

='http://mycompany.net/jump.ashx?employeeId=' & [Employee Id]

I’m going to use this in 10+ places so like to put this in a Script variable

Cannot figure out the syntax for referencing the dimension in a script variable, so I created a script variable for the dimension, Employee Id

In Script

vEmpId ='[Employee Id]';

in the URL/Expression Window, the variable works

='http://mycompany.net/jump.ashx?employeeId=' & $(vEmpId)

But when I tried to put that statement into the script format and I cannot figure out how to do it

varURL = ='http://mycompany.net/jump.ashx?employeeId=' & '$'&' (vEmpId);

varURL = ='http://mycompany.net/jump.ashx?employeeId=' &  chr(36) & (vEmpId);

Surprisingly I am getting a lot of

Thanks in advance

I have a data model including two data sources (SAP & Salesforce) - please see the attachment. SECURITYKEY is in SAP table. After applying section access, some data rows from Salesforce table disappear. How can this be fixed?

Hello all,

I'm facing a challenge getting last year sales based on a last year date we have, I have to use this date for comparison so I can't use the AddYear() or any of the system functions because of some special cases that require this logic. Basically I have my table below, and I want to write an expression for a master item (Sales LY). I've simplified the question in the below table.

if I put this master item in a table with the 3 already provided columns, the orange numbers would populate the question marks.

Appreciate your support 🙂

Hi,

We are dynamicly renaming the columns of a tDBInput. Up to now it has been a mysql where we got our data from but we have decided to move to Snowflake but when we exchange the tDBInput (mysql) to tDBInput (snowflake) the same code fails with an index outOfBounds exception where the index is -1 in an array with the length of the number of columns. After doing a java debug and stepping through the code i saw that for some reason the snowflakeInput requires the columnnames to always stay the same because for some reason it trys to look at the metadata of the first dynamic row while loading the second so the job fails after the first row. This is also true when using the jdbc connector directly via tJDBCInput

The isolated job setup looks like this:

tDBInput(Snowflake)(schema: resultset -Dynamic) ->  tJavaFlex -> tLogRow

Pseudo Code in tJavaFlex (Main):

for(Columns in resultset){

    if(columName starts with "H_"){

          rename columnName so it Starts with HS instead;

     }

}

As i said using any other tDBInput (oracle or mysql) this setup works, same code but with snowflake as the input the job explodes. Why is that and is there a workaround? (Talend Version we are using is 7.x)

Oi galera.

Integrei uma base de dados My SQL de um servidor local no Qlik Cloud.

Algumas tabelas consigo adicionar pelo Gerenciador de dados em outros casos aparecem a mensagem de que os dados não podem ser adicionados.

Eu acho que pode ser Timeout.

Alguém já passou por isso? Podem me dar algumas dicas, sou novato no Qlik.