Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

EDX - SSIS - QV11

Hi All,,

I am trying to trigger QV document from C# code using the API. I followed the steps and code from :  http://community.qlik.com/thread/40541 But i am unable to get it working.

I have modifed the config file , added web reference, other assemblies but i am stuck at following:

    // create a QMS API client

               IQMS apiClient = new QMSClient();

The type or namespace IQMS could not be found. I am not surewhat am i missing. Can you please help me out?

Thanks,

Ruby

9 Replies
Not applicable

Re: EDX - SSIS - QV11

I am out of the office until 03/14/2012.

I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact Nick-rcm Price or Jannette Lobemeier. Thanks

Note: This is an automated response to your message "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - EDX - SSIS - QV11" sent on 13.03.2012 16:57:02.

This is the only notification you will receive while this person is away.

--

Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

henrikmatz
Contributor II

EDX - SSIS - QV11

If you make it work i would like to know  We spendt a lot of time on this issue and ended using a exe-file instead.

There is a another thread on communty and a link to the exe-file.

This methode works also in a SBE enviroment.

You need to create the special API group, open port 4799 (if calling from another server) and use the document name (not task name) as parameter.

Search EDX.

HenrIk.

Not applicable

Re: EDX - SSIS - QV11

I am out of the office until 03/14/2012.

I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact Nick-rcm Price or Jannette Lobemeier. Thanks

Note: This is an automated response to your message "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - Re: EDX - SSIS - QV11" sent on 13.03.2012 23:42:43.

This is the only notification you will receive while this person is away.

--

Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Not applicable

EDX - SSIS - QV11

Hi,

Yeah very true. I started working on the exe only but got stuck again.

Can you let me know the steps.

I followed the steps as mentioned on following thread :

http://community.qlik.com/thread/47353?tstart=0

Downloaded the files

Created the bat file

D:\User_Documents\Ruby_A\qmsedx -task="test Dashboard_v3.1.qvw" -qms="http://servername:4799/QMS/Service" -password=Qlik123.

When running the bat file i am getting following error:

The Device is not ready.

Can someone please help me?

Thanks,

Ruby

henrikmatz
Contributor II

EDX - SSIS - QV11

Rember to add your user to a lokal Group on your qlikview server called "QlikView Management AP". This Group is not created during the installation, so it's needed to be created manually. If you running the file though a SQL agent, the user running this service has to be added as well.

If you run the bat file from another server than your qlikview server, you need to add the -QMS parameter to exe-fill call.

Also remember to open port 4799 on your qlikview server.

Finally I recommend to rename the EDX task, to a name without spaces. You might have to struggle a bit with this part if you have the error TaskNotFound.

Henrik

Not applicable

EDX - SSIS - QV11

Finally got it working thanks for the help!!

Not applicable

EDX - SSIS - QV11

Trying to call the code from Execute SQL task in SSIS. It is triggering the QV task but the script task fails with folloing error:

[Execute Process Task] Error: In Executing "H:\SSIS\QV_Working\QMSEDX.exe" " -task="Reload and Distribute of Applications\abc\abc Dashboard_v3.1.qvw" -QMS="http://hostname:4799/QMS/Service" -password=Qlik123" at "", The process exit code was "1" while the expected was "0".

Can someone please help!!

Thanks,

Ruby

perumal_41
Valued Contributor II

EDX - SSIS - QV11

Hi

Check this Link helpful for ur Problem

http://community.qlik.com/message/200201#200201

henrikmatz
Contributor II

EDX - SSIS - QV11

Is the SSIS package executed with another user?

If the SSIS package is executed by an SQL agent job, you need to include the sevice user of SSIS to the QlikView API user Group (sorry cant remember its name).

Also Make sure thar the SSIS user has access to sources and you QlikView folder structure.

Henrik