The environment was an R12 bulit on database 11gR2 and it was integrated with SSO as well.
Issue Description:
Getting a blank page after entering the login credentials at the SSO page when accessing the application URL.
Symptoms:
We tried first to check if the application was working fine without having to go through the SSO and hence we tried the AppsLocalLogin.jsp page (http://deif.isc.com:8043/OA_HTML/AppsLocalLogin.jsp). The link was leading to a blank page.
Nextly, When we tried the logging to the application through SSO (http://deif.isc.com:8043/OA_HTML/AppsLogin), the SSO page was loading and we were able to enter the login credentials and after that it was again giving a blank page. When we looked at the browser URL we again found that the it was pointing to the AppsLocalLogin.jsp after we authenticate against the SSO
Troubleshooting Steps:
Firstly, we tried to check the services and found it all to be up and running.
Nextly we turned to the access and error logs for the HTTP_Server and found no hints in there.
We also tried to recompile the jsp using the ojspcompile.pl (perl $FND_TOP/bin/ojspcompile.jsp --compile --flush --p 2)
But this also did not help.
We check to find if any invalids objects were present in the database and found that no new invalids were present.
Then further looking into the logs, we found the below error in the oacore log (application.log) at location
$LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_
10/10/04 01:57:06.314 html: chain failed javax.servlet.ServletException: java.lang.RuntimeException: Unable to create user session. Please contact your System Administrator.
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageThrowable EvermindPageContext.java:899) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageException EvermindPageContext.java:816)
at _AppsLocalLogin._jspService(_AppsLocalLogin.java:303)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.5.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
This prompted us to check alert log which had these errors recorded
ORA-1653: unable to extend table ICX.ICX_SESSIONS by 16 in tablespace APPS_DATA
Mon Oct 04 02:21:33 2010
It turned out to be a tablespace issue. Whenever a login process happens it is recorded in the ICX_SESSIONS table as GUEST user is making a connection when the AppsLocalLogin.jsp pages gets loaded even before it asks for the login credentials. Once the login credentials is made a record is made in the table against the user id used to login.
Once we added the space to the tablespace in problem here, the page AppsLocalLogin.jsp loaded without issues and were able to login.
- Tanveer Madan
Posts
12 comments:
Congratulations on your first post!
- Aravind
Boss,
Detailed and simple explanation!!!
Nice Work Tanveer!!!Keep rocking :-)
Cheers
Jegan N
Did it help anyone???
Thanks Dear,
It was a great help.
Cheers,
Aadil Qadri
Hi,
One of my SSO user is getting the blank and I am getting the same error message in oacore log as soon as user enters the credentials but I am not getting any error in the alert log file, can any one suggest on this.
Hi Syed
Check in the oacore logs (application.log) to see if you get messages like "unable to assert user". If yes, you need to check on the profile option settings for SSO. Also, you should be able to do a telnet on database listener port of your oid database from the web server where oacore is running.
Hope that helps
Aravind
Hi Aravind,
Thanks for your reply, I checked in the application log, I got the same error as you mentioned i.e cannot assert user, but I am able to do telnet from OID server to webserver. so as you said can you please tell me which SSO profile options I need to check. Thanks for your time.
Nice work
Hi,
Last week i was having on-call support and one of the users pinged me to check for one fo the instances for which login pages was not commming up.
This is the same error i found in alert log.
Thanks for making it public. It really helped me , the size of apps_data table space was almost full.
kns
I Got a AppsLocalLogin Page balank in R12.1.3 because of the my server time goes to old date (2002) and while starting up the system it may seen date changes in forms deploying ... But sarts with status 0.
after date corrected in server and full sytem bounce wold resolve.
Kosala- Sri Lanka
Great Post Tanveer....cheers!!!!
- Manish Ranjan
Hello Tanveer i need your help
Can you please guide me how to develop a custom jsp page to bypass Oracle Apps R12 Login.
Actually Our requirement is some external user will enter the login details in some third party login page with the third party generated username and passwrod, that user's credentials are mapped to oracle system,so as soon as they enter credentials having validated it has to redirect that external user to Oracle Apps R12 Home Page, where responsibilities are shown. Currently that third Party login page is set to redirect to RF.jsp through appslocallogin
when i try to enter url .....\....\appslocallogin, its not redirectin to custom login, m getting error uri is too large
Can you please help me...
Its very urgent. We are running short of time. Its a sev 1 issue.
Please reply soon.
Thanks
Post a Comment