LI77138: DATABASE ENDPOINT CONNECTION FAILS WHEN A CONFIGURATION PROPERTY IS ENTERED FOR 'ADDITIONAL PARAMETERS'

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • When 'Configuration Property' is picked as 'Parameter Value'
    of 'Additional Parameters' entry on database endpoint with valid
    data an error in Studio occurs.
    
    For example: while verifying the query or refreshing the table
    structure of database activities such as 'Execute Query' or 'Get
    Inserted Rows', WebSphere Cast Iron Studio fails to establish
    the connection to the target database.
    
    The project executes successfully when it's verified in Cast
    Iron Studio and on Cast Iron appliance.
    
    Steps to reproduce:
    1. Open project in studio
    2. Create a DB2 endpoint with configuration properties for the
    database name, server, port, username and password, and
    Package Collection = NULLID (not a configuration property).
    3. Create an Execute Query activity in the default orchestration
    that uses the DB2 endpoint
    4. Enter a query such as "select * From sysibm.sysattributes"
    and click View Columns
    5. Observe that the View Columns dialog opens without any errors
    6. Click Close
    7. Make the Package Collection a configuration property with
    value = NULLID (you have to create the configuration property in
    the Project>Configuration Properties dialog first to be able
    to select it from the drop down)
    8. Go back to the query and click View Columns again
    9. Observe the error "Unable to obtain a database connection.
    Please check the endpoint and try again" occurs.
    

Local fix

  • Assign the 'Parameter Value' with plain value instead of
    'Configuration Properties'.
    

Problem summary

  • When 'Configuration Property' is picked as 'Parameter Value'
    of 'Additional Parameters' entry on database endpoint with valid
    data an error in Studio occurs.
    For example: while verifying the query or refreshing the table
    structure of database activities such as 'Execute Query' or 'Get
    Inserted Rows', WebSphere Cast Iron Studio fails to establish
    the connection to the target database and error "Unable to
    obtain a database connection. Please check the endpoint and
    try again" occurs.
    
    The Studio Error log may also contain the following error:
    com.approuter.studio.connectors.database.util.DBConnectionManage
    r
    createConnection
    SEVERE: Unexpected error during test connection: null Nov 16,
    2012 3:46:28 PM
    com.approuter.studio.connectors.database.util.DBConnectionManage
    r
    makeConnection
    SEVERE: Can't get the database connection.
    Throwable occurred: java.sql.SQLNonTransientConnectionException:
    [CastIron Systems][Oracle JDBC Driver]The property value given
    is not a valid choice
    

Problem conclusion

  • The problem occurs because the configuration parameter value
    is not picked up while establishing the connection to the
    database. The configuration parameter name is picked up as the
    parameter value. This was fixed by obtaining the correct
    parameter value whenever configuration parameters are used in
    the database endpoint panel.
    
    The problem has been fixed and is targeted for WebSphere Cast
    Iron fix pack V6.1.0.15 and WebSphere Cast Iron V6.3.0.0
    
    Announcements of new fix packs are made on the WebSphere Cast
    Iron Support Portal at
    http://www-947.ibm.com/support/entry/portal/Overview/Software/We
    bSphere/WebSphere_Cast_Iron_Cloud_integration
    
    For planned fixpack maintenance release dates, see the following
    support announcement:
    http://www-01.ibm.com/support/docview.wss?uid=swg27036374
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI77138

  • Reported component name

    WS CASTIRON HV

  • Reported component ID

    5725C1100

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-17

  • Closed date

    2013-01-08

  • Last modified date

    2013-01-08

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WS CASTIRON HV

  • Fixed component ID

    5725C1100

Applicable component levels

  • R610 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Cast Iron Hypervisor Edition Standard

Software version:

610

Reference #:

LI77138

Modified date:

2013-01-08

Translate my page

Machine Translation

Content navigation