OBIEE Online Training

Tuesday, April 2, 2013

OBIEE 11.1.1.7 certification matrix


Hi All,

System Requirements and Supported Platforms for Oracle Business Intelligence Suite Enterprise Edition 11gR1 (11.1.1.7.0) ( xls)

Download Excel format (bi-11gr1certmatrix-ps6-1928219.xls)
https://docs.google.com/spreadsheet/ccc?key=0AhBUO3DvOkSPdEdJLTRvUEpoME03SzduZ01CV3pESnc#gid=0

For More,
http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Thanks
Deva

New features in Obiee 11.1.1.7.0

Hi,

"Recommended Visualizations Feature for Creating Views"

"Breadcrumbs"

"Enhancement to Dashboards"

"Enhancements to Graphs"

"Enhancements to Views"

"Enhancements to Prompts"

"New Menu Options for Exporting Views and Results"

"Total Member Placement for Hierarchical Columns"

"Browse Catalog Search Results by Object Attributes"

"Navigate from the Total or Grand Total in a Table or Pivot Table"

"New BI Desktop Tools Available for Download"

"Enhancement to Favorites"

"Integration of Oracle BI EE with Oracle Enterprise Performance Management System"

For more refer
http://docs.oracle.com/cd/E28280_01/bi.1111/e10544/whatsnew.htm#CEGGEIIJ


Thanks
Deva

Obiee11.1.1.7.0 has been released

Hi all,

Most waited version obiee11.1.1.7 has been released (hope this to be stable)

You can download from oracle website
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html




Thanks
Deva

Tuesday, March 12, 2013

BI Security Diagnostics Helper to Automatically Identify

Hi,

Obiee11.1.1.6.0 has one good trouble shooting feature " BI Security Diagnostics Helper to Automatically Identify" 

It's mainly used to  identify problems with your Oracle BI system.

You have to run a setup script before you deploy and run the application.

Once deployed you can start diagnosing possible security issues by accessing the Oracle BI Security Diagnostics Helper URL in a Web browser.

Setting Up the Oracle BI Security Diagnostics Helper Using a Script,

You must run a script before using the Oracle BI Security Diagnostics Helper for the first time use to ensure the Oracle BI Security Diagnostics Helper is setup correctly. The script grants the correct permissions to run the diagnostic checks. If you have already run the setup script you do not need to run it again.

You must run the script named addDiagnosticsCodeGrant.py for first time use only, to ensure that the Oracle BI Security Diagnostics Helper is setup correctly.

In Windows, the scripts directory is located in:
MW_HOME\ORACLE_HOME\bifoundation\admin\scripts
wlst.cmd D:\Oracle\Middleware\Oracle_BI1\bifoundation\admin\scripts\addDiagnosticsCodeGrant.py weblogic Admin123 t3://deva:7001
Note: syntax,
mw_home/Oracle_BI1/common/bin/wlst.cmd addDiagnosticsCodeGrant.py t3://<WebLogic_host_name>:<WebLogic_port_number>
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Admin>d:
D:\>cd D:\Oracle\Middleware\Oracle_BI1\common\bin
D:\Oracle\Middleware\Oracle_BI1\common\bin>wlst.cmd D:\Oracle\Middleware\Oracle_
BI1\bifoundation\admin\scripts\addDiagnosticsCodeGrant.py weblogic Admin123 t3:/
/deva:7001
CLASSPATH=D:\Oracle\MIDDLE~1\patch_wls1036\profiles\default\sys_manifest_classpa
th\weblogic_patch.jar;D:\Oracle\MIDDLE~1\patch_ocp371\profiles\default\sys_manif
est_classpath\weblogic_patch.jar;C:\Java\jdk\lib\tools.jar;D:\Oracle\MIDDLE~1\WL
SERV~1.3\server\lib\weblogic_sp.jar;D:\Oracle\MIDDLE~1\WLSERV~1.3\server\lib\web
logic.jar;D:\Oracle\MIDDLE~1\modules\features\weblogic.server.modules_10.3.6.0.j
ar;D:\Oracle\MIDDLE~1\WLSERV~1.3\server\lib\webservices.jar;D:\Oracle\MIDDLE~1\m
odules\ORGAPA~1.1/lib/ant-all.jar;D:\Oracle\MIDDLE~1\modules\NETSFA~1.0_1/lib/an
t-contrib.jar;;D:\Oracle\MIDDLE~1\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-wlstman
.jar;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\Oracle\MIDDLE~1
\ORACLE~1\common\wlst\lib\ADFSCR~1.JAR;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\l
ib\mdswlst.jar;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\
Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\IGFWLS~1.JAR;D:\Oracle\MIDDLE~1\OR
ACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst
\RESOUR~1\jrf-wlst.jar;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1
.JAR;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\Oracle\MID
DLE~1\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\Oracle\MIDDLE~1\ORACLE~1\comm
on\wlst\RESOUR~1\OSSOIA~1.JAR;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\O
VDWLS~1.JAR;D:\Oracle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\Ora
cle\MIDDLE~1\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\Oracle\MIDDLE~1\utils
\config\10.3\config-launch.jar;D:\Oracle\MIDDLE~1\WLSERV~1.3\common\derby\lib\de
rbynet.jar;D:\Oracle\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbyclient.jar;D:\Ora
cle\MIDDLE~1\WLSERV~1.3\common\derby\lib\derbytools.jar;;
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Connecting to t3://deva:7001 with userid weblogic ...
Successfully connected to Admin Server 'AdminServer' that belongs to domain 'bif
oundation_domain'.
Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.
Location changed to domainRuntime tree. This is a read-only tree with DomainMBea
n as the root.
For more help, use help(domainRuntime)
Already in Domain Runtime Tree
Already in Domain Runtime Tree
Already in Domain Runtime Tree
once added successfully then restart weblogic services. after that
Deploying the Oracle BI Security Diagnostics Helper
You must deploy the Oracle BI Security Diagnostics Helper as it is not automatically deployed into the WebLogic Server during installTo deploy the Oracle BI Security Diagnostics Helper:Log in to Oracle WebLogic Server Administration Console, and click Lock & Edit in the Change Center.Click Deployments.Click Install.Select the bidiagnostics.ear fileIn Windows, the bidiagnostics.ear file is located in:MW_HOME/ORACLE_HOME/bifoundation/jeeFor example:D:\Oracle\Middleware\Oracle_BI1\bifoundation\jee\bidiagnostics.earClick Next to display the Install Application Assistant page.Select Install this deployment as an application (already selected)Click Next to display the Select deployment targets page.In the Servers area select AdminServer.Click Next, then FinishClick, Activate Changes.The Oracle BI Diagnostic Helper changes into a 'prepared' State, and can be started.The following message should appear: "All changes have been activated. No restarts are necessary".


once deployment completed then try to start services 

 Running the Oracle BI Security Diagnostics Helper

After deploying the Oracle BI Diagnostics Helper it does not automatically start, you have to run it.

To run the Oracle BI Security diagnostics helper:

Log in to Oracle WebLogic Server Administration Console, and click Lock & Edit in the Change Center.

Click Deployments.

Select the bidiagnostics checkbox.

Click Start and choose one of the following options:

- Servicing all requests.

- Servicing only administration requests.

The Oracle BI Security Diagnostics Helper is now setup and running.

When started - bidiagnostics State is set to 'Active'

then u can launch http://deva:7001/bidiagnostics/security/diagnostics.jsp
and then its automatically trouble shoot Automatically and update status on below screen ..its very easy method identify bi system diagnostics.

  1. Tests for OWSM
  2. Tests for BI System User
  3. Tests authentication of user-supplied credentials





Reference:



Thanks
Deva


Monday, March 11, 2013

Obiee 11.1.1.6.9 patchset Released


Section 1: About The Oracle Business Intelligence 11.1.1.6.9 Patchset

The Oracle Business Intelligence 11.1.1.6.9 patchset comprises a number of patches:
PatchAbstract
16287811
Patch 11.1.1.6.9 (1 of 7) Oracle Business Intelligence Installer
16287778
Patch 11.1.1.6.9 (2 of 7) Oracle Real Time Decisions
16237960
Patch 11.1.1.6.9 (3 of 7) Oracle Business Intelligence Publisher
16287840
Patch 11.1.1.6.9 (4 of 7) Oracle Business Intelligence ADF Components
16287854
Patch 11.1.1.6.9 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
16227549
Patch 11.1.1.6.9 (6 of 7) Oracle Business Intelligence
16287884
Patch 11.1.1.6.9 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer


download link:
https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=11rnbpvbb5_381&_afrLoop=206791185040684

Thanks
Deva

Wednesday, February 20, 2013

Unable to Activate Changes in OBIEE11g (FMW - RPD/Catalog Deployment)

Hi,


When i tried to switch the active repository i got below error,actually selecting a new repository, and clicking Apply. So far so good. Upon clicking 'Activate Changes', this error occurs:



[2013-02-20T13:35:02.711+08:00] [bi_server1] [ERROR] [] [oracle.bi.management.sysmancommon] [tid: Thread-121] [userId: <WLS Kernel>] [ecid: 0000Jnq3pNrFs1p_sPS4yX1H95s9000000,0] Unable to apply changes to local config files due to exception:[[
javax.management.MBeanException: Exception occured during setting configuration values.
Underlying cause of exception was:
java.lang.IllegalStateException
Required environment variable BI_ORACLE_HOME not set
Report on underlying changes made is:
INFO: Element Type: JEE_SERVER, Element Id: W01BGPCBIAPP1A:bi_server1, Operation Result: APPLYING_CONFIGURATION_CHANGES, Detail Message: null
FINE: Element Type: ORACLE_INSTANCE, Element Id: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com:instance1, Operation Result: APPLYING_CONFIGURATION_CHANGES, Detail Message: null
FINE: Element Type: BI_INSTANCE_DEPLOYMENT, Element Id: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com:instance1:coreapplication, Operation Result: APPLYING_CONFIGURATION_CHANGES, Detail Message: null
FINER: Element Type: SYSTEM_COMPONENT, Element Id: W01BGPCBIAPP1A:coreapplication_obis1, Operation Result: MODIFIED_ATTRIBUTE, Detail Message: Attribute: RepositoryName set to value: GPC_DataMart_BI0003.rpd (was: GPC_DataMart_BI0002.rpd)
FINE: Element Type: BI_INSTANCE_DEPLOYMENT, Element Id: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com:instance1:coreapplication, Operation Result: APPLYING_ENDPOINT_CHANGES, Detail Message: null
FINER: Element Type: SYSTEM_COMPONENT, Element Id: W01BGPCBIAPP1A:coreapplication_sawbridge, Operation Result: MODIFIED_ATTRIBUTE, Detail Message: Attribute: sawservers set to value: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com:9710 (was: )
FINER: Element Type: SYSTEM_COMPONENT, Element Id: W01BGPCBIAPP1A:coreapplication_obips1, Operation Result: MODIFIED_ATTRIBUTE, Detail Message: Attribute: JavaHostProxyHost set to value: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com (was: )
FINER: Element Type: SYSTEM_COMPONENT, Element Id: W01BGPCBIAPP1A:coreapplication_obips1, Operation Result: MODIFIED_ATTRIBUTE, Detail Message: Attribute: JavaHostProxyPort set to value: 9810 (was: )


            at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.doInvoke(OracleStandardEmitterMBean.java:986)
            at oracle.adf.mbean.share.AdfMBeanInterceptor.internalInvoke(AdfMBeanInterceptor.java:104)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.security.AbstractMBeanSecurityInterceptor.internalInvoke(AbstractMBeanSecurityInterceptor.java:190)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.security.jps.ee.jmx.JpsJmxInterceptor$2.run(JpsJmxInterceptor.java:344)
            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
            at oracle.security.jps.ee.jmx.JpsJmxInterceptor.internalInvoke(JpsJmxInterceptor.java:360)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.ContextClassLoaderMBeanInterceptor.internalInvoke(ContextClassLoaderMBeanInterceptor.java:103)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.MBeanRestartInterceptor.internalInvoke(MBeanRestartInterceptor.java:116)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.LoggingMBeanInterceptor.internalInvoke(LoggingMBeanInterceptor.java:524)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.invoke(OracleStandardEmitterMBean.java:887)
            at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
            at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447)
            at weblogic.management.mbeanservers.internal.JMXContextInterceptor.invoke(JMXContextInterceptor.java:263)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447)
            at weblogic.management.mbeanservers.internal.SecurityInterceptor.invoke(SecurityInterceptor.java:444)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServer.invoke(WLSMBeanServer.java:323)
            at oracle.as.jmx.framework.generic.BaseMBeanServerInterceptor.invoke(BaseMBeanServerInterceptor.java:211)
            at oracle.as.jmx.framework.wls.spi.security.SuperPrivilegedMBeanServerInterceptor$5.run(SuperPrivilegedMBeanServerInterceptor.java:184)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
            at oracle.as.jmx.framework.wls.spi.security.SuperPrivilegedMBeanServerInterceptor.invoke(SuperPrivilegedMBeanServerInterceptor.java:189)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier.notifyViaMBean(ConfigMBeanNotifier.java:45)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier.notifyWithTimeout(ConfigMBeanNotifier.java:84)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier$1.run(ConfigMBeanNotifier.java:65)
Caused by: oracle.bi.management.bidomain.BIDomainConfigException: Exception occured during setting configuration values.
Underlying cause of exception was:
java.lang.IllegalStateException
Required environment variable BI_ORACLE_HOME not set
Report on underlying changes made is:
INFO: Element Type: JEE_SERVER, Element Id: W01BGPCBIAPP1A:bi_server1, Operation Result: APPLYING_CONFIGURATION_CHANGES, Detail Message: null
FINE: Element Type: ORACLE_INSTANCE, Element Id: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com:instance1, Operation Result: APPLYING_CONFIGURATION_CHANGES, Detail Message: null
FINE: Element Type: BI_INSTANCE_DEPLOYMENT, Element Id: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com:instance1:coreapplication, Operation Result: APPLYING_CONFIGURATION_CHANGES, Detail Message: null
FINER: Element Type: SYSTEM_COMPONENT, Element Id: W01BGPCBIAPP1A:coreapplication_obis1, Operation Result: MODIFIED_ATTRIBUTE, Detail Message: Attribute: RepositoryName set to value: GPC_DataMart_BI0003.rpd (was: GPC_DataMart_BI0002.rpd)
FINE: Element Type: BI_INSTANCE_DEPLOYMENT, Element Id: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com:instance1:coreapplication, Operation Result: APPLYING_ENDPOINT_CHANGES, Detail Message: null
FINER: Element Type: SYSTEM_COMPONENT, Element Id: W01BGPCBIAPP1A:coreapplication_sawbridge, Operation Result: MODIFIED_ATTRIBUTE, Detail Message: Attribute: sawservers set to value: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com:9710 (was: )
FINER: Element Type: SYSTEM_COMPONENT, Element Id: W01BGPCBIAPP1A:coreapplication_obips1, Operation Result: MODIFIED_ATTRIBUTE, Detail Message: Attribute: JavaHostProxyHost set to value: W01BGPCBIAPP1A.reg1.uat1bank.dbs.com (was: )
FINER: Element Type: SYSTEM_COMPONENT, Element Id: W01BGPCBIAPP1A:coreapplication_obips1, Operation Result: MODIFIED_ATTRIBUTE, Detail Message: Attribute: JavaHostProxyPort set to value: 9810 (was: )


            at oracle.bi.management.recvbidomain.config.CentralConfigXMLFileReceiver.throwBIDomainConfigException(CentralConfigXMLFileReceiver.java:207)
            at oracle.bi.management.recvbidomain.config.CentralConfigXMLFileReceiver.receiveCentralConfigXMLFile(CentralConfigXMLFileReceiver.java:186)
            at oracle.bi.management.recvbidomain.ManagedServerProxy._processCentralConfigXMLFile(ManagedServerProxy.java:448)
            at oracle.bi.management.recvbidomain.ManagedServerProxy.updateConfiguration(ManagedServerProxy.java:171)
            at oracle.bi.management.recvbidomain.ManagedServerProxy$1.run(ManagedServerProxy.java:100)
            at oracle.bi.management.recvbidomain.ManagedServerProxy.updateConfiguration(ManagedServerProxy.java:97)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:597)
            at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.doInvoke(OracleStandardEmitterMBean.java:973)
            at oracle.adf.mbean.share.AdfMBeanInterceptor.internalInvoke(AdfMBeanInterceptor.java:104)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.security.AbstractMBeanSecurityInterceptor.internalInvoke(AbstractMBeanSecurityInterceptor.java:190)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.security.jps.ee.jmx.JpsJmxInterceptor$2.run(JpsJmxInterceptor.java:344)
            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
            at oracle.security.jps.ee.jmx.JpsJmxInterceptor.internalInvoke(JpsJmxInterceptor.java:360)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.ContextClassLoaderMBeanInterceptor.internalInvoke(ContextClassLoaderMBeanInterceptor.java:103)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.MBeanRestartInterceptor.internalInvoke(MBeanRestartInterceptor.java:116)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.LoggingMBeanInterceptor.internalInvoke(LoggingMBeanInterceptor.java:524)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.invoke(OracleStandardEmitterMBean.java:887)
            at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
            at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447)
            at weblogic.management.mbeanservers.internal.JMXContextInterceptor.invoke(JMXContextInterceptor.java:263)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447)
            at weblogic.management.mbeanservers.internal.SecurityInterceptor.invoke(SecurityInterceptor.java:444)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServer.invoke(WLSMBeanServer.java:323)
            at oracle.as.jmx.framework.generic.BaseMBeanServerInterceptor.invoke(BaseMBeanServerInterceptor.java:211)
            at oracle.as.jmx.framework.wls.spi.security.SuperPrivilegedMBeanServerInterceptor$5.run(SuperPrivilegedMBeanServerInterceptor.java:184)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
            at oracle.as.jmx.framework.wls.spi.security.SuperPrivilegedMBeanServerInterceptor.invoke(SuperPrivilegedMBeanServerInterceptor.java:189)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier.notifyViaMBean(ConfigMBeanNotifier.java:44)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier.notifyWithTimeout(ConfigMBeanNotifier.java:84)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier$1.run(ConfigMBeanNotifier.java:64)
Caused by: java.lang.IllegalStateException: Required environment variable BI_ORACLE_HOME not set
            at oracle.bi.management.utils.OracleHome.getOracleHomePath(OracleHome.java:24)
            at oracle.bi.management.recvbidomain.ConfigureEndpointHelper._configureOdbc(ConfigureEndpointHelper.java:1182)
            at oracle.bi.management.recvbidomain.ConfigureEndpointHelper.configureDeployment(ConfigureEndpointHelper.java:212)
            at oracle.bi.management.recvbidomain.config.CentralConfigXMLFileReceiver.receiveCentralConfigXMLFile(CentralConfigXMLFileReceiver.java:137)
            at oracle.bi.management.recvbidomain.ManagedServerProxy._processCentralConfigXMLFile(ManagedServerProxy.java:449)
            at oracle.bi.management.recvbidomain.ManagedServerProxy.updateConfiguration(ManagedServerProxy.java:171)
            at oracle.bi.management.recvbidomain.ManagedServerProxy$1.run(ManagedServerProxy.java:101)
            at oracle.bi.management.recvbidomain.ManagedServerProxy.updateConfiguration(ManagedServerProxy.java:97)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:597)
            at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.doInvoke(OracleStandardEmitterMBean.java:973)
            at oracle.adf.mbean.share.AdfMBeanInterceptor.internalInvoke(AdfMBeanInterceptor.java:104)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.security.AbstractMBeanSecurityInterceptor.internalInvoke(AbstractMBeanSecurityInterceptor.java:190)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.security.jps.ee.jmx.JpsJmxInterceptor$2.run(JpsJmxInterceptor.java:344)
            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
            at oracle.security.jps.ee.jmx.JpsJmxInterceptor.internalInvoke(JpsJmxInterceptor.java:360)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.ContextClassLoaderMBeanInterceptor.internalInvoke(ContextClassLoaderMBeanInterceptor.java:103)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.MBeanRestartInterceptor.internalInvoke(MBeanRestartInterceptor.java:116)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.generic.spi.interceptors.LoggingMBeanInterceptor.internalInvoke(LoggingMBeanInterceptor.java:524)
            at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doInvoke(AbstractMBeanInterceptor.java:252)
            at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.invoke(OracleStandardEmitterMBean.java:887)
            at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
            at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447)
            at weblogic.management.mbeanservers.internal.JMXContextInterceptor.invoke(JMXContextInterceptor.java:263)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447)
            at weblogic.management.mbeanservers.internal.SecurityInterceptor.invoke(SecurityInterceptor.java:444)
            at weblogic.management.jmx.mbeanserver.WLSMBeanServer.invoke(WLSMBeanServer.java:323)
            at oracle.as.jmx.framework.generic.BaseMBeanServerInterceptor.invoke(BaseMBeanServerInterceptor.java:211)
            at oracle.as.jmx.framework.wls.spi.security.SuperPrivilegedMBeanServerInterceptor$5.run(SuperPrivilegedMBeanServerInterceptor.java:184)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
            at oracle.as.jmx.framework.wls.spi.security.SuperPrivilegedMBeanServerInterceptor.invoke(SuperPrivilegedMBeanServerInterceptor.java:189)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier.notifyViaMBean(ConfigMBeanNotifier.java:45)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier.notifyWithTimeout(ConfigMBeanNotifier.java:84)
            at oracle.bi.management.bidomain.mbeans.ConfigMBeanNotifier$1.run(ConfigMBeanNotifier.java:65)

]]

Solution:





Solution:
Required environment variable BI_ORACLE_HOME (at the moment this variable not set)





After setting this variable try to reboot your server then test it.

Thanks
Deva

LOCATE Function


Hi,

Syntax 
 
LOCATE(strExpr1, strExpr2, integer)
 
Example:   LOCATE('R',"balance_Sheet"."BS_Descr",2)
Where:
 
strExpr1 is any expression that evaluates to a character string. Identifies
the string for which to search.
strExpr2 is any expression that evaluates to a character string. Identifies
the string to be searched.
 
integer is any positive (nonzero) integer that represents the starting
position to begin to look for the character string.

Note:There is no function "LocateN". It is actually the function "Locate" with
another Form

This is explained in Bug 7235397 - LOCATEN STRING FUNCTION DOESN'T WORK IN ANSWERS

Thanks
Deva