Overview

When creating additional Oracle data sources with the Oracle drivers created by the CX Process (version 2018) installer deployed over WebSphere 8.5.5.14 the data source creation itself fails with the below message on the admin console:

“The provider type you have chosen is not supported by the current node version. Choose a different provider type.” 

The following error is logged in SystemOut.log

DSRA3604E: Unable to locate a datasource template for provider name: SBM Oracle ORACLEJDBC JDBC Driver

 

---

Solution

The JDBC driver created by the CX Process installer uses " SBM Oracle ORACLEJDBC JDBC Driver " for provider type.

There is no such provider type in Websphere Console, hence the data source creation fails.

This is a known issue fixed in CX Process 2019 R4. Upgrade to CX Process 2019 R4 or later (eg. to Aurea Process 2021).

<supportagent>

Agent-only:

• Defect number: SBM-66617
• Fix Release Date: 2020-02-21

</supportagent>

 

Workarounds

If the upgrade to CX Process version 2019 R4 (or later) is not immediately possible, you can use one of the workarounds mentioned below.

Manually rename the providerType

1. Locate the resource.xml files located under the following two locations
   • $IBM_HOME\WebSphere\AppServer\profiles\<SBM_Profile_Name>\config\cells\<SBMCell_Name>\nodes\<SBMNode_Name>\servers\ejbServer
   • $IBM_HOME\WebSphere\AppServer\profiles\<SBM_Profile_Name>\config\cells\<SBMCell_Name>\nodes\<SBMNode_Name>\servers\portalServer
   • eg:
     • $IBM_HOME\WebSphere\AppServer\profiles\SBM\config\cells\SBMCell\nodes\SBMNode\servers\ejbServer
       $IBM_HOME\WebSphere\AppServer\profiles\SBM\config\cells\SBMCell\nodes\SBMNode\servers\portalServer

    

2. In both resource.xml files, search for:

   providerType="SBM Oracle ORACLEJDBC JDBC Driver"

3. In both resource.xml files change this to:

   providerType="User-defined JDBC Provider "

4. Restart the servers for changes to take effect.

 

Create your own provider

When creating a new data source, do not use the default provider "SBM Oracle ORACLEJDBC JDBC Driver", instead create your own provider and use it while creating your new data source.

 

 

Back to the top