This discussion is archived
3 Replies Latest reply: Aug 26, 2013 8:24 AM by Joe Weinstein RSS

java hung threads

1003614 Newbie
Currently Being Moderated

Hi All,

 

am facing below error.kindly suggest how to avoide below error.

 

db:oracle 11g RAC

OS: solaris

 

SystemOut_13.08.16_15.10.53.log:[8/16/13 14:53:27:939 EST] 00000003 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 9" (00000254) has been active for 750886 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

SystemOut_13.08.16_16.10.15.log:[8/16/13 15:40:59:045 EST] 00000254 ThreadMonitor W   WSVR0606W: Thread "WebContainer : 9" (00000254) was previously reported to be hung but has completed.  It was active for approximately 3601993 milliseconds.  There is/are 0 thread(s) in total in the server that still may be hung.

 

SystemOut_13.08.16_14.52.28.log:[8/16/13 14:23:27:586 EST] 00000018 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 42" (00000322) has been active for 601450 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

SystemOut_13.08.16_14.52.28.log:[8/16/13 14:41:27:627 EST] 00000018 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 9" (00000044) has been active for 762650 milliseconds and may be hung.  There is/are 2 thread(s) in total in the server that may be hung.

 

SystemOut_13.08.16_15.27.53.log:[8/16/13 15:13:30:129 EST] 00000322 ThreadMonitor W   WSVR0606W: Thread "WebContainer : 42" (00000322) was previously reported to be hung but has completed.  It was active for approximately 3603994 milliseconds.  There is/are 1 thread(s) in total in the server that still may be hung.

SystemOut_13.08.16_16.07.41.log:[8/16/13 15:28:45:929 EST] 00000044 ThreadMonitor W   WSVR0606W: Thread "WebContainer : 9" (00000044) was previously reported to be hung but has completed.  It was active for approximately 3600957 milliseconds.  There is/are 0 thread(s) in total in the server that still may be hung.

 

 

SystemOut_13.08.16_17.25.18.log:[8/16/13 16:53:27:930 EST] 0000001a ThreadMonitor W   WSVR0605W: Thread "WebContainer : 53" (0000041e) has been active for 707561 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

SystemOut_13.08.16_17.25.18.log:[8/16/13 16:55:30:157 EST] 0000041e ThreadMonitor W   WSVR0606W: Thread "WebContainer : 53" (0000041e) was previously reported to be hung but has completed.  It was active for approximately 829789 milliseconds.  There is/are 0 thread(s) in total in the server that still may be hung.

 

SystemOut_13.08.16_23.00.00.log:[8/16/13 22:38:28:698 EST] 0000001a ThreadMonitor W   WSVR0605W: Thread "WebContainer : 71" (00000dde) has been active for 624191 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

SystemOut.log:[8/16/13 23:28:06:781 EST] 00000dde ThreadMonitor W   WSVR0606W: Thread "WebContainer : 71" (00000dde) was previously reported to be hung but has completed.  It was active for approximately 3602274 milliseconds.  There is/are 0 thread(s) in total in the server that still may be hung.

 

 

SystemOut_13.08.16_09.31.58.log:[8/16/13 9:02:28:481 EST] 00000003 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 25" (0000012b) has been active for 738235 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

SystemOut_13.08.16_09.31.58.log:[8/16/13 9:04:18:066 EST] 0000012b ThreadMonitor W   WSVR0606W: Thread "WebContainer : 25" (0000012b) was previously reported to be hung but has completed.  It was active for approximately 847821 milliseconds.  There is/are 0 thread(s) in total in the server that still may be hung.

SystemOut_13.08.16_23.00.00.log:[8/16/13 22:17:30:945 EST] 00000018 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 91" (0000107e) has been active for 754752 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

SystemOut.log:[8/16/13 23:05:00:606 EST] 0000107e ThreadMonitor W   WSVR0606W: Thread "WebContainer : 91" (0000107e) was previously reported to be hung but has completed.  It was active for approximately 3604414 milliseconds.  There is/are 0 thread(s) in total in the server that still may be hung.

 

 

 

SystemOut_13.08.16_05.22.04.log.gz:[8/16/13 0:14:26:916 EST] 0000001d ThreadMonitor W   WSVR0605W: Thread "WebContainer : 96" (000014c4) has been active for 723576 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

SystemOut_13.08.16_05.22.04.log.gz:[8/16/13 0:14:36:947 EST] 000014c4 ThreadMonitor W   WSVR0606W: Thread "WebContainer : 96" (000014c4) was previously reported to be hung but has completed.  It was active for approximately 733607 milliseconds.  There is/are 0 thread(s) in total in the server that still may be hung.

SystemOut_13.08.16_14.58.50.log.gz:[8/16/13 14:50:30:506 EST] 0000001a ThreadMonitor W   WSVR0605W: Thread "WebContainer : 47" (000002f4) has been active for 707705 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

SystemOut_13.08.16_16.27.01.log.gz:[8/16/13 15:38:46:339 EST] 000002f4 ThreadMonitor W   WSVR0606W: Thread "WebContainer : 47" (000002f4) was previously reported to be hung but has completed.  It was active for approximately 3603552 milliseconds.  There is/are 0 thread(s) in total in the server that still may be hung.

 

 

 

 

[8/16/13 14:40:57:053 EST] 00000254 SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO,PROJECT_ID

S ProjectId,A.Work_Type_Desc,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS SERVICE_IDENTIFIER,TO_CHAR(A.RECEIVED_TIMESTAMP, 'DD/MM/YYYY') "Received Date",TO_CHAR(A.RECEIVED_TIMESTAMP, 'HH:MI A.M.') "Recei

ved Time",TO_CHAR(CRD.FROM_TIME, 'DD/MM/YYYY') "Requested Date",TO_CHAR(CRD.FROM_TIME, 'HH:MI A.M.') "Requested Time",A.MEDIUM_OF_ENTRY,A.REVISION,A.SERVICE_STATUS,CASE WHEN CR.CHANGE_TYPE = 'MOD'

THEN 'Modify' WHEN CR.CHANGE_TYPE = 'WD' THEN 'Withdrawn' ELSE CR.CHANGE_TYPE END AS "TYPE" FROM (SELECT DISTINCT S.REVISION,R.CUSTOMER_NAME,R.PROJECT_ID,R.CHANNEL_TYPE,R.REQUEST_ID,R.SP_REFERENCE_

NO,WT.WORK_TYPE_DESC,R.REQUEST_REVISION_ID,R.RECEIVED_TIMESTAMP,R.MEDIUM_OF_ENTRY,RI.REQUEST_ITEM_REVISION_ID,(SELECT SERVICE_STATUS_DESCRIPTION FROM SERVICE_STATUS WHERE SERVICE_STATUS_CODE = (SEL

ECT SERVICE_STATUS_CODE FROM SERVICE_STATUS_HISTORY WHERE SERVICE_STATUS_HISTORY_ID = (SELECT SERVICE_STATUS_HISTORY_ID FROM SERVICE_STATUS_HISTORY WHERE STATUS_TIMESTAMP = (SELECT MAX(STATUS_TIMES

TAMP) FROM SERVICE_STATUS_HISTORY WHERE SERVICE_REVISION_ID=S.SERVICE_REVISION_ID )))) AS SERVICE_STATUS FROM REQUEST R,WORK_TYPE WT,REQUEST_ITEM RI,SERVICE S WHERE RI.REQUEST_REVISION_ID = R.REQUE

ST_REVISION_ID  AND WT.WORK_TYPE_ID = RI.WORK_TYPE_ID AND R.SP_ID = 34  AND RI.REQUEST_ITEM_REVISION_ID = S.REQUEST_ITEM_REVISION_ID AND R.RECEIVED_TIMESTAMP BETWEEN TO_DATE('15/08/13 00:00:00','dd

/mm/yy hh24:mi:ss') AND TO_DATE('16/08/13 00:00:00','dd/mm/yy hh24:mi:ss')  ) A LEFT JOIN APPOINTMENT APP ON (A.REQUEST_REVISION_ID=APP.REQUEST_REVISION_ID AND APP.REVISION = A.REVISION ) LEFT JOIN

CRD ON (APP.APPMT_REVISION_ID=CRD.APPMT_REVISION_ID AND CRD.ASSIGNED = 'Y' AND UPPER(CRD.CRD_TYPE)='TELSTRA') LEFT JOIN CUSTOMER CUST ON CUST.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID LEFT JOIN

CHANGE_REQUEST CR ON (CR.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID AND CR.VERSION = (A.REVISION-1)) ORDER BY A.REQUEST_ID ASC,SERVICE_IDENTIFIER,A.REVISION

[8/16/13 14:40:57:054 EST] 00000254 SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@28012801

 

 

 

[8/16/13 14:53:27:939 EST] 00000003 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 9" (00000254) has been active for 750886 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.GeneratedMethodAccessor1168.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

        at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

        at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

        at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

        at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

 

 

 

 

 

[8/16/13 14:13:26:137 EST] 00000322 SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO,PROJECT_ID

S ProjectId,A.Work_Type_Desc,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS SERVICE_IDENTIFIER,TO_CHAR(A.RECEIVED_TIMESTAMP, 'DD/MM/YYYY') "Received Date",TO_CHAR(A.RECEIVED_TIMESTAMP, 'HH:MI A.M.') "Recei

ved Time",TO_CHAR(CRD.FROM_TIME, 'DD/MM/YYYY') "Requested Date",TO_CHAR(CRD.FROM_TIME, 'HH:MI A.M.') "Requested Time",A.MEDIUM_OF_ENTRY,A.REVISION,A.SERVICE_STATUS,CASE WHEN CR.CHANGE_TYPE = 'MOD'

THEN 'Modify' WHEN CR.CHANGE_TYPE = 'WD' THEN 'Withdrawn' ELSE CR.CHANGE_TYPE END AS "TYPE" FROM (SELECT DISTINCT S.REVISION,R.CUSTOMER_NAME,R.PROJECT_ID,R.CHANNEL_TYPE,R.REQUEST_ID,R.SP_REFERENCE_

NO,WT.WORK_TYPE_DESC,R.REQUEST_REVISION_ID,R.RECEIVED_TIMESTAMP,R.MEDIUM_OF_ENTRY,RI.REQUEST_ITEM_REVISION_ID,(SELECT SERVICE_STATUS_DESCRIPTION FROM SERVICE_STATUS WHERE SERVICE_STATUS_CODE = (SEL

ECT SERVICE_STATUS_CODE FROM SERVICE_STATUS_HISTORY WHERE SERVICE_STATUS_HISTORY_ID = (SELECT SERVICE_STATUS_HISTORY_ID FROM SERVICE_STATUS_HISTORY WHERE STATUS_TIMESTAMP = (SELECT MAX(STATUS_TIMES

TAMP) FROM SERVICE_STATUS_HISTORY WHERE SERVICE_REVISION_ID=S.SERVICE_REVISION_ID )))) AS SERVICE_STATUS FROM REQUEST R,WORK_TYPE WT,REQUEST_ITEM RI,SERVICE S WHERE RI.REQUEST_REVISION_ID = R.REQUE

ST_REVISION_ID  AND WT.WORK_TYPE_ID = RI.WORK_TYPE_ID AND R.SP_ID = 34  AND RI.REQUEST_ITEM_REVISION_ID = S.REQUEST_ITEM_REVISION_ID AND R.RECEIVED_TIMESTAMP BETWEEN TO_DATE('15/08/13 00:00:00','dd

/mm/yy hh24:mi:ss') AND TO_DATE('16/08/13 00:00:00','dd/mm/yy hh24:mi:ss')  ) A LEFT JOIN APPOINTMENT APP ON (A.REQUEST_REVISION_ID=APP.REQUEST_REVISION_ID AND APP.REVISION = A.REVISION ) LEFT JOIN

CRD ON (APP.APPMT_REVISION_ID=CRD.APPMT_REVISION_ID AND CRD.ASSIGNED = 'Y' AND UPPER(CRD.CRD_TYPE)='TELSTRA') LEFT JOIN CUSTOMER CUST ON CUST.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID LEFT JOIN

CHANGE_REQUEST CR ON (CR.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID AND CR.VERSION = (A.REVISION-1)) ORDER BY A.REQUEST_ID ASC,SERVICE_IDENTIFIER,A.REVISION

[8/16/13 14:13:26:215 EST] 00000322 SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@3e653e65

 

[8/16/13 14:23:27:586 EST] 00000018 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 42" (00000322) has been active for 601450 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

        at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

        at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

        at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

        at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

 

 

[8/16/13 14:28:44:975 EST] 00000044 SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID REQUEST_NBR,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO

SP_REFERENCE_NBR,'' PROJECT_ID,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS FNN,A.REQUEST_ITEM_REVISION_ID REQUEST_ITEM_ID,WT.WORK_TYPE_DESC,A.ORDER_ITEM_ID ORDER_NO,'' SEGMENT_TYPE,'' SEGMENT_STATUS,A.D

ESCRIPTION,to_char(A.CREATED_DATE, 'dd/mm/yyyy') AH_CREATED_DATE,A.AH_CREATED_TIME,replace(replace(replace(A.NOTES, chr(10), ' '), chr(13), ' '),'  ', ' ') ACTIVITY_NOTES FROM (SELECT DISTINCT R.CU

STOMER_NAME,R.CHANNEL_TYPE,R.REQUEST_ID,R.REQUEST_REVISION_ID,R.SP_REFERENCE_NO,RI.REQUEST_ITEM_REVISION_ID,RI.WORK_TYPE_ID,AH.DESCRIPTION,AH.CREATED_DATE,TO_CHAR(AH.CREATED_DATE, 'HH24:mi:ss') AH_

CREATED_TIME,AH.NOTES,Get_Order_No(RI.REQUEST_ITEM_REVISION_ID) AS ORDER_ITEM_ID FROM ACTIVITY_HISTORY AH,REQUEST_ITEM RI,REQUEST R WHERE (AH.REQUEST_ITEM_REVISION_ID = RI.REQUEST_ITEM_REVISION_ID

OR AH.REQUEST_REVISION_ID = R.REQUEST_REVISION_ID) AND AH.SP_VIEWABLE_FLAG = 'Y' AND R.REQUEST_REVISION_ID = RI.REQUEST_REVISION_ID AND AH.CREATED_DATE > TO_DATE('15/08/13 12:00:00','dd/mm/yy hh24:

mi:ss') AND AH.CREATED_DATE <= TO_DATE('15/08/13 14:00:00','dd/mm/yy hh24:mi:ss' )AND R.SP_ID = 34 ) A LEFT JOIN WORK_TYPE WT ON WT.WORK_TYPE_ID = A.WORK_TYPE_ID LEFT JOIN CUSTOMER CUST ON CUST.REQ

UEST_REVISION_ID = A.REQUEST_REVISION_ID ORDER BY A.REQUEST_ID,A.AH_CREATED_TIME

[8/16/13 14:28:45:037 EST] 00000044 SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@4d374d37

 

 

[8/16/13 14:41:27:627 EST] 00000018 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 9" (00000044) has been active for 762650 milliseconds and may be hung.  There is/are 2 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

 

[8/16/13 16:41:40:370 EST] 0000041e SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO,PROJECT_ID

S ProjectId,A.Work_Type_Desc,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS SERVICE_IDENTIFIER,TO_CHAR(A.RECEIVED_TIMESTAMP, 'DD/MM/YYYY') "Received Date",TO_CHAR(A.RECEIVED_TIMESTAMP, 'HH:MI A.M.') "Recei

ved Time",TO_CHAR(CRD.FROM_TIME, 'DD/MM/YYYY') "Requested Date",TO_CHAR(CRD.FROM_TIME, 'HH:MI A.M.') "Requested Time",A.MEDIUM_OF_ENTRY,A.REVISION,A.SERVICE_STATUS,CASE WHEN CR.CHANGE_TYPE = 'MOD'

THEN 'Modify' WHEN CR.CHANGE_TYPE = 'WD' THEN 'Withdrawn' ELSE CR.CHANGE_TYPE END AS "TYPE" FROM (SELECT DISTINCT S.REVISION,R.CUSTOMER_NAME,R.PROJECT_ID,R.CHANNEL_TYPE,R.REQUEST_ID,R.SP_REFERENCE_

NO,WT.WORK_TYPE_DESC,R.REQUEST_REVISION_ID,R.RECEIVED_TIMESTAMP,R.MEDIUM_OF_ENTRY,RI.REQUEST_ITEM_REVISION_ID,(SELECT SERVICE_STATUS_DESCRIPTION FROM SERVICE_STATUS WHERE SERVICE_STATUS_CODE = (SEL

ECT SERVICE_STATUS_CODE FROM SERVICE_STATUS_HISTORY WHERE SERVICE_STATUS_HISTORY_ID = (SELECT SERVICE_STATUS_HISTORY_ID FROM SERVICE_STATUS_HISTORY WHERE STATUS_TIMESTAMP = (SELECT MAX(STATUS_TIMES

TAMP) FROM SERVICE_STATUS_HISTORY WHERE SERVICE_REVISION_ID=S.SERVICE_REVISION_ID )))) AS SERVICE_STATUS FROM REQUEST R,WORK_TYPE WT,REQUEST_ITEM RI,SERVICE S WHERE RI.REQUEST_REVISION_ID = R.REQUE

ST_REVISION_ID  AND WT.WORK_TYPE_ID = RI.WORK_TYPE_ID AND R.SP_ID = 29  AND RI.REQUEST_ITEM_REVISION_ID = S.REQUEST_ITEM_REVISION_ID AND R.RECEIVED_TIMESTAMP BETWEEN TO_DATE('15/08/13 00:00:00','dd

/mm/yy hh24:mi:ss') AND TO_DATE('16/08/13 00:00:00','dd/mm/yy hh24:mi:ss')  ) A LEFT JOIN APPOINTMENT APP ON (A.REQUEST_REVISION_ID=APP.REQUEST_REVISION_ID AND APP.REVISION = A.REVISION ) LEFT JOIN

CRD ON (APP.APPMT_REVISION_ID=CRD.APPMT_REVISION_ID AND CRD.ASSIGNED = 'Y' AND UPPER(CRD.CRD_TYPE)='TELSTRA') LEFT JOIN CUSTOMER CUST ON CUST.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID LEFT JOIN

CHANGE_REQUEST CR ON (CR.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID AND CR.VERSION = (A.REVISION-1)) ORDER BY A.REQUEST_ID ASC,SERVICE_IDENTIFIER,A.REVISION

 

[8/16/13 16:41:40:452 EST] 0000041e SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@7e837e83

 

 

[8/16/13 16:53:27:930 EST] 0000001a ThreadMonitor W   WSVR0605W: Thread "WebContainer : 53" (0000041e) has been active for 707561 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.GeneratedMethodAccessor1720.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

 

[8/16/13 22:28:04:508 EST] 00000dde SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID REQUEST_NBR,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO

SP_REFERENCE_NBR,'' PROJECT_ID,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS FNN,A.REQUEST_ITEM_REVISION_ID REQUEST_ITEM_ID,WT.WORK_TYPE_DESC,A.ORDER_ITEM_ID ORDER_NO,'' SEGMENT_TYPE,'' SEGMENT_STATUS,A.D

ESCRIPTION,to_char(A.CREATED_DATE, 'dd/mm/yyyy') AH_CREATED_DATE,A.AH_CREATED_TIME,replace(replace(replace(A.NOTES, chr(10), ' '), chr(13), ' '),'  ', ' ') ACTIVITY_NOTES FROM (SELECT DISTINCT R.CU

STOMER_NAME,R.CHANNEL_TYPE,R.REQUEST_ID,R.REQUEST_REVISION_ID,R.SP_REFERENCE_NO,RI.REQUEST_ITEM_REVISION_ID,RI.WORK_TYPE_ID,AH.DESCRIPTION,AH.CREATED_DATE,TO_CHAR(AH.CREATED_DATE, 'HH24:mi:ss') AH_

CREATED_TIME,AH.NOTES,Get_Order_No(RI.REQUEST_ITEM_REVISION_ID) AS ORDER_ITEM_ID FROM ACTIVITY_HISTORY AH,REQUEST_ITEM RI,REQUEST R WHERE (AH.REQUEST_ITEM_REVISION_ID = RI.REQUEST_ITEM_REVISION_ID

OR AH.REQUEST_REVISION_ID = R.REQUEST_REVISION_ID) AND AH.SP_VIEWABLE_FLAG = 'Y' AND R.REQUEST_REVISION_ID = RI.REQUEST_REVISION_ID AND AH.CREATED_DATE > TO_DATE('15/08/13 10:00:00','dd/mm/yy hh24:

mi:ss') AND AH.CREATED_DATE <= TO_DATE('15/08/13 12:00:00','dd/mm/yy hh24:mi:ss' )AND R.SP_ID = 34 ) A LEFT JOIN WORK_TYPE WT ON WT.WORK_TYPE_ID = A.WORK_TYPE_ID LEFT JOIN CUSTOMER CUST ON CUST.REQ

UEST_REVISION_ID = A.REQUEST_REVISION_ID ORDER BY A.REQUEST_ID,A.AH_CREATED_TIME

[8/16/13 22:28:04:509 EST] 00000dde SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@13a813a8

 

 

[8/16/13 22:38:28:698 EST] 0000001a ThreadMonitor W   WSVR0605W: Thread "WebContainer : 71" (00000dde) has been active for 624191 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.GeneratedMethodAccessor1720.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

 

 

 

[8/16/13 8:50:10:247 EST] 0000012b SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO,PROJECT_ID A

ProjectId,A.Work_Type_Desc,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS SERVICE_IDENTIFIER,TO_CHAR(A.RECEIVED_TIMESTAMP, 'DD/MM/YYYY') "Received Date",TO_CHAR(A.RECEIVED_TIMESTAMP, 'HH:MI A.M.') "Receiv

ed Time",TO_CHAR(CRD.FROM_TIME, 'DD/MM/YYYY') "Requested Date",TO_CHAR(CRD.FROM_TIME, 'HH:MI A.M.') "Requested Time",A.MEDIUM_OF_ENTRY,A.REVISION,A.SERVICE_STATUS,CASE WHEN CR.CHANGE_TYPE = 'MOD' T

HEN 'Modify' WHEN CR.CHANGE_TYPE = 'WD' THEN 'Withdrawn' ELSE CR.CHANGE_TYPE END AS "TYPE" FROM (SELECT DISTINCT S.REVISION,R.CUSTOMER_NAME,R.PROJECT_ID,R.CHANNEL_TYPE,R.REQUEST_ID,R.SP_REFERENCE_N

O,WT.WORK_TYPE_DESC,R.REQUEST_REVISION_ID,R.RECEIVED_TIMESTAMP,R.MEDIUM_OF_ENTRY,RI.REQUEST_ITEM_REVISION_ID,(SELECT SERVICE_STATUS_DESCRIPTION FROM SERVICE_STATUS WHERE SERVICE_STATUS_CODE = (SELE

CT SERVICE_STATUS_CODE FROM SERVICE_STATUS_HISTORY WHERE SERVICE_STATUS_HISTORY_ID = (SELECT SERVICE_STATUS_HISTORY_ID FROM SERVICE_STATUS_HISTORY WHERE STATUS_TIMESTAMP = (SELECT MAX(STATUS_TIMEST

AMP) FROM SERVICE_STATUS_HISTORY WHERE SERVICE_REVISION_ID=S.SERVICE_REVISION_ID )))) AS SERVICE_STATUS FROM REQUEST R,WORK_TYPE WT,REQUEST_ITEM RI,SERVICE S WHERE RI.REQUEST_REVISION_ID = R.REQUES

T_REVISION_ID  AND WT.WORK_TYPE_ID = RI.WORK_TYPE_ID AND R.SP_ID = 95  AND RI.REQUEST_ITEM_REVISION_ID = S.REQUEST_ITEM_REVISION_ID AND R.RECEIVED_TIMESTAMP BETWEEN TO_DATE('15/08/13 00:00:00','dd/

mm/yy hh24:mi:ss') AND TO_DATE('16/08/13 00:00:00','dd/mm/yy hh24:mi:ss')  ) A LEFT JOIN APPOINTMENT APP ON (A.REQUEST_REVISION_ID=APP.REQUEST_REVISION_ID AND APP.REVISION = A.REVISION ) LEFT JOIN

CRD ON (APP.APPMT_REVISION_ID=CRD.APPMT_REVISION_ID AND CRD.ASSIGNED = 'Y' AND UPPER(CRD.CRD_TYPE)='TELSTRA') LEFT JOIN CUSTOMER CUST ON CUST.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID LEFT JOIN C

HANGE_REQUEST CR ON (CR.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID AND CR.VERSION = (A.REVISION-1)) ORDER BY A.REQUEST_ID ASC,SERVICE_IDENTIFIER,A.REVISION

[8/16/13 8:50:10:247 EST] 000002d1 Class         I [TID: unknown] Class  Start SqMappingTransformer convertToBO()...

[8/16/13 8:50:10:248 EST] 000002d1 Class         I [TID: unknown] Class  End SqMappingTransformer convertToBO()...

[8/16/13 8:50:10:248 EST] 0000012b SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@15551555

[

 

 

 

[8/16/13 9:02:28:481 EST] 00000003 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 25" (0000012b) has been active for 738235 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

 

 

[8/16/13 22:04:56:194 EST] 0000107e SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO,PROJECT_ID

S ProjectId,A.Work_Type_Desc,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS SERVICE_IDENTIFIER,TO_CHAR(A.RECEIVED_TIMESTAMP, 'DD/MM/YYYY') "Received Date",TO_CHAR(A.RECEIVED_TIMESTAMP, 'HH:MI A.M.') "Recei

ved Time",TO_CHAR(CRD.FROM_TIME, 'DD/MM/YYYY') "Requested Date",TO_CHAR(CRD.FROM_TIME, 'HH:MI A.M.') "Requested Time",A.MEDIUM_OF_ENTRY,A.REVISION,A.SERVICE_STATUS,CASE WHEN CR.CHANGE_TYPE = 'MOD'

THEN 'Modify' WHEN CR.CHANGE_TYPE = 'WD' THEN 'Withdrawn' ELSE CR.CHANGE_TYPE END AS "TYPE" FROM (SELECT DISTINCT S.REVISION,R.CUSTOMER_NAME,R.PROJECT_ID,R.CHANNEL_TYPE,R.REQUEST_ID,R.SP_REFERENCE_

NO,WT.WORK_TYPE_DESC,R.REQUEST_REVISION_ID,R.RECEIVED_TIMESTAMP,R.MEDIUM_OF_ENTRY,RI.REQUEST_ITEM_REVISION_ID,(SELECT SERVICE_STATUS_DESCRIPTION FROM SERVICE_STATUS WHERE SERVICE_STATUS_CODE = (SEL

ECT SERVICE_STATUS_CODE FROM SERVICE_STATUS_HISTORY WHERE SERVICE_STATUS_HISTORY_ID = (SELECT SERVICE_STATUS_HISTORY_ID FROM SERVICE_STATUS_HISTORY WHERE STATUS_TIMESTAMP = (SELECT MAX(STATUS_TIMES

TAMP) FROM SERVICE_STATUS_HISTORY WHERE SERVICE_REVISION_ID=S.SERVICE_REVISION_ID )))) AS SERVICE_STATUS FROM REQUEST R,WORK_TYPE WT,REQUEST_ITEM RI,SERVICE S WHERE RI.REQUEST_REVISION_ID = R.REQUE

ST_REVISION_ID  AND WT.WORK_TYPE_ID = RI.WORK_TYPE_ID AND R.SP_ID = 34  AND RI.REQUEST_ITEM_REVISION_ID = S.REQUEST_ITEM_REVISION_ID AND R.RECEIVED_TIMESTAMP BETWEEN TO_DATE('15/08/13 00:00:00','dd

/mm/yy hh24:mi:ss') AND TO_DATE('16/08/13 00:00:00','dd/mm/yy hh24:mi:ss')  ) A LEFT JOIN APPOINTMENT APP ON (A.REQUEST_REVISION_ID=APP.REQUEST_REVISION_ID AND APP.REVISION = A.REVISION ) LEFT JOIN

CRD ON (APP.APPMT_REVISION_ID=CRD.APPMT_REVISION_ID AND CRD.ASSIGNED = 'Y' AND UPPER(CRD.CRD_TYPE)='TELSTRA') LEFT JOIN CUSTOMER CUST ON CUST.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID LEFT JOIN

CHANGE_REQUEST CR ON (CR.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID AND CR.VERSION = (A.REVISION-1)) ORDER BY A.REQUEST_ID ASC,SERVICE_IDENTIFIER,A.REVISION

 

 

[8/16/13 22:04:56:251 EST] 0000107e SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@695b695b

 

 

 

[8/16/13 22:17:30:945 EST] 00000018 ThreadMonitor W   WSVR0605W: Thread "WebContainer : 91" (0000107e) has been active for 754752 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

 

 

[8/16/13 14:38:42:791 EST] 000002f4 SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO,PROJECT_ID

S ProjectId,A.Work_Type_Desc,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS SERVICE_IDENTIFIER,TO_CHAR(A.RECEIVED_TIMESTAMP, 'DD/MM/YYYY') "Received Date",TO_CHAR(A.RECEIVED_TIMESTAMP, 'HH:MI A.M.') "Recei

ved Time",TO_CHAR(CRD.FROM_TIME, 'DD/MM/YYYY') "Requested Date",TO_CHAR(CRD.FROM_TIME, 'HH:MI A.M.') "Requested Time",A.MEDIUM_OF_ENTRY,A.REVISION,A.SERVICE_STATUS,CASE WHEN CR.CHANGE_TYPE = 'MOD'

THEN 'Modify' WHEN CR.CHANGE_TYPE = 'WD' THEN 'Withdrawn' ELSE CR.CHANGE_TYPE END AS "TYPE" FROM (SELECT DISTINCT S.REVISION,R.CUSTOMER_NAME,R.PROJECT_ID,R.CHANNEL_TYPE,R.REQUEST_ID,R.SP_REFERENCE_

NO,WT.WORK_TYPE_DESC,R.REQUEST_REVISION_ID,R.RECEIVED_TIMESTAMP,R.MEDIUM_OF_ENTRY,RI.REQUEST_ITEM_REVISION_ID,(SELECT SERVICE_STATUS_DESCRIPTION FROM SERVICE_STATUS WHERE SERVICE_STATUS_CODE = (SEL

ECT SERVICE_STATUS_CODE FROM SERVICE_STATUS_HISTORY WHERE SERVICE_STATUS_HISTORY_ID = (SELECT SERVICE_STATUS_HISTORY_ID FROM SERVICE_STATUS_HISTORY WHERE STATUS_TIMESTAMP = (SELECT MAX(STATUS_TIMES

TAMP) FROM SERVICE_STATUS_HISTORY WHERE SERVICE_REVISION_ID=S.SERVICE_REVISION_ID )))) AS SERVICE_STATUS FROM REQUEST R,WORK_TYPE WT,REQUEST_ITEM RI,SERVICE S WHERE RI.REQUEST_REVISION_ID = R.REQUE

ST_REVISION_ID  AND WT.WORK_TYPE_ID = RI.WORK_TYPE_ID AND R.SP_ID = 34  AND RI.REQUEST_ITEM_REVISION_ID = S.REQUEST_ITEM_REVISION_ID AND R.RECEIVED_TIMESTAMP BETWEEN TO_DATE('15/08/13 00:00:00','dd

/mm/yy hh24:mi:ss') AND TO_DATE('16/08/13 00:00:00','dd/mm/yy hh24:mi:ss')  ) A LEFT JOIN APPOINTMENT APP ON (A.REQUEST_REVISION_ID=APP.REQUEST_REVISION_ID AND APP.REVISION = A.REVISION ) LEFT JOIN

CRD ON (APP.APPMT_REVISION_ID=CRD.APPMT_REVISION_ID AND CRD.ASSIGNED = 'Y' AND UPPER(CRD.CRD_TYPE)='TELSTRA') LEFT JOIN CUSTOMER CUST ON CUST.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID LEFT JOIN

CHANGE_REQUEST CR ON (CR.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID AND CR.VERSION = (A.REVISION-1)) ORDER BY A.REQUEST_ID ASC,SERVICE_IDENTIFIER,A.REVISION

[8/16/13 14:38:42:792 EST] 000002f4 SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@2e902e9

[

 

 

 

[8/16/13 14:50:30:506 EST] 0000001a ThreadMonitor W   WSVR0605W: Thread "WebContainer : 47" (000002f4) has been active for 707705 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

        at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

        at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

        at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

        at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

[8/16/13 0:02:23:344 EST] 000014c4 SystemOut     O Passed query in getResultsInCSVFormat:SELECT DISTINCT A.CHANNEL_TYPE,A.REQUEST_ID,CASE WHEN A.CUSTOMER_NAME IS NOT NULL THEN A.CUSTOMER_NAME ELSE CUST.NAME END AS "END USER",A.SP_REFERENCE_NO,PROJECT_ID A

ProjectId,A.Work_Type_Desc,Get_Fnn(A.REQUEST_ITEM_REVISION_ID) AS SERVICE_IDENTIFIER,TO_CHAR(A.RECEIVED_TIMESTAMP, 'DD/MM/YYYY') "Received Date",TO_CHAR(A.RECEIVED_TIMESTAMP, 'HH:MI A.M.') "Receiv

ed Time",TO_CHAR(CRD.FROM_TIME, 'DD/MM/YYYY') "Requested Date",TO_CHAR(CRD.FROM_TIME, 'HH:MI A.M.') "Requested Time",A.MEDIUM_OF_ENTRY,A.REVISION,A.SERVICE_STATUS,CASE WHEN CR.CHANGE_TYPE = 'MOD' T

HEN 'Modify' WHEN CR.CHANGE_TYPE = 'WD' THEN 'Withdrawn' ELSE CR.CHANGE_TYPE END AS "TYPE" FROM (SELECT DISTINCT S.REVISION,R.CUSTOMER_NAME,R.PROJECT_ID,R.CHANNEL_TYPE,R.REQUEST_ID,R.SP_REFERENCE_N

O,WT.WORK_TYPE_DESC,R.REQUEST_REVISION_ID,R.RECEIVED_TIMESTAMP,R.MEDIUM_OF_ENTRY,RI.REQUEST_ITEM_REVISION_ID,(SELECT SERVICE_STATUS_DESCRIPTION FROM SERVICE_STATUS WHERE SERVICE_STATUS_CODE = (SELE

CT SERVICE_STATUS_CODE FROM SERVICE_STATUS_HISTORY WHERE SERVICE_STATUS_HISTORY_ID = (SELECT SERVICE_STATUS_HISTORY_ID FROM SERVICE_STATUS_HISTORY WHERE STATUS_TIMESTAMP = (SELECT MAX(STATUS_TIMEST

AMP) FROM SERVICE_STATUS_HISTORY WHERE SERVICE_REVISION_ID=S.SERVICE_REVISION_ID )))) AS SERVICE_STATUS FROM REQUEST R,WORK_TYPE WT,REQUEST_ITEM RI,SERVICE S WHERE RI.REQUEST_REVISION_ID = R.REQUES

T_REVISION_ID  AND WT.WORK_TYPE_ID = RI.WORK_TYPE_ID AND R.SP_ID = 29  AND RI.REQUEST_ITEM_REVISION_ID = S.REQUEST_ITEM_REVISION_ID AND R.RECEIVED_TIMESTAMP BETWEEN TO_DATE('15/08/13 00:00:00','dd/

mm/yy hh24:mi:ss') AND TO_DATE('16/08/13 00:00:00','dd/mm/yy hh24:mi:ss')  ) A LEFT JOIN APPOINTMENT APP ON (A.REQUEST_REVISION_ID=APP.REQUEST_REVISION_ID AND APP.REVISION = A.REVISION ) LEFT JOIN

CRD ON (APP.APPMT_REVISION_ID=CRD.APPMT_REVISION_ID AND CRD.ASSIGNED = 'Y' AND UPPER(CRD.CRD_TYPE)='TELSTRA') LEFT JOIN CUSTOMER CUST ON CUST.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID LEFT JOIN C

HANGE_REQUEST CR ON (CR.REQUEST_REVISION_ID = A.REQUEST_REVISION_ID AND CR.VERSION = (A.REVISION-1)) ORDER BY A.REQUEST_ID ASC,SERVICE_IDENTIFIER,A.REVISION

[8/16/13 0:02:23:435 EST] 000014c4 SystemOut     O Connection:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@7f5c7f5c

[

 

 

[8/16/13 0:14:26:916 EST] 0000001d ThreadMonitor W   WSVR0605W: Thread "WebContainer : 96" (000014c4) has been active for 723576 milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung.

        at java.net.SocketInputStream.socketRead0(Native Method)

        at java.net.SocketInputStream.read(SocketInputStream.java:129)

        at oracle.net.ns.Packet.receive(Packet.java:282)

        at oracle.net.ns.DataPacket.receive(DataPacket.java:103)

        at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)

        at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)

        at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)

        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1082)

        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:703)

        at com.telstra.lolo.nbn.GetResultsInCSVFormat.getResultsInCSVFormat(GetResultsInCSVFormat.java:22)

        at sun.reflect.GeneratedMethodAccessor1419.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:600)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeMethod(JavaDispatcher.java:178)

        at com.ibm.ws.webservices.engine.dispatchers.java.JavaDispatcher.invokeOperation(JavaDispatcher.java:141)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processRequestResponse(SoapRPCProcessor.java:490)

        at com.ibm.ws.webservices.engine.dispatchers.SoapRPCProcessor.processMessage(SoapRPCProcessor.java:433)

        at com.ibm.ws.webservices.engine.dispatchers.BasicDispatcher.processMessage(BasicDispatcher.java:134)

        at com.ibm.ws.webservices.engine.dispatchers.java.SessionDispatcher.invoke(SessionDispatcher.java:204)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler.invoke(JAXRPCHandler.java:153)

        at com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:64)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:263)

        at com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:336)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:1131)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

        at com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:344)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)

        at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)

        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)

        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:276)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

        at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

        at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205)

        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)

 

 

 

thanks,

Mike.

  • 1. Re: java hung threads
    rp0428 Guru
    Currently Being Moderated

    How do expect anyone to be able to help when you provide NO information about what you are even doing?

     

    Your question is basically the same as saying: my car is making a funny noise; please tell me why my car is making a funny noise.

     

    Reread your own thread and ask yourself if you could help anyone based ONLY on what you posted.


  • 2. Re: java hung threads
    1003614 Newbie
    Currently Being Moderated

    thanks rp for reply...am  dba ...what info required from my..i will get it from java application team...

  • 3. Re: java hung threads
    Joe Weinstein Expert
    Currently Being Moderated

    Hi Mike. From the one stacktrace you show, your client (WebSphere, using the Oracle JDBC driver)

    is simply waiting for the DBMS to respond to the query request. Something funny happened, most

    likely in the DBMS. You now need to find out what the DBMS thinks is going on in that DBMS

    session. Is the session blocked? Does the session think it already replied? Stuff like that.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points