Oracle MOS HTML Update 28112010


 Document ID   Title   Doc Type   Modified Date 
1182063.1 Applying Patch 9492821 OBIEE Filters No Longer Work PROBLEM 22-NOV-10
1268460.1 Issues Upgrading Obiee To HOWTO 22-NOV-10
1269144.1 Obiee Upgrade HOWTO 24-NOV-10
1269549.1 Bi Publisher Deployment Failure During Obiee Installation PROBLEM 26-NOV-10
1268693.1 The Section Heading Is Distorted.Background Colouration HOWTO 23-NOV-10
1268865.1 Error When Excluding Column HOWTO 23-NOV-10
1268451.1 An OBIEE 10g report not working on 11g after upgrade: [NCR][ODBC Teradata Driver][Teradata Database] The user does not have CREATE TABLE access to database PROBLEM 22-NOV-10
1269613.1 After Applyling Patch 9492821 Filter Is Changed In Dashboard From Is Between to Is Less & Variable Not properly Displayed in Prompt PROBLEM 26-NOV-10
1269303.1 Bi Application Hangs And Its Not Responding Until Restarting Of Services PROBLEM 24-NOV-10
1269002.1 The Writeback Checkbox Is Disabled In 11g Obiee PROBLEM 24-NOV-10
1154429.1 A brief explanation of EnableXmlValidation tag Javahost config FAQ 24-NOV-10
1268946.1 Error Wile Setting Up Preferences PROBLEM 23-NOV-10
1268621.1 Starting OBIEE 11g ( On Windows Via The ‘Start BI Service’ Menu Continues To Prompt For Username And Password With Configured PROBLEM 22-NOV-10

Oracle MOS HTML Update 21112010

 Document ID   Title   Doc Type   Modified Date 
1266745.1 Upgrading Webcat And Rpd To Obiee 11g Failure PROBLEM 15-NOV-10
1266613.1 Obiee 11g Install Using Existing Weblogic Deployment HOWTO 15-NOV-10
1266888.1 The Installation of Oracle BI EE 11g has Overview and Scorecard Errors in Sample Database Lite in Linux PROBLEM 16-NOV-10
1266999.1 OBIEE server crashes Aftter Upgrade From To HOWTO 16-NOV-10
1233233.1 OBIEE and OBI apps on Windows 2008 R2 with Processor Intel Xeon HOWTO 18-NOV-10
1266670.1 Can we Configure Our Obiee Application With Asp.Net HOWTO 15-NOV-10
1267930.1 Install Taking Very Long PROBLEM 19-NOV-10
493202.1 OBIEE Scheduler and Fusion Intelligence PROBLEM 15-NOV-10
1266746.1 Invalid Subscribers Skipped In Ibot Log And Do Not Get The Delivers Report PROBLEM 15-NOV-10
1266743.1 Invalid Subscribers Skipped Error In Ibot Log – Users Do Not Get Emailed The Delivers Report PROBLEM 15-NOV-10
1266583.1 How To Change The Default Settings For The Thousands Separator and the Decimal Separator? HOWTO 15-NOV-10
974195.1 About NQSERROR: 46103 PROBLEM 15-NOV-10
1266894.1 Obiee11g: Variable Not Set After Action Link (If Variable Has No Default Values) PROBLEM 16-NOV-10
1267405.1 Path Not Found Error Code ‘U9kp7q94’ When Navigating To Dashbord With Norwegian Characters In Path PROBLEM 17-NOV-10
979712.1 Cannot Log In To BI Publisher From Answers Using SSO PROBLEM 15-NOV-10
1268187.1 Ragged Hierarchy In 11g Obiee PROBLEM 19-NOV-10
1267603.1 WebLogic Repository becomes corrupted and the OBI EE 11g Services will not start with a ‘The menu element does not contain any child elements’ error in the ’emoms.log’ file PROBLEM 18-NOV-10
1267957.1 Error Code 10058 When Displaying Joined Tables In Answers PROBLEM 19-NOV-10
1268086.1 Obiee Presentation Service Won’T Start Up PROBLEM 19-NOV-10
954836.1 Why Does Not Legend Of A Line Graph Show Different Line Types PROBLEM 15-NOV-10
962802.1 How To Issue Database session specific Commands From OBIEE HOWTO 14-NOV-10
1267493.1 Obiee Server Generates Incorrect Sql HOWTO 17-NOV-10
1265441.1 Master Note for OBIEE Essbase Integration issues ANNOUNCEMENT 18-NOV-10
1266297.1 How to generate Metadata dictionary in OBIEE 11g BULLETIN 18-NOV-10
1267971.1 Oracle BI Server Crashes Sporadically PROBLEM 19-NOV-10
1071961.1 Error in Catalog Manager After Transfering the Web Catalog from Unix to Windows: Path not found PROBLEM 17-NOV-10
1267934.1 How To Change The List Of Available Languages And Locales In The OBIEE Login Screen HOWTO 19-NOV-10
1267073.1 Oracle Em 11g Does Not Work In Ie8 HOWTO 16-NOV-10

Deploy Custom content folder location in WLS

In an earlier post I ended up with problems with custom folders in Oracle BI 11g R1. It turned out that I had to make some additional steps to deploy a custom folder in the Weblogic Server. Thanks to the documentation of the SampleApp I was able to make this work.

I have been working on a demo. Therefore I have created an index site with links to custom images and custom documentation. When I migrated this demo from 10g to 11g, I had to copy the images and documents manually. This seemed not to be enough. I ended up with some red crosses.

You have to take the following steps to deploy custom folders to the Weblogic Server.

Login to the Weblogic Server
Navigate to te Deployments
Click on ‘Lock & Edit’ in the left pane to enable the ‘Install’-button


click ‘Install’

Navigate to ‘<MIDDLEWARE_HOME>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1’

select ‘analyticsRes’
click ‘Next’

select ‘Install this deployment as an application’ (default)
click ‘Next’

Select ‘Deployment targets’
Choose ‘bi_server1’
click ‘Next’

Under ‘Source accessibility’

Choose ‘I will make the deployment accessible from the following location’
click ‘Finish’

Check the ‘Deployments’ to see whether the ‘analyticsRes’ is available.

click on ‘Activate Changes’

start the deployment; ‘analyticsRes’

Now I am able to add the required images and documents in custom folders just by referencing to the  ‘analyticsRes’- folder, eg.; ‘/analyticsRes/Documents/’

Solving “EXP-00056: ORACLE error 932 encountered”

When I was trying to export a schema out of an Oracle Database; 10g Release

After a while I was faced with the following error; “EXP-00056: ORACLE error 932 encountered”

After a little bit of Googlin’ I found a solution on the Oracle OTN Forum. Thanks to ‘slappyjam’ I was able to solve my problem.

** Solution  **

Run following scripts while connected as SYS user:

sqlplus /nolog
SQL> connect / as sysdba
SQL> @?/rdbms/admin/catmetx.sql
SQL> @?/rdbms/admin/utlrp.sql

SQL> exit

The export ended succesfully; “Export terminated successfully without warnings”

Upgrading from 10g to 11g (Repository and Webcat)

When I had installed the Oracle BI 11g R1 version, I thought it would be nice to see what happened when I migrate a simple 10g Repository and Catalog to 11g.

Migrating from 10g to 11g seems very straight forward.

Navigate to <MIDDLEWARE_HOME>\Oracle_BI1\bin\ and start ‘ua.bat’

You are presented with the following screens fill in the required values according to your site’s needs;

click ‘Next’

Choose to upgrade the RPD and the Presentation Catalog.

click ‘Next’

Choose the location of  the RPD file you want to migrate.
Fill in the credentials

In 11g you have to provide an additional password for your RPD.
Fill in the credentials

Choose the location of your catalog
Choose the Deliveries directory

click ‘Next’

Provide the details (port and credentials) of your Weblogic server

click ‘Next’

If everything has been provided well so far the status will be ‘succeeded’ 

 click ‘Next’

The summary shows the details. Now you are ready to upgrade.

click ‘Upgrade’

If everything runs like expected, the status will be ‘succeeded’ 

 click ‘Next’

You are finished.

click ‘Closed’

For some more/other details, please refer to Venkat’s post.

You can now check the ‘Enterprise Manager’. There you will see that the newly created Repository and Catalog are ‘active’.

In the end it seems that most of the functionality has been migrated succesfully to 11g. Two ‘major’ problems I experienced immediately;

  1. I used some custom folders in 10g. In 11g you have to take some additional steps to make custom  folders available. I will cover this topic in a next post.
  2. I used a ‘Narrative View’ with; ‘ ‘. This doesn’t work for all HTML Markup. It does work in the ‘Static View’. I do not have a solution for that yet.

Oracle BI EE 10G – The Farewell Competition!

In a few days time, the new 11g version of Oracle BI EE  will be launched commercially.  Still John Minkjan wants to spent some time playing around with the 10g version.

If you like a challenge and some competition please join!

I will be one of the judges, so I am looking forward to your contributions.

Good Luck!!