Description:
TIBCO ActiveMatrix® Adapter for Database 7.0.0 Hotfix 2 is released for all platforms. Please refer to the product Readme file for details regarding the supported platforms.

Listed below is a summary of updates included in this Hotfix. Please refer to the Hotfix Readme for additional details and installation instructions.

===============================================================
Closed Issues in 7.0.0_HF-002

AADB-4933    
When the polling interval was set to 1 millisecond, the status of a few records was always 'P' in the publishing table.

AADB-4946
(PostgreSQL only) The Subscription Service failed to handle the Boolean data type correctly.

AADB-5102    
When inserting data before starting the adapter, the status of a few records was always 'P' in the publishing table.

AADB-5110 and AADB-5111
(MySQL only) If the adapter connected to the database by using the native JDBC driver, the connection could terminate when sending duplicated parent-child data to the Subscription Service.

AADB-5116
(MySQL only) If the adapter connected to the database by using the native JDBC driver, the Request-Response Service threw an exception after reconnecting to the database.

AADB-5201    
The batch commit feature of the Subscription Service occasionally failed to time out.

AADB-5232
When using the queue-based JMS messaging, the Request-Response Service could lose messages after reconnection.
===============================================================
Known Issues:

For Amazon Redshift,
*********************************************************************
AADB-5214: When run Sub Load Balance with three instances, two instances will stop and throw exception?org.postgresql.util.PSQLException: ERROR: 1023
AADB-5231: ADB7.0 don't support Bytea/Time Data types for Amazon Redshift DB
(database limitation, Amazon Redshift doesn't support)
AADB-5186: The Opaque Exception table cannot be created
(database limitation, Amazon Redshift doesn't support Bytea data type and opaque table has Bytea column)
AADB-5199: The Sub feature of Pre Commit Stored Procedure doesn't work with Amazon Redshift DB
(database limitation, Amazon Redshift doesn't support stored procedure)
AADB-5185: The publisher service cannot be created successfully
(database limitation, Amazon Redshift doesn't support trigger, index)
AADB-5200: The RPC custom service doesn't work with Amazon Redshift DB
(database limitation, Amazon Redshift doesn't support stored procedure or function
*********************************************************************

For MicroSoft Azure,
*********************************************************************
AADB-5127: The "Upsert" is invalid in Azure, Reason: Azure requires clustered index
Workaround: For pub service, we need to use workaround to generate DB objects in database, including publishing table, trigger and indexes.
Uncheck the checkbox "Write to Database on Save" in the adapter instance configuration After configuring the publication service, find the SQL script generated for the instance, modify it as follow:
-Comment or delete the "grant" statement in the script, for example, --GRANT INSERT ON P_yswtest TO tibco-user@tm7n425uby --go -Modify the index statement for "ADB_SEQUENCE" column, add CLUSTERED keyword between UNIQUE and INDEX, for example, CREATE UNIQUE CLUSTERED INDEX IDX1_P_yswtest ON P_yswtest (ADB_SEQUENCE) -Execute all the modified SQL script in SQL server client tool, for example, SQL server management studio -Test the pub service

AADB-5135: The ADB will pop up exception if does not set clustered index exception table or opaque exception table(Azure required clustered index)
Workaround: For the sub service, if you want to use the exception table/child exception table/opaque exception table, you also need to follow the workaround below:
-Uncheck the checkbox "Write to Database on Save" in the adapter instance configuration -After configuring the subscription service, find the SQL script generated for the instance, modify it as follow:
-Add clustered index for exception/opaque exception table, for example:
create clustered index yswtest1_excp_cluster_idx on yswtest1_excp (ADB_TRACKINGID) go where yswtest1_excp is the exception table name, yswtest1_excp_cluster_idx is the constraint name
*********************************************************************

This Hotfix can be downloaded from the TIBCO Product Support ftp server, ftp://support-ftp.tibco.com/, using your username and password for the TIBCO Support Web. Once logged on you can find the hot fix under:
available_downloads/ActiveEnterprise/Adapters/ActiveDataBase/7.0.0/hotfix-02/

And you can find the TIBCOUniversalInstaller (version 3.1.1) required to install this hot fix under:
/available_downloads/UniversalInstaller/TIBCOUniversalInstaller/3.1.1/TIBCOUniversalInstaller_311v1

Please contact TIBCO Support if you have any problems finding or downloading this hotfix and the universal installer.

TIBCO ActiveMatrix® Adapter for Database 7.0.0 Hotfix 2 is now available.

Product: TIBCO Adapter for ActiveDatabase Version: 7.0.0 OS: All --------------------