Tag Archives: obiee troubleshooting

Errors and warnings after upgrade to 11G from OBIEE 10g

If you are going to upgrade to from 10g to 11g soon, you should consider the following issue :

Why Does The OBIEE 11g Consistency Check Show Errors And Warnings After An Upgrade That Did Not Occur In 10g?

The goal is to understand why an OBIEE repository (RPD) that completed an error and warning free consistency check in 10g, results in many warnings or errors when the RPD is upgraded to 11g and a consistency check is executed.

A wide range of errors and warnings have been seen.  A few examples have been copied below; however, many other errors or warnings could show after the upgrade.

For example:

Error: The content filter of a source for logical table: Fact response details references multiple dimensions. [nQSError:15001] Could not load navigation space for subject area Test_Area

Error 38126 Object Type: Logical Level
Logical Level “XyZ”.”123″ .. has name with leading or trailing spaces

Error 15004 Object Type: Business Model
Internal Error: Missing functional dependency association for colum 5: X_TABLE.ROW_ID
[nQSError: 15001] Could not load navigation space for subject area Test_Area.

Error 38079 Object Type: Physical Foreign Key
Foreign Key “ABC.123″….
FKey#2 A comparison is being carried out between non-compatible types

Warning: Fact table is not joined to logical dimension table. This will cause the problems when extracting project(s).

Warning: Missing Functional dependency association for column:

Oracle’s reply was:

In general with each release, the consistency checker is enhanced  to improve the consistency rules and to correct consistency checks that may not have been occurring in a previous release, but should have been.  Therefore, it is common and expected for each major release upgrade that you will see additional consistency check errors or warnings that you did not see in a previous release.

The majority of consistency check  errors and warnings that show in 11g but did not show in 10g are legitimate and represent a RPD design issue. The goal of these warnings and errors is to enforce RPD design rules and each one should be investigated and addressed as these could cause additional issues.

It is also advisable if you are in ‘online’ mode to check the nqserver.log from the BI Server to ensure you are correcting all the errors associated with a particular Subject Area and/or consistency check issue.

The default location will be here (assuming default instance name).

[middleware_home]/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

My advice is to make a good contingency plan, including roll-back possibility along with full regression testing (which can be tricky in OBIEE).

 

Values In OBIEE 10g Multiselect Prompt Are Not Sorting in Alpha-Numeric Order In Large LOVs

Symptoms
When running an Oracle Business Intelligence Enterprise Edition (OBIEE) Dashboard with multi-select prompts that contain many values, the values in the list are not consistently alpha-numerically sorted.

The initial retrieval in the multi-select dialog box shows the values alpha-numerically sorted.  When the next set of values are retrieved, the values lose their sort order and are no longer alpha-numerically sorted.
Cause
This issue is described in the following known bugs:

Bug 8995183 – SORTING IN MULTISELECT PROMPT NOT WORKING AS EXPECTED
Bug 9787610, MULTISELECT PROMPT NOT SORTING PROPERLY WHEN CONTAINS MORE THAN 256 ITEMS
Solution
This issue is fixed in OBIEE 10.1.3.4.2.
If you are encountering this issue, you are urged to upgrade to version 10.1.3.4.2 to obtain the fix
for this bug and many other bugs.
For information on upgrading to this version, please see Note 1357872.1 How To Upgrade to
Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.2

If you are currently unable to upgrade to OBIEE 10.1.3.4.2, and require the fix in OBIEE 10.1.3.4.1, please do the following:
1.    Open a Service Request (SR) with Oracle Support and request the password for
Patch 9787610.

2.    Follow instructions for installing the patch as described in patch readme.txt file.
Oracle Support recommends that you first test this patch on a development or test server.
Once you are satisfied that the patch corrects the issue, you may promote the patch to
your production environment.

NOTE: If you are using any web server other than IIS, you will need to recreate and redeploy the
Analytics.war file after installing the patch.

For detailed instructions on how to do this in an OC4J environment, please see:

Note 1075754.1 Create and Deploy A New BIEE 10.1.3.4/10.1.3.4.1 ANALYTICS.WAR File.

References
BUG:8995183 – SORTING IN MULTISELECT PROMPT NOT WORKING AS EXPECTED
BUG:9787610 – MULTISELECT PROMPT NOT SORTING PROPERLY WHEN CONTAINS MORE THAN 256 ITEMS
NOTE:1075754.1 – How To Create And Deploy A New OBIEE 10.1.3.4.X ‘analytics.war’ File (for OC4J)
PATCH:9787610 – MULTISELECT PROMPT NOT SORTING PROPERLY WHEN CONTAINS MORE THAN 256 ITEMS

Applies to:
Business Intelligence Suite Enterprise Edition – Version: 10.1.3.4.1 [1900] to 10.1.3.4.1 [1900] – Release: to 10g
Business Intelligence Server Enterprise Edition – Version: 10.1.3.4.1 [1900] to 10.1.3.4.1 [1900]   [Release: 10g to 10g]
Business Intelligence Answers Option – Version: 10.1.3.4.1 [1900] to 10.1.3.4.1 [1900]   [Release: 10g to 10g]
Information in this document applies to any platform.
This knowledge document is a replacement for 952833.1 which has been deleted.

OBIEE expert forum is up and running

I’m delighted to announce that a new useful OBIEE forum / discussion board is open. Idea was up in the air for a long time – and it seems as multiple people planned this for awhile independently (rnm1978, Mark Rittman, Adrian Ward, and other guys and myself included). Part of it was frustration with moderation on official Oracle’s board, and part of it was a need for a resource where OBIEE and business intelligent professionals could share secrets of the trade. The difficult part is keeping balance between sharing knowledge as well as  providing a moderated environment.

The board is already active with several interesting topics going. If you’re interested in participating – please apply at Google OBIEE group

Thanks to Mark Rittman who organized the movement and to all those who agreed to become moderators.

Oracle Business Intelligence is not supported on this Windows version

When trying to install Oracle Business Intelligence Suite Enterprise Edition, v. 10.1.3.4.0 for Microsoft Windows in Windows XP and getting the following error message.

“Oracle Business Intelligence is not supported on this Windows version. Oracle Business Intelligence is only supported on Windows XP x86, Windows 2003 x86, Windows 2003 AMD64, Windows 2003 EM64T, Windows Vista x86, Windows Vista AMD64, Windows Vista EM64T, and Windows 2000 x86.”

Installer uses systeminfo.exe command to get information on the architecture of the machine. If this command will cause any error, then there is a need to check and fix that error first.

Run the following command and see if any errors. In our case we had the following error.

The command systeminfo.exe is run from command line.

***
C:>\windows\system32\systeminfo.exe

Error:-

Back with error for Network Card
Information???????..Error:Provider Load failures.

***********

Since installer use the same command to get information on the architecture of the machine. In this case because of the above error installer was not able to drive the machine detail and as a result installation failed.

The errors from the above command systeminfo.exe (if any) needs to be fixed first.  In our case after we fixed the Network Card issue, installation went fine.

OBIEE 10.1.3.4 is Not Supporting Excel 2007

I was just about to file an SR – and quick search shows that someone else has already had this problem.

OBIEE 10.1.3.4 is Not Supporting Excel 2007 – File you are Trying to Open is in a Different Format than Specified by the File Extension – Contain Features not Compatible [ID 980627.1]

Comments
——–
OBI APPS 7.8.2.13 [19250]
OBIEE 10.1.3.4
Microsoft Windows x64 (64-bit)

– Oracle OBIEE 10.1.3.4 is not supporting MS Office 2007.

– We are trying to download a report from answers to Excel 2007 but its downloading as Excel 2003.
– Why is it?

– After clicking Download -> Download to Excel, in the request, saving the file and then trying to open it in 2003, the following message appears:


Microsoft Office Excel

The file you are trying to open, ‘Test.xls’, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?
[Yes][No][Help]

If I click on Yes button, I am able to open the report.

If I update some values and try to save then I get a warning message:


Microsoft Office Excel

test.xls may contain features that are not compatible with Single File Web Page. Do you want to keep the workbook in this format?

– To keep this format, which leaves out any incompatible features, click Yes.
– To preserve the features, click No. Then save a copy in the latest Excel format.
– To see what might be lost, click Help.

[Yes][No][Help]

I have to click on Yes button then it can be saved.

I should update and save this 2003 excel type on excel 2007 without any warning message.

– In Citrix, If I use Download -> Download to Excel and click on open button to open the file, I get this popup:


Windows Installer

Preparing to install…

[Cancel]

and that ends up with error:


D:\TEMP\…\Temporary_Internet_Files\Content.IE5\STMP6X8Z\Test.xls

Only Administrators have permission to add, remove, or configure server software during a Terminal services remote session. If you want to install or configure software on the server, contact your Network Administrator.

[Ok]

Solution

Comments
——–
1. Excel 2003 documents can be opened in Excel 2007.

2. From Release Notes OBIEE 10.1.3.4.1:
(“http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/e10404/toc.htm)

4.1.18 Limitation on the Number of Rows in MS Excel 2007
This issue applies to Versions 10.1.3.3, 10.1.3.3.1, 10.1.3.3.2, and 10.1.3.3.3. It is fixed in version 10.1.3.4.

In Microsoft Excel 2007, users cannot insert views that have more than 65536 rows. This is because Oracle BI Office uses an Excel 2003 based template, which has a limit of 65536 rows per sheet.

So, template used is for Microsoft Windows Excel 2003.

3. There is an Enhancement Request already filed asking to use an Excel 2007 template.
It is Document Bug 6970162, “Abstract: DOWNLOAD TO EXCEL REQUIRES TRANSLATION WHEN OFFICE 2007 INSTALLED”.

It is set to be reviewed for future versions. It has not yet been approved to be included in a particular version.

4. About the error you get when you try to open the downloaded file, in Excel 2007:


Microsoft Office Excel

The file you are trying to open, ‘Test.xls’, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?
[Yes][No][Help]

It is an Excel 2007 issue.

ORACLE cannot  be responsible for giving you solutions for Microsoft Excel Issues, as it is not our area.
You could google the error.
Nevertheless, we are giving you an example of one of the documents available in Google for that error. Please, be aware it is being given as a guideline, if you want to try it.

There is a descdription and some workarounds provided at:

http://www.itexperience.net/2008/03/17/excel-2007-error-different-format-than-specified-by-the-file-extension/

where they say:

This errors particularly occurs when you’re trying to open an XLS file (Excel 2000-2003) with Excel 2007. In most cases, the problem can be solved by defining MIME types and associating them with extensions.
When you’re using a Document Management System (like Sharepoint or Livelink), you can try adding these:
.xls = application/msexcel
.xlsx = application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

However, if you don’t want to look for a solution, but just want to solve the problem, insert this key in your registry to suppress the notification:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
“ExtensionHardening”=dword:00000000

You can accomplish the above by doing the following:

Open your Registry (Start -> Run -> regedit.exe)
Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
Right click in the right window and choose New -> DWORD
Type “ExtensionHardening” as the name (without the quotes)
Verify that the data has the value “0?

You could talk to your Microsoft Excel Support to verify the workarounds given above, or to provide another solution.

5. About the error you get once you modify the file in Excel 2007 and try to save it:


Microsoft Office Excel

test.xls may contain features that are not compatible with Single File Web Page. Do you want to keep the workbook in this format?

– To keep this format, which leaves out any incompatible features, click Yes.
– To preserve the features, click No. Then save a copy in the latest Excel format.
– To see what might be lost, click Help.

[Yes][No][Help]

It seems to be due to OBIEE using mhtml when exporting to Excel.

There is an Enhancement Request already filed, Document Bug 5661454, “ABILITY TO GET EXCEL VIEWER WORKING WITH ‘DOWNLOAD TO EXCEL'”, requiring changing Excel download from MHTML to native Excel format.
It has been approved to be included in OBIEE 11.1.1.2.0.

Document Note 749436.1, “Download to Excel from reports downloading as HTML/MHTML rather than ‘real’ Excel”, explains more about that.

Having said that, the following document provides some information on the error when trying to save files with some formats in Excel 2007 (again, it is not an ORACLE article, so we are giving it only as a guide):

http://office.microsoft.com/en-us/help/hp100141051033.aspx

They say:

The Microsoft Office Excel 2007 Workbook format (.xlsx) preserves all worksheet and chart data, formatting, and other features available in Office Excel 2007, and the Macro-Enabled Workbook format (.xlsm) preserves macros and macro sheets in addition to those features.

If you frequently share workbook data with people who use an earlier version of Excel, you can work in Compatibility Mode to prevent the loss of data and fidelity when the workbook is opened in the earlier version of Excel, or you can use converters that help you transition the data. For more information, see Use Office Excel 2007 with earlier versions of Excel(http://office.microsoft.com/en-us/help/HA100775611033.aspx).



Web Page and Single File Web Page
These Web Page file formats (.htm, .html), Single File Web Page file formats (.mht, .mhtml) can be used for exporting Excel data. In Office Excel 2007, worksheet features (such as formulas, charts, PivotTables, and Visual Basic for Application (VBA) projects) are no longer supported in these file formats, and they will be lost when you open a file in this file format again in Excel.

6. About the other errors you get on Citrix:


Windows Installer

Preparing to install…

[Cancel]

and


D:\TEMP\…\Temporary_Internet_Files\Content.IE5\STMP6X8Z\Test.xls

Only Administrators have permission to add, remove, or configure server software during a Terminal services remote session. If you want to install or configure software on the server, contact your Network Administrator.

[Ok]

You would need to verify them with your Citrix Support, as they cannot be reproduced outside Citrix. The error text seems to say you do not have permissions to write in the TEMP directory for IE to create a temporary Excel file. It is a Windows issue also, apparently.

References
BUG:5661454 – ABILITY TO GET EXCEL VIEWER WORKING WITH ‘DOWNLOAD TO EXCEL’
BUG:6970162 – DOWNLOAD TO EXCEL REQUIRES TRANSLATION WHEN OFFICE 2007 INSTALLED
NOTE:749436.1 – Download to Excel from reports downloading as HTML/MHTML rather than ‘real’ Excel