OBIEE change default style

After upgrade of OBIEE from 11.1.1.6.X to 11.1.1.7.X , dashboard style has changed.According to Oracle note before 11.1.1.7 default style was blafp and new is FusionFX. Customer declared old style is preferred.

To change back to old style , instanceconfig.xml configuration files are edited with below attributes.Related files are located in ORACLE_INSTANCE/config/ OracleBIPresentationServicesComponent / coreapplication_obipsn.

Add or change following attributes between <ServerInstance> and </ServerInstance> tags

    <UI>
    <DefaultStyle>blafp</DefaultStyle>
    <DefaultSkin>blafp</DefaultSkin>
    </UI>

Restart presentation Services.

After this change , there will be icon trouble which is no longer displayed.Related "System busy" icon searching_light.gif is located in %ORACLE_HOME%\bifoundation\ web \appv2\res\s_FusionFX\views\searching_light.gif and must be copied into following locations

Middleware\Oracle_BI1\bifoundation\web\appv2\res\s_blafp\views
 
Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\views

Restart all services.

Invalid Service Name while using RCU

In order to install ODI schemas while using Repository Creation Utility (RCU) , despite entering all connection parameters of database true , "Invalid service name" error occured. From SQLDeveloper using same database connection parameters did not give any error like "Invalid Service Name".

Firstly i have thought it was caused from domain name entry in service name.With and without domain name issue not changed. Also checked tnsnames.ora and listener.ora. But nothing found.

Finally I have examined log file of listener in order to detect any error which points "Invalid service name" . In listener.log file there was an entry like this,

18-AUG-2015 09:16:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=XXX))(service_name=TESTDB.LOCALDOMA0N.LOCAL)(server=dedicated)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.10.10)(PORT=55852)) * establish * TESTDB.LOCALDOMA0N.LOCAL * 12514

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

Service name which is TESTDB.LOCALDOMA0N.LOCAL was not the service name that I entered and "i" character was changed with "0" character.My entry was "testdb.localdomain.local". 

With  upper case of service name  RCU executed as well.

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