Run task using EDX

[Anonymous]

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

[Peter_Cammaert]

Which version of QlikView are you running on your server?

[Anonymous]

Hi

We use Qlikview server 11.20.

Thanks

[Anonymous]

Hi,

I have the same problem. Did you resolve it?

Thanks

[Anonymous]

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