Oracle EBS R12.2, Login Page doesn't not open

 

                             

 

EBS_DOMAIN log where there was a stuck thread processing the AppsLocalLogin.jsp page

Error:

<Error> <WebLogicServer> <devebsapp.bescom.com> <oacore_server1> <[ACTIVE] ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0c3c553ba012d498:21ac6fdc:1789db30822:-8000-0000000000000756> <1617632797420> <BEA-000337> <[STUCK] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "652" seconds working on the request "Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 652083 ms

[

POST /OA_HTML/AppsLocalLogin.jsp? HTTP/1.1

Accept: */*

X-Service: AuthenticateUser

Content-type: application/x-www-form-urlencoded

Referer: http://devebsapp.bescom.com:8005/OA_HTML/AppsLocalLogin.jsp

Accept-Language: en-IN

Accept-Encoding: gzip, deflate

User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; Zoom 3.6.0)

Content-Length: 72

Cache-Control: no-cache

Cookie: oracle.uix=0^I^GMT+5:30^p; treemenu1=0,1,34; JSESSIONID=QYGiYM_jdSFfrhsSPsxtse89sYdoTAfAHCcF7pLjOLpmakYnt436!1903357836; DEV=-1

ECID-Context: 1.005jndLPaYL9xWo6wVaeMG0000N0000041;kXjE

Connection: Keep-Alive

X-Forwarded-For: 10.212.134.200

Proxy-Client-IP: 10.212.134.200

X-WebLogic-KeepAliveSecs: 30

X-WebLogic-Force-JVMID: 1903357836

That was caused by the same issue described in the above note:

]", 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:325)

oracle.net.ns.NetInputStream.read(NetInputStream.java:269)

oracle.net.ns.NetInputStream.read(NetInputStream.java:191)

oracle.net.ns.NetInputStream.read(NetInputStream.java:108)

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.DBPreferenceStore.save(DBPreferenceStore.java:485)

oracle.apps.fnd.login.lang.LanguageContext.recordLastSessionLanguage(LanguageContext.java:1047)

oracle.apps.fnd.sso.SessionMgr.createSession(SessionMgr.java:2479)

oracle.apps.fnd.sso.SessionMgr.createSession(SessionMgr.java:1107)

oracle.apps.fnd.sso.SessionMgr.createAppsSession(SessionMgr.java:3504)

oracle.apps.fnd.login.LoginHelper.doAuthenticate(LoginHelper.java:743)

oracle.apps.fnd.login.LoginHelper.callService(LoginHelper.java:1086)

oracle.apps.fnd.login.LoginHelper.service(LoginHelper.java:372)

_pages.__appslocallogin._jspService(__appslocallogin.java:194)

weblogic.servlet.jsp.JspBase.service(JspBase.java:34)

weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

Cause:

1. During execution test dependent on login at the same time hundreds or thousands of times with a similar client.
2. In case there are numerous users who have lapsed password and attempt to change the password simultaneously or then again assuming any client opens the terminated secret key screen and left without finishing, then, at that point, this conflict can happen. 
3. The secret phrase stream is refreshing the inclination of LANGUAGE_CALC for Visitor client, because the real client can't associate until PW is reset,

Action Plan:

1. Please review Note 2578726.1 - High Number Of "enq: TX - Row Lock Contention" On FND_USER_PREFERENCES

2. Apply 30134567:R12.FND.C

3.adident Header $JAVA_TOP/oracle/apps/fnd/login/lang/LanguageContext.class

to verify the version is 120.0.12020000.15

4. Complete the following manual step to fix it

Add the following line to $INST_TOP/appl/admin/oacore_wls.properties and bounce

services:

oracle.fnd.language.rule.lastsession=disable

5. Retest the issue 

Reference :

 Note 2578726.1 - High Number Of "enq: TX - Row Lock Contention" On FND_USER_PREFERENCES