topic Re: Can perform reload task in QAP Server? in App Development

Can perform reload task in QAP Server?

jim_chan — Tue, 02 Feb 2016 10:24:20 GMT

I have setup a QAP Server. i was trying the task reload in " Task" for these 2 default dashboard.

Why is it "Failed" ? cannot be reload?

Rgds,

Jim

Re: Can perform reload task in QAP Server?

undergrinder — Tue, 02 Feb 2016 10:46:22 GMT

Hi Jim,

You should try the following:

First of all: restart the QlikSense services
If it doesn't help then check the user, who runs the services.
If it doesn't help, dwell into the logs.

Re: Can perform reload task in QAP Server?

jim_chan — Wed, 03 Feb 2016 01:38:38 GMT

is your solution suitable on QAP Server? i am not discussing about Qlik Sense Server.

Re: Can perform reload task in QAP Server?

jim_chan — Wed, 03 Feb 2016 02:07:05 GMT

I have tried restarting the services. still failed to start the scheduled task. I only facing this issue on my QAP Server. not Qlik Sense Server.

Re: Can perform reload task in QAP Server?

undergrinder — Wed, 03 Feb 2016 08:25:28 GMT

Hi,

Sorry, I didn't noticed that this isn't a Qlik Sense Server.

I don't know what QAP server is,( Qlik Analytics Platform | Qlik‌‌ ) I can't see what is this

When I've faced same problem with QlikSense Server the restart/set the proper user privilege on system solved my problem.

Re: Can perform reload task in QAP Server?

jim_chan — Wed, 03 Feb 2016 08:44:32 GMT

Hi there,

I have restarted the services and the server as well. i logged to the QMC with FullRights admin account. But, is still the same.

But anyway, thanks for your advice.

Re: Can perform reload task in QAP Server?

undergrinder — Wed, 03 Feb 2016 12:08:16 GMT

I'm sorry, not the access with administrator rights is crucial, but the user who are running the services must have the proper rights. (Local Service Account, Network Service Account so on...)

Re: Can perform reload task in QAP Server?

freinholdson — Tue, 03 May 2016 09:37:22 GMT

Jim,

Check the log files for errors. If you have imported the apps from another Qlik Sense Server the required data connections are unfortunately not imported together with the qvf-file. That is probably why the tasks fail since the data connections are missing. Check in QMC > Data Conenctions if they are there and if they are properly set up.

” When you import an app developed on Qlik Sense Desktop, existing data connections are imported to the QMC. When you export an app from a server, existing data connections are not exported with the app.”

http://help.qlik.com/en-US/sense/2.2/Subsystems/ManagementConsole/Content/data-connections-overview.htm

Since the QAP is a Qlik Sense-server without the "hub" and aimed for integration purposes only you have to find a way to import the data connections into the QAP QMC for reloads to work. One way could be to create an empty app in Qlik Sense Desktop with the required data connections and then import this qvf into the QAP. Then you can manage and set up the imported data connections properly in the QAP QMC.

Please set this answer as a correct answer if this helped you out

Re: Can perform reload task in QAP Server?

NZFei — Wed, 06 Sep 2017 01:25:50 GMT

Sense desktop is not allowed to be installed in Windows server where Sense server is installed, so if I want to export apps from Sense server to QAP and refresh them in QAP, how can I do that? As Jim has mentioned, the connections are not coming with apps so they do not exist in the QAP, causing reload task failed.

Thanks

Fei

Re: Can perform reload task in QAP Server?

eclutario — Mon, 27 Nov 2017 12:31:33 GMT

Hi,

Were you able to figure it out?

I had the same problem earlier: no QS desktop on the server and thus cannot import data connections at all. I solved this by applying the QSE license in the server first, created an app with all data connections I would need later in QAP, I then switched back to QAP license as soon as all the data connections I need are created and tested. I then replaced all the data connections in the data load of the QSE apps before they get imported to QAP.

Example of commenting QSE data connection and switching to QAP data connection in the data load prior to exporting the app:

//LIB CONNECT TO 'Prod Redshift DSN (domain_email@mycompany.org)’;
LIB CONNECT TO ‘Prod Redshift DSN (domain_username)’;

If the QAP data connections are properly configured and tested, reloading shouldn’t be a problem in QAP.

Re: Can perform reload task in QAP Server?

shraddha_g — Mon, 27 Nov 2017 12:34:11 GMT

From Data connection,

Remove (domainname/username)

Keep only Prod Redshift DSN

Re: Can perform reload task in QAP Server?

NZFei — Mon, 27 Nov 2017 20:07:09 GMT

Hi Eric,

There are two solutions.

1) I created a case and Qlik support asked me to log onto the repository database as an admin and make change there. To be honest, I dare not just go there and directly change anything or import anything. The steps are also quite complicated.

2) We solve this by creating a Sense app using Sense desktop on our own PC, upload this app to client's QAP server and then modify the connections there. When modifying connections in QSE or QAP server, you can change basically everything except the type. So for example we know we need to connect to SQL server and some folders so we create an app that has SQL connection and 5 or 10 folder connections. Then upload it to the QAP server, modify the connection settings and delete the folder connections that are not needed.

Hope this can help?

Fei