ODI-26039 Connection Failed SnpConnect does not exit

After successful creation of Physical Connection for topology , whenever i would like to test connection below error occured.

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

[2015-07-10T11:16:56.605+03:00] [] [ERROR] [ODI-1131] [] [tid: 138] [ecid: 0000KtqYh5M2zG15zvP5iW1LbDz400001H,0] Agent XXX encountered an error: c.getObjectByIdent :  SnpConnect does not exist[[
oracle.odi.runtime.agent.ExecutionException: SnpConnect.getObjectByIdent :  SnpConnect does not exist
        at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:144)
        at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)
        at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
        at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)
        at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
        at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
        at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

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

There was no error at connection string, username or password. Maybe error was about agent and new agent was created. But starting agent was not also successful and another error occured like below ,

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



Agent NEWAGENT encountered an error: ODI-1405: Agent NEWAGENT start failure: the agent is not defined in the topology for master repository.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------

This error gave some clue and in odiparams.sh file wrong setting of ODI_MASTER_URL was observed.After setting to proper value , everything gone fine.

Not able to view notifications - ORA:20002: 3207

A client declared "I am not Not able to view notifications from OAF despite I have lots of .. " . Also clicking related URL in notifications mail give ORA-2002:3707 : User does not have access to notification ..

Expired FND  user can cause this issue.

To detect that if it is  , below sql can be run.

select f.USER_NAME "FND USER NAME", wfr.DISPLAY_NAME, f.END_DATE, r.EXPIRATION_DATE,
    wfr.STATUS, wfr.EXPIRATION_DATE, wfr.ORIG_SYSTEM, wfr.PARENT_ORIG_SYSTEM
    from fnd_user f, wf_roles wfr, wf_local_user_roles r
    where f.USER_NAME=wfr.NAME
    and wfr.NAME=r.ROLE_NAME
    and r.user_name = '&username';

If expiration date is less then SYSDATE then this user seems Expried Employee

In order to solve this

1.From Security--> User-->Define query user.

2.Remove employee name from Person field

3.Save

4.Add employee name to Person field back

5.Save

6.Re-query user.
7.Run Synchronize WF Local Tables program

Asmcmd cp command gives ORA-15046

Copy process with following command for asm gave ORA-15046 error ,

asmcmd> cp +DISKGROUP1/thread_1_seq_113238.728.870731045 +DISKGROUP2/thread_1_seq_113238.728.870731045


ASMCMD-8016: copy source->'+DISKGROUP1/thread_1_seq_113238.728.870731045' and target->'+DISKGROUP2/thread_1_seq_113238.728.870731045' failed
ORA-15056: additional error message
ORA-15046: ASM file name '+DISKGROUP2/thread_1_seq_113238.728.870731045' is not in single-file creation form
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 413
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

According to metalink target filename should not contain number incarnation.File is not in a form that can e used to create single file.

In order to fix this below command can be used in like form

asmcmd> cp +DISKGROUP1/thread_1_seq_113238.728.870731045 +DISKGROUP2/thread_1_seq_113238

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

Tips & Tricks 4 : Conditional index

Client asked me if it is possible to create unique index on any table on condition. For example only 1 record is acceptable for any document which has active_flag as '1'. For active_flag '0' there can be more than 1 record.

In order to do this  we will create unique index with condition

SQL> create table t1 (document_id number,active_flag char(1));

Table created.

SQL> create unique index t1_idx on t1(case when active_flag='1' then document_id else null end);



For active_flag as '1' index will be populated with document_id , and for '0' not.
 
SQL> insert into t1 values (1,'1');

1 row created.

SQL> insert into t1 values (2,'1');

1 row created.

SQL> insert into t1 values (1,'0');

1 row created.

SQL> insert into t1 values (1,'0');

1 row created. -- able to insert same record

SQL> insert into t1 values (1,'1');
insert into t1 values (1,'1')
*
ERROR at line 1:
ORA-00001: unique constraint (TEST.T1_IDX) violated

-- Not able to insert same record for active_flag '1' value .