EBS 12.2 login page not showing ,after running autoconfig on DB + App tier

[ashish_oracleguy]

Hello,

I am running EBS 12.2.3  against 11.2.0.4 RAC db.

I was trying to do adop phase=prepare, had an error, had to abort it.

Then successfully ran autoconfig on all the DB nodes (RAC) + also on the EBS App tier (Run file system)

All the EBS mid tier processes strt, including concurrent mgrs etc.

But the EBS login page does not show and as soon as I paste the URL of the login page on the browser, the following error message shows in the oacore_server1.log file

---

####<Jul 17, 2017 3:45:07 PM CDT> <Error> <ServletContext-/OA_HTML> <dvcpap01.mclaneco.com> <oacore_server1> <[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005L8_tMOlQ3BDW5pz_AiY0004kf00000N> <1500324307367> <BEA-000000> <chain failed
javax.servlet.ServletException: java.lang.Exception: java.lang.NullPointerException
at weblogic.servlet.jsp.PageContextImpl.handlePageException(PageContextImpl.java:417)
at _pages.__appslocallogin._jspService(__appslocallogin.java:300)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.ServletStubImpl.onAddToMapException(ServletStubImpl.java:416)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:327)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
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:442)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3739)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3705)


Please help

[ErmanArslansOracleBlog]

What is shown in the browser?

Blank page? or error?

Send me the screenshot.

[ashish_oracleguy]

Blank page, no error on the page.

As I mentioned, same time this message shows in the oacore_server1.log file


####<Jul 17, 2017 3:45:07 PM CDT> <Error> <ServletContext-/OA_HTML> <dvcpap01.mclaneco.com> <oacore_server1> <[ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005L8_tMOlQ3BDW5pz_AiY0004kf00000N> <1500324307367> <BEA-000000> <chain failed
javax.servlet.ServletException: java.lang.Exception: java.lang.NullPointerException
at weblogic.servlet.jsp.PageContextImpl.handlePageException(PageContextImpl.java:417)
at _pages.__appslocallogin._jspService(__appslocallogin.java:300)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.ServletStubImpl.onAddToMapException(ServletStubImpl.java:416)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:327)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
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:442)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3739)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3705)

-------------


Thanks

[ErmanArslansOracleBlog]

Well.. As this is started after autoconfig, there might be some profile values that was changed by autoconfig.

check this one - > When Bringing Up The EBS Apps Login Page, A Blank Page Is Returned (Doc ID 1943995.1)

[ashish_oracleguy]

ok.
Thanks.

I will update, after I have checked.

Regards,

Ashish

[ashish_oracleguy]

Hello Erman,

I reviewed the document 1943995.1, and i am checking the profile value.

However, I saw something, which might be the cause of my issue, here is the data, please provide your input


--------

In the current environment, where the login screen does not show up, D1, here is some relevant information

SQL> select * from dba_editions;

EDITION_NAME PARENT_EDITION_NAME USA
------------------------------ ------------------------------ ---
ORA$BASE YES


--------------

Ran this query and got no row at all

As applsys

select APPLICATION_ID,PROFILE_OPTION_ID from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME='APPS_LOGIN_FUNCTION';

APPLICATION_ID PROFILE_OPTION_ID
-------------- -----------------
0 9869
--------------

SQL> select LEVEL_VALUE,LAST_UPDATE_DATE,PROFILE_OPTION_VALUE,ZD_EDITION_NAME from fnd_profile_option_values where APPLICATION_ID=0 and PROFILE_OPTION_ID=9869
2 /

no rows selected

--------------------In another environment, where things are working fine etc, VCPD2

SQL> select * from dba_editions;

EDITION_NAME PARENT_EDITION_NAME USA
------------------------------ ------------------------------ ---
ORA$BASE YES
V_20161007_1449 ORA$BASE YES
V_20170117_1225 V_20161007_1449 YES
V_20170628_0911 V_20170117_1225 YES
-----------------------

SQL> select APPLICATION_ID,PROFILE_OPTION_ID from FND_PROFILE_OPTIONS where PROFILE_OPTION_NAME='APPS_LOGIN_FUNCTION';

APPLICATION_ID PROFILE_OPTION_ID
-------------- -----------------
0 9869

---------------------

SQL> select LEVEL_VALUE,LAST_UPDATE_DATE,PROFILE_OPTION_VALUE,ZD_EDITION_NAME from fnd_profile_option_values where APPLICATION_ID=0 and PROFILE_OPTION_ID=9869;

LEVEL_VALUE LAST_UPDATE_DATE PROFILE_OPTION_VALUE ZD_EDITION_NAME
----------- ------------------ ---------------------------------------- ------------------------------
0 19-JUL-06 APPS_LOGIN_DEFAULT V_20170628_0911


----------------

As I mentioned, initially I was trying to apply a patch to the D1 environment,

adop phase=prepare had an error, running autoconfig on the run file system.

I did an adop phase=abort

Then successfully ran the autoconfig on all the DB nodes and App tier , then the issue of login screen now showing started.

Thanks

[ErmanArslansOracleBlog]

Aha..
Interesting.

"The local login page is defined by the profile 'Applications Login Fuction' and by default this should be set to 'APPS_LOGIN_DEFAULT'."

*so, set that profile using fnd_profile api and retry. If successful, do a full cleanup (adop phase=cleanup cleanup_mode=full) and do fs_clone (adop phase=fs_clone) to be in a clean state.
Afterwards, rerun autoconfig  and check if the value of APPS_LOGIN_DEFAULT is updated. If you don't see any problem after running autoconfig, run prepare phase and see if you can run adop prepare without any problems.

[ashish_oracleguy]

Hello Erman,

You pointed in the right direction -

"The local login page is defined by the profile 'Applications Login Fuction' and by default this should be set to 'APPS_LOGIN_DEFAULT'." "

---------------

I had made a backup of the table FND_PROFILE_OPTION_VALUES in APPLSYS schema and deleted some rows that had , ZD_EDITION_NAME value to an old DB editions which was not there, which caused my login screen missing issue.

Once I restored those rows from the backup table to FND_PROFILE_OPTION_VALUES , the login screen appeared and I was able to login into my system. -- Things are fine now.

----------------------------------------------------------


However the fundamental issue with my system is still there and i can't apply any patch right now on it.
 
Basically, here is how I would pra-phase my issue
 
I have my AD_ZD tech stack out of sync with the DB editions.
 
Here is why I say this
 
Basically , the out come of these 2 queries tell me that ,my AD_ZD tech stack is out of sync with DB editions:
 
SQL> select distinct zd_edition_name from fnd_profile_option_values;
 
ZD_EDITION_NAME
------------------------------
V_20160624_1030
 
SQL> select * from dba_editions;
 
EDITION_NAME PARENT_EDITION_NAME USA
------------------------------ ------------------------------ ---
ORA$BASE                                                       YES
 
---
 
Any suggestions on how to fix it.

Thanks,

Ashish
 

[ErmanArslansOracleBlog]

You say : "However the fundamental issue with my system is still there and i can't apply any patch right now on it. "

what is the issue that you are getting while applying a patch?
Send me the relevant output and log.

[ashish_oracleguy]

Hello Erman,

When I initially ran the

adop phase=prepare , i got this error


ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.ADX_PRF_PKG", line 52
ORA-06512: at line 6


------

Thanks

[ashish_oracleguy]

Here is the error message

****************************************************


Executing script in InstantiateFile:
/u02/mclvcp/VCPD1/fs1/inst/apps/VCPD1_dvcpap01/admin/install/adgendbc.sh
script returned:
****************************************************

adgendbc.sh started at Wed Jul 12 00:37:56 CDT 2017


SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jul 12 00:37:56 2017

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
begin
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.ADX_PRF_PKG", line 52
ORA-06512: at line 6


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options



===================

Please let me know what log you want.

Regards

Ashish

[ErmanArslansOracleBlog]

This plsql is probably doing some operations on fnd_profile_options and fnd_profile_options_values. I mean the seeded tables.

What is written in line 512 of APPS.ADX_PRF_PKG. What is the query used there?  Can you check the code.
Maybe it can give us a clue.
Plsql gets more than one rows while running a query, although it is not designed to do so.

[ashish_oracleguy]

Hello Erman,

Thanks for your feedback.

Here is my analysis, as you mentioned about the "the seeded tables.  "

In my database , when i run this query and get the below output

SQL> select * from dba_editions;

EDITION_NAME PARENT_EDITION_NAME                    USA
------------------------------ ------------------------------ ---
ORA$BASE                                                                 YES

whereas when i run this query and get this output.

SQL> select distinct zd_edition_name from fnd_profile_option_values;

ZD_EDITION_NAME
------------------------------
V_20160624_1030


This tells me that, my AD_ZD tech stack info is NOT in sync with DB Editions.

As in my other systems where adop works, the output of the above query matches.

---

So now the question is how do I handle this NOT in sync situation.

Thanks

[ErmanArslansOracleBlog]

How is it sync in that system? Can you show me?

25 Tem 2017 21:35 tarihinde "ashish_oracleguy [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hello Erman,

Thanks for your feedback.

Here is my analysis, as you mentioned about the "the seeded tables.  "

In my database , when i run this query and get the below output

SQL> select * from dba_editions;

EDITION_NAME PARENT_EDITION_NAME                    USA
------------------------------ ------------------------------ ---
ORA$BASE                                                                 YES

whereas when i run this query and get this output.

SQL> select distinct zd_edition_name from fnd_profile_option_values;

ZD_EDITION_NAME
------------------------------
V_20160624_1030


This tells me that, my AD_ZD tech stack info is NOT in sync with DB Editions.

As in my other systems where adop works, the output of the above query matches.

---

So now the question is how do I handle this NOT in sync situation.

Thanks

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-login-page-not-showing-after-running-autoconfig-on-DB-App-tier-tp2977p3048.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[ashish_oracleguy]

ok.

Here is a system, where ADOP works

Please see the output of the same 2 queries ---

SQL> select * from dba_editions;

EDITION_NAME                   PARENT_EDITION_NAME            USA
------------------------------ ------------------------------ ---
ORA$BASE                                                      YES
V_20161007_1449                ORA$BASE                       YES
V_20170117_1225                V_20161007_1449                YES
V_20170628_0911                V_20170117_1225                YES


-------------

SQL> select distinct zd_edition_name from fnd_profile_option_values;

ZD_EDITION_NAME
------------------------------
V_20170628_0911


--

See how the ZD_EDITIONS_NAME output matches with the latest DB edition -- V_20170628_0911

Whereas in the system where I have the adop issue, the output does NOT match.

Thanks