TIBCO ActiveMatrix BusinessWorks(TM) Plug-in for SAP HANA Database 6.0.0 Hotfix 2 is released for all supported platforms. This hotfix is cumulative of prior hot fixes for this version. Listed below is a summary of updates included in Hotfix 2. Please refer to the attached Readme for additional details on these and other cumulative fixes included in this Hotfix.

================================================================================
Closed Issues in 6.0.0_HF-002 (This Release)

BWHD-236

Cannot apply SAP HANA Database hotfix1 delta installer on BWCE envrionment.
This issue is fixed.

BWHD-230

Support of Import From CSV FILE statement.

Notes:
(1) To use this feature, select the 'Use Import From' checkbox and the 'Import File Type' 
    as 'CSV FILE', in the SAP HANA Database Insert activity.

(2) Entity picker is a mandatory field when user wants to use Import From CSV FILE.
    SQL builder tab is read-only and can be used to view the metadata of selected entity.
    
(3) CSV file that needs to be imported, should exist either on HANA Server or should 
    be available in folder visible to the HANA Server.
    
(4) Input field 'COLUMN_NAME_LIST' and 'COLUMN_NAME_LIST_WITH_SCHEMA_FLEXIBILITY' accepts 
    comma separated column names.
    e.g: "COL1,COL2,COL3"

(5) When input field 'COLUMN_LIST_IN_FIRST_ROW_WITH_SCHEMA_FLEXIBILITY' is set to true, it
    will be given preference over value entered for input field 'COLUMN_LIST_IN_FIRST_ROW'.

    Value entered for input field 'COLUMN_NAME_LIST_WITH_SCHEMA_FLEXIBILITY' will be given 
    preference over value entered for input field 'COLUMN_NAME_LIST'.
    
(6) No support of extended storage tables.


When catch block is added after SAP HANA Database Insert activity is configured with 
'Use Import From' feature, application might throw "XML Schema validation failed" error.

Workaround: To use catch block along with 'Use Import From' feature, after adding SAP HANA 
Database Insert activity in the process, first add "SapHanaDatabaseJdbcPluginException", 
"SapHanaDatabaseJdbcSQLException" and "SapHanaDatabaseJdbcInsertSQLException" faults in 
three respective catch blocks and then configure SAP HANA Database Insert activity to use 
'Import from' feature.

BWHD-229    

Role of SAP HANA Database JDBC palette error codes 200004 and 200005 should be Debug 
instead of Trace.
This issue is fixed.

BWHD-228

Ability to throw fault in case of batch insert failure using SAP HANA Database 
Insert activity.

Notes:
(1) To use this feature, select 'Fault on Batch Failure' in the Advanced tab of SAP 
    HANA Database Insert activity.
    This checkbox will be disabled when the 'Use Import From' checkbox in the General
    tab is selected.
    
(2) 'SapHanaDatabaseJdbcInsertSQLException' fault is added in SAP HANA Database Insert
    activity to handle the batch insert failure.
    This fault will not be visible when the 'Use Import From' checkbox in the General 
    tab is selected.

BWHD-225

Support of query, update and delete operation on records where field value is NULL
using SAP HANA Database JDBC palette activities.

================================================================================

Please refer to the instruction of Installation/Uninstallation in Readme file for more information.

This hotfix can be downloaded from TIBCO Support Customer Portal Web UI(https://support.tibco.com). You will need to provide your TIBCO Support Portal credentials. Once logged in you can download the hotfix by selecting the “Downloads” -> “Hotfixes” option under:

/AvailableDownloads/BusinessWorks/Plugins/SAPHANADB/6.0.0/hotfix-02

Please contact TIBCO Support if you have any problems finding or downloading this Hotfix.