Data in APPLSYS.WF_LOCAL_USER_ROLES are not synchronized.
The following error message when running the following script outlines thecause :
select count(*) from APPLSYS.WF_LOCAL_USER_ROLES;
ORA-01578: ORACLE data block corrupted (file# 23, block # 221085)
ORA-01110: data file 23: '/RDBMS ORACLE_HOME/app/a_txn_data02.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
Http 500 : Internal Server Error When Login To A New Cloned Environment (文档 ID 781413.1)
________________________________________
In this Document
Symptoms
Cause
Solution
________________________________________
Applies to:
Oracle Applications Manager - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
***Checked for relevance on 20-Dec-2012***
Symptoms
On 12.0.4, when attempting to clone the environment,
the following error occurs when login to the new cloned environment.
ERROR:
500 Internal Server Error
java.lang.NoClassDefFoundError
at oracle.apps.fnd.sso.AppsLoginRedirect.doGet(AppsLoginRedirect.java:623)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
Cause
Data in APPLSYS.WF_LOCAL_USER_ROLES are not synchronized.
The following error message when running the following script outlines the cause :
select count(*) from APPLSYS.WF_LOCAL_USER_ROLES;
ORA-01578: ORACLE data block corrupted (file # 23, block # 221085)
ORA-01110: data file 23: '/RDBMS ORACLE_HOME/app/a_txn_data02.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
Solution
To implement the solution, please execute the following steps:
1. Ensure that you have taken a backup of your environment,
2. run the following script on the cloned environment to synchronize the Workflow tables with APPS user
sqlplus apps/<apps password>
set serveroutput on size 100000;
declare
begin
WF_LOCAL_SYNCH.BULKSYNCHRONIZATION(
P_ORIG_SYSTEM => 'ALL',
P_PARALLEL_PROCESSES => null,
P_LOGGING => null,
P_RAISEERRORS => TRUE);
exception
when others then
dbms_output.put_line('sqlerrm = ' || sqlerrm);
end;
/
3. Retest the login issue.
4. Migrate the solution as appropriate to other environments.