9 Replies Latest reply: Mar 16, 2012 1:23 AM by Henrik Matz RSS

    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

        • 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.

          • EDX - SSIS - QV11
            Henrik Matz

            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.

              • 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.

                • 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

                    • EDX - SSIS - QV11
                      Henrik Matz

                      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

                        • EDX - SSIS - QV11

                          Finally got it working thanks for the help!!

                          • 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

                              • EDX - SSIS - QV11
                                Henrik Matz

                                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

                        • EDX - SSIS - QV11
                          Perumal Ayyappan

                          Hi

                           

                          Check this Link helpful for ur Problem

                           

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