10 Replies Latest reply: Apr 20, 2017 8:29 AM by umar khan Branched to a new discussion. RSS

    Reload with Control-M

    Rogelio de Hoyos

      I have a problem with the Reload process.
      Currently incremental load processes and the final application is made through Control-M. The way it is done is with an executable which request QlikView through command line.
      The problem is that sometimes the two processes run smoothly and others just run the incremental load, the application does not load but make no mistake. There is no pattern of failure, just sometimes does and sometimes not.
      any idea what might be happening?

        • Reload with Control-M
          Stefan Wühl

          I think I don't completely understand your setting, maybe you could clarify:

           

          I would assume that CTRL-M from within QlikView would open the macro or module editor and not start a reload,

          so probably you use this short key in a different context?

           

          Have you enabled the application log file (Settings- Doument Properties - general tab -enable logfile)? If yes, do you see anything different here between passed and failed runs?

           

          Regards,

          Stefan

            • Reload with Control-M
              Rogelio de Hoyos

              Hi Stefan.

              When the reload is no successfull, the log file only says:

              11/29/2011 7:28:41 AM:      Execution started.

              11/29/2011 7:28:41 AM:      QlikView Version:10.00.9055.7

               

              But only these, doesn't appear a error.

               

              Control-M executes the next batch file:

              QV.exe /r "E:\Market Basket\Procesos Intermedios\Integracion QVD\Integracion GENERA TEMPORAL.qvw"

              QV.exe /r "E:\Market Basket\Aplicacion\Market Basket.qvw"

               

              The problem is that sometimes the reload is correcto for both process and some times only for the first of them.

              • Re: Reload with Control-M
                Rogelio de Hoyos

                Hi Stefan.

                When the reload is no successfull, the log file only says:

                11/29/2011 7:28:41 AM:      Execution started.

                11/29/2011 7:28:41 AM:      QlikView Version:10.00.9055.7

                 

                But only these, doesn't appear a error.

                 

                Control-M executes the next batch file:

                QV.exe /r "E:\Market Basket\Procesos Intermedios\Integracion QVD\Integracion GENERA TEMPORAL.qvw"

                QV.exe /r "E:\Market Basket\Aplicacion\Market Basket.qvw"

                 

                The problem is that sometimes the reload is correcto for both process and some times only for the first of them.

                  • Reload with Control-M
                    Rob Wunderlich

                    By Control-M, I assume you mean the scheduling product.

                     

                    Using Qv.exe to do reloads can be kind of problematic because of the interactive and GUI nature. You have to run in a virtual machine or a borrowed desktop  QV.exe expects it's dealing with a person -- messages can get missed. Check the windows event application log to see if there are any Application Popup messages.

                     

                    Do you have Qlikview server installed?

                     

                    -Rob

                      • Reload with Control-M
                        Rogelio de Hoyos

                        Hi rob,

                        Yes I have Qlikview Server installed.

                         

                        Roger.

                          • Reload with Control-M
                            Rob Wunderlich

                            So you may be able to improves the process by using the Qlikview Server scheduling facilities. If you need Control-M to trigger the first task (because of non-QV workflow), you can do that in a couple of ways.

                             

                            1.

                            a) Define a Reload task GENERATEMPORAL.qvw with an "External Event" trigger and use the EDX facility to trigger the task.

                            b) Define a reload task for Market Basket.qvw that triggers on completion of GENERATEMPORAL.qvw.

                             

                            Or

                            2. Continue to load commandline as you did before, but use QlikviewDistributionService.exe instead of qv.exe The former does not require a GUI. Pay attention to the note in section 25.2 of the QVS Ref Guide.

                             

                            -Rob

                    • Re: Reload with Control-M
                      Maria Berrocal Barrena

                      Hello!!

                       

                      I'm having problem planing the reloads with control-M. Have you solved this problem?

                       

                      I really not understand how i have to do it in the way Rob explains.

                       

                      Thanks