1. Release Notes for GoldenGate Stream Analytics
  2. GoldenGate Stream Analytics Release Notes
  3. Known Issues and Workarounds
  4. Release 19.1.0.0.2 - Known Issues

1.1.2.9 Release 19.1.0.0.2 - Known Issues

This section lists the known issues and workarounds for Oracle Stream Analytics release 19.1.0.0.2.

1.1.2.9.1 Truncate Table With Goldengate Stream

Bug Number: 30677198

Issue

Any event processing based on deleting a record, will fail for all Truncate Table and Drop Table operations. This is a known issue.

Workaround

None.

1.1.2.9.2 GG Change Data created from OSA not starting when source table has SDO_Geometry Column

Bug Number: 30709930

Issue

Creating and starting a GG Change Data fails, when the source table has column of type SDO_GEOMETRY.

Workaround

None.

1.1.2.9.3 OSA Support for CLOB And BLOB Columns

Issue

Bug Number: 30759814

OSA does not support a Database Reference table with a BLOB column type.

OSA supports a Database Reference table with a CLOB column type, but you cannot define any operations on the stream field which is mapped to that column.

Workaround

None.

1.1.2.9.4 UI allow no mapping for a DB table column with Not Null constraint

Bug Number: 30542553

Issue

While adding a Database target, the UI allows you to map to any field in the target DB table, which has a 'not null' constraint. But when you try to publish a pipeline with a 'not nullable' column mapped to a 'No Mapping' field, you will encounter an exception with error code OSA-01213.

This is a known issue.

Workaround

None.