TIBCO ActiveMatrix BusinessWorks(TM) Plug-in for SAP HANA Database 6.0.0 Hotfix 1 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 1. 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-001 (This Release)

BWHD-227

Support of Import From CONTROL FILE statement

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

(2) Entity picker is not a mandatory field when user wants to use Import From CONTROL FILE.
    User can configure it if they wish to view metadata of the entity. SQL builder tab is 
    read-only.
    
(3) Control 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) Two new error codes have been added.
    i)    Error Code:        TIBCO-BW-PALETTE-SAP_HANA_DATABASE_JDBC-200006
        Error Message:    Import File Type selected: {0}
        Role:             Debug
        Description:    Message is shown for SAP HANA Database Insert activity when 
                        'Use Import From' checkbox is selected and prints import file type.
        
    ii)    Error Code:        TIBCO-BW-PALETTE-SAP_HANA_DATABASE_JDBC-500017
        Error Message:    Invalid Import File Path. Entered value is either null or empty.
        Role:            Error
        Description:    Message is shown for SAP HANA Database Insert activity when 
                        'Use Import From' checkbox is selected and if you input a null or 
                        an empty value for import file path.

(7) Currently, SAP throws error on usage of 'WITH_SCHEMA_FLEXIBILITY' option when used 
    with Import From CONTROL FILE. Once issue is addressed at their end, activity should 
    work as expected.

(8) No support of extended storage tables.

BWHD-219 

SapHanaDatabaseJdbcSQLException is caught in the catch block but msg and 
msgCode fields data is not getting populated.

This issue is fixed.

For an existing project in TIBCO Business Studio
1. Delete the catch block.
2. Change any field in the activity and save the activity to reflect changes in the fault tab.
3. Add the catch block again.
4. Save and Run the project.

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

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-01

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