PI63440: ISSUES WITH WEBSPHERE CONFIG 'USE THIS DATA SOURCE IN CONTAINER MANAGED PERSISTENCE'

APAR status

• Closed as program error.

Error description

• You will have issues using Websphere config 'Use this data
  source in container managed
  persistence' to discover using the UrbanCode Websphere
  configuration plugin.
  
  Steps to reproduce:
  1. Create a data source "ccc" in the Websphere without enabling
  the option 'Use this data source in container managed
  persistence (CMP)'
  2. Use UrbanCode step 'WebSphere Configuration Discovery' from
  'WAS -Configure' plugin to discover datasource (WebSphere
  Configuration Types=DataSource)
  3. Check the exported json file and you can find:
  ....
  {
          "name": "ccc",
          "path": "\/Cell-01\/ServerClusters\/NEWCPS\/JDBC
  Providers\/DB2
  Universal JDBC Driver Provider (XA)\/Data Sources\/ccc",
          "teamMappings": [],
          "inheritTeam": "true",
          "description": "Discovered WebSphereDataSource",
          "roleName": "WebSphereDataSource",
          "roleProperties": {
              "cmp": "true",
              "websphere.datasource.statementcachesize": "10",
              "websphere.datasource.logmissingtransactioncontext":
  "true",
              "websphere.datasource.datasourcehelperclassname":
  "com.ibm.
  websphere.rsadapter.DB2UniversalDataStoreHelper",
              "websphere.datasource.authmechanismpreference":
  "BASIC_PASSWORD",
              "websphere.datasource.providertype": "DB2 Universal
  JDBC
  Driver Provider (XA)",
              "websphere.datasource.authdataalias": "",
              "websphere.datasource.jndiname": "ccc",
              "websphere.datasource.managecachedhandles": "false",
              "websphere.datasource.xarecoveryauthalias":
  "DMGR\/JAAS_DBUSR",
              "websphere.datasource.description": "DB2 Universal
  Driver
  Datasource",
              "websphere.datasource.diagnoseconnectionusage":
  "false",
              "websphere.datasource.name": "ccc"
          }
      },
  ....
  
  where "cmp": "true", is NOT correct since it is not enabled in
  the Websphere
  
  4. Use UrbanCode step 'WebSphere Configuration Apply' from 'WAS
  -Configure' plugin(with the json file exported in the step 3) to
  create the same data source in a new Websphere
  
  5. The option 'Use this data source in container managed
  persistence(CMP)' is not enabled for the data source althrough
  "cmp": "true" is set in the json file.
  
  The process will fail.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You will have issues using Websphere config 'Use this data   *
  * source in container managed                                  *
  * persistence' to discover using the UrbanCode Websphere       *
  * configuration plugin.                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix is available in version 34 of the Websphere Application
  Server - Configure plugin.
  

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

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels

• R600 PSN

     UP

• R600 PSY

     UP

• R601 PSN

     UP

• R601 PSY

     UP

• R610 PSN

     UP

• R610 PSY

     UP

• R611 PSN

     UP

• R611 PSY

     UP

• R612 PSN

     UP

• R612 PSY

     UP

• R613 PSN

     UP

• R613 PSY

     UP

• R620 PSN

     UP

• R620 PSY

     UP

• R621 PSN

     UP

• R621 PSY

     UP