This section lists the prerequisites and steps for applying this patch.
Though every release of Adeptia comes with seamless upgrades and bug-free patches. For customer's complex use cases, we recommend applying the patch in a non-production environment first followed by testing. After the use cases run successfully without any errors or warnings, you can apply the patch in the production environment.
Prerequisites
Ensure that you have:
- You have Read and Write permissions on all sub-folders and files of .../AdeptiaConnect-<Version>.
- Services such as Kernel, WebRunner, and AIMap are stopped.
- Take backup of jetty.xml file from …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc\jetty location. This file will help you recover the patch manually, if required.
- No process flow or transaction should be in running, waiting or queued state.
Latest License details of Adeptia Connect. You can contact Adeptia Support for more details.
Applying the patch
Post Patch Deployment Steps
Changes in jetty.xml File
- Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc\jetty location.
- Open jetty.xml file.
- Update the sslContextFactory bean class value by adding $Server at the end.
- Add one Array type item as <Item>TLSv1.1</Item> to exclude the TLSv1.1 protocol.
- Save the file.
Changes in web.xml File
- Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\web\WEB-INF location.
- Take backup of web.xml file from the above-mentioned location.
- Go to the downloaded Adeptia Connect zip folder and rename the web.xml_Server file to web.xml.
- Copy the renamed web.xml file.
- Replace the existing file with the copied file at the following location: …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\web\WEB-INF.
- Open web.xml file.
- Do the same manual changes in the file that you have done in your previous web.xml file (that you had saved as a backup).
- Save the file.
Changes in server-configure.properties File
In case you are using MySQL as Backend and Log database then do the following manual changes.
- Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc location.
- Take backup of server-configure.properties file from the above-mentioned location.
- Open server-configure.properties file.
- Go to Database Configuration section and do the following changes:
- Update the property 'abpm.jdo.driver' value as com.mysql.cj.jdbc.Driver.
Update the property 'abpm.jdo.url' by appending the value ?useSSL=false&serverTimezone=<time zone> at the end of the URL.
- Append the value ?useSSL=false at the end of the URL. However, this argument is not required if SSL is configured on your MySQL database server.
- Append the value &serverTimezone=<time zone> at the end of the URL. For example, &serverTimezone=UTC+3:00. This argument is required only when an error related to the time zone is displayed while starting the Connect Kernel.
Here, <time zone> is the time zone of your MySQL server.
Save the file.
- Go to Database Appender section and do the following changes:
- Update the property 'log4j.appender.jdbc.dbclass' value as com.mysql.cj.jdbc.Driver.
Update the property 'log4j.appender.jdbc.url' by appending the value ?useSSL=false&serverTimezone=<time zone> at the end of the URL.
- Append the value ?useSSL=false at the end of the URL. However, this argument is not required if SSL is configured on your MySQL database server.
- Append the value &serverTimezone=<time zone> at the end of the URL. For example, &serverTimezone=UTC+3:00. This argument is required only when an error related to the time zone is displayed while starting the Connect Kernel.
Here, <time zone> is the time zone of your MySQL server.
Save the file.
Changes in quartz.properties File
In case you are using MySQL as Backend and Log database then do these manual changes.
- Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc location.
- Take backup of quartz.properties file from the above-mentioned location.
- Open quartz.properties file.
- Go to Configure Datasources section and do the following changes:
- Update the property 'org.quartz.dataSource.aBPM.driver' value as com.mysql.cj.jdbc.Driver.
Update the property 'org.quartz.dataSource.aBPM.URL' by appending the value ?useSSL=false&serverTimezone=<time zone> at the end of the URL.
- Append the value ?useSSL=false at the end of the URL. However, this argument is not required if SSL is configured on your MySQL database server.
- Append the value &serverTimezone=<time zone> at the end of the URL. For example, &serverTimezone=UTC+3:00. This argument is required only when an error related to time zone is displayed while starting the Connect Kernel.
Here, <time zone> is the time zone of your MySQL server.
- Save the file.
Restoring user-defined jars
With the new patch the launcher.properties file is updated and no longer has the list of jars in it. If you have defined your own jars in previous version of launcher.properties file, you need to move them to the ext folder to load them at the time of Kernel and WebRunner start up. Follow the steps below:
- Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc location.
- Open launcher-bak.properties file.
- Identify your jars and move those jars from their current location to the following location: …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\ext.
Update window services
If you have upgraded from Adeptia Connect v2.9.2 or earlier to the higher versions, you need to remove the existing windows services i.e. Adeptia Suite Kernel and Adeptia Suite WebRunner and add two new windows services (Connect Kernel and Connect WebRunner).
Follow the steps below to remove the older services:
- Open the Terminal as an administrator.
- Go to the …<ConnectServerInstallFolder>\jre\bin.
Run the following command to remove the old Windows services:
jsl -remove "…<ConnectServerInstallFolder>\ServerKernel\jsl-Kernel_Unregister.ini"
jsl -remove "…<ConnectServerInstallFolder>\ServerKernel\jsl-WebRunner_Unregister.ini"
Follow the steps below to add the new services:
- Open the Terminal as an administrator.
- Go to the …<ConnectServerInstallFolder>\jre\bin.
Run the following command to add the new Windows services:
jsl -install "…<ConnectServerInstallFolder>\ServerKernel\jsl-Kernel.ini"
jsl -install "…<ConnectServerInstallFolder>\ServerKernel\jsl-WebRunner.ini"
Go to windows services to check if these services have been added successfully. To start Adeptia Connect server, you need to start these two services.
Once the post patch deployment steps are done, start the services, i.e. Kernel, WebRunner, and AIMap.
- If you are using Database/Advanced Database Event, Source/Target activity with MySQL Database Server using an older version of MySQL JDBC jars then it is recommended to upgrade the jars to mitigate the vulnerability associated with the older jars.
Click here to download the recommended version of MySQL jars (mysql-connector-java-8.0.18.jar) and follow the steps to upgrade it. - If you are using Spazio Listener, Spazio Source, and Spazio Target then you have to copy active MQ jars in ext folder. Click here for detailed information.
Updating database info for CDATA drivers
If you are using any CDATA JDBC driver to connect with any business application such as salesforce, etc. then follow the steps below to update the database info:
- Login into Adeptia application.
- Edit the database info which is using CDATA driver.
- Save it.
Next Step