[ONE-OFF] (7.10.1) Long running query at kie-server startup

PATCH NAME:
RHPAM-3909
PRODUCT NAME:
Red Hat Process Automation Manager(rhpam)
VERSION:
7.10.1.GA
SHORT DESCRIPTION:
Long running query at kie-server startup
LONG DESCRIPTION:
One-off patch for RHPAM-3909 - Long running query at kie-server startup
https://issues.redhat.com/browse/RHPAM-3909

MANUAL INSTALL INSTRUCTIONS FOR ALL PLATFORMS:

1. Backup and remove the following jar:

$SERVER_DEPLOYMENT_DIR/business-central.war/WEB-INF/lib/kie-soup-dataset-sql-7.48.0.Final-redhat-00006.jar

2. Unzip the file jboss-rhba-7.10.1-RHPAM-3909.zip and copy:

RHPAM-3909/kie-soup-dataset-sql-7.48.0.Final-redhat-00006.jar

to:

$SERVER_DEPLOYMENT_DIR/business-central.war/WEB-INF/lib
$SERVER_DEPLOYMENT_DIR/kie-server.war/WEB-INF/lib

MANUAL INSTALL INSTRUCTIONS FOR MAVEN BASED PROJECTS:

1. Extract the attached zip (jboss-rhba-7.10.1-RHPAM-3909.zip) and change into the RHPAM-3909 directory

2. Run the following commands to install the patch binaries to the local maven repository:

       $ mvn install:install-file -Dfile=kie-soup-dataset-sql-7.48.0.Final-redhat-00006-RHPAM-3909.jar -Dsources=kie-soup-dataset-sql-7.48.0.Final-redhat-00006-RHPAM-3909-sources.jar -DgroupId=org.kie.soup -DartifactId=kie-soup-dataset-sql -Dversion=7.48.0.Final-redhat-00006-RHPAM-3909 -DpomFile=kie-soup-dataset-sql-7.48.0.Final-redhat-00006-RHPAM-3909.pom -Dpackaging=jar

3. Override the original version of modified jars explicitly declaring them in <dependencyManagement> of your project pom.xml:

<dependency>
<groupId>org.drools.drools-workbench-models</groupId>
<artifactId>drools-workbench-models-guided-dtable</artifactId>
<version>7.33.0.Final-redhat-00002-RHPAM-3909</version>
</dependency>

ADDITIONAL INSTALL INSTRUCTIONS FOR ALL PLATFORMS:

Find and replace kie-soup-dataset-sql-7.48.0.Final-redhat-00006.jar with the patched jar kie-soup-dataset-sql-7.48.0.Final-redhat-00006-RHPAM-3909.jar
for all occurences of that file in your project.

SUPERSEDES:

SUPERSEDED BY:
N/A

CREATOR:
Alberto Fanjul
DATE:
20-Sep-2021