Patch Information Note 12.0.30
Note
This patch is a cumulative patch for version V12.0.20 and above. The minimum version required to apply this patch is V12.0.19.
- To install the patch: This cumulative patch will update your solution to the current patch in a single step.
- To install the technical components and perform manual actions: Check the documents from the previous releases using the Index or Previous/Next links. Depending on your current version, you may need to install other components or perform other manual actions to complete this update.
Installation of mandatory technical components
Configuration console
Console_2.54.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named CONSOLE_2.54.0_ENG.htm or CONSOLE_2.54.0_FRA.htm.
Important: The setup file must be executed locally. Make sure to download the setup file locally to the workstation where the Console is installed or updated. Otherwise, a blocking error message can be triggered during the setup process, but the installation will still be completed.
Adxadmin administration server
Adxadmin_94.1.17.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named ADXADMIN_94.1.17_ENG.htm or ADXADMIN_94.1.17_FRA.htm.
Process server
Runtime_94.1.17.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named RUNTIME_94.1.17_ENG.htm or RUNTIME_94.1.17_FRA.htm.
Syracuse server
SyracuseServer_12.15.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named SYRACUSESERVER_12.15.0_ENG.htm or SYRACUSESERVER_12.15.0_FRA.htm.
Print server
Print server_2.26.0.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named PRINTSERVER_2.26.0_ENG.htm or PRINTSERVER_2.26.0_FRA.htm.
Important: The setup file must be executed locally. Make sure to download the setup file locally to the workstation where the Console is installed or updated. Otherwise, a blocking error message can be triggered during the setup process, but the installation will still be completed.
Installation of recommended technical components
VT web server
VTWebServer_2.40.1.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named VTWEBSERVER_2.40.1_ENG.htm or VTWEBSERVER_2.40.1_FRA.htm.
Elasticsearch
You can use Elasticsearch 7.16.2 with Sage X3.
Note: Although Sage X3 remains compatible with previous releases, Sage strongly recommends that you install this latest version.
MongoDB
Mongodb_4.4.12.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named MONGODB_4.4.12_ENG.htm or MONGODB_4.4.12_FRA.htm.
Notes:
- The Sage X3 platform is compatible with MongoDB 4.4. If you are using a previous version of MongoDB, Sage strongly recommends that you upgrade it.
- To install the MongoDB 4.4 upgrade, MongoDB 4.2 must be running. You need to check your MongoDB version and update it to version 4.2, if necessary.
- If you're using an Oracle JAVA platform, please note that the prerequisites have evolved. Refer to the How to upgrade to MongoDB 4.4 documentation for more information.
Installation of other technical components
X3 Services (only for Sage X3, not Sage X3 HR & Payroll)
X3 Services is a new component used to manage Automatic Data Collection.
x3-services-17.0.37-win.zip file
Automated Test Platform (not for Sage X3 HR & Payroll)
The Automated Test Platform is a technical licensed component used to create automated tests for Sage X3 products using Cucumber tools.
atp-2.7.0-win.zip file
- Download the file.
- Unzip the file and follow the instructions provided in the file named ATP_2.7.0_ENG.htm or ATP_2.7.0_FRA.htm.
Technical manual update (Oracle database 12.1)
If your V12 solution has already been installed with version 12.1 of the Oracle database, check the value of the deferred_segment_creation parameter:
- Enter the following command: show parameter deferred_segment_creation.
If the value is true, you have to manually set it to false:
- Launch a system connection with sqlplus: rlwrap sqlplus system/...
- Modify the system by changing the spfile init file: alter system set deferred_segment_creation=FALSE scope=spfile.
- Restart the database.
Installation of the patch
x3-patch-12.0.30.zip file for Sage X3; x3hr-patch-12.0.30.zip file for Sage X3 HR & Payroll.
The patch must be updated from the Updates function of the Syracuse server (Administration > Utilities > Update > Updates).
The .zip file contains:
- DELIVERY: for externalized resources
- DIVPAT_Pxx: for presettings (Pxx related to the patch)
- FILES: for standard patches
- INDPAT_Pxx: for additional translations (Pxx related to the patch)
- LAN: for standard patch translations except FRA-ENG
Manual actions (only for Sage X3, not Sage X3 HR & Payroll)
Web service CWSGPRTRPT
Printing a Crystal report from a Mobile Automation page
To use this web service, perform the following actions in Sage X3:
1. Open Administration > Administration > Web services > Classic SOAP pools configuration and stop the web service pool.
2. Open Development > Script dictionary > Scripts > Web services (GESAWE) and publish the CWSGPRTRPT web service.
3. Open Administration > Administration > Web services > Classic SOAP pools configuration and start the web service pool.
Evolution of the PRINC and PYODD automatic journals for payment posting
Setup > Financials > Accounting interface > Automatic journals (GESGAU)
The lines below have been updated in the PRINC and PYODD automatic journals.
PRINC automatic journal:
- Line 10, General section, Condition field
The 2nd triggering condition has been modified:
- Old value: [F:PYH]CUR=[F:PYD]CURLIN or [F:PYD]CURLIN=func CPTINIVAR.DEVMAINLED([F:PYH]CPY)
- Updated value: [F:PYH]CUR=[F:PYD]CURLIN or ([F:GAC]FRWCUR<>2 & [F:PYD]CURLIN=func CPTINIVAR.DEVMAINLED([F:PYH]CPY))
- Line 19, General section, Condition field
The 2nd triggering condition has been modified:
- Old value: [F:PYH]CUR<>[F:PYD]CURLIN & [F:PYD]CURLIN<>func CPTINIVAR.DEVMAINLED([F:PYH]CPY)
- Updated value: [F:PYH]CUR<>[F:PYD]CURLIN & ([F:GAC]FRWCUR=2 or [F:PYD]CURLIN<>func CPTINIVAR.DEVMAINLED([F:PYH]CPY))
PYODD automatic journal:
- Line 10, General section, Condition field
The 2nd triggering condition has been modified:
- Old value: [F:PYH]CUR<>[F:PYD]CURLIN & [F:PYD]CURLIN<>func CPTINIVAR.DEVMAINLED([F:PYH]CPY)
- Updated value: [F:PYH]CUR<>[F:PYD]CURLIN & ([F:GAC]FRWCUR=2 or [F:PYD]CURLIN<>func CPTINIVAR.DEVMAINLED([F:PYH]CPY))
- Line 20, General section, Condition field
The 2nd triggering condition has been modified:
- Old value: [F:PYH]CUR<>[F:PYD]CURLIN & [F:PYD]CURLIN<>func CPTINIVAR.DEVMAINLED([F:PYH]CPY)
- Updated value: [F:PYH]CUR<>[F:PYD]CURLIN & ([F:GAC]FRWCUR=2 or [F:PYD]CURLIN<>func CPTINIVAR.DEVMAINLED([F:PYH]CPY))
For these two automatic journals, the GACCOUNT table and its ACC field have been added to the Linked table list grid, both in the header and at line level.
Automatic journals are integrated into the X3 parent folder only.
Before copying them manually to the X3 operating folder from the Automatic journals function (GESGAU), start the Automatic document comparison (CMPGAU) to identify your variances.
Miscellaneous table 204
Development > Data and parameters > Miscellaneous tables > Definition (GESADV)
The definition of miscellaneous table 204 - Manual hold reasons has been updated.
The description of the second numeric column has been changed to 'Block BTB' (Block back-to-back). This update has been implemented in the X3 folder only by patch 635.
If you want to get this update in your application folder, open miscellaneous table 204 (ADV object) and enter the description from the X3 folder (in your connection language) on the second line of the Description column in the Numeric columns grid.
Documents
Readme files
- For technical components: Readme-Components-ENG-12.0.30.html
- For the application patch: Readme-X3-X3HR-ENG-12.0.30.html