4 Replies Latest reply: Feb 15, 2018 12:45 PM by Kris Markee RSS

    NPrinting 17 - accessing the postgres database

    Kris Markee

      I'm hoping someone will have some info on this topic and/or offer some suggestions.  We are using QV 12 and NP 17 and would like a way to explicitly determine if a NP Publish Task was in fact successful (NOT just attempted) so that we can take that data and then import it into our QV app to set some flags and do some other analysis. Are any of these ideas below feasible or does anyone have other experiences or suggestions?  Thanks.

       

      Idea 1:  If possible, access and query the NP postgres database with the hopes that all task statistics are stored in it, which we can then use as a datasource for our QV app.  If we can connect, can you provide info on "how to"?

       

      Idea 2:  Dump the report output to a network location and have my QV app look to see that reports exist there for the day.

        • Re: NPrinting 17 - accessing the postgres database
          Ruggero Piccoli

          Hi,

           

          To retrieve information about Tasks you can use Qlik NPrinting APIs https://help.qlik.com/en-US/nprinting/November2017/Content/Extending/Intro-Extending.htm. In particular task executions APIs returs the status of tasks https://help.qlik.com/en-US/nprinting/November2017/APIs/NP+API/index.html#TaskExecutions

           

          We strongly suggest to connect to the PostgreSQL database only if you are aware of what you are doing. There is the risk that an error compromises the Repository so, first of all, create a backup and keep it updated. Then connect to PostgreSQL.

           

           

          Best Regards,

          Ruggero

          ---------------------------------------------

          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

            • Re: NPrinting 17 - accessing the postgres database
              Kris Markee

              So even just simply querying the database is risky?

                • Re: NPrinting 17 - accessing the postgres database
                  Ruggero Piccoli

                  When you install the Repository you create only one PostreSQL user with administrative rights. So the first connection to the DB can be done only with that superuser. If you do the wrong actions with a superuser you can damage the repository and compromise Qlik NPrinting. The only way to restore it is by using a backup.

                   

                  So if you are skilled with PostgreSQL you already know how to connect, you already know that you must create a backup before and you know how to create a new PostgreSQL user with only querying rights. If you don't already know these information my suggestion is to avoid to connect to avoid the risk to damage your Qlik NPrinting installation or to ask to an expert to assist you.

                   

                  If you want to connect in any case you can but you'll do at your own risk.

                   

                   

                  Best Regards,

                  Ruggero

                  ---------------------------------------------

                  When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.