PH41279: CMPCONNECTORFACTORY IS REMOVED UNEXPECTEDLY WHEN DELETING JDBC PROVIDER FROM A SERVER TEMPLATE.

APAR status

• Closed as program error.

Error description

• If deleting JDBC Provider from a server template.
  JDBC Provider is removed from resource.xml of the template.
  However, CMPConnectorFactory is remain in resource.xml of the
  template, but CMPConnectorFactory is removed from resource.xml
  of the original application server of the template.
  
  Reproduction Steps:
  1. Create a JDBC provider and a data source the scope is the
  original application server(a1sus101).
  
  wsadmin>target_jdbc_provider =
  AdminTask.createJDBCProvider('[-scope
  Node=a1sn34Node01,Server=a1sus301 -databaseType Oracle
  -providerType "Oracle JDBC Driver" -implementationType
  "Connection pool data source" -name "Oracle JDBC Driver"
  -description "Oracle JDBC Driver" -classpath
  [${ORACLE_JDBC_DRIVER_PATH}/ojdbc6.jar ] -nativePath "" ]')
  
  wsadmin>ds=AdminTask.createDatasource(target_jdbc_provider,
  '[-name b1su301app -jndiName jdbc/b1su301app
  -dataStoreHelperClassName
  com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
  -containerManagedPersistence true
  -componentManagedAuthenticationAlias
  a1sn34CellManager01/a1sus301/d1snr33 -description ""
  -configureResourceProperties [[URL java.lang.String
  jdbc:oracle:thin:@a1sn33mg:2521:d1snr33]]]')
  wsadmin>AdminConfig.modify(ds, '[[statementCacheSize "10"]]')
  wsadmin>AdminConfig.modify(AdminConfig.showAttribute(ds,
  'connectionPool'), '[[connectionTimeout "180"] [maxConnections
  "20"] [minConnections "1"]]')
  
  wsadmin>AdminConfig.save()
  
  Because set "-containerManagedPersistence true" as a option,
  CMPConnectorFactory is created when creating data source.
  
  2. Create a template of application server.
  
  wsadmin>AdminTask.createApplicationServerTemplate('[-nodeName
  lmbv41vmNode01 -serverName a1sus101 -templateName a1sus101_temp
  -description a1sus101_template ]')
  
  wsadmin>AdminConfig.save()
  
  
  3. Delete JDBCProvider from template
  wsadmin>jdbc=AdminConfig.listTemplates('JDBCProvider',
  'Oracle*a1sus101*')
  wsadmin>AdminTask.deleteJDBCProvider( jdbc )
  wsadmin>AdminConfig.save()
  
  
  4. Check the resource.xml
  
  *The resource.xml of template:
  Followings part is remained (This is NOT expected).
  --------------------    <factories
  xmi:type="resources.jdbc:CMPConnectorFactory"
  xmi:id="CMPConnectorFactory_1626399722737" name="b1su101app_CF"
  authMechanismPreference="BASIC_PASSWORD"
  authDataAlias="lmbv41vmCellManager01/a1sus101/d1snr33"
  connectionDefinition="ConnectionDefinition_1054132487569"
  cmpDatasource="DataSource_1626399722714">
       <propertySet
  xmi:id="J2EEResourcePropertySet_1626399722737"/>
     </factories>
  --------------------
  
  *The resource.xml of original server:
  
  Followings part is removed (This is NOT expected).
  --------------------    <factories
  xmi:type="resources.jdbc:CMPConnectorFactory"
  xmi:id="CMPConnectorFactory_1626399722737" name="b1su101app_CF"
  authMechanismPreference="BASIC_PASSWORD"
  authDataAlias="lmbv41vmCellManager01/a1sus101/d1snr33"
  connectionDefinition="ConnectionDefinition_1054132487569"
  cmpDatasource="DataSource_1626399722714">
       <propertySet
  xmi:id="J2EEResourcePropertySet_1626399722737"/>
     </factories>
  --------------------
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server using AdminTask.deleteJDBCProvider   *
  *                  for template                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Delete JDBCProvider from template       *
  *                      does not remove the container managed   *
  *                      persistents configuration correctly     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The CMPConnectorFactory is removed from the base resources.xml
  incorrectly.  It should be removed from thee template
  resources.xml fille.
  

Problem conclusion

• The CMPConnectorFactory is now removed from the template
  resources.xml when using AdminTask.deleteJDBCProvider on a
  template object.
  
  The fix for this APAR is targeted for inclusion in fix pack
  8.5.5.21 and 9.0.5.11. For more information, see 'Recommended
  Updates for WebSphere Application Server':
  https://www.ibm.com/support/pages/node/715553
  

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

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels