RS02941: ORACLE URL VALUE IS NOT POPULATING IN THE DATASOURCE

Operational Decision Manager V8.9.2 Download Document
Operational Decision Manager V8.9.2 Mod Pack
Operational Decision Manager for z/OS 8.9.2 Mod Pack
Operational Decision Manager V8.8.1.4 Fix Pack

APAR status

• Closed as program error.

Error description

• Customer is installing ODM 8902. They are using the templates
  to
  deploy clusters. Even though they are providing the correct
  information for the ODM Dmgr profile and cluster creation,
  the Oracle URL values are not populating in the ISC in the
  datasource
  connection information.
  

Local fix

• Go to C:
  \IBM\WebSphere\AppServer\profileTemplates\rules\actions\scripts\
  was\datasource_utils.py
  
  Modify the method createOracleDatasource with the following
  code:
  def createOracleDatasource(jdbcProvider, datasourceName,
  jndiName, dbName, dbHostName, dbPort, dbUser, dbPassword):
      AdminTask.createDatasource(jdbcProvider, '[-name "' +
  datasourceName + '"'
        + ' -jndiName ' + jndiName
        + ' -dataStoreHelperClassName com.ibm.websphere.rsadapter.
  Oracle11gDataStoreHelper'
        + ' -componentManagedAuthenticationAlias'
        + ' -containerManagedPersistence false'
        + ' -configureResourceProperties [[URL java.lang.String
  jdbc:oracle:thin:@'+dbHostName+':'+dbPort+':'+dbName+']]]')
      localizedMessages.printMessageWithParams('GBRPT0007I', [
  datasourceName])
      AdminConfig.save()
  Original method is:
  def createOracleDatasource(jdbcProvider, datasourceName,
  jndiName, dbName, dbHostName, dbPort, dbUser, dbPassword):
      return createGenericDatasource(jdbcProvider,
                                     datasourceName,
                                     jndiName,
                                     dbName,
                                     dbHostName,
                                     dbPort,
                                     dbUser,
                                     dbPassword,
                                     'com.ibm.websphere.rsadapter.
  Oracle11gDataStoreHelper',
                                     'thin')
  

Problem summary

• When using templates to deploy clusters. Even though the
  correct information are provided for the ODM Dmgr profile and
  cluster creation, those values are not populating in the ISC in
  the datasource connection information.
  The current profile template/ConfigureDCCluster script is using
  datasource custom properties to communicate the setting (URL
  and credentials) to the JDBC driver. It explains why connection
  fields are empty.
  

Problem conclusion

• The code is fixed.
  

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:

Modules/Macros

• 999
  

Fix information

• Fixed component name

  WDS FOR RULES

• Fixed component ID

  5725B6903

Applicable component levels

• R890 PSY

     UP