Striim® 220.127.116.11 release notes
For evaluating Striim:
- memory: minimum 4 GB for use by Striim (so the system should have at least 5GB,
preferably 8GB or more)
- free disk space: minimum 10 GB, 20 GB recommended
- operating system:
- for evaluation, development, and production (if you need to run Striim on another operating system or version,
please contact Striim support):
64-bit CentOS 6.7 through 7.6,
64-bit Ubuntu 14.04, 16.04, or 18.04,
64-bit Windows Server 2012
- for evaluation and development only: Mac OS X 10, Windows 8.1 or 10
- 64-bit Oracle Java SE JDK 8 (recommended) or 64-bit OpenJDK 8
A production environment will require more memory and disk space.
Java SE JDK 7 and OpenJDK 7 are no longer supported. You must upgrade to version 8.
Using Striim with MySQL requires the MySQL Connector/J JDBC driver 5.1.46. If you
are using an earlier version, you must upgrade it. See "Installing the MySQL JDBC driver" in
the Installation and Configuration Guide.
Striim requires Oracle JDBC driver ojdbc8.jar. If you are using an
earlier version, remove it and install ojdbc8.jar. See "Installing the
Oracle JDBC driver" in the Installation and Configuration Guide.
The web client has been tested on Chrome. Other web browsers should work, but if you
encounter bugs, try Chrome.
Changes that may require modification of your TQL code, workflow, or environment
Salesforce Reader limitations in 18.104.22.168
- Undeletes may be published as update events. Downstream consumers must have UPSERT
functionality. When using Database Writer with a Salesforce Reader source, specify
NO_OP_UPDATES in Ignorable Exception Code.
- Purge is not supported.
- Salesforce Reader and Salesforce Push Topic Reader do not read changes to linked objects.
For more information, see
in Salesforce's Change Data Capture Developer Guide.
Writing to Cassandra
If you have an application that uses DatabaseWriter to write to Cassandra, rewrite it
to use CassandraWriter. This should require only changing the name of the writer from
DatabaseWriter to CassandraWriter.
Writing to Cosmos DB using the Cassandra API
If you have an application that uses DatabaseWriter to write to Cosmos DB using the
Cassandra API, rewrite it to use Cassandra Cosmos DB Writer.
Reading from Oracle GoldenGate
GG Trail Reader can read metadata from GoldenGate trail files. See Change Data Capture (CDC) Guide > Oracle GoldenGate > GG Trail Reader properties
for instructions on migrating the properties.
File Reader + GG Trail Parser have been deprecated in favor of GG Trail Reader.
You may continue to use the FileReader + GG Trail Parser combination used in previous releases but it will not read metadata. GG Trail Parser will be deprecated in a future release. Please contact Striim support to plan a transition.
Google PubSub Writer default property change in 22.214.171.124
The default values for PubSubConfig have changed. The new values should avoid
DEADLINE_EXCEEDED errors. Do not change these values unless instructed to by Striim
SQL Server JDBC drivers
SQL Server 2008 requires an older version of Microsoft's JDBC driver that is not
compatible with the most recent SQL Server versions. See the Installation and Configuration
Guide > Configuring Striim > Insalling third-party drivers > Installing the Microsoft
JDBC driver for more information.
Customer-reported issues fixed in release 126.96.36.199:
- DEV-21544: HP NonStop Enscribe Reader: logs flooded while stopping app post CPU failure
- DEV-22452: Oracle Reader > PostgreSQL Databasea Writer: issue with ChangeOperationToInsert
- DEV-22948: external cache with incorrect URL does not crash promptly
- DEV-23316: error message is too large for exception store
- DEV-24144: dashboard is very slow
- DEV-24145: heap issue
- DEV-24433: Oracle Reader > Kudu Writer: frequent crashes
- DEV-24607: issue when joining Oracle Reader and Database Reader output
- DEV-24657: Forwarding Agent: deploy fails with "FLOW already deployed on this server"
- DEV-24680: GG Trail Reader sequence number issue
- DEV-24701: support alert when app is quiesced
- DEV-24713: MySQL Reader hangs on Starting Sources when Start Timestamp is set
- DEV-24719: GG Trail Reader recovery checkpoint issues
- DEV-24776: heap issue
- DEV-24796: Spanner Writer: label sessions
- DEV-24802: GG Trail Reader missing some functionality of GG Trail Parser
- DEV-24815: monitoring UI disabled when ClusterQuorumSize is set
- DEV-24817: Snowflake Writer: crash with SnowflakeSQLException error
- DEV-24864: MS SQL Reader > Snowflake Writer: no data flowing, no errors in log
- DEV-24899: GG Trail Reader error
- DEV-24923: Oracle Reader > BigQuery Writer: "Syntax error: Illegal escape sequence"
- DEV-24928: frequent timeouts when using external caches
- DEV-24933: GG Trail Reader > Snowflake Writer: java.lang.IndexOutOfBoundsException
- DEV-24934: BigQuery Writer: add batch and table details to error messages
- DEV-24938: GG Trail Reader > BigQuery Writer: error when large operations are split between trail files
- DEV-24958: Salesforce Reader: in 188.8.131.52, will not accept Start Timestamp value
- DEV-25008: Oracle Reader: in 11g, failure with "column name not found" when CLOB contains single quote
- DEV-25040: 184.108.40.206: undeploy failure
- DEV-25121: GG Trail Reader > BigQuery Writer: crash with "WaitingNodes is not 0" error
- DEV-25143: heap issue
- DEV-25144: BigQuery Writer: primary key update fails when data contains single quote
Customer-reported issues fixed in release 220.127.116.11:
- DEV-21913: MSSQL Reader to Database Writer SQL Server: java.lang.Long cannot be cast to org.joda.time.DateTime
- DEV-22275: OracleReader: Bidirectional setting does not work with CDB
- DEV-22548: Schema conversion utility issue with string_agg
- DEV-23143: BigQuery Writer with timestamp with embedded T and (+0000) timezone specifier
- DEV-23530: Salesforce Reader: for delete + insert + update, only delete and update are captured
- DEV-23532: Salesforce Reader in incremental mode missing some events
- DEV-23817: MSSQL Reader fails to crash after connection failure
- DEV-24164: MaskGeneric function does not work if the string contains multibyte character
- DEV-24268: MySQL Reader with StartTimestamp specified selects the wrong binlog file
- DEV-24315: Persisted stream doesn't work when Kafka uses SASL (Kerberos) authentication with SSL encryption
- DEV-24380: Salesforce Reader crashes when typeUUID is null
- DEV-24391: Monitoring app crashes when metadata repository is hosted on PostgreSQL
- DEV-24408: Salesforce Reader "Could not send data to the platform: null" error"
- DEV-24493: BigQuery Writer "unexpected time partitioning MONTH" error;
to fix this issue, google-cloud-bigquery client for Java API version has been upgraded
Customer-reported issues fixed in release 18.104.22.168:
- DEV-22650: Snowflake Writer mistakenly deployed on agent
- DEV-22904: MySQL Reader Start Timestamp issue
- DEV-23537: Web UI is slow
- DEV-23582: HP NonStop Enscribe Reader issue with two-byte characters
- DEV-23603: Oracle JDBC SSL connection issue
- DEV-23632: HP NonStop readers do not release listening port
- DEV-23718: GG Trail Parser datetime issue
- DEV-23733: STATUS command output is incomplete
- DEV-23759: Application moved from default group still appears in default group in UI
- DEV-23792: Kafka Writer fails when source is deployed on agent or another server and encryption is enabled
- DEV-23881: Oracle Reader checkpointing issue
- DEV-23882: Oracle Reader issue with long-running queries
- DEV-23897: Salesforce > BigQuery issue with deleting custom Salesforce objects
- DEV-24044: Oracle Reader hangs instead of stopping
- DEV-24111: Updated Kudu Java client to version 1.13.0
- DEV-24117: MySQL Reader hangs
- DEV-24118: MySQL Reader hangs
- DEV-24126: System health REST API return is incomplete
- DEV-24213: Updated google-cloud-pubsub client API to version 1.108.2
Customer-reported issues fixed in release 22.214.171.124:
- DEV-16873: Database Reader (MySQL) issue reading integer columns
- DEV-22651: Issue with hyphen in SQL Server database name
- DEV-23119: GG Trail Reader crash on DDL event
- DEV-23221: Stale output in
MON <source> output
- DEV-23271: GG Trail Parser: DDL issue
- DEV-23286: GG Trail Parser: DDL issue
- DEV-23297: REST API token is invalid after associated user logs out from Striim UI
- DEV-23501: Oracle Reader file sequence gap
- DEV-23513: GG Trail Parser > Database Writer error when primary key has timestamp data type
- DEV-23515: Oracle Reader crash after upgrade to 126.96.36.199
- DEV-23520: Kafka Reader stops capturing data
- DEV-23561: PostgreSQL Reader > Database Wrier (PostgreSQL) ClassCastException
- DEV-23596: Database Reader (Oracle) ORA-01000 error during initial load
Customer-reported issues fixed in release 188.8.131.52:
- DEV-21018: Database Reader row count warnings in log
- DEV-21818: MongoDB Reader JSONParseException error
- DEV-22636: Oracle Reader > Database Writer PostgreSQL handling of single quote in data values
- DEV-22639: can't start Striim as a service in Windows
- DEV-22657: passwordEncryptor.bat null pointer exception
- DEV-22769: Oracle Reader can't find log file
- DEV-22890: Oracle Reader issue with Active Data Guard
- DEV-22941: app crashed with "not enough servers" when there were enough servers
- DEV-22945: GGTrail Parser issue
- DEV-22957: errors quiescing app with Kafka-persisted stream
- DEV-22971: app crashed with 90% memory usage though usage was not that high
- DEV-22975: Kafka Writer fails with network exception
- DEV-23089: Oracle Reader file sequence gap message
Customer-reported issues fixed in release 3.10.3:
- DEV-19680: Google Cloud Platofrm: can not enter Product key for BYOL solution
- DEV-20672: HP NonStop readers: list of active transactions grows without limit when CDC process reads from a single auxiliary audit trail
- DEV-21398: Dashboard GRANT permission issue
- DEV-21471: Configure MEM_MAX in startUp.properties in Windows
- DEV-21818: MongoDB Reader error com.fasterxml.jackson.core.JsonParseException: Non-standard token 'NaN'
- DEV-22107: Property variable issue
- DEV-22508: Alerts not working
- DEV-22636: Single quote in Oracle CLOB becomes converted to double quotes PostgreSQL text
- DEV-22639: Unable to start Striim as a service in Windows
- DEV-22650: Snowflake Writer deployed on default deployment group deploys on agent
- DEV-22657: passwordencryptor.bat throws null pointer exception
- DEV-22769: Oracle Reader fails with missing log file error when the file exists
- DEV-22886: Importing TQL in web UI loses multi-byte character
- DEV-22935: DROP NAMESPACE ... CASCADE does not drop property variables
- DEV-22937: GG Trail Parser on agent: checkpoint is wrong after restart
- DEV-22938: GG Trail Parser on agent: file lineage is not avaialble
- DEV-22939: Can not save Kafka Writer created in UI with default batch size and mode
- DEV-22945: File Reader + GG Trail Parser not quiescing properly
- DEV-22950: Kafka Writer sometimes sticks on retry
- DEV-22952: MonitoringSourceStream error
- DEV-22957: Quiesce fails with error "Could not get a lock on Kafka topic"
- DEV-22971: When LEE is enabled, app crashes with 90% memory usage
- DEV-23066: Exported TQL includes namespace declarations
- DEV-23102: File Reader + GG Trail Parser > File Writer sometimes missing data
- DEV-23156: "Free disk space" reported incorrectly as GB when it should be percent
- DEV-23172: GCS Writer: unexpected comma at the beginning of file
- DEV-23187: Kafka Writer hangs on stop with ActionNotFoundWarning
- DEV-23243: Data from Kafka stream is not received by target Database Writer
- DEV-23263: Spanner Writer: NullPointerException due to race condition
The following issues have been identified but not yet fixed as of this release.
Additional known issues are mentioned in the relevant topics in the documentation.
HTTPReader is missing the Parser menu in the UI (DEV-1854)
Workaround: Use the console or import TQL.
MAP settings are not exposed in the UI (DEV-4138)
MAP clause of
CREATE SOURCE ... OUTPUT TO is not
exposed in the UI, though it can be created with the App Wizard.
Workaround: in the console, use
DESCRIBE to view settings,
ALTER to change them.
WActionStore silently discards events with null value for event type key (DEV-5599)
Creating a source using HTTPReader and DSVParser fails with error (DEV-5916)
Workaround: Have the sender include type=dsv in the URI. For example:
curl -X POST "http://192.168.1.107:9090?type=dsv&charset=utf-8"...
Dashboard queries not dropped with the dashboard or overwritten on import (DEV-6068)
When you drop a dashboard, its queries are not dropped. If you drop and re-import a dashboard, the queries in the JSON file do not overwrite those already in Striim.
Workaround: drop the namespace.
SORTER objects do not appear in the UI (DEV-8142)
DatabaseWriter shows no error in UI when MySQL credentials are incorrect (DEV-8933)
If your DatabaseWriter Username or Password values are correct, you will see no error
in the UI but no data will be written to MySQL. You will see errors in
webaction.server.log regarding DatabaseWriter containing
Failure in Processing
command denied to user.
DatabaseWriter needs separate checkpoint table for each node when deployed on multiple nodes (DEV-11305)
GRANT command wildcard does not work for objects (DEV-12146)
Commands such as
GRANT ALL ON * *.* TO ROLE ... will fail.
Workaround: leave out the object element, for example,
GRANT ALL ON *.* TO ROLE ....
Import of custom Java function fails (DEV-17653)
IMPORT STATIC may fail. Workaround: use lowercase
When DatabaseReader Tables property uses wildcard, views are also read (DEV-19903)
Workaround: use Excluded Tables to exclude the views.
SELECT FROM exception store using JUMPING WITHIN does not work (DEV-23377)
Workaround: omit WITHIN. For example:
SELECT to_waevent(s.relatedObjects) AS evtlist
FROM ExceptionstoreDemo_exceptionstore [JUMPING 5 SECOND] s;