Blank Page Accessing R12 - Application.log shows "html: chain failed", "Unable to create user session"

Blank Page Accessing R12 - Application.log shows "html: chain failed", "Unable to create user session"

The following is seen in the $INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log:

10/03/05 09:14:58.625 html: 10.1.3.0.0 Started
10/03/05 09:22:38.520 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1267777358520

10/03/05 09:22:38.520 html: LeakSetting:
global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
ignoring:null

10/03/05 09:22:39.951 html: chain failedjavax.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.0.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:780)

at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:727)

at _AppsLocalLogin._jspService(_AppsLocalLogin.java:304)

at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.0.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

at ...

Cause:

The transition from the main page to the AppsLocalLogin page cannot happen because of problems with the database.  In several reported cases, the problem was easily identified in the database alert log as a table space being full:

For example, the alert_sid.log contained several repeats of the following:

ORA-1654: unable to extend index APPLSYS.FND_LOGINS_U1 by 16 in tablespace APPS_TS_ARCHIVE in another service request the similar error was seen, but with APPS_TS_MEDIA instead.

Solution:

1. Review the database alert_sid.log and check for errors indicating a full tablespace.

2. Extend the size of the indicated tablespace

Reference metalink Doc ID 734692.1