Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

EDX Triggers Not Working Since 11 Upgrade

We have recently upgraded our test environment from Qlikiview 10 to Qlikview 11 so as to evaluate the changes and confirm that existing reports and functions still work

As it stands the only functionality that has failed to work in qlikview 11 is the EDX triggers

I have done a significant amount of net research around this area but can find no article that concretely states that EDX trigger that work in QV 10 will not work in QV 11

When we attempt to fire the EDX trigger we get the following error:

17/10/2014 12:06:08-The remote server returned an error: (404) Not Found.

17/10/2014 12:06:08-Runtime exception encountered

Is this due to the existing EDX code no longer working in QV 11?

The EDX trigger we currently have implemented is an exe written in c# and as yet I can find no example of how to re-write an EDX exe in c# (the only example I can fin is for a DLL and this does not appear to translate into an exe)

Here is a code snippet from our existing EDX trigger code:

bool blnStartTask = sqlHelper.execSQL("SELECT * FROM [database].[flagtable] WHERE TRUNC(rptdate) = trunc(sysdate-1)");

                    //bool blnStartTask = sqlHelper.execSQL("SELECT * FROM [database].[flagtable] WHERE TRUNC(rptdate) = trunc(sysdate)");

                    if (blnStartTask == true)

                    {

                        //Indicates that the data migration from gold to goldmine is completed

                        status = true;

                        // Settings

                        string Result = "";

                        string QvsAddress = ConfigurationManager.AppSettings["server"];

                        string TaskName = ConfigurationManager.AppSettings["task"];

                        string EDXPassword = ConfigurationManager.AppSettings["password"];

                      

                        // Create class

                        EDXCall Caller = new EDXCall();

                        // Obtain a EDX key from QVS

                        string EDXKey = Caller.GetEDXKey(QvsAddress);

                        // Call the EDX to execute the task in QVS

                        Result = Caller.LaunchEDX(QvsAddress, EDXKey, EDXPassword, TaskName);

                        //Log the result after executing the task

                        Logger.log(Result);

                        Result = Caller.CheckEDXStatus(QvsAddress, EDXKey, TaskName);

                        Logger.log("EDX Task Completed");

16 Replies
agomes1971
Specialist II
Specialist II

Hi,

...

</basicHttpBinding>

        </bindings>

<client>

            <endpoint address="http://yourserver:4799/QMS/Service" binding="basicHttpBinding"

                bindingConfiguration="BasicHttpBinding_IQMS" contract="yourservicereference.IQMS"

                name="BasicHttpBinding_IQMS" behaviorConfiguration="ServiceKeyEndpointBehavior"/>

I hope this helps

The attachment you just download it.

Regards

André Gomes

agomes1971
Specialist II
Specialist II

Hi,

So how things are going on?

Regards

André Gomes

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Note that the referenced document

Using EDX in QlikView 11

contains a downloadable commandline EDX exe and complete source code. You may want to use that as a starting point.

I have customers who use the supplied commandline exe as is with their database. As long as your database can fire off commandline tasks, you can use the sample as is with parameters.

One possible stumbling block is if your database server is non-windows. The V11 EDX expects NTLM authentication. You can try to implement that in your non-windows code or implement a pass-through webservice proxy on a windows box. I used this webservice from Stefan Walther. http://qvextcalledxfromajax.codeplex.com/

-Rob

Not applicable
Author

Hi Andre,

Thanks for all your very useful help - much appreciated

I am now getting the following error when running the code:

An exception occurred: System.Exception: Document mount \\unc\some does not exist.

Does this need the file path to the source documents folder?

Also just to be clear we are connecting to an Oracle database and we do not want the task triggered from an external button - we need the code to periodically check an Oracle table for a flag that indicates the data has fully loaded and upon finding the flag automatically trigger the start of the Qlikview data load task?

agomes1971
Specialist II
Specialist II

Hi,

to the first question i think so because it is telling that it doesn´t exist...

Second Question: So if you want periodically it might be better to create an exe with the respective permissions to be executed...

I execute my app from web interface form.

And don't forget that you can do it a partial or full reload...

Regards

André Gomes

agomes1971
Specialist II
Specialist II

Hi,

when are you expect to close this thread?

Regards

André Gomes

agomes1971
Specialist II
Specialist II

Hi,

any more news?

Regards

André Gomes