Prerequisites for MySQL database

This section is applicable only when MySQL is being used as a backend or log database. In case you are using MS SQL or Oracle as backend or log database then you can skip this step.

If you are using MySQL as a backend/log database and applying the latest patch 'AdeptiaSuite_6_9_8_04_30April2020.zip' on the tags mentioned below then follow the steps below before applying the patch.

• Release_AS_6_9_8_06March2020

Steps to remove the manual changes from server-configure.properties file:

1. Go to .../<AdeptiaInstallFolder>/AdeptiaServer/ServerKernel/etc location.
2. Open server-configure.properties file.
3. Go to Database Configuration section and do the following changes:
   • Update the property 'abpm.jdo.driver' value as com.mysql.jdbc.Driver.
   • Update the property 'abpm.jdo.url' by removing the value ?useSSL=false&serverTimezone=<time zone> at the end of the URL.
4. Go to Database Appender section and do the following changes:
   • Update the property 'log4j.appender.jdbc.dbclass' value as com.mysql.jdbc.Driver.

   • Update the property 'log4j.appender.jdbc.url' by removing the value ?useSSL=false&amp;serverTimezone=<time zone> at the end of the URL.

5. Save the file.
   
   

Steps to remove the manual changes from qaurtz.properties file:

1. Go to .../<AdeptiaInstallFolder>/AdeptiaServer/ServerKernel/etc location.
2. Open quartz.properties file.
3. Go to Configure Datasources section and do the following changes:
   • Update the property 'org.quartz.dataSource.aBPM.driver' value as com.mysql.jdbc.Driver.

   • Update the property 'org.quartz.dataSource.aBPM.URL' by removing the value ?useSSL=false&serverTimezone=<time zone> at the end of the URL.

4. Save the file.

1. Download the latest patch from the provided URL.
2. Extract the downloaded zip file in a folder.
3. Open the Command Prompt.
4. Go to the folder where you have extracted the zip file.
5. Run the following command to apply the patch:
   

   Apply-Patch.bat "<Path where Adeptia Suite is installed till AdeptiaServer folder>" 

   For example:

   Apply-Patch.bat "C:/Program Files/AdeptiaSuite/AdeptiaSuite-x.x/AdeptiaServer"

   Once the patch is applied, a confirmation message will be displayed.

6. Start Kernel and WebRunner. 

1. Open the Terminal.
2. Download the latest patch from the provided URL.
3. Extract the downloaded zip file in a directory.
4. Go to the directory where you have extracted the zip file.

5. Run the following command to apply the patch:

   ./Apply-Patch.sh <Path where Adeptia Suite is installed till Adeptia Server folder> 

   For example:

   ./Apply-Patch.sh /mnt/AdeptiaSuite-x.x/AdeptiaServer

   Once the patch is applied, a confirmation message will be displayed.

6. Start Kernel and WebRunner.

• Patch application may take some time, in case there are a large number of records in the backend and log database.
• A PatchApplicationLog<Date>.log file is also created inside the logs folder. The logs folder is available in the same folder from where you have applied the patch. PatchApplicationLog_<Date>.log file contains the logs generated during patch application and can be used to troubleshoot any issue related to the patch application.
  
• After applying the patch, clear the browser history before login to Adeptia Suite.
• Clear the Java cache and the previous certificate of Adeptia from Java Control Panel. Click here to know how to clear Java cache and delete Adeptia certificates.
• If any error occurs during patch deployment then the patch will be recovered automatically.