Skip to main content

Support & downloads  >  

Test Connection fails with error DSRA0010E
 Technote (troubleshooting)
 
Problem(Abstract)
Test Connection fails on data source which has newly created J2C Authentication Alias.
 
Cause
After configuring the data source, click the Test Connection button from Administrative Console gets the following error:
    The test connection operation failed for data source [datasource] on server nodeagent at node [node] with the following exception: java.lang.Exception: java.sql.SQLException: null userid not supported
    DSRA0010E: SQL State = null, Error Code = -99,999. View JVM logs for further details.
This error often occurs after a new J2C authentication alias was created or an existing one was modified. The configuration change for the new authentication alias was not pushed out to the Java™ process in which the Test Connection was invoked on.
 
Resolving the problem
The problem can be easily solved by restarting the Java process (application server, node agent or deployment manager) for which the Test Connection is running based on the following:
    • In the IBM WebSphere Application Server Base environment, there is a single Java process running. The Administrative Console runs in this process, and Test Connection operation for the data source takes place in this process as well.
    • In the WebSphere Network Deployment environment, the Test Connection operation for data sources configured at the server level is performed in the node agent of that server. The data source configured at the node or cell level is performed in the node agent or deployment manager servers respectively.
If server restart cannot be done, see the following for another possible solution: http://www-1.ibm.com/support/docview.wss?uid=swg24009485
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application ServersRuntimes for Java TechnologyJava SDK
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Application Servers
 Distributed Application & Web Servers
 WebSphere Application Server
 DB Connections/Connection Pooling
 Operating system(s):
  AIX, HP-UX, Linux, Linux Red Hat - pSeries, Solaris, Windows
 Software version:
  5.1, 5.1.1, 6.0, 6.0.1, 6.0.2, 6.1, 7.0
 Software edition:
  Base, Enterprise, Network Deployment, WebSphere Business Integrations Server Foundation
 Reference #:
  1235300
 IBM Group:
 Software Group
 Modified date:
 2006-04-14

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.