OBIEE Online Training

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