Troubleshooting
Problem
Configuration Manager unable to configure the gcd jdbc data source. Unable to run the script. However , database test passes.
Symptom
Unable to configure the gcd jdbc data source receiving the following error in CMUI:
5/21/12 10:48:21:107 EDT] 00000000 AbstractShell E WASX7120E: Diagnostic
information from exception with text
"javax.management.JMRuntimeException: ADMN0022E: Access is denied for
the testConnectionToDataSource operation on DataSourceCfgHelper MBean
because of insufficient or empty credentials.
" follows:
javax.management.JMRuntimeException: ADMN0022E: Access is denied for the
testConnectionToDataSource operation on DataSourceCfgHelper MBean
because of insufficient or empty credentials.
Cause
Using the configuration manager against a WAS cluster, operates against the Dmgr node. The DSRA8000E: No jar or zip files found in /db2jcc.jar;/db2jcc_license_cu.jar error is due to not having the variable defined for the deployment manager node.
The connection test is performed through Java code which takes a different path than the scripts. This is why you get a successful connection test while the configuration script will fail. JDBC path variable needs to be set for Dmgr node.
Resolving The Problem
- Access WAS(Websphere) admin console
- Go to Environment|WebSphere Variables
- Select the different nodes by their [nodename]Node01 scope,
- Add an environment variable named
DB2UNIVERSAL_JDBC_DRIVER_PATH, and set that to be /opt/IBM/db2jars.
Also set the DB2UNIVERSAL_JDBC_DRIVER_PATH at the Dmgr cell level to be /opt/IBM/db2jars.
===
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21599005