13 Replies Latest reply: Jul 4, 2017 8:24 AM by Ruggero Piccoli RSS

    Nprinting 17 Tasks run "forever"

    Stefan Habermacher

      Dear Community

       

      I've ran into another problem: I created a test report and tried to start the task via Run Now. But nothing happens, no mail is sent. In the

      Tasklist (yourserver.cc:4993/#/tasks/executions) i get the following picture:

       

      28-06-_2017_16-52-16.png

       

      All the Tasks are running but at 0%. Does anyone have an idea whats the problem here?

       

      Kind Reagrds

       

      EDIT: I have now upgraded to June version of nPrinting. This has improved the performance and added some functionality. As mentioned bellow, I expect / hope performance will further improve with coming updates, however now we can at least work with the tool.

        • Re: Nprinting 17 Tasks run "forever"
          Andy Weir

          1. Have you looked in the logs for more detail.

          2. Perhaps your SMTP Settings arent setup correctly.

          3. Have you previewed the report in designer and checked it generates before you created the task.

            • Re: Nprinting 17 Tasks run "forever"
              Lech Miszkiewicz

              I suggest you

              • remove all those tasks from your publish scheduler,
              • restart services and
              • start over.

              Those tasks will try to generate reports forever untill they either fail or time out. I think it is better to kill them, test them in preview, test SMTP or better distribute to NewsStand first and then use it with SMTP .


              If you do not remove task from publish task list they will startover after you restart services, so you have to remove them if you want to kill them!


              I also suggest an upgrade to June 2017 version which has abort task property!!!

               

              cheers

              Lech

              • Re: Nprinting 17 Tasks run "forever"
                Stefan Habermacher

                Hi Andy

                 

                Thanks for your inputs.

                 

                1. Yes I have. Found a few errors but in general they look good.

                2. No, SMTP is ok. I have run other tests and Emails were sent.

                3. I've tried. But it takes more than 10 Minutes and the hint was to try it with a task... But it guess this is the problem. Some performance issues.

                For example This table (nothinh else in the report):

                 

                29-06-_2017_09-20-54.png

                Takes mor than 10 Minutes for preview?

                In QlikView, everything works just fine. The Chart looks like this:

                29-06-_2017_09-17-53.png

                 

                Although these charts have five formulas (in variables). Some pretty long set analysis in the script:

                29-06-_2017_09-25-48.png

                Could this have an impact on the nprinting performance?

                 

                Best regards

                  • Re: Nprinting 17 Tasks run "forever"
                    Andy Weir

                    How large is the app you are sourcing the data from?

                     

                    What is the spec of your server.  perhaps it is under powered for what you are trying to do. Look at the white paper on performance for guidence.

                     

                    Also what you might want to try is adding a report filter to it that reduces the data down to a point the preview runs successfully.

                     

                    I know I had trouble getting reports to run until I threw a number of cores and memory at it.

                     

                    17 although improved from .3 onwards is still not as efficient at processing reports as 16 was.

                      • Re: Nprinting 17 Tasks run "forever"
                        Stefan Habermacher

                        Hello Andy

                         

                        Abou 350 MB.

                         

                        Server Specs:

                        29-06-_2017_10-44-54.png

                         

                        But we run both (NPrinting & Qlikview) on the same machine. However, even after starting a Preview request in Nprinting the RAM on the server are only used up to 37%. CPU is used up to 27%. And we use different Users for Nprinting and Qlikview.

                         

                        Will try the filter thing later today or next week.

                         

                        Thank you for your inputs!

                      • Re: Nprinting 17 Tasks run "forever"
                        Lech Miszkiewicz

                        Hi Stefan,

                         

                        regarding performance - are you using LOCAL or QVP connection to qvw document?

                         

                        i strongly suggest QVP to improve performance!

                         

                        regards

                        Lech

                        • Re: Nprinting 17 Tasks run "forever"
                          Ruggero Piccoli

                          Hi,

                           

                          Yes, experience suggests that formulas in QlikView objects can degrade performances.

                           

                          If you have performances issues, my suggestions are:

                          - if possible clone the QlikView document and create one used only as data source for reporting. Include only the data and charts that are necessary for reporting.

                          - save the QlikView document with all objects minimized. This reduce the QlikView document opening time.

                          - if possible move formulas from objects to the script. Formula values in the script are calculated during the reload and stored ready. Instead formulas in the objects are calculated when you open the .qvw and re-calculated every time you apply filters. This slow down NPrinting performances. For example inserting a QlikView object into a NPrinting Level means that NPrinting apply a filter for each value of the level, QlikView formula are re-calcularted for each value of the level and the the object is exporte to be inserted into the report. If formulas are complex the total amount of time can be big.

                           

                          Best,

                          Ruggero

                            • Re: Nprinting 17 Tasks run "forever"
                              Stefan Habermacher

                              Hi Ruggero


                              Thanks for the inputs.


                              There was a misunderstanding: We have the formulas created in the script and load them in variables. These variables are then assigned to the objects. I guess that is best practice in any case?

                               

                              I have now upgraded to June version and performance has improved. Not yet what I expect, but now we can work with the tool. For the time being we will generate excel reports and send them as PDFs. This seems to work pretty well. Even though the eventual goal is to use high quality images of the current dashboard so we don't have to rebuild the charts we already have built in QlikView.


                              I guess upgrading to june version is best thing you can do right now to improve peformance.


                              Best Regards

                              Stefan