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

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