Error occured when executing a query

[Rahesh Kumar <ra...@gmail.com>]

 jeff,

 while working on a query we suddenly experienced a problem as

 ORA-04031: unable to allocate 96 bytes of shared memory ("shared
pool","unknown object","sql area","optdef : apanlg")  . This is a problem
with the database. can this be solved by any means in IBatis . I am giving
the complete stack trace for your kind reference


com.ibatis.dao.client.DaoException: Failed to queryForList - id
[getTimesheets4AppStatus], parameterObject [{endSqlDate=07/02/2006,
startSqlDate=06/04/2006, isWeekEnd=TRUE, statusList=[TIMESHEET APPROVED,
TIMESHEET REJECTED, SUBMITTED FOR APPROVAL, SAVED AS DRAFT],
selectedContractors=[000303622], selectedProjects=[81, 0000000443,
0000000412, 0000000544, 82, 83, 84, 85, 86, 87, 88, 0000000019, 0000000596,
0000000533, 0000000008, 0000000017, 0000000016, 0000000060, 0000000044,
0000000042, 0000000043, 0000000039, 0000000045, 0000000040, 0000000038, 89,
90, 91, 0000000560, 92, 93, 94, 0000000036, 95, 96, 97, 98, 0000000014,
0000000365, 99, 0000000023, 101, 0000000361, 102, 0000000608, 0000000621,
0000000633, 0000000601, 0000000598, 0000000599, 0000000570, 0000000631,
0000000571, 0000000569, 0000000567, 0000000568, 103, 104, 105, 106,
0000000618, 107, 108, 109, 111, 112, 0000000513, 113, 114, 115, 116, 117,
118, 119, 121, 0000000575, 0000000444, 0000000002, 0000000499, 0000000047,
0000000037, 0000000503, 0000000414, 0000000061, 0000000564, 0000000565,
0000000026, 0000000626, 0000000478, 0000000518, 0000000430, 0000000539,
0000000510, 0000000368, 123, 124, 125, 126, 127, 128, 130, 129, 131,
0000000526, 0000000396, 132, 133, 134, 135, 136, 137, 138, 139, 0000000024,
0000000003, 0000000075, 0000000595, 0000000007, 0000000481, 0000000420,
0000000509, 0000000425, 0000000054, 145, 146, 147, 148, 149, 143, 144,
0000000519, 0000000456, 0000000493, 150, 151, 0000000613, 0000000614, 152,
153, 0000000537, 0000000615, 154, 0000000013, 155, 0000000021, 156, 157,
158, 0000000457, 0000000563, 0000000586, 0000000475, 0000000609, 0000000476,
0000000474, 0000000470, 0000000473, 0000000616, 0000000468, 0000000467,
0000000469, 0000000472, 0000000466, 0000000471, 0000000556, 159, 160, 161,
162, 0000000035, 0000000502, 0000000459, 0000000027, 0000000434, 0000000515,
0000000433, 164, 163, 165, 0000000056, 166, 0000000385, 167, 168, 169, 170,
171, 0000000455, 0000000523, 0000000410, 0000000419, 0000000500, 0000000413,
172, 173, 174, 0000000559, 0000000576, 175, 176, 0000000527, 177, 178, 180,
0000000531, 0000000463, 181, 182, 0000000384, 0000000555, 183, 0000000482,
0000000485, 0000000484, 0000000521, 0000000483, 0000000005, 184, 0000000065,
0000000079, 185, 0000000378, 0000000629, 0000000489, 0000000532, 0000000070,
186, 187, 0000000512, 0000000370, 0000000426, 0000000550, 0000000072, 188,
189, 0000000554, 0000000587, 0000000592, 0000000562, 0000000551, 0000000464,
0000000634, 190, 193, 0000000479, 191, 0000000552, 192, 0000000379,
0000000055, 0000000620, 194, 0000000549, 195, 0000000422, 0000000423,
0000000041, 0000000049, 0000000048, 0000000031, 0000000004, 196, 0000000397,
0000000622, 0000000623, 0000000619, 197, 198, 199, 200, 201, 203, 204, 205,
0000000454, 0000000488, 0000000487, 0000000577, 0000000486, 206, 207, 208,
0000000078, 0000000605, 0000000546, 0000000607, 0000000606, 209, 0000000580,
0000000579, 210, 211, 0000000074, 212, 213, 214, 215, 216, 217, 218, 219,
220, 221, 222, 223, 224, 225, 0000000520, 226, 0000000417, 227, 0000000033,
228, 229, 0000000432, 0000000492, 0000000358, 0000000446, 0000000498,
0000000447, 0000000491, 231, 0000000610, 0000000602, 0000000617, 0000000448,
0000000449, 0000000067, 0000000578, 338, 0000000632, 232, 0000000001,
0000000548, 0000000069, 0000000006, 235, 0000000418, 0000000528, 0000000465,
0000000581, 0000000356, 0000000372, 236, 237, 238, 0000000445, 239, 240,
241, 242, 0000000062, 0000000077, 243, 245, 246, 247, 0000000630, 248,
0000000494, 0000000362, 249, 250, 251, 0000000604, 0000000012, 0000000360,
0000000584, 0000000588, 279, 280, 281, 282, 0000000522, 0000000636, 284,
285, 286, 287, 0000000359, 288, 289, 0000000389, 0000000511, 0000000366,
0000000427, 0000000536, 0000000508, 0000000553, 0000000025, 0000000591,
0000000517, 0000000382, 0000000080, 0000000052, 290, 291, 0000000572,
0000000574, 292, 293, 0000000028, 0000000011, 0000000516, 0000000395, 294,
0000000480, 295, 296, 297, 0000000566, 0000000557, 298, 299, 300, 301,
0000000643, 0000000642, 0000000640, 0000000644, 0000000646, 0000000638,
0000000645, 0000000641, 0000000639, 0000000367, 0000000504, 302, 303,
0000000051, 0000000458, 0000000030, 304, 0000000415, 0000000363, 305, 306,
307, 308, 309, 310, 311, 0000000386, 0000000409, 0000000408, 0000000402,
0000000391, 0000000390, 0000000407, 0000000394, 0000000589, 0000000401,
0000000403, 0000000388, 0000000411, 0000000392, 0000000404, 0000000387,
0000000399, 0000000405, 0000000406, 0000000393, 0000000400, 312, 313, 314,
315, 316, 317, 318, 319, 320, 0000000059, 0000000058, 321, 322, 323,
0000000534, 0000000635, 0000000383, 0000000637, 0000000600, 0000000535,
0000000547, 0000000440, 0000000441, 0000000076, 0000000435, 0000000442,
0000000439, 0000000437, 0000000438, 0000000529, 0000000524, 326, 324, 325,
327, 328, 0000000015, 0000000376, 329, 330, 332, 333, 335, 336, 0000000477,
0000000009, 0000000593, 0000000050, 0000000625, 0000000624, 0000000357, 253,
254, 255, 257, 0000000429, 258, 259, 260, 261, 0000000431, 0000000612, 262,
263, 0000000542, 264, 266, 267, 268, 0000000505, 0000000506, 0000000543,
0000000421, 0000000416, 0000000501, 0000000369, 0000000540, 0000000573,
0000000497, 0000000377, 0000000071, 0000000018, 0000000538, 0000000022,
0000000545, 0000000380, 0000000046, 0000000066, 270, 271, 272, 273, 274,
275, 0000000453, 276, 0000000029, 277, 278, 339, 0000000611, 0000000064,
0000000057, 0000000541, 0000000585, 0000000558, 0000000053, 0000000020,
0000000594, 0000000582, 0000000583, 0000000507, 340, 341, 342, 343,
0000000603, 0000000375, 0000000063, 0000000461, 0000000462, 0000000460,
0000000073, 345, 0000000495, 346, 347, 348, 349, 0000000436, 350, 351, 354,
0000000428, 0000000371, 0000000530, 0000000034, 0000000514, 0000000398,
0000000628, 0000000561, 0000000590, 0000000424, 0000000381, 0000000373,
0000000452, 0000000451, 355, 0000000597, 0000000374, 0000000525, 0000000496,
0000000450, 142, 0000000627, 0000000364, 0000000068]}]. Cause:
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred
while applying a parameter map. --- Check the
getTimesheets4AppStatus-InlineParameterMap. --- Check the statement (query
failed). --- Cause: java.sql.SQLException: ORA-04031: unable to allocate 96
bytes of shared memory ("shared pool","unknown object","sql area","optdef :
apanlg") Caused by: java.sql.SQLException: ORA-04031: unable to allocate 96
bytes of shared memory ("shared pool","unknown object","sql area","optdef :
apanlg") Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: ---
The error occurred while applying a parameter map. --- Check the
getTimesheets4AppStatus-InlineParameterMap. --- Check the statement (query
failed). --- Cause: java.sql.SQLException: ORA-04031: unable to allocate 96
bytes of shared memory ("shared pool","unknown object","sql area","optdef :
apanlg") Caused by: java.sql.SQLException: ORA-04031: unable to allocate 96
bytes of shared memory ("shared pool","unknown object","sql area","optdef :
apanlg") at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(
SqlMapDaoTemplate.java:205) at
ctrs.persistence.dao.sqlmapdao.TimesheetSqlMapDao.getTimesheets4AppStatus(Unknown
Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(
Method.java:324) at
com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:64)
at $Proxy1.getTimesheets4AppStatus(Unknown Source) at
ctrs.actions.TimesheetsStatusAction.timesheetsReports(Unknown Source) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(
Method.java:324) at org.apache.struts.actions.DispatchAction.dispatchMethod(
DispatchAction.java:270) at org.apache.struts.actions.DispatchAction.execute
(DispatchAction.java:187) at
org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:431) at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(
StrictServletInstance.java:110) at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(
StrictLifecycleServlet.java:174) at
com.ibm.ws.webcontainer.servlet.ServicingServletState.service(
StrictLifecycleServlet.java:333) at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(
StrictLifecycleServlet.java:116) at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(
ValidServletReferenceState.java:42) at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(
ServletInstanceReference.java:40) at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(
WebAppRequestDispatcher.java:1171) at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(
WebAppRequestDispatcher.java:676) at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(
WebAppRequestDispatcher.java:203) at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:125)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(
WebAppInvoker.java:294) at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(
CachedInvocation.java:71) at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(
CacheableInvocationContext.java:116) at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(
ServletRequestProcessor.java:186) at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(
OSEListener.java:334) at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(
HttpConnection.java:56) at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448) at
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912) Caused by:
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred
while applying a parameter map. --- Check the
getTimesheets4AppStatus-InlineParameterMap. --- Check the statement (query
failed). --- Cause: java.sql.SQLException: ORA-04031: unable to allocate 96
bytes of shared memory ("shared pool","unknown object","sql area","optdef :
apanlg") Caused by: java.sql.SQLException: ORA-04031: unable to allocate 96
bytes of shared memory ("shared pool","unknown object","sql area","optdef :
apanlg") at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
(GeneralStatement.java:185) at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList
(GeneralStatement.java:123) at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
SqlMapExecutorDelegate.java:610) at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
SqlMapExecutorDelegate.java:584) at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(
SqlMapSessionImpl.java:101) at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(
SqlMapClientImpl.java:78) at
com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(
SqlMapDaoTemplate.java:203) ... 40 more Caused by: java.sql.SQLException:
ORA-04031: unable to allocate 96 bytes of shared memory ("shared
pool","unknown object","sql area","optdef : apanlg") at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:2672) at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
OraclePreparedStatement.java:589) at
oracle.jdbc.driver.OraclePreparedStatement.execute(
OraclePreparedStatement.java:656) at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(
WSJdbcPreparedStatement.java:400) at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:180)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
GeneralStatement.java:205) at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
(GeneralStatement.java:173) ... 46 more Caused by:
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred
while applying a parameter map. --- Check the
getTimesheets4AppStatus-InlineParameterMap. --- Check the statement (query
failed). --- Cause: java.sql.SQLException: ORA-04031: unable to allocate 96
bytes of shared memory ("shared pool","unknown object","sql area","optdef :
apanlg") Caused by: java.sql.SQLException: ORA-04031: unable to allocate 96
bytes of shared memory ("shared pool","unknown object","sql area","optdef :
apanlg") at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
(GeneralStatement.java:185) at com.ibatis.sqlmap.enginue255
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;