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