topic Re: EDX Command Line trigger not working in Management & Governance

EDX Command Line trigger not working

gdevarashettyhf — Thu, 28 Jul 2016 14:15:39 GMT

***************************************************** NOTE *******************************************************************************************

I posted this in wrong forum looks like. Updated the thread to Deployment forum. Also attached a word document that tells how to do but I am not able to find the QVCertTool.zip file. Anyone knows where can I find the zip file please. THANK YOU. Ganesh

***************************************************** NOTE ******************************************************************************************

I am using command line EDX run. did the following.

1. Created a QMC Task with EDX trigger and password

2. Copied the EDX command program onto a machine (even on server).

3. executing below in cmd (admin mode)

qmsedx -task="ABC.qvw" -qms="http://PUB:4799/QMS/Service" -password=Password123 -verbosity=3

4. Get below error message followed by an exception trace:

Failed to create a client to the specified Uri.

The request channel timed out while waiting for a reply after 00:00:59.8979898.

Increase the timeout value passed to the call to Request or increase the SendTim

eout value on the Binding. The time allotted to this operation may have been a p

ortion of a longer timeout.

5. If I give https://PUB:4799/QMS/Service (https instead of http), the following error comes up

Failed to create a client to the specified Uri.
The provided URI scheme 'https' is invalid; expected 'http'.
Parameter name: via

Unhandled Exception: System.ArgumentException: The provided URI scheme 'https' i
s invalid; expected 'http'.

6. If enter http://PUB:4799/QMS/Service URL in browser, there is no response (timeout). If I enter https://PUB:4799/QMS/Service URL in browser, a certificate message shows up but webpage opens up.

Any help is greatly appreciated.

Thank you,

Ganesh

Message was edited by: Ganesh Devarashetty Added a Word Document that lists how to do it. But I am not able to find the QVCertTool.zip file. Anyone knows where can I find the zip file please. THANK YOU. Ganesh

Re: EDX Command Line trigger not working

gdevarashettyhf — Fri, 12 Aug 2016 19:38:28 GMT

Just checking if anyone? One thing I am thinking is the QMS port number is the same for both HTTP and HTTPS. Is that an issue? Is that the reason that HTTPS works but HTTP does not?

Appreciate any insight.

Re: EDX Command Line trigger not working

cleite2014 — Tue, 07 Feb 2017 17:33:52 GMT

Hi Ganesh,

Did you get the EDX Command Line Trigger working? I am beginning to look at this at my company and am looking for a complete beginning to end setup process to accomplish this task.

Any help would be greatly appreciated.

Thank you,

Craig Leite

Re: EDX Command Line trigger not working

gdevarashettyhf — Mon, 13 Feb 2017 16:41:54 GMT

Hi Craig, Good for you. No I still haven't solved this issue. But I feel my issue is mainly due to the use of certificates. If you are not using certificates, you can make this work using a simple BATCH file setup, available in the forums.

URL - Using EDX in QlikView 11

Ganesh

Re: EDX Command Line trigger not working

Bill_Britt — Thu, 15 Feb 2018 13:24:13 GMT

Hi Ganish,

Try qmsedx -task="ABC.qvw" -qms= PUB -password=Password123 -verbosity=3

Also, the task ID is "Task Name" not the abc.qvw

Bill

Re: EDX Command Line trigger not working

maheshacharya12 — Wed, 06 Mar 2019 13:39:33 GMT

Hi Ganesh,

were you able to resolve this issue ?

We recently moved from AD authentication to Certification method, and our QMSEDX setup has stopped working with below error:

Failed to create a client to the specified Uri.
The request channel timed out while waiting for a reply after 00:00:59.6249970. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.

Any help from your side would be really appreciated.

Thanks,

Mahesh

Re: EDX Command Line trigger not working

martinzalloccodxc — Thu, 05 Nov 2020 12:49:26 GMT

Hi Mahsh/Ganesh, we are experiencing the same issue after changing to use certificates. Did you have any response or were you able to fix the issue? If so, could you please share the resolution? Thanks

Re: EDX Command Line trigger not working

maheshacharya12 — Thu, 05 Nov 2020 13:47:16 GMT

Hello,

We were able to fix the issue.

you need to put a config file(named QMSEDX.exe.config) in the same directory where u put QMSEDX.exe utility.

I am attaching file we are using as .txt as .config is not supported for upload here, you can remove .txt and use.

you need to replace things at two places:

First:

Replace <endpoint address="http://qmsserver:4799/QMS/Service" with your qmsserver address at both occurences.

Second:

Replace clientCertificate findValue in below row with thumbprint of your certificate.

Third:

The command to run QMSEDX should go like this(mind https:)

"D:\Program Files\QlikView\QMSEDX\Utility\qmsedx" -qms="https://qmsserver:4799/QMS/Service" -task="Reload_QMSEDX_Task" -timeout=30000 -verbosity=5 > "D:\Program Files\QlikView\QMSEDX\Logs\Reload_QMSEDX_Task.log"

Let me know if it helps you or if you need more information.

Thanks,

Mahesh

Re: EDX Command Line trigger not working

martinzalloccodxc — Thu, 05 Nov 2020 16:59:12 GMT

I am trying to implement the workaround you provided. Thank you Mahesh!

I do have a question. Regarding "Replace clientCertificate findValue in below row with thumbprint of your certificate." I am not sure where to find/check for that required value. Would you please guide me how can I know what that value is?

Thank you again!!

Re: EDX Command Line trigger not working

maheshacharya12 — Thu, 12 Nov 2020 05:19:05 GMT

Steps to get certificate thumbprint:

1. Login with QlikView Service Account to the server where QMSEDX utility is installed( ideally the same server where QMS service is installed).

2. Under Microsoft Management Console(mmc.exe), File-->Add Remove Snap-in, Choose Certificates-->Add , Select "My user account" option(this is the default)-->Finish-->OK

3. Under Certificates-Current User-->Personal-->Certificates, find a certificate issued by your organization to the QlikView service account( with the same name of service account).

4. Double click the certificates, Under Details tab, find Thumbprint attribute, here you see the thumbprint value of the certificate, avoid copy-paste as that does not go well, try to read and write down the thumbprint value from here to the configuration file.

That's all...Let me know if you further see any issues.

Thanks,

Mahesh

Re: EDX Command Line trigger not working

martinzalloccodxc — Thu, 26 Nov 2020 15:58:02 GMT

Thank you for your support Mahesh! It cost me more than expected to get the .config file correcly configurated (I had to do some tweaks like "CurrentUser" storeName="Root" and I think it is now). Now I am receiving an error message:

Failed to create a client to the specified Uri.
Could not establish trust relationship for the SSL/TLS secure channel with authority '10.173.101.6:4799'.

Unhandled Exception: System.ServiceModel.Security.SecurityNegotiationException: Could not establish trust relationship for the SSL/TLS secure channel with authority '10.173.101.6:4799'. ---> System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.

I understand I need to implement a certificate in order to allow trust to reach the URL. In my case I think it is a very dificult option due to costs. Is there any way to change something on the config file to avoid expecting https and allow me to use http? FYI , from a web browser in can reach access point, QMC, etc without having this issue.

Thank you in advance!!

Re: EDX Command Line trigger not working

ilyas393 — Mon, 24 Jul 2023 17:44:12 GMT

Hi @gdevarashettyhf, @maheshacharya12 or anyone who know -

where can I find this QVCertTool.exe tool mention in the document?

Also, the instruction in the document seem to be different than what @maheshacharya12 mentioned. Does both work or need to be combined in some way?

I appreciate any assistance. Thanks

Re: EDX Command Line trigger not working

ilyas393 — Mon, 14 Aug 2023 22:39:08 GMT

Hi @gdevarashettyhf , @gdevarashettyhf

I was able to figure out and fix the specified uri error, and I think I am pretty close to solving it. I am stuck with missing service key. where can I find this or configure this service key?

Here is the error message I am getting now:

Error while starting task with id/name=taskname
Error message: Service key is missing
Failed to start the task!

I have already looked into Solved: Re: Service key is missing - Qlik Community - 1436424 and has behaviorConfiguration="ServiceKeyEndpointBehavior" in the config file

Thank you for your help