DB 39.5.23

21 Feb 2025

Stable 1 For DB 39.5.23

To install Stable 1 for DB 39.5.23, download the file DB 39.5.23_Stable1 from the transfer server, unzip it into the server directory and run the migration with the “DB23 Hotfix” component (i.e. under linux ./planta_migration.sh -c config/migration/db23_hotfix.par or under windows .\planta_migration.bat -c config\migration\db23_hotfix.par).

Go to Release Notes

Specific System Requirements for Update to DB 39.5.23

Before Update

Before updating to DB 39.5.23 under Oracle you have to grant access to DBMS_CRYPTO: GRANT EXECUTE ON SYS.DBMS_CRYPTO TO <user>
If you update from DB 39.5.19 - DB 39.5.21 to DB 39.5.23 under Oracle, you have to verify that the ICOU has been run correctly in earlier updates.

Further information

From S 39.5.36 Installer, Oracle systems are checked to see whether access to DBMS_CRYPTO is possible (see above). The update will not start if the rights are missing.
If the rights were already missing in the previous updates, the ICOU could not run correctly.
- This can be recognized by the fact that the migration package ApplyInCaseOfUpdate .
Before any update to DB 39.5.22 under Oracle you should therefore verify that ApplyInCaseOfUpdate has run correctly in the previous updates.
If it has failed, the reference tables in the system must be replaced prior to the update:
1) Download the reference status for the DB version from which you want to update from the transfer server under Current Releases > 39.5.x > Database > ICOU Reference Statuses and store it on the server.
2) Open module 009D18 Import Reference, store and import the path to the ZIP file.
3) After the import, close the system and run the update normally with the installer.
- DO NOT click on Find adjustments here! This step is carried out during the update.

After Update

Due to a technical change to improve the performance of the department absence data, manual execution of the mandatory migration package CalculateDepartmentAbsence is required after the update to version 39.5.23. This ensures that the absence data recorded before the update is still displayed in the module.
- Technical reason: To improve performance in the Absence (009AVH) and Department Absence (009ALC) modules, the DIs DI066000 Vacation incl. sub-resources and DI066001 Absence incl. sub-resources have been converted from virtual to real, therefore the absence values must be summarized once for all periods via the resource structure.
  - The execution of the migration package can take some time.

General Notes

Since release DB 39.5.17, PLANTA offers a new Online Help. If you update from a release < DB 39.5.17 and want to continue to use context sensitive help directly from within your system (F1/F2), or if your firewall only permits limited internet access, you have to make sure that the PLANTA project application server has least access to the IP address: 3.65.222.100.

Notes on update sources and component dependencies

A direct update to version DB 39.5.23 is possible from source versions DB 39.5.16 or higher. If you use an earlier version, you first have to update to version DB 39.5.16 and subsequently to version DB 39.5.23.
For an update to database DB 39.5.23, it is absolutely essential that you also update the server to version S 39.5.37 and the client to version C 39.5.34.
If you work with hybrid systems, please note that PLANTA project version 39.5.23 requires at least PLANTA pulse version 42.1.

If you have any questions, please contact your PLANTA consultant.

PLANTA project/portfolio and PLANTA Hybrid

Go to Release Notes

PLANTA customizer

Go to Release Notes

PLANTA link

Go to Release Notes