'ORA-04025: maximum allowed library object lock allocated' When Trying to Accept Tenders from the 'Online Booking and Tendering' (Doc ID 2514149.1)

Last updated on AUGUST 01, 2023

Applies to:

Symptoms

When attempting to accept tenders from the Online Booking and Tendering, the following error occurs.

ERROR
-----------------------
java.sql.SQLException: ORA-04025: maximum allowed library object lock allocated for SELECT T.i_transaction_no, T.shipment_gid, T.origin_location, T.destination_location, T.delivery_time, T.expected_response, S.is_equipment_fixed, S.total_actual_cost, SV.status_value_xid, T.tender_type, T.domain_name, S.servprov_gid, S.t_actual_cost_currency_gid, dl.time_zone_gid, S.exchange_rate_date, S.exchange_rate_gid, S.total_actual_c_fn_currency_gid, S.total_actual_c_fn FROM TENDER_COLLABORATION T, SHIPMENT S, TENDER_COLLABORATION_STATUS TCS, STATUS_VALUE SV, location dl where (T.destination_location=dl.location_gid(+)) and T.shipment_gid = S.shipment_gid AND T.i_transaction_no = TCS.i_transaction_no AND TCS.status_value_gid = SV.status_value_gid AND T.i_transaction_no = :1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:227)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:60)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:748)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1157)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3833)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1344)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1166)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:213)
at glog.util.jdbc.noserver.SqlQuery.resetArguments(SqlQuery.java:178)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:147)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:130)
at glog.server.executionapi.servprov.tenderresp.TCShipmentQuery.runTenderCollabQuery(TCShipmentQuery.java:193)
at glog.server.executionapi.servprov.tenderresp.TenderSessionBean.getTenderCollaborationDetails(TenderSessionBean.java:465)
at glog.server.executionapi.servprov.tenderresp.TenderSessionStub.getTenderCollaborationDetails(TenderSessionStub.java:205)
at glog.webserver.tender.TenderCollaborationProducer.retrieveChildren(TenderCollaborationProducer.java:158)
at glog.webserver.util.Producer.refreshChild(Producer.java:498)
at glog.webserver.util.Producer.refreshChild(Producer.java:484)
at glog.server.producer.ProducerBean.createMasterElementRemote(ProducerBean.java:85)
at glog.server.producer.ProducerStub.createMasterElementRemote(ProducerStub.java:29)
at glog.webserver.util.Producer.createMasterElementRemote(Producer.java:191)
at glog.webserver.util.Producer.loadDocument(Producer.java:73)
at glog.webserver.util.AbstractManagementServlet.getDocument(AbstractManagementServlet.java:346)
at glog.webserver.tender.TenderCollabManagementServlet.getDocument(TenderCollabManagementServlet.java:48)
at glog.webserver.util.AbstractServletProducer.process(AbstractServletProducer.java:80)
at glog.webserver.util.BaseServlet.serviceInternal(BaseServlet.java:995)
at glog.webserver.util.BaseServlet.doServiceGet(BaseServlet.java:888)
at glog.webserver.util.BaseServlet.service(BaseServlet.java:880)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.screenlayout.CsrfFilter.doFilter(CsrfFilter.java:79)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.session.ParameterValidation.doFilter(ParameterValidation.java:32)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.session.clientsession.ClientSessionFilter.doFilter(ClientSessionFilter.java:74)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.session.CacheControlFilter.doFilter(CacheControlFilter.java:29)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.session.ProtectionHeaderFilter.doFilter(ProtectionHeaderFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.session.ContentTypeHeaderFilter.doFilter(ContentTypeHeaderFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.session.CSPFilter.doFilter(CSPFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.screenlayout.FrameInterceptFilter.doFilter(FrameInterceptFilter.java:33)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at glog.webserver.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:46)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:172)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:110)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:273)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:147)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3701)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3667)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2443)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2291)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2269)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1705)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1665)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:652)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: Error : 4025, Position : 0, Sql = SELECT T.i_transaction_no, T.shipment_gid, T.origin_location, T.destination_location, T.delivery_time, T.expected_response, S.is_equipment_fixed, S.total_actual_cost, SV.status_value_xid, T.tender_type, T.domain_name, S.servprov_gid, S.t_actual_cost_currency_gid, dl.time_zone_gid, S.exchange_rate_date, S.exchange_rate_gid, S.total_actual_c_fn_currency_gid, S.total_actual_c_fn FROM TENDER_COLLABORATION T, SHIPMENT S, TENDER_COLLABORATION_STATUS TCS, STATUS_VALUE SV, location dl where (T.destination_location=dl.location_gid(+)) and T.shipment_gid = S.shipment_gid AND T.i_transaction_no = TCS.i_transaction_no AND TCS.status_value_gid = SV.status_value_gid AND T.i_transaction_no = :1 , OriginalSql = SELECT T.i_transaction_no, T.shipment_gid, T.origin_location, T.destination_location, T.delivery_time, T.expected_response, S.is_equipment_fixed, S.total_actual_cost, SV.status_value_xid, T.tender_type, T.domain_name, S.servprov_gid, S.t_actual_cost_currency_gid, dl.time_zone_gid, S.exchange_rate_date, S.exchange_rate_gid, S.total_actual_c_fn_currency_gid, S.total_actual_c_fn FROM TENDER_COLLABORATION T, SHIPMENT S, TENDER_COLLABORATION_STATUS TCS, STATUS_VALUE SV, location dl where (T.destination_location=dl.location_gid(+)) and T.shipment_gid = S.shipment_gid AND T.i_transaction_no = TCS.i_transaction_no AND TCS.status_value_gid = SV.status_value_gid AND T.i_transaction_no = ? , Error Msg = ORA-04025: maximum allowed library object lock allocated for SELECT T.i_transaction_no, T.shipment_gid, T.origin_location, T.destination_location, T.delivery_time, T.expected_response, S.is_equipment_fixed, S.total_actual_cost, SV.status_value_xid, T.tender_type, T.domain_name, S.servprov_gid, S.t_actual_cost_currency_gid, dl.time_zone_gid, S.exchange_rate_date, S.exchange_rate_gid, S.total_actual_c_fn_currency_gid, S.total_actual_c_fn FROM TENDER_COLLABORATION T, SHIPMENT S, TENDER_COLLABORATION_STATUS TCS, STATUS_VALUE SV, location dl where (T.destination_location=dl.location_gid(+)) and T.shipment_gid = S.shipment_gid AND T.i_transaction_no = TCS.i_transaction_no AND TCS.status_value_gid = SV.status_value_gid AND T.i_transaction_no = :1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.