topic Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX in Alteryx Server Discussions

Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

prashantkumar — Fri, 11 Sep 2020 15:14:15 GMT

Hi There,

So, i am trying to run 2 batch files from Alteryx Gallery

For moving files
to trigger auto-reload of QlikView Dashboard using QMSEDX

Alteryx Server (single node) is separate --> QlikView Server (single node) is separate (all ports and protocols are in place)

The workflow run fine when I RDP into Alteryx server and run it and the batch files run on the QlikView server as well from the Alteryx server.

But, when I create a package (.yxzp) and upload it on Alteryx Gallery, 1st batch file runs (moves files successfully) but 2nd one doesn't trigger auto-reload of QlikView dashboard.

There is no error and the workflow just keeps on running till countdown of 10 like below -

Job Status: Running

Retry Attempt: 6

Results will appear when the Workflow is finished running.

and then shows this -

We are unable to get the status of your workflow results at this time. You can close this view and check the Workflow Results page later.

When I check the workflow results page, it gives below -

Unknown error. ArgumentException RequestID: 72433d998244463ab1fbee4bf9d3ad32

Am I doing something wrong?

Copy.bat file has below command -

echo D | xcopy /S /I /Q /Y /F "\\QlikViewServer\QlikViewDashboardFiles\ExecDashboard\L1 Output\*.*" "\\QlikViewServer\QlikViewDashboardFiles\ExecDashboard\QV Input"

Trigger.bat file has below command -

\\QlikViewServer\QlikViewDashboardFiles\ExecDashboard\QMSEDX\QMSEDX.exe -task="Reload and Distribute of ExecDashboard\Executive Dashboard - Redesigned-Live.qvw" -qms="http://QlikViewServer:4799/QMS/Service"

Any help would be highly apriciated.

Thanks,

Prashant

Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

hroderick-thr — Fri, 11 Sep 2020 20:35:37 GMT

When you run on the server, can you use the same credentials as gallery?

Could you put both commands into one bat file?

Are you using run command tool or event?

Can you make the black cmd window appear and add a pause statement to the end to debug?

Try putting 'call ' at the beginning of your commands...

call xcopy...

call \\QlikViewServer\QlikViewDashboardFiles\ExecDashboard\QMSEDX\QMSEDX.exe...

Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

prashantkumar — Mon, 14 Sep 2020 07:19:02 GMT

Hi hroderick-thr,

Thank you so much for taking out time to reply to my question.

Yes, I use same credentials for RDP into Alteryx server and Alteryx Gallery, and both the commands are into a single bat file and I am using the command tool for QMSEDX. So I don't think this will be issue of creds.

When I run it from server the cmd window pops up, waits for 2 min and the reload of QlikView starts, because it triggers the reload of QlikView dashboard, I never thought of using pause statement because there was nothing to debug. Would you recommend using pause when trying to run from Alteryx Gallery?

As suggested, I tried call before each commands, but same thing, copying works but not the QMSEDX.

Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

hroderick-thr — Mon, 14 Sep 2020 13:58:29 GMT

Try...

RDP to the server that runs the problem bat file.

Open a cmd window

Copy/paste the commands from bat file to cmd window.

You may need to press enter so the last line will run.

Examine output for indication of problems.

Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

prashantkumar — Mon, 14 Sep 2020 14:20:17 GMT

So I tried it, and it run without any issue and triggers the reload as well.

Somehow when I upload it on Alteryx Gallery, it doesn't work, the first part work (moving files) but the QMSEDX dosen't work from Alteryx Gallery

I am at my wits end here 😞

Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

prashantkumar — Fri, 23 Apr 2021 17:51:12 GMT

thanks, it worked 🙂

Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

hroderick-thr — Sun, 25 Apr 2021 01:10:11 GMT

Please mark solved if it did the trick.

Likes are nice.

Solves earn clout

Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

Fahmad100 — Tue, 16 Apr 2024 03:56:06 GMT

Hi,

What was the resolution?

Thanks

Re: Run Batch File from Alteryx Gallery to trigger QlikView QMSEDX

hroderick-thr — Sat, 11 May 2024 12:20:08 GMT

@prashantkumar I recommend the TIMEOUT command that continues after a few seconds instead of the PAUSE which requires operator intervention. A gallery job running in the background with a PAUSE statement would be bad.