Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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");
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
Hi,
So how things are going on?
Regards
André Gomes
Note that the referenced document
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
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?
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
Hi,
when are you expect to close this thread?
Regards
André Gomes
Hi,
any more news?
Regards
André Gomes