Release 19.1.0.0.6_MLR32849357

Bug 32845653: ENHANCE TOJSON PATTERN WITH OUTPUT JSON

Enhanced the ToJson pattern to upload a sample JSON file which will be used to infer JSON path for field mapping.

Bug 32647810: INCREASE THE STRING LENGTH IN CQLENGINE

Fixed the CQLEngine restriction of 1024 characters for attribute of type string. Increased the attribute length to allow 4096 characters.

Bug 32820171: NULL VALUES SEEN ON SELECTING ENABLE BATCHING IN TOJSON PATTERN

Fixed an issue in which the new event values showed null in the Live Output table, on clicking the Enable Batching option after adding a ToJson pattern to an event stream.

Bug 32845715: FIX TO IGNORE DELIMITED COLUMN HEADER AND DISABLE CHARACTER ESCAPING

Enabled an option to ignore the column header, while writing the delimited text using GGBD handler. This fix also disables escaping of characters while writing JSON string as a delimited text.

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 32870972: WRITING TO KAFKA TARGET FAILS IF THE FIELD_PATH AND FIELD_NAME ARE DIFFERENT

Fixed the writing to Kafka target failure issue, when the field_path and field_name are different.

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 32853397: STREAMING ANALYTICS FAILED TO START PIPELINE. : UNCAUGHT EXCEPTION. : 1024

Fixed the Failed to start pipeline. : Uncaught exception. : 1024 error when configuring a pipeline.

Bug 32894915: KAFKA GROUPAUTHORIZATIONEXCEPTION: NOT AUTHORIZED TO ACCESS GROUP

Fixed the user authorization to access group issue with the error GroupAuthorizationException: Not authorized to access group.

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.

Bug 32873823: OSA INSTALLER FAILS WITH ADW METADATA STORE WITH ERROR CODE ORA-64308

Fixed the issue where the OSA installation fails with ADW metadata configuration, while running the sql script seedSchema-19.1.0.0.6.sql, with error ORA-64308: hybrid columnar compressed table cannot have column with LONG data type.