LI77138: DATABASE ENDPOINT CONNECTION FAILS WHEN A CONFIGURATION PROPERTY IS ENTERED FOR 'ADDITIONAL PARAMETERS'
Closed as program error.
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.
Assign the 'Parameter Value' with plain value instead of 'Configuration Properties'.
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
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 V126.96.36.199 and WebSphere Cast Iron V188.8.131.52 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
Reported component name
WS CASTIRON HV
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
WS CASTIRON HV
Fixed component ID
Applicable component levels
More support for:
WebSphere Cast Iron Hypervisor Edition Standard
Software version: 610
Reference #: LI77138
Modified date: 08 January 2013