oacore warrning
Locked
 
|
Hello,
i would like some help please i have a problem it come everyday almost same time no one can load the login page and it take long time to load or not loading at all if we login and run the java app its working fine inside the app only the login page is the problem and the web browser when i cheek the weblogic i saw a warning at that time to the oacore_server1 "ThreadPool has stuck threads" what could be the problem and how can we fix it attached part of the log with error ####<Jun 13, 2022 5:38:58 AM UTC> <Error> <WebLogicServer> <ebsprod1> <oacore_server1> <[STANDBY] ExecuteThread: '112' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <ce4fc0fa3a639335:-4a0aa5c9:18157912827:-8000-0000000000000bb3> <1655098738136> <BEA-000337> <[STUCK] ExecuteThread: '188' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "613" seconds working on the request "Workmanager: default, Version: 1, Scheduled=true, Started=true, Started time: 613601 ms [ GET /OA_HTML/RF.jsp?function_id=55277&resp_id=50942&resp_appl_id=800&security_group_id=0&lang_code=AR&oas=Lq3T1oG1k5dS8HqXLt0AxQ..&formsLink=yes HTTP/1.1 Accept: text/html, application/xhtml+xml, image/jxr, */* Accept-Language: ar-SA,ar;q=0.8,en-US;q=0.5,en;q=0.2 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko Accept-Encoding: gzip, deflate Cookie: oracle.uix=0^^GMT+3:00^p; JSESSIONID=kvpbXjKEIBHOT4gtfcMmw7kebuQzhUd6oDmvGNh3hlxRqL-3ISrc!-372217979; PROD=BRZdglWO0Wgy78iOluTU4P3Urn ECID-Context: 1.005sKnhXqdwEwGG6yzbe6G0002bo000003;kXjE Connection: Keep-Alive X-Forwarded-For: 172.16.4.251 Proxy-Client-IP: 172.16.4.251 X-WebLogic-KeepAliveSecs: 30 X-WebLogic-Force-JVMID: -372217979 ]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace: java.net.SocketInputStream.socketRead0(Native Method) java.net.SocketInputStream.read(SocketInputStream.java:152) java.net.SocketInputStream.read(SocketInputStream.java:122) oracle.net.nt.MetricsEnabledInputStream.read(TcpNTAdapter.java:730) oracle.net.ns.Packet.receive(Packet.java:310) oracle.net.ns.DataPacket.receive(DataPacket.java:108) oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:317) oracle.net.ns.NetInputStream.read(NetInputStream.java:262) oracle.net.ns.NetInputStream.read(NetInputStream.java:187) oracle.net.ns.NetInputStream.read(NetInputStream.java:104) oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:126) oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:82) oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1178) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:314) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213) oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769) oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954) oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353) oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539) weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99) oracle.apps.fnd.common.WebAppsContext.doValidateSession(WebAppsContext.java:1255) oracle.apps.fnd.common.WebAppsContext.validateSession(WebAppsContext.java:1618) oracle.apps.fnd.common.WebRequestUtil.validateContextPrivate(WebRequestUtil.java:500) oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:369) oracle.apps.fnd.functionSecurity.RunFunction.init(RunFunction.java:366) oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.isActionableURI(JTFWrapperFilter.java:190) oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:132) weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source) weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432) weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138) java.security.AccessController.doPrivileged(Native Method) oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324) oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464) oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121) oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211) oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163) weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748) weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714) weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283) weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182) weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499) weblogic.work.ExecuteThread.execute(ExecuteThread.java:263) weblogic.work.ExecuteThread.run(ExecuteThread.java:221) > |
Administrator
|
1) I checked the error stack. Some part of it is generic. But the line T4C8Oall.java:548 seems specific.
According to that, the issue seems like the jdbc driver bug.. OSB stuck threads on JDBC calls, 'java.net.SocketInputStream.socketRead0' (Doc ID 2114310.1) you may try upgrading the jdbc driver.. (some ref: Upgrading to Oracle JDBC Thin Driver 12.1 with Oracle E-Business Suite Release 12.2 (Doc ID 2704025.1)) But first you should verify it.. Verify the current JDBC version. Verify the Oracle JDBC Thin Driver Version 12.1.0.2 Installed Use the following procedure to verify that the new version of Oracle JDBC Thin driver is installed: Log in to Oracle E-Business Suite as the SYSADMIN user. Set the profile option "FND: Diagnostics" at user level to "Yes". Note that the profile code is FND_DIAGNOSTICS. Navigate back to the HTML-based Oracle E-Business Suite applications home page. Click About this Page at the bottom of the page. Click the Technology Components tab. *What is the name of the JDBC driver Product/Component named there? 2) The cause may be different than the login page problem. Here -> Oacore Going to Failed State Due to STUCK Threads when Performing a Search in Receipts Page (Doc ID 2905389.1) -- please check that as well. |
|
|
hello
today we got this issue again i went to dump thread stacks found this
|
|
Administrator
|
Check this Note -> Higher CPU usage on the e-Business Suite database after implementing Non-Reversible Hash Passwords (Doc ID 2349156.1)
If your state (Non-reversible hash password algorithm has been implemented) is similar, you may consider applying Patch 27038079 1OFF:25656271:25197573: AOLJ TRACKING BUG FOR PERFORMANCE ISSUE. |
«
Return to EBS 12.2
|
1 view|%1 views
| Free forum by Nabble | Edit this page |