Home > [2015/7/23 08:34:26:039 GMT+07:00] FFDC Exception:com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException SourceId:com.ibm.ws.rsadapter.spi.WSRdbMan

[2015/7/23 08:34:26:039 GMT+07:00] FFDC Exception:com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException SourceId:com.ibm.ws.rsadapter.spi.WSRdbMan

[2015/7/23 08:34:26:039 GMT+07:00] FFDC Exception:com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException SourceId:com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions ProbeId:1592 Reporter:com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@6ed46ed4
com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Cannot call 'cleanup' on a ManagedConnection while it is still in a transaction..
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:251)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:200)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:444)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4560)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java:4010)
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1531)
at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:509)
at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1862)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2384)
at com.ibm.ejs.j2c.ConnectionEventListener.connectionClosed(ConnectionEventListener.java:377)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionClosedEvent(WSRdbManagedConnectionImpl.java:1832)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.closeWrapper(WSJdbcConnection.java:908)
at com.ibm.ws.rsadapter.jdbc.WSJccConnection.closeWrapper(WSJccConnection.java:767)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:240)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:193)
at com.icsc.dpms.de.sql.dejc301c.close(dejc301c.java:614)
at com.icsc.dpms.de.dejc301.close(dejc301.java:531)
at com.icsc.po.api.pojcSXAPI_CS.forcastDate(pojcSXAPI_CS.java:1699)
at com.icsc.sl.lp.sljcLP02.procStatus(sljcLP02.java:941)
at com.icsc.sl.lp.sljcLP02.instantStart(sljcLP02.java:163)
at com.icsc.sl.lp.sljcLP01.run(sljcLP01.java:97)

==> Performing default dump from com.ibm.ws.rsadapter.DiagnosticModuleForAdapter :Thu Jul 23 08:34:26 GMT+07:00 2015
This is a FFDC log generated for the Default Resource Adapter from source:com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions
The exception caught:com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Cannot call 'cleanup' on a ManagedConnection while it is still in a transaction..
Operating System:AIX 6.1 ppc64
Classpath:/usr/IBM/WebSphere/AppServer/profiles/AppSrv01/properties:/usr/IBM/WebSphere/AppServer/properties:/usr/IBM/WebSphere/AppServer/lib/startup.jar:/usr/IBM/WebSphere/AppServer/lib/bootstrap.jar:/usr/IBM/WebSphere/AppServer/lib/jsf-nls.jar:/usr/IBM/WebSphere/AppServer/lib/lmproxy.jar:/usr/IBM/WebSphere/AppServer/lib/urlprotocols.jar:/usr/IBM/WebSphere/AppServer/deploytool/itp/batchboot.jar:/usr/IBM/WebSphere/AppServer/deploytool/itp/batch2.jar:/usr/IBM/WebSphere/AppServer/java/lib/tools.jar
Ext dirs:/usr/IBM/WebSphere/AppServer/java/jre/lib/ext
IntrospectDepth set from:3 to: 4
Other related data. If null, nothing was passed in BEGIN:[Ljava.lang.Object;@5fb55fb5
[
Cannot call 'cleanup' on a ManagedConnection while it is still in a transaction.
Possible components: Connection Manager
]
END:[Ljava.lang.Object;@5fb55fb5

IntrospectDepth reset to:3
IntrospectDepth set from:3 to: 5
The Objects' instance variables are printed below recursively 2 levels deep BEGIN:com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@6ed46ed4
_______________________________________________________________________

First Failure Data Capture information for
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@6ed46ed4
_______________________________________________________________________

ONE PHASE ENABLED

Database Type:
null

Transaction State:
LOCAL_TRANSACTION_ACTIVE

Statement Cache Size (maximum):
10

Key:
[B@a5d0a5d

Performance Monitoring Instrumentation:
com.ibm.ws.pmi.server.modules.J2CModule@8df08df

Log Writer:
null

Subject:
null

ManagedConnection:
WSRdbManagedConnectionImpl@6ed46ed4

Counter of fatal connection errors for the ManagedConnectionFactory as of the most recent getConnection on this ManagedConnection:
2

Default AutoCommit:
true

Current AutoCommit:
false

AutoCommit reported by the JDBC driver:
false

Current Isolation:
READ COMMITTED (2)

Isolation level has changed? :
true

Support isolation level switching:
true

The tc name is:

null

The tc original user is:

null

The tc releam is:

null

The tc user security token is:

null

The connection wait Time for the mc is:
0

The j2eename is:

null

The gssCredential is:

null

The gssName is:

null

Isolation reported by the JDBC driver:
READ COMMITTED (2)

Catalog, IsReadOnly, or TypeMap has changed? :
false

Default Holdability:
HOLD CURSORS OVER COMMIT (1)

Current Holdability:
HOLD CURSORS OVER COMMIT (1)

Holdability value has changed? :
false

Holdability reported by the JDBC driver:
HOLD CURSORS OVER COMMIT (1)

Thread ID:
null

Lazily enlisted in the current transaction? :
false

Underlying Connection Object: com.ibm.db2.jcc.a.nc@6ecf6ecf
com.ibm.db2.jcc.a.nc@6ecf6ecf

Underlying PooledConnection Object: com.ibm.db2.jcc.DB2PooledConnection@47b447b4
com.ibm.db2.jcc.DB2PooledConnection@47b447b4

SQLJ Default Context: null
null

Is statement caching enabled? :
true

Fatal connection error was detected? :
false

Currently cleaning up handles? :
false

Last ConnectionEvent sent for this ManagedConnection:

com.ibm.ws.rsadapter.spi.WSConnectionEvent@6f1f6f1f
Connection Handle: com.ibm.ws.rsadapter.jdbc.WSJccSQLJConnection@6e2d6e2d
Event ID: CONNECTION CLOSED (1)
Exception: null

Driver version:
2.11.65

Database version:
SQL09077

Connection Event Listeners:

com.ibm.ejs.j2c.ConnectionEventListener@709f709f

Interaction Metrics:
com.ibm.ejs.j2c.ConnectionEventListener@709f709f

Maximum Handle List Size: 15

Handle Count: 0

Handles:

null
null
null
null
null
null
null
null
null
null
null
null
null
null
null

State Manager:
com.ibm.ws.rsadapter.spi.WSStateManager@709b709b

XA Resource:
null

_______________________________________________________________________

First Failure Data Capture information for
com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@7e767e76
_______________________________________________________________________

Connection:
com.ibm.db2.jcc.a.nc@6ecf6ecf

ManagedConnection:
WSRdbManagedConnectionImpl@6ed46ed4

Detection of multithreaded access is:
DISABLED

ManagedConnectionMetaData:
null

Statement Cache:

com.ibm.ws.rsadapter.spi.CacheMap@6f766f76
Number of entries: 0
Maximum entries: 10
Number of buckets: 13
Maximum bucket size: 5
Number of discards: 0

BUCKET SIZE PREV NEXT
000 000 013 013
001 000 013 013
002 000 013 013
003 000 013 013
004 000 013 013
005 000 013 013
006 000 013 013
007 000 013 013
008 000 013 013
009 000 013 013
010 000 013 013
011 000 013 013
012 000 013 013
013 LRU 014
014 MRU 013


_______________________________________________________________________

First Failure Data Capture information for
com.ibm.ws.rsadapter.spi.WSConnectionRequestInfoImpl@6e106e10
_______________________________________________________________________

extention DS properties =
null

extention DS properties key =
-1

useHetrogeneous =
false

changable CRI =
true

optimizeForGetUseCloseUsage =
false

propagateClientIdentityUsingTrustedContext =
false

User Name:
null

Password:
null

Isolation Level:
REPEATABLE READ (4)

Catalog:
null

Is Read Only?
null

Type Map:
null

Cursor Holdability:
DEFAULT CURSOR HOLDABILITY VALUE (0)

Config ID: 0

Hash Code:
0

Support isolation switching on connection:
true

NoEnlistment:
false

ShareWithCMPOnly:
false

propagateClientIdentityUsingTrustedContext:
false

Handle type:
java.sql.Connection

TrustedContext_name:

null

TrustedContext_realm:

null

TrustedContext_userSecToken:

null

TrustedContext_originalUser:

null

gssName =

null

gssCredential =

null

J2EEName =

null

oracle properties =

null

_______________________________________________________________________

First Failure Data Capture information for
com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl@38233823
_______________________________________________________________________

Detection of multithreaded access is
DISABLED

Resource Adapter:
com.ibm.ws.rsadapter.spi.WSResourceAdapterImpl@32713271

Hash Code:
1089084741 (0x40ea1d45)

DataSource properties:
{streamBufferSize=, readOnly=false, statementCacheSize=10, retryIntervalForClientReroute=, deferPrepares=true, useTransactionRedirect=false, currentFunctionPath=, propagateClientIdentityUsingTrustedContext=false, sqljEnableClassLoaderSpecificProfiles=, loginTimeout=0, userDefinedErrorMap=, currentPackagePath=, portNumber=50000, resultSetHoldability=, serverName=localhost, validateNewConnectionRetryInterval=3, preTestSQLString=SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1, securityMechanism=, enableMultithreadedAccessDetection=false, validateNewConnectionRetryCount=100, clientRerouteAlternatePortNumber=, clientRerouteAlternateServerName=, description=, traceFile=, useCachedCursor=, maxRetriesForClientReroute=, validateNewConnection=false, fullyMaterializeLobData=true, dataStoreHelperClass=com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper, kerberosServerPrincipal=, databaseName=idbcsvc, beginTranForVendorAPIs=false, resultSetHoldabilityForCatalogQueries=, freeResourcesOnClose=false, clientUser=, unbindClientRerouteListFromJndi=false, traceLevel=-1, errorDetectionModel=ExceptionMapping, user=javauser, currentPackageSet=, password=******, driverType=4, clientRerouteServerListJNDIName=, queryCloseImplicit=, currentLockTimeout=, jmsOnePhaseOptimization=false, connectionSharing=1, sendDataAsIs=, traceFileAppend=false, validateNewConnectionTimeout=, retrieveMessagesFromServerOnGetMessage=true, blockingReadConnectionTimeout=, traceDirectory=, reauthentication=false, beginTranForResultSetScrollingAPIs=false, fullyMaterializeInputStreams=, keepDynamic=, dataSourceJndiName=jdbc/dscsvc, currentSQLID=, sysSchema=, webSphereDefaultIsolationLevel=, sslConnection=, nonTransactionalDataSource=false, clientProgramName=ERP01, cursorSensitivity=, dataSourceClass=com.ibm.db2.jcc.DB2ConnectionPoolDataSource, currentSchema=, clientWorkstation=, useJDBC4ColumnNameAndLabelSemantics=}

Database Type:
null

DataStoreHelper:
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper@10411041

Description:
null

InternalDataStoreHelper:
com.ibm.ws.rsadapter.spi.InternalDB2UniversalDataStoreHelper@12291229

Log Writer:
null

Performance Monitoring Instrumentation:
com.ibm.ws.pmi.server.modules.J2CModule@8df08df

Statement Cache Size (maximum):
10

Transaction Branches are set to be Loosely Coupled:
null

Counter of fatal connection errors on ManagedConnections created by this MCF:
2

Validate existing connections on cleanup after a fatal connection error is detected?
true

ResetConnectionByBackendDatabase:
false

Backend id checking is:
true

JMSOnePhaseOptimization:
false

Reauthentication:
false

newDBConnectionValidationEnabled:
false

connectionRetriesDuringDBFailover:
100

connRetryDurationDuringDBFailover:
3000

Failover count:
0

DBConnectionPooling enabled:
false

Connection Factory Type:
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource

Listing PropertyChangeListeners:


_______________________________________________________________________

First Failure Data Capture information for
com.ibm.ws.rsadapter.spi.WSRdbDataSource@401b401b
_______________________________________________________________________

DataSource Implementation Class Name:
com.ibm.db2.jcc.DB2ConnectionPoolDataSource

DataSource Name:
null

DataStoreHelper:
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper@10411041

DataSource properties:
{streamBufferSize=, readOnly=false, statementCacheSize=10, retryIntervalForClientReroute=, deferPrepares=true, useTransactionRedirect=false, currentFunctionPath=, propagateClientIdentityUsingTrustedContext=false, sqljEnableClassLoaderSpecificProfiles=, loginTimeout=0, userDefinedErrorMap=, currentPackagePath=, portNumber=50000, resultSetHoldability=, serverName=localhost, validateNewConnectionRetryInterval=3, preTestSQLString=SELECT CURRENT SQLID FROM SYSIBM.SYSDUMMY1, securityMechanism=, enableMultithreadedAccessDetection=false, validateNewConnectionRetryCount=100, clientRerouteAlternatePortNumber=, clientRerouteAlternateServerName=, description=, traceFile=, useCachedCursor=, maxRetriesForClientReroute=, validateNewConnection=false, fullyMaterializeLobData=true, dataStoreHelperClass=com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper, kerberosServerPrincipal=, databaseName=idbcsvc, beginTranForVendorAPIs=false, resultSetHoldabilityForCatalogQueries=, freeResourcesOnClose=false, clientUser=, unbindClientRerouteListFromJndi=false, traceLevel=-1, errorDetectionModel=ExceptionMapping, user=javauser, currentPackageSet=, password=******, driverType=4, clientRerouteServerListJNDIName=, queryCloseImplicit=, currentLockTimeout=, jmsOnePhaseOptimization=false, connectionSharing=1, sendDataAsIs=, traceFileAppend=false, validateNewConnectionTimeout=, retrieveMessagesFromServerOnGetMessage=true, blockingReadConnectionTimeout=, traceDirectory=, reauthentication=false, beginTranForResultSetScrollingAPIs=false, fullyMaterializeInputStreams=, keepDynamic=, dataSourceJndiName=jdbc/dscsvc, currentSQLID=, sysSchema=, webSphereDefaultIsolationLevel=, sslConnection=, nonTransactionalDataSource=false, clientProgramName=ERP01, cursorSensitivity=, dataSourceClass=com.ibm.db2.jcc.DB2ConnectionPoolDataSource, currentSchema=, clientWorkstation=, useJDBC4ColumnNameAndLabelSemantics=}

ONE PHASE ENABLED

Underlying DataSource Object: com.ibm.db2.jcc.DB2ConnectionPoolDataSource@12941294
com.ibm.db2.jcc.DB2ConnectionPoolDataSource@12941294

Counter of unique, modified DataSource configurations: 0

Failover servers list:
[Ljava.lang.Object;@40324032

DynamicDSConfigManager
null

END:com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@6ed46ed4

IntrospectDepth reset to:3
+Data for directive [defaultadapter] obtained.:
==> Dump complete for com.ibm.ws.rsadapter.DiagnosticModuleForAdapter :Thu Jul 23 08:34:26 GMT+07:00 2015

Set Home | Add to Favorites

All Rights Reserved Powered by Free Document Search and Download

Copyright © 2011
This site does not host pdf,doc,ppt,xls,rtf,txt files all document are the property of their respective owners. complaint#downhi.com
TOP