Error when trying to execute QMSEDX file on the QV server

[swarup_malli]

Hello,

I downloaded the files from http://community.qlik.com/docs/DOC-5111.

I got the following errors:

The Operating system on the QV server :

Windows Server 2008 R2 datacenter,

64-bit OS

Perhaps I might have made syntactical errors while passing arguments, I'm pasting the code below:

=== QMSEDX 1.0.3 (patched by Excelcio) ===
The program is used to execute a single EDX task and wait for the result.

qmsedx -task="Testing  QVD Extract:AppName_QVD_Dev-Reload-Business Development"
[-qms="NameOfTheServer"] [-password="ServerLoginPassword"]

[-variablename=vname]

[-variablevalues=vvalues]

[-timeout=timeout]

[-pollinterval=interval]

[-nowait=true/false]

[-verbosity=verbosity]
Arguments:
  -task [REQUIRED]: The name or id of the task to execute.
  -qms [OPTIONAL]: The name of the qms. Default is the local host.
  -password (-pwd) [OPTIONAL]: The password required to execute the task, if set.
  -variablename (-vn) [OPTIONAL]: The name of the variable to pass on to the task, if set.
  -variablevalues (-vv) [OPTIONAL]: A semicolon separated list of values of the variable to pass on to the task.
  -timeout (-to) [OPTIONAL]: How many seconds to wait for the task to finish. Default value is 24 hours.
  -pollinterval (-pi) [OPTIONAL]: How often to check the status of the task. Default value is every five seconds.
  -nowait (-nw) [OPTIONAL]: Don't wait for task completion (not compatible with tasks chaining!)
  -verbosity [OPTIONAL]: The level of output, 0-5. 0 will not produce any output and 5 is the most verbose.

[Peter_Cammaert]

It's the name of the server box, optionally including a domain, like "qvserverABC" or "qvserverABC.mycompany.com". Not the QlikView name, because that isn't known outside the QMC I suppose.

BTW I mistyped. The server address option is -qms, not -qmc. It points the executable to the machine on which the QlikView Management Service is running.

[swarup_malli]

I  got the following error when I try to execute it from the server box

Used the following command

QMSEDX.exe -task="Testing  QVD Extract:Myapp BI_QVD_Dev-Reload-Business Development"
-qms="192.xxx.x.xx" -password="xxxxx*"

also tried using the name of the box instead of ip address of the server box

QMSEDX.exe -task="Testing  QVD Extract:Myapp BI_QVD_Dev-Reload-Business Development"
-qms="Name of my server" -password="xxxxx*"

same error  😞

[swarup_malli]

I'm very close to finding  a solution

I copied the executables in C:\Program Files (x86), unblocked the QMSEDX.EXE in the properties ( as you had advised previously ),

and ran the following command

C:\Program Files (x86)\QMSEDX 1.0.3 and source>QMSEDX.exe -task="Testing  QVD Ex
tract:MyAppBI_QVD_Dev-Reload-Business Development" -qms"MyserverBox"  -passw
ord="xxxX"

This is error I got
Arguments must start with an - and contain =, as in -timeout=5. -qmsMyserverBox does
not follow that rule.

[Peter_Cammaert]

Obvious. There is no = sign between -qms and "MyserverBox". Just a parameter syntax error.

It should be like this:

QMSEDX.exe -task="Testing  QVD Extract:MyAppBI_QVD_Dev-Reload-Business Development" -qms="MyserverBox"  -password="xxxX"

[swarup_malli]

You are the man!!!

Was able to trigger from QV server box and remote system.

[Peter_Cammaert · Accepted solution]

When you start QMSEDX.exe on the server box, you can omit the -qms parameter. In that case, loacalhost will be used as default server name.

If you want to run this command on any other system, copy QMSEDX.exe to a suitable directory on that system and execute with the -qms parameter. Its value should be set to the servername or domain name of the server box.

Just try.

[nandhuvji]

Hello Peter,

I am not able to trigger tasks via EDX in QMC. Please let me know, what i am missing or is there anything wrong in the  steps that i followed.

I have downloaded QMSEDX_CommandLine_v1 from Using EDX in QlikView 11and configured the tasks in QMC as below

1. Task set to schedule on External Event in QMC

2. Entered password for the task

3. Downloaded QMSEDX_CommandLine_v1 from Using EDX in QlikView 11 and extracted the file s to to C:\Program Files (x86)\QMSEDX_CommandLine

4. Created batch file to trigger the task and saved the bacth file in C:\Program Files (x86)\

Batch file script :

"C:\Program Files (x86)\QMSEDX_CommandLine_v1\QMSEDX.exe" -task="Report Name.qvw" -qms="QVServerName"  -password="XXXX"

5. I ran the batch scrip by double clicking on the file / right click run as administrator. The command line pop up page flickers and immediately disappeared.

6. The task did not run in QMC

[nandhuvji]

Can you please check and revert on the above steps?

[Peter_Cammaert]

Please don't hijaack a closed discussion. You can easily create a new one all for yourself, thereby avoiding a mile-long thread in the rightmost column.

When creating a new discussion, first do a test at the most basic level by starting a Command prompt and entering the command prompt from your batch file. Then post a screenshot of the QMSEDX output. Thanks.

[nandhuvji]

As suggested, i have created new discussion and attached screen shot. Below is the link.

Not able to execute QMSEDX on QV server