WWC-41417 UNABLE TO LOGIN TO PORTAL

When user is unable to login Portal system with following error , deletion of user record from  portal.wwsec_person$ table can solve this issue.

Internal error (WWC-00006)
Unexpected error encountered in wwsec_app_priv.process_signon (User-Defined Exception) (WWC-41417)
There is a conflict with your assigned user name. There is a user entry with this name, but with a different globally unique identifier, which must be resolved before you can log on with this name. Notify your administrator. (WWC-41742)

According to MOS , this issue can occur when user is deleted from OID or recreated in OID and portal tables are not getting the update.

Unexpected SYSAUX tablespace growth because of WRH$_LATCH_CHILDREN

For a while , I have seen unexpected growth at SYSAUX tablespace . When listed objects ordered by size , WRH$_LATCH_CHILDREN table is on the top and as a result of examination , it was caused from statistics_level parameter. For a performance issue i have changed this parameter from TYPICAL to ALL to get more detail information . But after performance issue resolved , i have not changed parameter back and it affected tablespace SYSAUX increased to bigger values.

After changing parameter to old value "TYPICAL" , growth decreased to expected values.


Not only statistics_level parameter can cause this issue according to metalink note, also low snapshot interval can cause. For interval 60 minutes is ideal.

MapViewer Runtime Failure After Upgrading BI from Release 11.1.1.6 to Release 11.1.1.7

After upgrade of current OBIEE to 11.1.1.7 from 11.1.1.6 when trying to access mapviewer URL (http://localhost:7001/mapviewer  below error occured.

"HTTP 500 Internal Server Error" 

Mapviewer was deployed into bi_server1 and related logfile were examined located at $DOMAIN_HOME/bifoundation_domain/servers/bi_server1/logs. Log files had entries like

WatchRuleType: Log
WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))
WatchData: DATE = Dec 5, 2014 8:49:56 PM EET SERVER = bi_server1 MESSAGE = [ServletContext@1774584388[app:mapviewer module:/mapviewer path:/mapviewer spec-version:2.5 version:11.1.1]] Root cause of ServletException.
java.lang.NoClassDefFoundError: oracle/adfinternal/view/faces/taglib/html/HtmlHtmlTag
        at java.lang.Class.getDeclaredConstructors0(Native Method)
        at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
        at java.lang.Class.getConstructor0(Class.java:2699)
        at java.lang.Class.newInstance0(Class.java:326)
        at java.lang.Class.newInstance(Class.java:308)

As a solution Oracle  suggests to delete some files of MapViewer deployment and delete the Weblogic internal cache of the MapViewer application. 

1. Stop Managed server (bi_server1)
2. Delete the following files from MapViewer deployment MW_HOME/Oracle_BI1/bifoundation/jee/mapviewer.ear

• web.war/WEB-INF/lib/adf-faces-api.jar
• web.war/WEB-INF/lib/adf-faces-impl.jar
• web.war/WEB-INF/lib/commons-digester.jar
• web.war/WEB-INF/lib/commons-logging-1.1.jar
• web.war/WEB-INF/lib/jsf-api.jar
• web.war/WEB-INF/lib/jsf-impl.jar
• web.war/WEB-INF/lib/jsr173_1.0_api.jar
• web.war/WEB-INF/lib/mvutil.jar
• web.war/WEB-INF/lib/xdb.jar
• web.war/WEB-INF/adf-faces-config.xml
• web.war/WEB-INF/orion-web.xml

 3. Delete the directory
 MW_HOME/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/mapviewer_11.1.1

4. Restart the managed server

Source 
http://docs.oracle.com/cd/E28280_01/doc.1111/e14770/biee.htm#CHDJIDBD