Troubleshooting
Problem
When you use the Websphere administration console to test the connection to the CDS_DataSource data source, the test fails.
Symptom
The WebSphere Network Deployment Test Connection operation fails when testing data source CDS_DataSource with the exception:
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA8050W: Unable to find the DataStoreHelper class specified: com.spss.datadirect.jdbc.websphere.ConnectJDBCDataStoreHelper.
Cause
SPSS Collaboration and Deployment Services uses a user-defined data store helper. When used with a WebSphere ND topology, the test connection operation occurs in the node agent instead of the application server instance, which does not have the SPSS data store helper in the classpath. This is a known problem described in WebSphere APAR PM98768.
Resolving The Problem
To test the CDS_DataSource connection follow these steps:
1. Start the deployment manager and node agents.
2. Open the WebSphere administration console and login.
3. Navigate to Resources -> JDBC -> Data sources.
4. Select the CDS_DataSource data source.
5. Enter the following in the Specify a user-defined data store helper class name text box:
com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
6. Click OK.
7. Save the changes to the master configuration.
8. If automatic synchronization is not enabled:
- a. Navigate to System administration -> Nodes
b. Check each node in the cluster where IBM SPSS Collaboration and Deployment Services is deployed and click Synchronize.
10. Check the CDS_DataSource data source and click Test connection.
11. Once the data source connection has tested successfully, restore the user-defined data source connection by repeating steps 1-8, using the data source helper class:
com.spss.datadirect.jdbc.websphere.ConnectJDBCDataStoreHelper
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21655977