Issue: Cannot manage OHS configuration from Fusion Middleware Control / Enterprise Manager (Error:Failed to invoke operation load on MBean)

Share

Issue

 

You are unable to view your Oracle HTTP Server (OHS) component configuration on the Fusion Middleware Control (Enterprise Manager). This issue tends to present itself after an interaction with Oracle Universal Installer (installing, patching, upgrading).

 

Symptoms

The following error is displayed when you attempt to follow any of the administration links:

Failed to invoke operation load on MBean oracle.as.management.mbeans.register:type=component,name=ohs1,instance=instance1,Location=AdminServer

 

Parsing error while loading MBeans

oracle.sysman.emSDK.app.exception.EMSystemException at oracle.sysman.emas.sdk.model.jmx.JMXUtil.invokeOperation(JMXUtil.java:100) at oracle.sysman.emas.model.ohs.ModWeblogicModel.initializeData(ModWeblogicModel.java:99) at oracle.sysman.core.model.util.ModelUtil$EMObjectResetter.initOrResetEMObject(ModelUtil.java:319) at oracle.sysman.core.model.util.ModelUtil$EMObjectResetter.access$000(ModelUtil.java:280) at oracle.sysman.core.model.util.ModelUtil.initializeMBEMObjects(ModelUtil.java:231) at oracle.sysman.core.model.util.ModelUtil.initializeAllEMObjects(ModelUtil.java:128) at oracle.sysman.core.model.util.ModelUtil.initializeAllEMObjects(ModelUtil.java:101) at oracle.sysman.emSDK.adfext.ctlr.EMPagePhaseListener.doPrePrepareModel(EMPagePhaseListener.java:867) at oracle.sysman.emSDK.adfext.ctlr.EMPagePhaseListener.beforePhase(EMPagePhaseListener.java:795) at oracle.adfinternal.controller.lifecycle.ADFLifecycleImpl$PagePhaseListenerWrapper.beforePhase(ADFLifecycleImpl.java:551) at oracle.adfinternal.controller.lifecycle.LifecycleImpl.internalDispatchBeforeEvent(LifecycleImpl.java:100) at oracle.adfinternal.controller.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:191) at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.access$400(ADFPhaseListener.java:23) at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$PhaseInvokerImpl.startPageLifecycle(ADFPhaseListener.java:238) at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$2.after(ADFPhaseListener.java:297) at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.afterPhase(ADFPhaseListener.java:75) at oracle.adfinternal.controller.faces.lifecycle.ADFLifecyclePhaseListener.afterPhase(ADFLifecyclePhaseListener.java:53) at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:399) at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:186) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.help.web.rich.OHWFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.sysman.emSDK.license.LicenseFilter.doFilter(LicenseFilter.java:101) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:205) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:106) at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446) at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60) at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446) at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271) at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177) at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.sysman.emas.fwk.MASConnectionFilter.doFilter(MASConnectionFilter.java:41) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:175) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.sysman.eml.app.AuditServletFilter.doFilter(AuditServletFilter.java:179) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:203) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.sysman.core.model.targetauth.EMLangPrefFilter.doFilter(EMLangPrefFilter.java:158) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.sysman.core.app.perf.PerfFilter.doFilter(PerfFilter.java:141) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:542) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111) at java.security.AccessController.doPrivileged(Native Method) 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.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) at weblogic.work.ExecuteThread.run(ExecuteThread.java:178) Caused by: javax.management.MBeanException: Parsing error while loading MBeans at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:205) at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:222) at javax.management.remote.rmi.RMIConnectionImpl_1035_WLStub.invoke(Unknown Source) at javax.management.remote.rmi.RMIConnector$RemoteMBeanServerConnection.invoke(RMIConnector.java:993) at weblogic.management.remote.wlx.ClientProvider$WLXMBeanServerConnectionWrapper.invoke(ClientProvider.java:291) at weblogic.management.remote.wlx.ClientProvider$WLXMBeanServerConnectionWrapper.invoke(ClientProvider.java:291) at oracle.sysman.emas.sdk.model.jmx.JMXUtil.invokeOperation(JMXUtil.java:92) … 73 more Caused by: java.io.IOException: Parsing error while loading MBeans at oracle.ohs.OHSGlobalConfig.load(OHSGlobalConfig.java:2283) 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 java.security.AccessController.doPrivileged(Native Method) 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 java.security.AccessController.doPrivileged(Native Method) 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 java.security.AccessController.doPrivileged(Native Method) 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 weblogic.management.mbeanservers.domainruntime.internal.ManagedMBeanServerConnection.invoke(ManagedMBeanServerConnection.java:330) at weblogic.management.mbeanservers.domainruntime.internal.FederatedMBeanServerInterceptor.invoke(FederatedMBeanServerInterceptor.java:349) at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449) at java.security.AccessController.doPrivileged(Native Method) 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 java.security.AccessController.doPrivileged(Native Method) at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase.invoke(WLSMBeanServerInterceptorBase.java:447) at weblogic.management.mbeanservers.internal.SecurityMBeanMgmtOpsInterceptor.invoke(SecurityMBeanMgmtOpsInterceptor.java:65) at weblogic.management.jmx.mbeanserver.WLSMBeanServerInterceptorBase$16.run(WLSMBeanServerInterceptorBase.java:449) at java.security.AccessController.doPrivileged(Native Method) 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 weblogic.management.mbeanservers.internal.JMXConnectorSubjectForwarder$11$1.run(JMXConnectorSubjectForwarder.java:663) at java.security.AccessController.doPrivileged(Native Method) at weblogic.management.mbeanservers.internal.JMXConnectorSubjectForwarder$11.run(JMXConnectorSubjectForwarder.java:661) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.management.mbeanservers.internal.JMXConnectorSubjectForwarder.invoke(JMXConnectorSubjectForwarder.java:654) at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1427) at javax.management.remote.rmi.RMIConnectionImpl.access$200(RMIConnectionImpl.java:72) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1265) at java.security.AccessController.doPrivileged(Native Method) at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1367) at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:788) at javax.management.remote.rmi.RMIConnectionImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174) … 79 more

 

 

Cause

 

This is a common error after Oracle Universal Installer has failed to redeploy the system components on OPMN

 

Solution

 

Delete and redeploy your system components. Make sure AdminServer is up and running at the time you do this.

listing of components registered in OPMN for a particular instance

 

opmnctl unregisterinstance -instanceName wt_inst1 -adminHost localhost -adminPort 7001

 

opmnctl redeploy -adminHost localhost -adminPort 7001

 

opmnctl registerinstance -adminHost localhost -adminPort 7001

 

 

If you find this post useful please  or Share our site!

 

Reference

 

 

 

 

Read the rest of Issue: Cannot manage OHS configuration from Fusion Middleware Control / Enterprise Manager (Error:Failed to invoke operation load on MBean) »

OBIEE 11.1.1.6.0 Installation

Share

This is a step by step guide for the installation of Oracle Business Intelligence Enterprise Edition 11.1.1.6.0

 

  1. Click Next on the welcome screen

    01 - welcome

  2. Enter your Oracle Support credentials or chose to skip the software udpate check

    02 - software update

  3. Select the Installation Type

    03 - Install Type

  4. Enter a domain password to create a new installation or chose scale out

    05 - create domain or scale out

  5. Enter the path to the new Middleware Home, all other paths are automatically generated:

    Oracle Home Directory:
    c:\app\oracle\fmw\Oracle_BI1

    Weblogic Server Directory: c:\app\oracle\fmw\wlserver_10.3

    Domain Home: C:\app\oracle\fmw\user_projects\domains\bifoundation_domain

    Instance Location: C:\app\oracle\fmw\instances\instance1

    06 - mwhome

  6. Select the components to be installed and configured

    07 - select components

  7. Enter the information for the BIPLATFORM schema created by the RCU

    09 - BIPLATFORM info

  8. Enter the information for the MDS schema created by the RCU

    10 - MDS schema info

  9. Leave the Automatic Port Configuration option selected to use the default ports

    11 - configure ports

  10. Enter your Oracle Support account information to receive security updates

    12 - security updates

  11. Click install on the summary screen to begin the installation

    16 - Install Summary

Tags: , , ,
Posted in Uncategorized by Ignacio de la Torre. No Comments

Issue with [nQSError: 10040] The requested data source name is either not found, incomplete, or incorrect. (IM002)

Share

Problem:

The OBIEE 11g presentation service fails to start.

Symptoms:

Error Code:

“IM002. Code: 10040. [NQODBC] [SQL_STATE: IM002] [nQSError: 10040]
The requested data source name is either not found, incomplete, or incorrect. (IM002)”

 

Cause:

The DSN tag value on the instanceconfig.xml file is incorrect or a valid data source is missing.

 

Solution:

Verify that a valid OBIEE 11g ODBC is configured on the ODBC manager.

Verify that the name of the ODBC data source in the instanceconfig.xml file matches the ODBC manager data source name.

 

 

 

 

 

How to launch OBIEE Catalog Manager in 11g

Share

In secondary cluster node systems and versions before 11.1.1.5 a shortcut to the OBIEE Catalog Manager was not created by the install utility, when running on a Windows Box you can easily solve this by running the runcat.cmd file on the Catalog Manager Path:

<Middleware Home>\instances\instance<Instance Number>\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager

An example of the this path on a secondary cluster (instance 2):

D:\obi_mw\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager

Note: For ease of use I have created a shortcut to runcat.cmd on my desktop and quick launch bar.

Read the rest of How to launch OBIEE Catalog Manager in 11g »

Oracle Support asking for flash version

Share

Disculpa, pero esta entrada está disponible sólo en English.

Posted in OBIEE Troubleshooting by Ignacio de la Torre. No Comments

Oracle Business Intelligence 11.1.1.6.0 is Generally Available!

Share

Disculpa, pero esta entrada está disponible sólo en English.

Workaround: OBIEE compatibility issue with Firefox 10

Share

 

  Read the rest of Workaround: OBIEE compatibility issue with Firefox 10 »

Warning: OBIEE error: “Your browser is not supported by Oracle BI Presentation Services” being triggered by automatic update to Firefox 10

Share

Disculpa, pero esta entrada está disponible sólo en English.

Issue: WordPress sticky posts always on top instead of being incorporated in the default descending date sort for blog home

Share

I am using WordPress 3.1, I was able to solve this issue by customizing the call to the query_posts() function in my theme’s home.php file.

The only customization necessary was adding the ignore_sticky_posts variable at the end of the query string as illustrated below.

Current code in my theme:

query_posts($category."&paged=$paged&showposts=$number_posts");

Tweaked code:

query_posts($category."&paged=$paged&showposts=$number_posts&ignore_sticky_posts=1");

Tags: , ,
Posted in GoogleTracking Tips by Ignacio de la Torre. No Comments

List of Bug Fixes Included In OBIEE 11.1.1.5.0

Share

The following is the list of Bugs fixed in OBIEE 11.1.1.5 Release grouped by component :

Admin Tool

* 7538753 SAP BW IMPORT DOES NOT RETRIEVE UNIQUE NAME FOR MEASURE COLUMNS
* 10012297 ADMIN TOOL CRASH ON VERY LARGE EXPRESSIONS – OVERFLOW AT APPROX 3200 CHARACTERS
* 10032385 TABLE MISSING IN SQL "FROM" CLAUSE – FWD PORT 8308443 TO 11G
* 10045212 EQUALITY EXPRESSION IN LTS "WHERE" CAUSES INTERNAL SQORRQLIST ERROR ON QUERY
* 10264475 ADMINISTRATION’S "SHUTDOWN SERVER" MENU SHOULD BE REMOVED
* 10265121 ADMIN TOOL EXPRESSION BUILDER CRASHES ON DOUBLE-BYTE LOGICAL COLUMN NAME
* 10394725 ON-LINE MODE CHECK-IN OF DYNAMIC INIT BLOCK CAUSES [43058] REFRESH LOCK FAILURE

Answers

* 6521146 ERROR: "NO FILTER" WHEN USING "COMBINE WITH SIMILAR REQUEST" – UNION
* 7534635 INACTIVATING DRILLDOWN ON COLUMN VALUE ALSO INACTIVATES COLUMN HEADER LINK
* 9026854 CLARIFICATION REGARDING DATA FORMAT WHEN COMBINING REQUESTS
* 9107277 KEEP THE NUMBER PRECISION IN DATABASE WHEN "DOWNLOADING TO EXCEL"
* 9524080 PIVOT TOTAL DIFFERENT TO TABLE TOTAL WHEN REPORTAGGREGATEENABLED TRUE
* 9697529 JAPANESE CHARACTER SET NOT PASSED CORRECTLY TO DRILL REPORT IN FIREFOX BROWSER
* 9871470 SORTING ON A NULL VALUED COLUMNS GIVES ASSERTION ERRORS
* 9886904 CORRECT DOC FOR ADDING CUSTOM DATE FORMAT STRING
* 9918283 CORRECT DASHBOARD FORMATTING PROBLEMS WITH SCROLLING
* 9928318 ROW HEADER MISSING AT PIVOT TABLE VIEW FOR MIGRATED REPORTS IN 11G
* 9968574 SOME UPGRADED 10G CHARTS SHOW UP JAVA EXCEPTION
* 10023165 MAPS DO NOT WORK IN MAP VIEWS WHEN JOIN COLUMN CONTAINS A "&" CHARACTER
* 10065166 GAUGE RANGE IS NOT UPDATED WHEN IT CHANGES THE FIELD VALUE
* 10078041 ACTION LINK DOES NOT WORK WHEN COMPOUND LAYOUT ONLY HAS A MAP VIEW
* 10091354 "SCALE MARKERS" OPTION IS MISSING IN VERTICAL AXIS 2
* 10147762 CANNOT SET GAUGE FOOTER (TITLE), KEEPS SHOWING "UNDEFINEDUNDEFINEDUNDEFINED"
* 10182955 BUBBLE CHART IS NOT BEHAVING AS EXPECTED
* 10213761 CONDITIONAL DASHBOARD SECTIONS (GUIDED NAVIGATION) ALWAYS RUNS REPORTS
* 10229397 CANNOT SAVE REQUEST USING STANDARD DATE FORMATS.
* 10282140 CELL IMAGE AT BLANK CELL OF PIVOT TABLE IS NOT DISPLAYED WHEN USING COND FORMAT
* 10296730 UNABLE TO USE PRESENTATION VARIABLE IN SCALE MARKERS
* 10312496 CHARTS. MEASURE LABEL IN GRAPH PROMPTS DOES NOT CHANGE CONTENT OF THE CHART
* 10312795 ACTION LINK ON COLUMN HEADING NAVIGATION DOES NOT CONSIDER PROMPT VALUES
* 10329343 CLICKING A LINE GRAPH BETWEEN TWO DATA POINTS DRILLS TO LAST VALUE IN HORIZONTAL
* 10337649 PIVOT TABLE SHOWS BUTTONS FOR SORTING ON CALCULATED ITEMS.
* 10402102 INCORRECT RESULT WHEN USING [NEW CALCULATED ITEM] PROP IN PIVOT TABLE
* 10414887 DRILL DOWNS NOT WORKING IN CHART PIVOTED TABLE SELECTED FROM VIEW SELECTOR
* 10418875 CHART SIZE IS CHANGING AFTER WEBCAT UPGRADE FROM 10G
* 10634175 GRAPH ENGINE IS NOT RESPONDING
* 10639913 COMPLETE TEXT IS NOT SAVED IN DB IF CURSOR IS MOVED AWAY DURING INSERT
* 11711658 FILTER NEEDS TO SUPPORT UNTYPE LITERAL FOR RANK OPERATOR AS 10G DOES
* 11805468 CUSTOMIZED GAUGE VIEW IS NOT CONSISTENT WHEN EXPORTED AS PDF,HTML AND XLS
* 11817696 INCORRECT FILTER IS BUILT IF FILTER IS CONTRUCTED BEFORE SELECTING REQ. COLUMNS
* 11845286 PIVOT TABLE WITH PERCENTAGES, GRAPHED PERCENTAGE VALUES DISPLAYED ARE INCORRECT
* 11894921 GRAPH LABEL OPTIONS NOT AVAILABLE IN 11G
* 11895279 INCORRECT FILTER VALUE WHEN USING ACTION LINK WITH GRAPH
* 12412666 ALL PAGES LOSES CONDITIONAL FORMATTING
* 12561361 PSE FOR BASE BUG 10295403 ON TOP OF 11.1.1.5.0 FOR GENERIC OS

CHARTING

* 8990756 MISLEADING INFORMATION IN DOC REGARDING PIVOT TABLE SETTINGS

DASHBOARDS

* 7459700 ABILITY TO SPECIFY FIXED COLUMN WIDTH TO A DASHBOARD PROMPT
* 10177865 OBIEE 11G : DEFAULT VALUES CANNOT BE DE-SELECTED FROM MULTI SELECT PROMPT
* 10279722 DASHBOARD SLIDER PROMPT SHOWS THUMB VALUES WITH TWO DECIMAL PLACES FOR INTEGERS
* 10279829 DASHBOARD SLIDER PROMPT SHOWS WRONG VALUES FOR "ALL COLUMN VALUES" OR "SPECIFIC
* 10310511 "REQUIRE USER INPUT" MESSAGE APPEARS THE FIRST TIME ONLY FOR THE REQUIRED PROMPT
* 10389799 DASHBOARD NAVIGATION MAY CAUSE GETELEMENTBYTAGNAME ERROR IN IE
* 10411545 PROMPT WITH BETWEEN OPERATOR AND SQL DEFAULT VALUES ARE NOT UPGRADED PROPERLY
* 11056057 ERROR WHILE UPGRADING THE DASHBOARD WITH CERTAIN FILTER FUNCTIONS
* 11076452 ABILITY TO CONSTRAIN PROMPTS AGAINST A SLIDER PROMPT
* 11717024 ERROR 500 OCCURS WHEN SETTING ACCESSIBILITY MODE TO ON
* 12620143 PSE FOR BASE BUG 12561330 ON TOP OF 11.1.1.5.0 FOR LINUX X86 [46] (PSE #602152)

INSTALL

* 9459177 PREREQUISITES FOR DEPLOYMENT ON SEPARATE MACHINES
* 9540009 UNIXCHK.SH ENCOUNTERS HOST NOT FOUND ERROR WHEN DNS IS NOT AVAILABLE.
* 10071302 ENTERPRISE INSTALL: CONFIGURE PORTS : FORMAT OF INI FILE
* 10126542 OBIEE 11G INSTALATION FAILS AT AS INSTANCE CREATION DUE TO PERM SIZE ERROR
* 10287335 CANNOT START BISERVER1 . SWITCH TO JSSE FRAMEWORK REQUIRED
* 10302421 OBIEE 11G WINDOWS PROMPTS FOR USERNAME / PASSWORD AFTER ENCRYPTING CREDENTIALS
* 11849674 SAG: DISCREPANCY IN DOCUMENTED ORACLE DATABASE REQUIRED FOR MAPVIEWER

MIGRATION

* 7432799 ORACLE EUL CONVERTER CRASHED WHILE GENERATING A REPOSITORY

REL_NOTES

* 12604761 TWO STEPS OF THE UPGRADE TO 11.1.1.5.0 ARE NOT CLEARLY DOCUMENTED

SCHEDULER

* 10036466 "RE-RUN INSTANCE(S) NOW" MENU IS NOT AVAILABLE FOR COMPLETED JOB INSTANCES

SECURITY

* 8996295 PROVIDE DETAIL INFORMATION TO SETUP WNA(KERBEROS) FOR OBIEE AUTHENTIFICATION
* 9216995 PROVIDE LATEST DETAIL INFORMATION ABOUT HOW TO SETUP LDAP SSL FOR OBIEE
* 10194154 TECHNOTES- PROVIDE DETAIL INFORMATION TO SETUP WNA(KERBEROS) FOR OBIEE AUTHENT
* 10198837 BIEEHOME LOGIN PAGE IS NOT DISABLED EVEN AFTER ENABLING THE SSO
* 10218031 USING EXTERNAL DB TABLE TO SET ROLES SESSION VARIABLE DOESN’T ACCEPT LONG NAMES
* 10373788 IF OBJECTGUID PUBLISHED AND SAMACCOUNTNAME CHANGED USER CANNOT CONNECT ANYMORE
* 11731080 QA:SECURITY GUIDE NEEDS UPDATE FOR DEFINING A USER SESSION VARIABLE

SERVER

* 6510747 NETWORK FAILURE DURING PHYSICAL QUERY HANGS END USER WITHOUT ERROR MESSAGE
* 6836444 OBIEE SERVER SYSTEM DATE IS WRONG AND DOES NOT MATCH MACHINE SYSTEM DATE
* 8371912 BI SERVER CRASHES ON NAVIGATION SPACE MAP RACE – SR 3-887711721
* 9433198 DOCUMENT SYSLOG ENTRIES IN SYSTEM ADMINISTRATOR’S GUIDE
* 9696424 DOC INSTANCECONFIG PARMS ALLOWEDLANGUAGES & ALLOWEDLOCALES IN SYSADMIN GUIDE
* 9954411 PSR:MOD_SUPPORTED NOT ENABLED FOR TERADATA AND CAUSES CAMPAIGN SLOW PERFORMANCE
* 10258683 REQUEST WITH COMPLEX FILTER IS CONSUMING ALMOST ALL CPU & NO SESSION IS CREATED
* 10258755 EXCEL FAILS TO CONNECT TO 11G BI SERVER USING ODBC DSN
* 10335924 REPORT-BASED TOTALS FAIL ON MEASURES CONTAINING AGGREGATION EXPRS SUCH AS FILTER
* 10374571 NEED FLEXIBILITY TO OVERRIDE HOSTNAMES WHEN CUSTOMER DNS IS INCORRECT OR BROKEN
* 10650122 PIVOT VIEW WITH UNION OF NON – COMPATABLE TYPE ERROR IN OBIEE 11G AFTER UPGRADE
* 11804596 NQQUERY LOG LEVEL 2 IS TOO VERBOSE – BACKPORT 10308263 TO 11.1.1.5
* 11809295 NQUDMLGEN NOT GENERATING UDML FILE IN UTF FORMAT

UPGRADE

* 9886765 ERRORS ENCOUNTERED WHEN UPGRADING WEB CATALOG USING UA.BAT
* 10121344 ERROR IN LOG USING UA TO UPGRADE BI SCHEDULER SCHEMA ON SQL SERVER DATABASE
* 11069928 UPGRADE SHOULD HANDLE PROMPT WITH INCONSISTENT VALUES AS 10G DOES

WEB_ADMIN

* 8564456 SHARED FOLDER ACCESS PERMISSION ISSUE
* 9381764 CATALOG MANAGER COPY FUNCTION NOT WORKING AS EXPECTED
* 9739865 EXITING MANAGE SESSION RESULTS IN HTTP ERROR
* 10016252 LACKING INFORMATION ON FORCEABSOLUTECOMMANDURL FOR ABSOLUTECOMMANDURLPREFIX
* 10144989 WEB CATALOG DOES NOT UPGRADE TO 11.1.1.3.0
* 10218524 VALIDATION ERROR AFTER THE UPGRADE OF WEBCATALOG TO OBIEE 11G
* 11723425 INCORRECT DEFAULT VALUE OF DEFAULTROWSDISPLAYED IN THE INSTANCECONFIG.XML
* 11827202 OPMN NOT STARTING AFTER SETTING UP THE REPLICATION AGENT

WEB_GNRL

* 10191078 FILTER VALUES ARE RESET IN GO URL WHEN COLUMNS ARE SORTED OR RE-ARRANGED
* 10360461 NEED ABILITY TO CONTROL NEW, DASHBOARD AND OTHER HEADER LINKS
* 11780508 10G COLUMN FILTER PROMPT WITH PROMPTCAPTION ATTR NOT UPGRADING
* 12416695 TOOLTIP EMPTY IN MAPVIEWER

WEB_INTGRT

* 10294759 FMAP-REFERENCED IMAGES IN ANALYSIS HEADERS DONâÂÂT APPEAR IN DOWNLOADS TO EXCEL

WEB_MKTG

* 8692820 DIRECT DATABASE CAMPAIGN LOAD FORMAT COMBINED LISTS FAILS
* 9908019 SAW SERVER CRASH WHEN LOADING A PARTICULAR CAMPAIGN
* 9935859 UNGROUP OF SEGMENT BLOCKS CORRUPTS SEGMENT DEFINTION AND BAD COUNTS
* 10331355 MOVING CRITERIA WITHIN A SEGMENT’S GROUP CORRUPTS THE INCLUSION OPTIONS


References:

NOTE: 1329694.1 – List of Bug Fixes Included In Oracle BI Publisher 11.1.1.5.0

Posted in Infrastructure OBIEE Troubleshooting by Ignacio de la Torre. No Comments

11g Bug: Issue with equality operator on content filters (spanish)

Share

Spanish

Read the rest of 11g Bug: Issue with equality operator on content filters (spanish) »

Como modificar el valor de una variable de sesion globalmente

Share

In OBIEE it is possible to update the value of both session and presentation variables with the  value of  a prompt selection, I recently ran into a situation where I needed to update the value of a session variable beyond this scope. I couldn’t find a good solution without using the write back feature but I thought I would document the NQSSetSessionValue() function.   NQSSetSessionValue is an ODBC function that allows a developer to update the value of a session variable for the globally, the syntax for the function call is as follows: call NQSSetSessionValue(‘=;’); A simple example of its use would be: call NQSSetSessionValue(‘string SV_DEFAULT_DEPARTMENT=Finance;’); One caveat is that you cannot use the variables as part of your function call, so I couldn’t use VALUEOF(SV_DEFAULT_DEPARTMENT) as part of my function call, this led me away from this solution path. Note:

This is an ODBC function, it cannot be run from “DIRECT SQL request” against a connection pool, instead you need to go to the Administration link on the top right and click on issue SQL. If your requirement is somewhat different of what I was attempting, you can play around with the function in the screen illustrated below and once you are satisfied with the behavior of your function call you can add this function call at the beginning of your logical SQL in a report.

OBI_Issue_SQL

Read the rest of Como modificar el valor de una variable de sesion globalmente »

List of Bug Fixes Included In Oracle BI Publisher 11.1.1.5.0

Share

List of Bug Fixes Included In Oracle BI Publisher 11.1.1.5.0The following is a list of all bug fixes included in Oracle BI Publisher 11.1.1.5.0, grouped by type:

Administration (ADMIN)

* Bug 9381019 XMLP ROLES NOT HONORED WITH SSO ENABLED FOR AD SYNCHED USERS.
* Bug 9934771 UNABLE TO LOGON TO PUBLISHER USING SECURITY MODEL EBS: JAVA.LANG.ILLEGALACCESSER
* Bug 10326227 EBS SECURITY MODEL INTEGRATION SIGNON W/CASE SENSITIVE PASSWORD NOT SUPPORTED

Install and Upgrade (BIPUPGRADE)
 
* Bug 11665472 BI PUBLISHER REPOSITORY UPGRADE FROM 10G TO 11G FAILS WHEN A 10G FOLDER IS EMPTY

Core Formatting API (CORE)

* Bug 9727000 CSV OUTPUT COLUMN ORDER DOES NOT MATCH SQL SELECT COLUMN ORDER
* Bug 10182980 ER: WAY TO FORMAT DATES (E.G. D HH:MM:SS) ON Y AXIS AND MARKER TEXT IN CHART

* Data Model (DATAMODEL)
*
* Bug 10226625 MDX STATEMENTS THAT INCLUDE "+" DO NOT WORK WITH PUBLISHER 11G
* Bug 10231671 MDX QUERY WITH NAMED SETS NOT RETURNING EXPECTED RESULTS.
* Bug 10303941 BIP11G: RESPONSEDATA XPATH FILTER NOT APPLIED TO XML DATA RETURNED BY WS SOURCE
* Bug 10365310 EXCEPTION/ERROR WHEN THERE IS A COLUMN NAMED IN CHINESE IN BI ANALYSIS

Delivery Service and API (DELIVERY)

* Bug 9848981 SFTP FAILS TO NEGOTIATE SECONDARY CIPHER
* Bug 9937937 SSHTOOLSPRIVATEKEYFORMAT.CLASS & OPENSSHPRIVATEKEYFORMAT.CLASS FAILS TO LOAD

Integration (INTG)

* Bug 9646599 USER ROLE DEFINED AS PRIMARYGROUP IN ACTIVEDIRECTORY GROUP ARE NOT RECOGNIZED
* Bug 9664768 ER: NEED TO BIND USER ATTRIBUTE VALUES DEFINED IN ACTIVEDIRECTORY IN DATA QUERY
* Bug 9704401 ER: NEED TO SUPPORT DEFAULT GROUP FOR ALL USERS IN LDAP/AD SECURITY
* Bug 9753736 SOME ROLES FROM ACTIVEDIRECTORY ARE NOT LISTED IN ADMIN ROLE-FOLDER MAPPING
* Bug 10221061 CATALOG NOT DISPLAYED USING BI SERVER SECURITY W/ EXTERNAL TABLE AUTHENTICATION
* Bug 10367106 CANNOT CREATE DATA SET IF BI ANALYSIS HAS JAPANESE COLUMN NAME

Layout Tools (LAYOUTTOOL)

* Bug 9811428 CANNOT INSTALL BI PUBLISHER DESKTOP ON WINDOWS 7
* Bug 10036545 UNABLE TO UPLOAD OR VALIDATE RTF TEMPLATE WITH UNNAMED MERGEFIELD
* Bug 10037640 LOGIN SCREEN APPEARS AFTER INSTALL OF ANALYZER FOR EXCEL USING SSO
* Bug 11061157 HYPERLINK WITH DATA PARAMETERS IS NOT WORKING CORRECTLY BI PUBLISHER LAYOUT

Scheduler (SCHEDULE)

* Bug 9053770 CSV REPORT OUTPUT WHEN SENT VIA EMAIL HAS .DAT EXTENSION OR NO EXTENSION
* Bug 10052481 ETEXT REPORT FAILS WHEN RUN AS A SCHEDULED JOB
* Bug 11685035 OBIEE 11G : BI PUBLISHER WEBSERVICE CALL TO SCHEDULE A REPORT FAILS
* Bug 11776420 CURRENT PARAMETER VALUE IS NOT BEING DISPLAYED USING SCHEDULER
* Bug 12347367 SCHEDULE FAILS IF A REPORT HAS HIDDEN PARAMETER

Templates (TEMPLATES)

* Bug 9571670 ER: EXCEL TEMPLATE TO SUPPORT XSLT LOGIC AND XSL CUSTOM EXTENTIONS
* Bug 9706624 FONT MAPPING FOR PDF TEMPLATES IS NOT WORKING FOR CZECH CHARACTERS
* Bug 10072475 ER: PARAMTERS INCLUDED IN PRINT HEADER FOR EXCEL EXTRACTS
* Bug 10118898 BI PUBLISHER TEMPLATE VIEWER ADDS UNEXPECTED BLANK PAGES IN FIXED SIZE TEMPLATE
* Bug 10139027 RTFPROCESSOR THROW EXCEPTION
* Bug 10143841 ER: PARAGRAPH-ALIGNMENT LOST WHEN BLOCK IN A LIST AND OUTPUT-FORMAT IS RTF
* Bug 10143943 ER: PARAGRAPH-PROPERTIES ARE LOST WHEN PARAGRAPH IS IN A LIST
* Bug 10303133 ER: BI PUBLISHER TABLE IS NOT GETTING CENTERED WHEN OUTPUT IS HTML
* Bug 10304256 BULLETS AND NUMBERING DO NOT WORK TOGETHER

Web Server (WEBSERVER)

* Bug 7420229 QUERY FROM BI PUBLISHER REPORTS APPEARS TO MISS/SKIP THE CACHE FOR LIST OF VALUE
* Bug 9669973 ER: NEED TO SUPPORT PRE-PROCESSING XML WITH XSL FOR EXCEL TEMPLATE
* Bug 10337868 TAB DELIMITER DOES NOT WORK FOR A CSV OUTPUT
* Bug 11670678 RUNNING CLOCK INDICATOR ( HOURGLASS ) DOES NOT SHOW UP FOR HTML OUTPUT
* Bug 11679262 SYSDATE SYNTAX {$SYSDATE()$} NOT WORKING FOR DEFAULT VALUE IN REPORT PARAMETERS
* Bug 11718291 DATE PICKER OF DATE PARAMETER IN A REPORT HIDES BEHIND THE PDF OUTPUT IN IE8

E-Business Suite – XDO (XEBS)

* Bug 9747198 WATERMARK IN ARABIC IN PDF APPEARS FROM LEFT TO RIGHT – SHOULD BE RIGHT TO LEFT
* Bug 9836706 INCORRECT NUMBER FORMAT FOR CARRY FORWARD CALCULATION
* Bug 9860192 CONVERSION TO PDF FORMAT FAILS WITH ERROR – FOR INPUT STRING: "4901001241"
* Bug 10321578 PERFORMANCE ISSUE WHEN USING PDF TEMPLATE
* Bug 9381019 XMLP ROLES NOT HONORED WITH SSO ENABLED FOR AD SYNCHED USERS.
* Bug 9934771 UNABLE TO LOGON TO PUBLISHER USING SECURITY MODEL EBS: JAVA.LANG.ILLEGALACCESSER
* Bug 10326227 EBS SECURITY MODEL INTEGRATION SIGNON W/CASE SENSITIVE PASSWORD NOT SUPPORTED

Install and Upgrade (BIPUPGRADE)

* Bug 11665472 BI PUBLISHER REPOSITORY UPGRADE FROM 10G TO 11G FAILS WHEN A 10G FOLDER IS EMPTY

* Core Formatting API (CORE)
*
* Bug 9727000 CSV OUTPUT COLUMN ORDER DOES NOT MATCH SQL SELECT COLUMN ORDER
* Bug 10182980 ER: WAY TO FORMAT DATES (E.G. D HH:MM:SS) ON Y AXIS AND MARKER TEXT IN CHART

Data Model (DATAMODEL)

* Bug 10226625 MDX STATEMENTS THAT INCLUDE "+" DO NOT WORK WITH PUBLISHER 11G
* Bug 10231671 MDX QUERY WITH NAMED SETS NOT RETURNING EXPECTED RESULTS.
* Bug 10303941 BIP11G: RESPONSEDATA XPATH FILTER NOT APPLIED TO XML DATA RETURNED BY WS SOURCE
* Bug 10365310 EXCEPTION/ERROR WHEN THERE IS A COLUMN NAMED IN CHINESE IN BI ANALYSIS

Delivery Service and API (DELIVERY)

* Bug 9848981 SFTP FAILS TO NEGOTIATE SECONDARY CIPHER
* Bug 9937937 SSHTOOLSPRIVATEKEYFORMAT.CLASS & OPENSSHPRIVATEKEYFORMAT.CLASS FAILS TO LOAD

Integration (INTG)
 
* Bug 9646599 USER ROLE DEFINED AS PRIMARYGROUP IN ACTIVEDIRECTORY GROUP ARE NOT RECOGNIZED
* Bug 9664768 ER: NEED TO BIND USER ATTRIBUTE VALUES DEFINED IN ACTIVEDIRECTORY IN DATA QUERY
* Bug 9704401 ER: NEED TO SUPPORT DEFAULT GROUP FOR ALL USERS IN LDAP/AD SECURITY
* Bug 9753736 SOME ROLES FROM ACTIVEDIRECTORY ARE NOT LISTED IN ADMIN ROLE-FOLDER MAPPING
* Bug 10221061 CATALOG NOT DISPLAYED USING BI SERVER SECURITY W/ EXTERNAL TABLE AUTHENTICATION
* Bug 10367106 CANNOT CREATE DATA SET IF BI ANALYSIS HAS JAPANESE COLUMN NAME

Layout Tools (LAYOUTTOOL)
 
* Bug 9811428 CANNOT INSTALL BI PUBLISHER DESKTOP ON WINDOWS 7
* Bug 10036545 UNABLE TO UPLOAD OR VALIDATE RTF TEMPLATE WITH UNNAMED MERGEFIELD
* Bug 10037640 LOGIN SCREEN APPEARS AFTER INSTALL OF ANALYZER FOR EXCEL USING SSO
* Bug 11061157 HYPERLINK WITH DATA PARAMETERS IS NOT WORKING CORRECTLY BI PUBLISHER LAYOUT

Scheduler (SCHEDULE)

* Bug 9053770 CSV REPORT OUTPUT WHEN SENT VIA EMAIL HAS .DAT EXTENSION OR NO EXTENSION
* Bug 10052481 ETEXT REPORT FAILS WHEN RUN AS A SCHEDULED JOB
* Bug 11685035 OBIEE 11G : BI PUBLISHER WEBSERVICE CALL TO SCHEDULE A REPORT FAILS
* Bug 11776420 CURRENT PARAMETER VALUE IS NOT BEING DISPLAYED USING SCHEDULER
* Bug 12347367 SCHEDULE FAILS IF A REPORT HAS HIDDEN PARAMETER

Templates (TEMPLATES)

* Bug 9571670 ER: EXCEL TEMPLATE TO SUPPORT XSLT LOGIC AND XSL CUSTOM EXTENTIONS
* Bug 9706624 FONT MAPPING FOR PDF TEMPLATES IS NOT WORKING FOR CZECH CHARACTERS
* Bug 10072475 ER: PARAMTERS INCLUDED IN PRINT HEADER FOR EXCEL EXTRACTS
* Bug 10118898 BI PUBLISHER TEMPLATE VIEWER ADDS UNEXPECTED BLANK PAGES IN FIXED SIZE TEMPLATE
* Bug 10139027 RTFPROCESSOR THROW EXCEPTION
* Bug 10143841 ER: PARAGRAPH-ALIGNMENT LOST WHEN BLOCK IN A LIST AND OUTPUT-FORMAT IS RTF
* Bug 10143943 ER: PARAGRAPH-PROPERTIES ARE LOST WHEN PARAGRAPH IS IN A LIST
* Bug 10303133 ER: BI PUBLISHER TABLE IS NOT GETTING CENTERED WHEN OUTPUT IS HTML
* Bug 10304256 BULLETS AND NUMBERING DO NOT WORK TOGETHER

Web Server (WEBSERVER)

* Bug 7420229 QUERY FROM BI PUBLISHER REPORTS APPEARS TO MISS/SKIP THE CACHE FOR LIST OF VALUE
* Bug 9669973 ER: NEED TO SUPPORT PRE-PROCESSING XML WITH XSL FOR EXCEL TEMPLATE
* Bug 10337868 TAB DELIMITER DOES NOT WORK FOR A CSV OUTPUT
* Bug 11670678 RUNNING CLOCK INDICATOR ( HOURGLASS ) DOES NOT SHOW UP FOR HTML OUTPUT
* Bug 11679262 SYSDATE SYNTAX {$SYSDATE()$} NOT WORKING FOR DEFAULT VALUE IN REPORT PARAMETERS
* Bug 11718291 DATE PICKER OF DATE PARAMETER IN A REPORT HIDES BEHIND THE PDF OUTPUT IN IE8

E-Business Suite – XDO (XEBS)

* Bug 9747198 WATERMARK IN ARABIC IN PDF APPEARS FROM LEFT TO RIGHT – SHOULD BE RIGHT TO LEFT
* Bug 9836706 INCORRECT NUMBER FORMAT FOR CARRY FORWARD CALCULATION
* Bug 9860192 CONVERSION TO PDF FORMAT FAILS WITH ERROR – FOR INPUT STRING: "4901001241"
* Bug 10321578 PERFORMANCE ISSUE WHEN USING PDF TEMPLATE

References

NOTE:1322357.1 – How To Upgrade Oracle BI Publisher 11.1.1.3.0 to 11.1.1.5.0 ?
NOTE:1329825.1 – List of Bug Fixes Included In OBIEE 11.1.1.5.0

Troubleshoting Error: unable to get file lock, will retry …

Share

I ran into this error the first time I restarted Weblogic on one of my installs, the only reference that I was able to find is the error description below:

BEA-141281 Info:unable to get file lock, will retry …

Description This message indicates that WLS can not get file lock because other process still holds the lock. W LS will try again before timeout.
Cause This is an information-level message only.
Action If WLS fails to start due to unable to get file lock, then lock files need to be removed manually before restart WLS.

The funny thing is that it tells you to remove the locks but doesn’t provide their location, if you are running OBIEE 11g you can remove AdminServer.lok from:   d:\oracle\fmw\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp If you are not using Weblogic in the context of Oracle Busines Intelligence you can do a file search for any lok files under your middleware home (d:\oracle\fmw).

Technorati : BEA-141281, error, troubleshoting Del.icio.us : BEA-141281, error, troubleshoting Zooomr : BEA-141281, error, troubleshoting Flickr : BEA-141281, error, troubleshoting

 

Read the rest of Troubleshoting Error: unable to get file lock, will retry … »

Fixing device references after importing a Linux guest in Oracle Virtual Box

Share

I’ve run into issues with Oracle VirtualBox Virtual Appliances not being able to boot after being imported into a new host. I have a base openSUSE 11.3 image that I use to build all my App and DB servers. This post documents some steps I now take when exporting my base VM to minimize the pain of getting my new guests up and running:

First identify how physical partitions and devices are mapped to logical device names by listing the contents of /dev/disk/by-id:
$ ls -l
ata-VBOX_HARDDISK_VB4c05ce37-15844d37 -> ../../sda ata-VBOX_HARDDISK_VB4c05ce37-15844d37-part1 -> ../../sda1 ata-VBOX_HARDDISK_VB4c05ce37-15844d37-part2 -> ../../sda2 ata-VBOX_HARDDISK_VB4c05ce37-15844d37-part3 -> ../../sda3 scsi-SATA_VBOX_HARDDISK_VB4c05ce37-15844d37 -> ../../sda scsi-SATA_VBOX_HARDDISK_VB4c05ce37-15844d37-part1 -> ../../sda1 scsi-SATA_VBOX_HARDDISK_VB4c05ce37-15844d37-part2 -> ../../sda2 scsi-SATA_VBOX_HARDDISK_VB4c05ce37-15844d37-part3 -> ../../sda3
Also note the current mount points by listing the contents of your /etc/fstab file
$ cat /etc/fstab
/dev/disk/by-id/ata-VBOX_HARDDISK_VB4c05ce37-15844d37-part1      swap /dev/disk/by-id/ata-VBOX_HARDDISK_VB4c05ce37-15844d37-part2      / /dev/disk/by-id/ata-VBOX_HARDDISK_VB4c05ce37-15844d37-part3      /home
Steps to fix disk mappings on an oracle virtual box virtual machine / appliance after you import it:
  1. Boot your SUSE virtual machine and click on escape when the startup options screen comes up:
  2. Confirm you want to exit the graphical mode if asked
  3. When the GRUB boot options screen comes up select your default boot mode and press the letter “e”to edit this entry
  4. Using the notes from the original virtual machine you exported replace the current “root” device reference with your boot partition (the one mounted at “/”)
  5. You can optionally correct any additional device references in this line
  6. Once you are done with your changes press ENTER to exit this screen and then the letter “b” to boot
  7. To permanently fix this issue you will need to replace the physical device IDs in the /etc/fstab file (ie. map /dev/sda1 instead of the physical device ID to mount point /)
  8. You also will need to permanently correct the startup entries in your /boot/grub/grub.conf file by repeating the string replacements you performed in step four.

Summary: After reading this post you should be better prepared to smoothly export and import Linux virtual machines from your Oracle Virtual Box servers by being ready to correct any disk device reference issues in fstab and grub.conf

Questions and Comments: Please use the comment form on this post to send us your questions and comments, we look forward to hearing from you!

Read the rest of Fixing device references after importing a Linux guest in Oracle Virtual Box »

Default Web Catalog Path in OBIEE 11g

Share

One thing to have in mind when familiarizing with Oracle Business Intelligence Enterprise Edition’s new 11g version is the default location for the Web Cat should be something like the PATH below:

$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips$INST_NUM/catalog/<webcat_directory>

You can read the post “Environment variables to simplify your life – OBIEE 11g System Administrator Edition” to help you in simplifying the administration of your OBIEE 11g environments.
Summary:
This post should guide users new to Oracle Business Intelligence Enterprise Edition version 11g familiarize themselves with changes in directory structure and answer questions such as:
  • Where is the OBIEE 11g web catalog located?
  • How can I see my 11g BI Publisher reports from the OBIEE Analysis and Dashboards front end? What is the correct path for my BI Publisher repository if I want it to integrate with the OBIEE front-end?
  • Where are report and dashboards located after the 11g upgrade wizard process is completed?

Questions and Comments: Please use the comment form on this post to send us your questions and comments, we look forward to hearing from you!

Read the rest of Default Web Catalog Path in OBIEE 11g »

Tags: , , ,
Posted in Install and Configuration OBIEE by Ignacio de la Torre. No Comments

Installing the Oracle Business Intelligence 11g (11.1.1.5) Client Tools

Share

Overview

This is a brief installation guide for those currently working on their 11.1.1.5 OBIEE installation. Please post commnents if you have any questions or run into issues installing OBIEE 11g, we will try to fix them and can document their resolution for future reference.

Pre-requisites

Installation

  • Unzip the files in your local disk and double click the biee_client_install.exe file to start the installation wizard.

  • Verify the installation directory and click Next.

  • Specify the location where you want the program shortcuts created, in my case I chose a new program group from where I can copy shortcuts and paste them into my quick launch toolbar.

  • Click Install on the summary screen to actually begin the process.

  • Once the installation is complete you can see the client tool shortcuts in your new program group.

Other posts that might be of your interest are:

Tags: , ,
Posted in Business Intelligence OBIEE by Ignacio de la Torre. No Comments

Configuring WebLogic Automated Startup Credentials

Share

As one of those who have recently acquired administrator duties as part of our organizations push to adopt OBIEE 11g I recently struggled with the issue of how to correctly start the Web Logic server so that it would not die with my session expiration

The main issue I faced was the fact that every time I tried to start WebLogic I would be asked for the administrator username and password, this really got in the way of automating the WebLogic startup. After a little bit of digging into the WebLogic Server Documentation I discovered a section about the boot.properties file and how use it to configure the startup credentials so that input from a command prompt wouldn’t be necessary. Here are the simple steps to implement this configuration:
  1. Locate the $MW_HOME/user_projects/domains/[domain (ie. bifoundation)]/servers/[managed server (ie. biserver_1)]/security
  2. Edit the boot.properties file by entering or replacing the following lines:username=
    password=
  3. Execute the commands below to stop the WebLogic server:cd $MW_HOME/user_projects/domains/bifoundation/bin
    ./stopWebLogic.sh
  4. Now execute the command below to bring the server back up:./startWebLogic.shNote: Notice how this script will no longer ask you to enter the WebLogic administrator’s user name and password.
  5. Review the credentials in the boot.properties file, the first time the server is started it will read the clear text credentials and replace them with encrypted values.cat $MW_HOME/user_projects/domains/bifoundation/servers/biserver_1/security
After this configuration is in place you are now able to configure WebLogic to start automatically with your server without nay mayor issues:
Other posts that might be of your interest are:

Summary:

After reading this post you should be able to configure the boot.properties file to provide the server with startup credentials, a necessary step when configuring the WebLogic Server automated startup. This post should also help in answering or resolving these related topics:
  • How to configure WebLogic to start automatically with my server?
  • The WebLogic server does not start automatically, it is prompting for a user name and password
  • WebLogic not reading boot.properties file at $MW_HOME/user_projects/domains/[domain (ie. bifoundation)] (this location has been deprecated, use the one listed above)

Questions and Comments: Please use the comment form on this post to send us your questions and comments, we look forward to hearing from you!

Nota de Interes: Oracle anuncia version 11.1.1.5 de OBIEE

Share

La semana pasada Oracle anuncio la disponibilidad de una nueva version de Oracle Business Intelligence Enterprise Edition 11g. Este es el enlace a la pagina de descarga de la version 11.1.1.5 de OBIEE.Yo anticipo que estas dos nuevas funciones van a ser las que acapararan la atencion de la base de usuarios siendo que muchas empresas han estado en espera de ellas con relativa ansiedad:

  • La aplicacion “Oracle Business Intelligence Mobile” que permite a directivos y otros empleados corporativos consumir dashboards, reportes y graficos desde dispositivos mobiles de marca Apple.Esta pagina muestra como se ve el nuevo control MapView con un mapa de ingresos en la pantalla de un iPad.
  • Un conector nativo (BAPI) para consumir cubos de SAP BW como fuentes de datos en la capa fisica de OBIEE. Esto es especialmente importante para corporativos que han realizado grandes inversiones de capital y esfuerzo en sus instalaciones de SAP BW pero que se dan cuenta de las limitaciones de Business Objects y BEx Explorer en comparacion con OBIEE 11g.

Y ustedes, ya estan listos para implementar OBIEE 11g en sus empresas? Espero sus comentarios y preguntas!

Environment variables to simplify your life – OBIEE 11g System Administrator Edition

Share
As I spend a lot of time switching between a very well defined set of directories in the Oracle Middleware home for OBIEE 11g I have been developing a list of variables that I like to use in my scripts and configure in the servers that I most commonly work with. They have proven to be very useful in being able to remember where each component or file has been moved with the upgrade to 11g.
#########################
### OBI 11g Variables ###
#########################
#use INST_NUM to simplify the setting of all other instance related variables
export INST_NUM=1 #Most developer workstations will only have one instance
#Middleware home
export MW_HOME=/u01/app/oracle/Middleware/
#Enterprise Manager Home
export OBIEM=$MW_HOME/Oracle_BI1
#Oracle Instance (contains services, config, domain, etc)
export ORACLE_INSTANCE=$MW_HOME/instances/instance$INST_NUM
#Configuration File Directory (Most of them)
export OBICFG=$ORACLE_INSTANCE/config
#Cache Directory (out of the box location)
export OBI_CACHE=$ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obis$INST_NUM/cache
#MDX Cache (out of the box location)
export OBI_MDXCACHE=$ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obis$INST_NUM/MDXCache
#Repository Directory
export OBIRPD=$ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obis$INST_NUM/repository
#Webcat Directory
export OBICAT=$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips$INST_NUM/catalog
#Weblogic Server home
export WLS_HOME=$MW_HOME/wlserver_10.3
##########################
##END OBI 11g Variables ##
##########################
#before you save your changes also make sure you set the following variables to their correct value
export CLASSPATH=/ora01/app/oracle/oraInventory:$CLASSPATH
export TMP=/tmpexport
TMPDIR=/tmp
Summary:
After reading this post you should be able to answer questions such as the ones listed below:
  • What is the path to the OBIEE 11g Web Catalog ($OBICAT)?
  • What is the default location of the Oracle Middleware Home ($MW_HOME)?
  • Where is the opmnctl located at in my OBIEE 11g install ($OBIEM/opmn/opmnctl)?
  • Where is the OBIEE RPD repository located at in OBIEE 11g ($OBIRPD)?
  • What is the path to the Fusion Middleware Control (Enterprise Manager) instance on my OBIEE 11g server ($OBIEM)?
Questions and Comments: Please use the comment form on this post to send us your questions and comments, we look forward to hearing from you!

Slider by IWEBIX Webdesign