SDP MSP solution for postgres 11 upgrade issues

SDP MSP solution for postgres 11 upgrade issues


  • When ServiceDesk Plus MSP is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens.
 
To ensure efficiency in Postgres 11.17, make sure your Windows is updated to the Windows Server 2019 or later. Refer here for more details.
 
  • Missing libraries in Windows machines may lead to upgrade failure. So, make sure your system is installed with important updates from Microsoft, such as Universal C Runtime.
 
  Windows Server that is not up to date may look as follows:
                                                            
      
A fully updated Windows Server will look as follows :
                                                              
 
 

Steps to Install Windows Updates:

             Step 1: Click Start and type "Windows Update" in the search bar.

            Step 2: Under Windows Update Settings, click "Check for updates".

            Step 3: Windows will check for updates and display any available updates.

            Step 4: Click "Install updates" to start the update process.

            Step 5: Windows will download and install the updates. This process may take several minutes or longer, depending on the size and number of updates.

            Step 6: After the updates have been installed, you may be prompted to restart your computer. If so, click "Restart now" to complete the update process.

If you facing the same issue after updating to latest windows updates, you may have missing updates for Universal C Runtime Libraries.

                  New to ADManager Plus?

                    New to ADSelfService Plus?

                      • Related Articles

                      • 10.5 Linux Upgrade failure and solutions

                        Traces in logs : 1. java.lang.Exception: InitPgsqlScript exited with value :: 1 at com.adventnet.persistence.PostgresPreProcessor.executeInitPgsqlScript(PostgresPreProcessor.java:1733) 2. PGSQL Permission related errors. 3. SDP MSP installed as root ...
                      • Upgrade failure to 10500 - Linux platforms

                        You may experience an upgrade failure in linux platforms when upgrading to 10500. Here are the traces from logs, Feb 21, 2020 4:55:03 PM  [com.adventnet.tools.update.installer.Unzipper]  [SEVERE] : ERRUnexpected Error. Please click View Log>> for ...
                      • Upgrade issue from 14200 to 14300 (LINUX)

                        We have a prerequisiste that when upgrading SDP MSP from version 14200 to 14300 in a Linux environment the GNU C library should be upgrade to version 2.14 or above -> Sometime even if you have upgraded your GNU C library to the 2.14 or above the ...
                      • SCP, SDP and MSP Differences

                        Though ManageEngine has multiple HelpDesk applications, they are developed and targeted for Different markets. Here are few cases to understand the difference between them. HelpDesk Applications in ManageEngine (ME) are as follows :  1. SupportCenter ...
                      • Upgrade Failed -> Reverting steps

                        This article covers 2 areas : a) Analysis stage b) Reversion steps (rollback) a) Analysis stage Please send the below files to our support for analysis: 1. Zip the complete log folder present under <servicedesk plus msp home>/server/default or from ...