7 Replies Latest reply on Jul 26, 2019 12:10 AM by Ralph Wittig

    Hotfix Installation Question

    Ryan Jenson Seasoned Veteran
    Ryan Jenson Jul 9, 2019 8:37 AM

      Hello everyone,

       

      I am attempting a hotfix from 8.0.03.01 to 8.0.03.07 as there are separate complications with Hotfix 8 in our environment to be addressed at a later time. After visiting the provided link on the Product 360 Hotfix 7 blog post and downloading all "8.0.03.07" installations from the Informatica downloads section, I'm a little bit confused.

       

      The download links here appear to be full distributions and are not specifically hotfixes/just the files which have been changed. Are these the proper files to download for a basic hotfix?

       

      Using the full installation files I had migrated them into the /Informatica/PIM/ directory and merged/replaced/re-customized where necessary. The "Informatica MDM - Product 360 v8.0" service will not start (all other INFA services resume correctly). Checking the error logs, it appears that there should be some changes made to the PIM_MAIN database but none of the .zip files included a SQL update script. Full .error.log attached. Is there somewhere to look for such a script?

       

      Does anyone have some insight that I am missing? Anything would help!

       

      Environment (dev):

      Windows Server 2012 R2 (64 bit)

      PIM (32 bit) 8.0.03.01 - 8.0.03.07

        • 1. Re: Hotfix Installation Question
          Stefan Reinhardt Guru
          Stefan Reinhardt Jul 9, 2019 8:44 AM (in response to Ryan Jenson)

          Hi Ryan,

           

          this is how the package of 8.0.03.07 internally looks for me:

          Core package includes the DB client setup archive. Does that reflect what you are seeing as well?

           

          Best,

          Stefan

          • 2. Re: Hotfix Installation Question
            Ryan Jenson Seasoned Veteran
            Ryan Jenson Jul 9, 2019 8:59 AM (in response to Stefan Reinhardt)

            Hi Stefan,

             

            Yes, the downloads look just like that. To install

            • I uploaded PIM_8.0.03.07_Core.zip (and installed) to Clusterix,
            • Disabled all INFA services.
            • Copied the contents of PIM_8.0.03.07_Core.zip and similarly .zips into the main /PIM/ directory
              • These subdirectories are the specific ones copied in:
            • Adjusted the new files to reflect prior customization if needed

             

            All services aside from Product 360 itself seem to be functioning as normal. Rolling the /Informatica/PIM/ root folder back to its pre-installation contents successfully allows PIM 8.0.03.01 to open again.

            • 3. Re: Hotfix Installation Question
              Stefan Reinhardt Guru
              Stefan Reinhardt Jul 9, 2019 9:02 AM (in response to Ryan Jenson)

              Then I guess a support case with GCS may be the best option to do go forward here (despite upgrading to 8.1.1 ).

               

              But please share back what you learned with us here after if possible.

               

              Thanks,

              Stefan

              1 of 1 people found this helpful
              • 4. Re: Hotfix Installation Question
                Ryan Jenson Seasoned Veteran
                Ryan Jenson Jul 9, 2019 9:10 AM (in response to Stefan Reinhardt)

                Ok Stefan, thanks for the help!

                 

                We will be upgrading to 8.2 shortly after release. This hotfix is more of a test/learning experience to prep for future HFs as the environment is expecting a large scale overhaul anyway ("why not give it a shot" kind of a deal).

                • 5. Re: Hotfix Installation Question
                  Stefan Reinhardt Guru
                  Stefan Reinhardt Jul 9, 2019 9:13 AM (in response to Ryan Jenson)

                  Sounds good. However 8.0.03 is really an old release. A learning experience going a bit higher like 8.0.6 would potentially also be an option in case you'd feel stuck here in the end.

                  • 6. Re: Hotfix Installation Question
                    Ryan Jenson Seasoned Veteran
                    Ryan Jenson Jul 25, 2019 11:15 AM (in response to Stefan Reinhardt)

                    Been up and stable for long enough to submit a reply:

                     

                    The /dbclient/Database.exe needed to be run. I intentionally did not run it (until instructed by GCS) for fear it would wipe the databse and create a new one. After successfully running the .exe and making a few adjustments to the repo.repo files PIM is now hotfixed on both environments.

                     

                     

                    I think going forward it would be smart to contact GCS for confirmation that Database.exe won't drop the whole database...if for nothing but a second opinion.

                    • 7. Re: Hotfix Installation Question
                      Ralph Wittig Guru
                      Ralph Wittig Jul 26, 2019 12:10 AM (in response to Ryan Jenson)

                      Hi Ryan,

                       

                      when ever there is a DB installer in the Hotfix/EBF that one must be executed and there will no new DB created as long as you are using the same server.properties with your existing one.

                      He will only check and run the needed Updates and recreated SPs and so on. There is no drop DB in it so no danger.

                       

                      As always you should take a Update but that should be a normal step

                       

                      Best Regards

                       

                      Ralph

                      1 of 1 people found this helpful