Release 19.1.0.0.5_MLR32849350

Bug 32251429: ISSUE WITH PIPELINE DEPLOYMENT WITH MULTIPLE TARGETS

Fixed the pipeline deployment failure issue for pipelines with multiple targets.

Bug 32251367: HOT DEPLOY ISSUE WITH SSL ENABLED KAFKA SETTINGS

Fixed the issue where the hot deployment of pipeline fails with SparkException, when SSL is enabled for Kafka system settings.

Bug 32613021: PIPELINE TERMINATES WHEN NESTED JSON HAS NULL VALUE

Fixed the terminating of pipelines when the input nested JSON data has a null value.

Bug 32647925: PERFORMANCE ISSUE WITH DB TARGET AND REFERENCE

Enhanced the validation performance while writing to a Database Target and Reference.

Bug 32647546: WRITING TO OCI TARGET FAILED WITH JSON WITH NULL VALUES

Fixed issue where a pipeline fails with NullPointerException exception while writing to an OCI target, when input JSON data has null values.

Bug 32712524: PUBLISHED PIPELINE GETS KILLED WHILE WRITING TO REST ENDPOINT IF RECORD HAS DIACRITIC CHARACTERS

Fixed the issue where the published pipeline is killed while writing to a REST target, when data in input JSON contains a string value with characters with diacritics: ě¿čř¿ýáíé (valid UTF-8 characters).

Bug 32375359 - BIG DECIMAL ROUNDING NECESSARY EXCEPTION

Fixed the issue where a pipeline fails with an NullPointerException, when the input JSON has a big decimal value with scale greater than 56. Now the default supported precision and scale is 64.

Bug 32669536: INCORRECT QUERY GENERATED FOR CURRENT AND PREVIOUS PATTERN

Fixed the issue where an incorrect query is generated when more than one partition field is selected in the Current and Previous Events pattern.

Bug 32846444: MAKE JDBCSINK QUERY TIMEOUT CONFIGURABLE

Set the JDBC sink query timeout as a configurable parameter from the osa_system_property table. The property that needs to be inserted into the osa_system_property table is mkey=com.oracle.cep.adapters.jdbc.JdbcSink.QueryTimeout.

Bug 32850867: OSA INSTALLER FAILS WITH ORACLE DB METADATA STORE

Fixed the issue where the metadata store user creation fails when the password has a special character like '@', while configuring Oracle metadata store. The metadata store password is the password that is configured in the jetty-osa-datasource.xml file.

Bug 32872055: NULLPOINTEREXCEPTION AND NOSUCHELEMENTEXCEPTION WHILE COMMITTING THE OFFSET TO OSA INTERNAL TOPIC

Fixed the NullPointerException and NoSuchElementException issue arising while committing the offset to OSA internal topic.

Bug 32887340: ALLOW COLUMNS TO BE DROPPED IN THE DATABASE TARGET TYPE

Fixed the UI to allow columns to be dropped in the Database target type. At runtime the insert statement only specifies columns in the shape.

Bug 32754024: NO SPACE LEFT ON DEVICE- CHANGE SPARK WORKING DIRECTORY

The fix is to ensure that the correct pipeline status is reflected after changing the Spark working directory.

To change the Spark working directory:

Stop Spark service:
1. sudo systemctl stop spark-slave.service
2. sudo systemctl stop spark-master.service
Create work directory under u02:
1. Navigate to /u02
2. sudo mkdir spark. Here spark is the work folder name, you can create folder with the name of your choice.
3. chmod 777 spark, to change permission.
Edit spark-env.sh
1. Navigate to SPARK_HOME/conf, and edit spark-env.sh
2. Add SPARK_WORKER_DIR=/u02/spark at the end of the file spark-env.sh to point to newly created folder under /u02
Start Spark service:
1. sudo systemctl start spark-master.service
2. sudo systemctl start spark-slave.service
You will see the application and driver data ( files and logs) under /u02/spark when you publish the pipeline again.