Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Problems With Oracle Data Source WAS 6.1 RHEL : Error Code = 17,068

389 views

Skip to first unread message

karl....@googlemail.com

unread,

Apr 7, 2008, 11:46:57 AM4/7/08

Hi All, 
 
We are currently moving over to WAS 6.1 with EJB3 feature pack. I have a working instance of was 5.x and I am trying to replicate the necessary setting on was 6.1 to deploy the app. 
 
When creating and trying to connect to a oracle 10g datasource I get the following error of which I am unable to find any help information from oracle or IBM. 
 
The deployment manager console shows the following when trying to test the connection: 
 
The test connection operation failed for data source FAB Datasource on server nodeagent at node VictoriaNode with the following exception: java.sql.SQLException: Invalid argument(s) in callDSRA0010E: SQL State = null, Error Code = 17,068. 
 
The log file shows the following; 
 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R java.sql.SQLException: Invalid argument(s) in callDSRA0010E: SQL State = null, Error Code = 17,068 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:99) 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1207) 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1239) 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2559) 
<strike>07/04/08 14:57:36:054 BST</strike> 000000eb SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at java.lang.reflect.Method.invoke(Method.java:618) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:532) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:460) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at java.lang.reflect.Method.invoke(Method.java:618) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:62) 
<strike>07/04/08 14:57:36:055 BST</strike> 000000eb SystemErr R at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at java.lang.reflect.Method.invoke(Method.java:618) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:265) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1089) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:971) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:231) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:238) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:833) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:802) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1080) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:973) 
<strike>07/04/08 14:57:36:056 BST</strike> 000000eb SystemErr R at com.ibm.ws.management.connector.AdminServiceDelegator.invoke(AdminServiceDelegator.java:139) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at java.lang.reflect.Method.invoke(Method.java:618) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnector.invoke(SOAPConnector.java:351) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnector.service(SOAPConnector.java:207) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at com.ibm.ws.management.connector.soap.SOAPConnection.handleRequest(SOAPConnection.java:55) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:680) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:484) 
<strike>07/04/08 14:57:36:057 BST</strike> 000000eb SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469) 
<strike>07/04/08 14:57:36:059 BST</strike> 000000eb SystemErr R java.sql.SQLException: Invalid argument(s) in callDSRA0010E: SQL State = null, Error Code = 17,068 
 
Any help would be most appreciate. 
 
Regards 
 
Karl

Ben_

unread,

Apr 7, 2008, 12:18:32 PM4/7/08

Verify the parameters are correct.

Isn't there a "caused by" clause in the stacktrace ?

karl....@googlemail.com

unread,

Apr 8, 2008, 4:19:14 AM4/8/08

By parameters I assume you mean custom properties and these are correct to the best of my knowledge; 
 
The nested stack trace provides no further information; 
 
My custom properties are as follows: 
 
driverType - false 
oracleLogFileSizeLimit 0 false 
oracleLogFileCount 1 false 
oracleLogFileName - false 
oracleLogTraceLevel INFO false 
oracle9iLogTraceLevel - false 
oracleLogFormat SimpleFormat false 
oracleLogPackageName oracle.jdbc.driver false 
TNSEntryName - false 
networkProtocol - false 
databaseName IATRADE false 
serverName bank false 
portNumber 1521 false 
dataSourceName IATRADE false 
loginTimeout false 
description false 
transactionBranchesLooselyCoupled false 
Total 17

0 new messages