Upgrade from PPS v1 to v2

  1. You have the version V_PPS_001.00X.00X_STOLL of PPS installed and want to update to V_PPS_002.00X.00X_STOLL. Since the database version has changed, you must migrate the PostgreSQL database from 9.5-10 to 15.5-1.

    Several steps are necessary to migrate. Steps 3-8 are automated to the extent that you just need to click through them in the preset order.

    Before you start, check if there are any temporary files similar to this 0_ffff7f000001_6badf352_63f5cf83_8f1802 are staying in the D:\PPS\PpsJBossServer\standalone\data\tx-object-store\ShadowNoFileLockStore\defaultStore\StateManager\BasicAction\TwoPhaseCoordinator\AtomicAction folder.
    In this case, please contact the service first before proceeding.
    Migration is not possible with open transactions.
    These open transactions must be cleared first.
    1
    Copy PpsInstallation (V_PPS_002.000.002_STOLL)_PG15.5eff or higher e.g. to nach D:\

    Copy PpsUpdate (V_PPS_002.000.002_STOLL)_PG15.5eff or higher to nach D:\PPS\PpsJBossServer\PpsServerInstallScripts\.
    2
    Save the current standard backup in a safe location in a folder with the name of the current PPS version and DB version.
    Example: PpsBackup\BackupBeforeUpdate\PpsV1.10.6_PG9510
    3
    Create a special backup with D:\PpsInstallation (V_PPS_002.000.002_STOLL)_PG15.5eff\SKR\upgrade_skript\BackupDb4Upgrade.bat.

    The backup will usually be saved to D:\PpsDbBackup4Migration. When asked for the path, you can press Enter if the drive D:\ exists and still has a few GB of free disk space. Otherwise, enter another path.
    4
    Uninstall the entire PPS via Windows Apps.


    Keep the DB of SNS and SKR3 if you are asked to delete them.

    Select No.


    Select No.

    Even if you chose to delete the SNS database when uninstalling SNS, it will still be included in the default backup and can be restored later using the backup program (How to Restore the PPS and SKR3 or the SNS Database).
    To uninstall PPS, the former PPS installation package must be in the same storage location from where it was installed.
    5
    Execute the new PPS installation PpsInstallation (V_PPS_002.000.002_STOLL)_PG15.5eff\PPSSetup\setup.exe (Installation of the PPS Server Suite).
    6
    Restore the database backup created in step 3 with PpsInstallation V_PPS_002.000.002_STOLL)_PG15.5eff\SKR\upgrade_skript\RestoreDbAfterUpgrade.bat.

    If the displayed path to the backup folder is the same as in step 3, just press Enter.
    Otherwise, enter the correspondent path.
    7
    Execute the D:\PPS\PpsJBossServer\PpsServerInstallScripts\PpsUpdate (V_PPS_002.000.002_STOLL)_PG15.5eff\Pps_Start_Update_Batch.bat update with with admin rights (Updating the PPS Server Suite).
    This is necessary because the imported database from the previous step was created with the Postgres 9.5-10 DB, inserts Stored Procedure and additional tables have to be adjusted for the DB 15.5-10 \ PPS 2.0.2.
    Use the option U of the Update-Batch-Menu to start the update.
    8
    Use the option S of the Update-Batch-Menu to start the PPS after the update is done. Or start the StollPpsServer in the Service Manager.
    9
    Check the configuration of the PPS Backup Program (How to Backup the PPS Database).
    Is the backup program enabled and the backup path correctly configured?
    10
    Verify that access to the Postgres DB is enabled in D:\SKR3_DB_15\DB_Root\PG_15\pg_hba.conf for all clients that require access.
    You will find the former pg_hba.conf files under:
    D:\PPS\PpsJBossServer\PpsServerInstallScripts\PpsLast\PpsSwUsedTillSetup_<date_time>\SKR3_DB\DB_9_4_Root
    Example:


    You can copy the client entries from the pg_hba.conf file.
    11
    If the PosgreSQL ODBC driver is installed on clients that have used access to the database, reinstall the driver (...\ODBC\Driver\psqlodbc-setup.exe).
    12
    Copy the D:\PPS\PpsJBossServer\PpsServerInstallScripts\ODBC-DefaultConnectionSetup1500.reg file from the PPS directory to the clients and run the file.

    This provides the basic settings for access to the database. Open the Windows programs ODBCad32.exe and ODBCad64.exe, adjust the server settings (localhost) to your PPS server and click on Test Connection.
    13
    If nothing unusual appears after a few weeks, you can remove the folders D:\PpsDbBackup4Migration and D:\SKR3_DB.
  1. PPS should now work again with the new database and new PPS.