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]

This is a 32-bit tool that needs the 32-bit to 64-bit interface layer.

Does it work if you put it in a subdirectory in C:\Program Files (x86) ?

[swarup_malli]

Thank you for the response Peter,

I just copied the  entire extracted folder and tried to run it , this is what I got

[Peter_Cammaert]

Download the archive again from the Resource page and copy the program over the current one. Your executable is probably broken.

[Peter_Cammaert]

Another tip: did you unblock the executable? Check Properties->General at the bottom for annoying flags.

[swarup_malli]

It doesn't work , The unblock option disappears after I add the arguments and save the executable ( ie QMSEDX_p2,.exe)

[Peter_Cammaert]

What exactly is QMSEDX_p2.exe?

If it's a batch file that calls the real QMSEDX.exe, you'll have to change the extension into either .bat ar .cmd in order to get it to work...

If it's not, then please list the steps you take to create QMSEDX_p2.exe.

Do not change QMSEDX.exe yourself in any way. It's a command line executable that should work as-is on your 64-bit Win2K8 Server..

[swarup_malli]

Thank  you for getting back to me.

This is what I did

1) I downloaded and extracted the executables.

2) Then copied all the contents of QMSEDX.exe into a notepad ( using command promt ,command used is  QMSEDX.exe > QMSEDX_p2.txt).The reason why I did that  was I was under the impression that this was how its done.

This is the code present in QMSEDX_p2.txt ( I have highlighted the arguments in red)

=== 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.

QMSEDX_p2.exe is a file I created by copying all the contents of    the original downloaded  QMSEDX.exe file onto a notepad , after copying it inot notepad,I entered the arguments (see below,I have highlighted the arguments in red

)

3) After saving the contents in the txt file ( QMSEDX_p2.txt) ,I changed the file extension from txt to exe

4) Then tried to run the file ( QMSEDX_p2.txt) in command prompt using the command QMSEDX_p2.exe.

I did not create a bat file  to execute the QMSEDX_p2.exe file.

[Peter_Cammaert]

So you turned a binary executable into a text file to patch it and change it back into a binary "executable"? That's not going to work. You shouldn't touch .exe files, as unexpected things or simply nothing may happen.

If you open a command prompt and start the original QMSEDX.exe program, you will get the text that you listed above as output. Sort of help text from a command line program on how to use it.

The text tells you to start QMSEDX.exe from the command line and add parameters to this command line. For example:

C:\>QMSEDX.exe -task="AnArbitrayQMCTask" -qmc="MyQlikViewServer" -password="TaskPassword"

The bold stuff is what I input on the command line. Upon pressing Enter, QMSEDX.exe will start, parse the parameters and execute the specified task on the specified server. After completion, some additional output may tell you what worked and what did not. All inside this command window and in black-and-white.

Such a command line (the bold part) can be put as-is in a batch file (a text file with .bat or .cmd extension) and scheduled as a timed job in Windows Task Scheduler or as a Supporting Task in QMC.

Hope this clarifies a few things. If not, ask away.

Best,

Peter

[swarup_malli]

Thank you Peter, never realized I was not supposed to edit the exe file 😉 My bad

C:\>QMSEDX.exe -task="AnArbitrayQMCTask" -qmc="MyQlikViewServer" -password="TaskPassword"

Here

-qmc="MyQlikViewServer"

--the argument "MyQlikViewServer" is it the name of the QV server ? or the name of the server box on which QV sever is installed

I'm assuming its the name of the server box and not the name of the Qlikview server( see fig below,I got the name of the QV server name from here), because if I want to trigger this from a remote system, how will the system know where to execute this command .. I mean which serverbox to go to