6 Replies Latest reply: Jul 25, 2014 2:30 AM by Sachin Gupta RSS

    How to know a sevice pack already installed to Primavera

    2719522

      Good day everyone,

       

      I'm currently take over to support Primavera (P6 V7) at my organization, I dont know the previous guys already installed service pack for this product or not.

      Anybody know how to check a service pack already installed for the product? and how to check from database that the service pack also already applied to database as well?

       

      Thanks,

       

      Han

        • 1. Re: How to know a sevice pack already installed to Primavera
          Sachin Gupta

          Hi Han,

           

          You can review the below doc id

           

          How To Determine The Project Management (P6 Professional) Client, Database, P6 Web Access and Progress Reporter Version (Doc ID 914490.1)

           

          Basically you can verify it from P6 Client (Click: Help, About Primavera..., About (tab)). Alternatively from the database "select database_version from prefer;"

           

          Let me know if this is not what you were looking for,

           

          Regards,
          Sachin Gupta

          • 2. Re: How to know a sevice pack already installed to Primavera
            Wang Xin - Oracle

            #1. From application, go to Help -> About Primavera, and System tabe

            i.e

             

            PMDB Release 7.0 SP3(0700.0001.0001.0003)

             

            #2. From database

            select database_version from prefer;


            Thanks

            Wang

            ========
            Was our answer helpful?

             

            If so, highlight the information for other Community members by rating it or marking the answer as correct.

             

            Just hit the “Correct Answer” link on the answer, or rate it by clicking "Helpful Answer" or "Like".


            • 3. Re: How to know a sevice pack already installed to Primavera
              2719522

              Thanks Sachin, Wang,

               

              Seem that all I need to know. My software is under SP2:

               

              About: Primavera P6 Project Management

              Release: 7.0 SP2

              ID#:00022043

              Module: P3C

              Username: admin (Adminstrator);<Admin Superuser>

              PM Database: PMDB: SQLServer (admin, .\[...])

              MM Database: MMDB: SQLServer ()

              Database Schema Version: PMDB,0700.0001.0001.0002

               

              However, I check on DocID  (Doc ID 914490.1), seem the database version is PMDB,0700.0001.0001.0002 does not speak a lot of thing to me coz it could be Release 7.0, or 7.0 SP1, or 7.0 SP2.

               

              PMDB Release 7.0 SP5(0700.0001.0001.0004)
              PMDB Release 7.0 SP4(0700.0001.0001.0003)
              PMDB Release 7.0 SP3(0700.0001.0001.0003)
              PMDB Release 7.0 SP2(0700.0001.0001.0002)
              PMDB Release 7.0 SP1(0700.0001.0001.0002)
              PMDB Release 7.0(0700.0001.0001.0002)

               

              So how can I know exactly this is the upgrade version SP2? (I just to make sure my previous guys did the upgrade the service pack for database as well)

               

              Regards,

               

              Han Nguyen

              • 4. Re: How to know a sevice pack already installed to Primavera
                Sachin Gupta

                Hi Han,

                 

                Looking at the database alone it is difficult to conclude. However P6 client is on SP2. I think there will be compatibility issue if both database and P6 client are not on same service pack.

                 

                One way to handle this situation could be that you apply latest service packs to both database and P6 client so you are sure of the versions.

                 

                Regards,

                Sachin Gupta

                • 5. Re: How to know a sevice pack already installed to Primavera
                  2719522

                  Hello Sachin,

                   

                  I don't think will be compatipility issue because we have a lot of users are sharing this database, some of them still using Release 7.0 and some using 7.0 SP2.

                   

                  I assump that Release 7.0, 7.0 SP1, and 7.0 SP2 are compatible with PMDB,0700.0001.0001.0002; Release 7.0 SP3, and 7.0 SP4 are compatible with PMDB,0700.0001.0001.0003; and Release 7.0 SP5 is for PMDB,0700.0001.0001.0004...

                   

                  Thanks,

                   

                  Han Nguyen

                  • 6. Re: How to know a sevice pack already installed to Primavera
                    Sachin Gupta

                    You are right Han. Not all service packs contains updates to the database.

                     

                    Regards,
                    Sachin Gupta