Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
asisa_bi
Contributor III
Contributor III

Run task using EDX

Hi

We want to run a scheduled task of Qlikview Server using EDX with Talend ETL (we have not license for Publisher). For that, we have created manually the local user group QlikView EDX to add a service user which we use to run Talend. In addition, we have added this user to the group QlikView Administrators.

The command of .bat executed is the following:

QMSEDX.exe -qms="http://xxxx:4799/QMS/Service" -task="TALEND/xxxxx.qvw"  -password="12345678"

If we run it using our local user it works fine. But when we try to run it using TALEND and the service user, it doesn't work with this error:

Unhandled Exception: System.ServiceModel.FaultException: Authorization failed for user XXXXXX, required access level is QlikViewEDX


As I mentioned, we have added the user which should run the .bat file in Qlikview EDX and Administrators groups. and we have restarted all QlikView services. Please, could you tell me if is there any extra configuration needed?


Thanks in advance,

Cheers

4 Replies
Peter_Cammaert
Partner
Partner

Which version of QlikView are you running on your server?

asisa_bi
Contributor III
Contributor III
Author

Hi

We use Qlikview server 11.20.

Thanks

jose_67136
Contributor
Contributor

Hi,

I have the same problem. Did you resolve it?

Thanks

asisa_bi
Contributor III
Contributor III
Author

Hey José

Yes, I got it. Please, ask me if you have any doubt:

I have wrote a little guide in my blog (spanish), you can check it here: http://www.n4gash.com/2018/ejecutar-tarea-qlikview-server-linea-comandos-cmd/

  1. Configure EDX reload of qv document from QMC.
    • Check On External Event and type a custom password.
  2. If you're using Talend or any ETL which can run .bat or CMD to send commands, you need to execute the following command:

your directory\QMSEDX.exe
-qms="http://yourserver:port/QMS/Service"
-task="FOLDER OF QV'S DOCUMENTS/document name.qvw"
-password="12345678"
-verbosity=5

  • QMSEDX.exe Once you have downloaded and uncompressed QMSEDX, you need to get the absolute path of qmsedx.exe (ex: c:\QMSEDX\QMSEDX.exe)
  • -qms: URL of your Qlikview Server with port 4799. Easily you can catch the URL of your QMC and then change the port.
  • -task: it's mandatory to include the FOLDER name assigned in QMC where it's your qv document (QMC > System > QV Servers > Folders tab). And finally, the document name with extension ".qvw".
  • -password: Password typed when you configurated the EDX reload.

For example:

C:\QMSEDX\QMSEDX.exe -qms="http://server.company:4799/QMS/Service" -task="REPORTS_COMPANY/My Report 2018.qvw" -password="12345678" -verbosity=5

Remember, you need to download QMSEDX. We're running version 11, you can find it here (at bottom): Using EDX in QlikView 11

Cheers