Tag Archives: Oracle support

How to Keep Track of OBIEE 10g Patches Applied? How To Handle Version.Txt Files When You Have Multiple Patches? Are Patches Cumulative?

Applies to:

Business Intelligence Server Enterprise Edition – Version: to [2405] – Release: 10g to 10g
Business Intelligence Suite Enterprise Edition – Version: to [2405]   [Release: 10g to 10g]
Information in this document applies to any platform.


– How to handle VERSION.TXT files when you have multiple patches?

– When Oracle supplies an OBIEE patch, its README file always says to replace the VERSION.TXT file on the [Oracle Home] directory with the one included.

– When you apply a second, unrelated patch to the environment why would we want to replace the entire VERSION.TXT file?

– Would you append the text in the second patch’s VERSION.TXT file to the first?

– How will this display on the Settings > Administration window when it displays the information in the Product Information box?

– Are OBIEE Patches cumulative?


This has been confirmed by Development.

1. Version.txt file should be replaced, following instructions in the readme files of each patch.
New version.txt file should not be appended to the end of the current one, but it should replace the current one.

2. Currently, for 10G versions, OBIEE patch installation does not provide for an automatic way of keeping track of the patches applied.

Nevertheless, Development is working to make 11g use opatch installer. Opatch provides a way to keep track of previous patches installed. There is no official date for 11G release.

3. It is recommended that you keep a record of the patches you have applied.
You could implement that in the way you prefer, but separated from OBIEE installation, and in addition to replace the version.txt file used in OBIEE.

For example, you could:
– Append the version.txt file to another file, with name version_history.txt or something like that, everytime you apply a patch.
– When applying first patch, rename original version.txt from GA release to version0.txt and copy version.txt from the patch.
Then, when applying second patch, rename version.txt to version1.txt and copy new version.txt from the second patch, and so on.
– copy new version.txt file to a file named like version_<YYYY_MM_DD>.txt, indicating the date when you applied it.
That way you can have in a single directory all the previous version.txt with its dates of installation.

4. OBIEE One-off patches are not cumulative at this time.

5. Production patches (the ones that do not require a password), normally, contain the fixes of older production patches.

6. When we create a new patch for you (that is when you report a new issue, never seen before, and then we create a fix for that and provide it to you) we ask you the list of one-off patches you have applied. Development uses it to create a merged patch including all those fixes plus the new one.

7. In the case a one-off patch is already available (so, it was not produced for you), you would need to open an SR to ask for a password to download it. In that same SR, please, provide the list of patches applied previously, so Support can determine if it is ok for you to apply the patch, or if a merged patch needs to be created for you.

8. When in doubt, ask ORACLE Support if a patch can be applied by you without conflict issues.

Few Oracle’s support treasures

Normally, I like to browse through Oracle’s support in search of hidden gems and to get new ideas. This is how I smile when I find solution in the knowledge base for my problem:

I’m also almost used to new flash interface and it doesn’t irk me anymore.

It’s amazing how they deal with all kinds of issues and requests. I’ve found few things I’d like to share today:

How To Concatenate or Merge Amount and Currency Columns?

Your report displays transactions amount and currency in two separate columns. The requirement is to display the amount and currency as one column. For example:
100USD 100EUR etc….

Currently you have a numeric (double) column – Amount, and a second column – currency (alpha code format, such as:USD,EUR,….) in the report. The currency column is placed on the right side of the
amount column, as below:

date | merchant | amount | currency

The currency might be different for each transaction

Currently this cannot not be achieved because when casting the amount to char, in order to concat it with the currency, the 1000s separator is lost (15,321 becomes 15321).  Also when casting the amount to char, the sum agg is no longer available.  Formatting the amount as currency is also not possible because the amount is
of different currencies.
There is an Enhancement Request Bug 8680024 logged to address this matter.

Multiselect Prompt Displays ‘No Choices Available’ When Used With A Presentation Variable

You have configured a dashboard prompt with two columns, where the value selected by the user in the first prompt column is stored in a presentation variable, and the values in the second prompt column depend on
the value in this presentation variable.

When both column prompts are defined as type ‘drop down’ all works fine. The second column correctly displays in the drop down the values. However when the second column prompt control is defined as ‘multi select’, no data is displayed in the prompt. The prompt displays ‘No Choices Available’.

The multi-select prompt column should correctly display values in the prompt as it does when it is defined as a drop down.

This is bug 7571682

There are three possible work-arounds:
1. Click the ‘Go’ button will bring back data
2. Enter a value in the match box and it returns data
3. Use the vanilla constrain option for the dashboard prompts, so you can have column 2 constrained by column 1

Integrating BI Office with OBIEE that has SSO

It is possible to integrate BI Office with OBIEE that has SSO?

BI Office is similar to BI Publisher in integrating with OBIEE that has SSO.

Which is documented in the Oracle® Business Intelligence Enterprise Edition Deployment Guide and “Additional Configuration When SSO is Enabled for Oracle BI and BI Publisher” section.

Basically you need to deploy a second saw bridge (analytics.ear) that dedicates for web service calls and bypasses the SSO:
* Locate analytics.ear in the directory OracleBI_HOME/web, deploy and name the new Plug-in analyticsSOAP.  See the Oracle Business Intelligence Infrastructure Installation and Configuration
Guide for more information on Deploying an Ear file on your Web Application Server.
* Locate the Office Server config file (bioffice.xml), update the SawBaseURL property to point the new analyticsSOAP deployed above.
Config file bioffice.xml can be found in the directory OAS_HOME\j2ee\home\applications\bioffice\bioffice\WEB-INF
And the SawBaseURL property should look like this:
The BI Office add-in would require the user to enter their SSO credentials to login from within Excel or PowerPoint.

Without these steps, and when attempting to login to Excel plugin to OBI\SSO environment, the error message “Unknown error” is likely to occur.

Fmap Image Not Shown When Printing to PDF only – Fmap Function Showing White Space Instead – Image Can be Seeing in Dashboard

I also had this problem (Thank you very much people at Oracle’s support):


When using the function @{fmap:images/my_image.jpg} no image is being returned on the PDF version of the report.

Image is properly shown in the dashboard screen.

It only happens with one Presentation Service and Web Server. The other one works fine.

No custom skins/styles used.

War file has already been redeployed.

Already have tested many things: paths, permissions, fmap syntax, war/ear webserver redeployment, invoking image url, copying image file from one server to the other, testing with different image files, smaller and bigger ones, testing with less data, using the fmap in different areas of the Dashboard (footer, narrative, title), verifying there is no custom style in Dashboard properties, etc.

Results are always the same: the image is shown in the dashboard but not in PDF print.

No error message reported in sawlog0.log.

Cannot see images when printing to pdf only. The image can be seen in the dashboard, and its direct URL shows the image fine too.

Is there a particular setting to get the images in PDF? A particular path PDF format uses that is different to the one used to show the image in the dashboard? Any additional path where the image needs to be copied? Something particular to Websphere?

Could you point us to where to look or how to get better detailed information on what is happening when printing to pdf when looking for the instance of the image? We have tried with different image files, very small ones, and copying the image that works from one server to the other. Customer also redeployed his war file after adding the image.

Could you give us any pointer to where to look or how to get better log info or how the printing to pdf looks for the image?

1. OBIEE Development provided the following answer for you:

Make sure the path to the file used by fmap is fully qualified (i.e. a complete path). The problem is likely because the PDF generation process which is being generated in the Javahost process, doesn’t have access to the same path.

The path to the file must be the same for both the Presentation Server, and also available to the Javahost process. If they’re on different servers then this will need to be a path that is common to both systems.

A fully qualified path would typically satisfy this requirement, but this really is dependent on the customers environment, and the permissions granted to each process. A webserver doesn’t necessarily have access to a fully qualified path, and the Javahost process may well have the same problem.

So the easy solution may be to duplicate the image file on the javahost server, and try to figure out a path where both the Presentation Server and Javahost server see the “same” file.

Please, review and follow it.

They also suggested to verify this image be downloaded to other file types. That is, it is shown when printing to html, or downloading to other file types.

Also, make sure adobe version to download to pdf is the same in both the environments. the one that works and the one that does not.

2. Additionally, you could, access the working environment via a web browser in Answers, open the HTML source code (like right-click and View Page Source (or View Image Info) in FireFox or View Source in MS IE) and search for the image.
you will see the HTML source like:
<img border=0 src=”analyticsRes/s_customSkin/mydirectory/my_image.jpg”> or
<img border=”0″ src=”res/s_oracle10/images/my.gif”>

Compare the values in both footers, for your working and not working environment.
The source of the image in the working environment should give a clue of the relative directory there. You could try to place the image in the same location on the non-working environment (see point 1 first).

3. Additionally, as a test, you could place the image in an accessible virtual directory via websphere (i.e. http://server/domain:port/virtualdir/../../mi_image.gif) and then in Answers, test with a URL mapping instead of the fmap. That is, try pointing the image as a URL instead of an fmap.

4. You could also look in the javahost log to search for errors thrown when the issue is reproduced.
They are all the log files in the following directory:


They are multiple and OBIEE rotates then.

5. Given that one environment is working and another is not, please, review your webserver/oc4j  mappings of both environments (in this case they were using Websphere). Moreover in relation to point 1. Websphere mappings and access given to process, fall outside of OBIEE scope.