| Oracle® Warehouse Builder Release Notes 11g Release 2 (11.2) Part Number E10585-05 |
|
| View PDF |
| Oracle® Warehouse Builder Release Notes 11g Release 2 (11.2) Part Number E10585-05 |
|
| View PDF |
Release Notes
11g Release 2 (11.2)
E10585-05
April 2010
This document contains important information not included in the Oracle Warehouse Builder documentation.
This document provides the following information about Oracle Warehouse Builder 11g Release 2 (11.2):
Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
Access to Oracle Support
Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/support/contact.html or visit http://www.oracle.com/accessibility/support.html if you are hearing impaired.
The Oracle Warehouse Builder 11g Release 2 (11.2) documentation set includes these publications:
Oracle Warehouse Builder Installation and Administration Guide
Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide
To access the documentation set, including the latest version of the release notes, refer to the following Web site:
http://www.oracle.com/technology/documentation/warehouse.html
For the latest information on platform-specific requirements, certifications and patches, refer to the following Web site:
This section lists the known issues and limitations for 11g Release 2 (11.2) release. They are grouped into the following categories:
5213153, 5191402: NLS: NON-ASCII CHARACTERS ARE CORRUPTED IN GENERATED EEX FILE
When you deploy business definitions that include non-ASCII characters, the deployment fails with errors.
Workaround: Manually import the .eex file generated for the deployed objects by Warehouse Builder into your Discoverer EUL. The .eex file is located in the OWB_HOME/owb/deployed_files directory.
6074518: UI MESSAGES ARE NOT DISPLAYED IN SQL*PLUS WINDOW
In the Design Center, if you attempt to start the SQL*Plus window from the Tools menu, you may encounter errors. For certain languages such as Japanese, Korean, and Chinese, you may not be able to invoke the SQL*Plus window from the Design Center. Or, you may not be able to see user interface messages.
Workaround: Invoke SQL*Plus from a tool other than Warehouse Builder.
5112489: REPOSITORY ASSISTANT DOES NOT FOLLOW LOCALE PREFERENCE
In the Design Center, if you set the locale to a different language, the change does not affect the Repository Assistant. That is, if you select a new locale using the Appearance Preferences in the Preferences dialog box, commit the changes, and then launch the Repository Assistant, the system default language displays in the assistant despite your selection in the Design Center.
5122612: UNABLE TO CREATE MULTIBYTE TARGET USER IN OMB PLUS
When you create a target user using OMB*Plus, if you use multibyte characters in the user name, the target user creation fails.
5031270: NAMES OF SEEDED OBJECTS IN THE REPOSITORY ARE NOT TRANSLATED
Seeded objects in the repository are not translated. These include, for example, the names of predefined transformations as displayed under the Public Transformations node of the Globals Navigator. This also includes the default project named MY_PROJECT, the default control center named DEFAULT_CONTROL_CENTER, the folder called DERIVED_DATA_RULES that contains derived data rules, and the default configuration called DEFAULT_CONFIGURATION.
3066632: WAREHOUSE BUILDER FLAT FILE SAMPLE WIZARD COUNTS A MULTIBYTE CHARACTER LENGTH AS 1
When translated into Japanese, the Warehouse Builder Flat File Sample Wizard does not handle multibyte characters in delimited files correctly. The wizard handles a multibyte character in delimited files as 1 length.
Workaround: Manually edit the length using the Flat File Sample Wizard.
8702449: ERROR WHEN CREATING NEW FILE MODULE WITH JAPANESE LOCALE
In the Oracle Warehouse Builder 11.2 Linux release, when your Locale is set to Japanese, if you create a new File module, an error dialog is displayed. This error occurs because the default name for a new File module, when translated, is too long.
Workaround: Click OK on the error dialog box. You can then enter a name for the File module.
6050580: MAPPINGS WITH TIMESTAMP DATA MAY BEHAVE INCORRECTLY
Under some conditions, you may encounter unexpected behavior when running a mapping that loads and transforms timestamp data. For example, if you deploy and run a mapping that transforms a column from TIMESTAMP type to VARCHAR2, the resulting data in the target column may be incorrect.
Workaround: This behavior does not arise when using the Mapping Debugger. Run the mapping and load the data using the Mapping Debugger.
4483510: PLUGGABLE MAPPINGS DO NOT WORK IN SAP MAPPINGS
5215322: WAREHOUSE BUILDER CONNECTOR TO SAP R/3 REQUIRES SAP LIBRARY FILE
Workaround: To access SAP R/3 in the Design Center, first obtain the SAP RFC library from SAP and copy it to the OWB_CLIENT_HOME/owb/bin/admin directory.
To access SAP R/3 in the Control Center, first obtain the SAP RFC library from SAP and copy it to the OWB_SERVER_HOME/owb/bin/admin directory. OWB_SERVER_HOME is the directory where the Warehouse Builder control center service is installed.
To connect to non-Oracle databases, you need the JDBC driver corresponding to that database. Non-Oracle JDBC drivers are not shipped as part of the Oracle Warehouse Builder software. You can obtain the JDBC drivers from the vendor and copy them to the OWB_HOME/owb/lib/ext folder.
Table 1 lists the drivers that are required to connect to DB2, SQL Server, and Teradata.
7135670: OMBPLUS CANNOT LOAD NLS TEST SCRIPTS
If you use OMB*Plus to run a Tcl script containing non-ASCII characters, the characters may be corrupted in OMB*Plus. Scripts with non-ASCII NLS characters may not execute successfully. There is no workaround.
5129228: MULTIPLE REPOSITORY BROWSER SESSIONS FROM A SINGLE CLIENT MACHINE NOT SUPPORTED
If you launch multiple Repository Browser sessions from a single Internet browser on a single client machine, you will encounter unexpected results. This scenario is not supported. As a consequence, you cannot browse multiple repositories with a single Internet browser on a single machine.
Workaround: Each Repository Browser session requires its own Internet cookies storage. If feasible, you can launch multiple, different Internet browsers to maintain separate Repository Browser sessions on the same machine.
Oracle Warehouse Builder 11.2 Repository Must Contain a Workspace Before Upgrade of Oracle Warehouse Builder 10.2 or 11.1 Repository MDL Export
If you are upgrading a Warehouse Builder 10.2 or 11.1 repository to Warehouse Builder 11.2 by exporting the entire repository to MDL with the Repository Assistant, then importing it into Warehouse Builder 11.2, then your destination Warehouse Builder 11.2 repository must have at least one Warehouse Builder 11.2 workspace in it before you can import the MDL.
If your Warehouse Builder 11.2 repository does not already contain a workspace before import, then you must create a dummy workspace, with a name that does not conflict with the names of any workspaces to be imported.
Follow the instructions in Oracle Warehouse Builder Installation and Administration Guide to create a workspace. At step 6 in the Repository Assistant, assign a workspace name and workspace owner that do not conflict with workspaces and workspace owners you actually plan to use. Note that if importing a Warehouse Builder 10.2 repository, the workspace name will be the name of the source schema in which the repository was stored in Warehouse Builder 10.2
You can then run Repository Assistant again to import your Warehouse Builder 10.2 or 11.1 repository export MDL file to your Warehouse Builder 11g.2 repository.
8596439: WAREHOUSE BUILDER ONLINE HELP LINKS FROM DESIGN CENTER START PAGE NOT WORKING
In the Oracle Warehouse Builder integrated installation that is included with Oracle Database 11.2, links from the Start Pages in the Design Center to the Warehouse Builder online help will not function properly. This problem does not affect the Oracle Warehouse Builder standalone installation.
Workaround: To enable invoking online help from the Start Pages, temporarily rename or delete the file ORACLE_HOME/jlib/oracle_ice.jar.
8661211: OWB DESIGN CENTER WARNING: UNKNOWN DIRECTIVE: SETSKIPJ2SDKCHECK
When you start the Oracle Warehouse Builder Design Center on Windows, you may notice the following warning in the command window that is displayed while starting the Design Center:
WARNING: Unknown directive: SetSkipJ2SDKCheck
Workaround: You can ignore this warning and proceed with logging in to the Design Center.
This section contains corrections or additions to the following Oracle Warehouse Builder documentation for this release:
The following information should be added to the section titled "Silent Install Response Values" in Chapter 2, Installing Oracle Warehouse Builder on the Server:
To perform a silent installation of Warehouse Builder, open a Command window and navigate to the directory containing the response file that is used for the silent installation. Use the following command to start the silent installation:
For Windows: setup -responseFile filename optional_parameters
For Linux: runInstaller -responseFile filename optional_parameters
Here, filename represents the name of the response file (including the complete path) and optional_parameters represents the parameters used for the silent installation.
The following information should be added to the section titled "Installing OWB on Oracle Database 11g Release 2" in Chapter 2, Installing Oracle Warehouse Builder on the Server.
Although many features in Warehouse Builder are included in Oracle Database licenses, there are features that require additional licensing. As an administrator, you can assist in managing license compliance by enabling or restricting user access to optional features. The management of optional features as described here is entirely voluntary.
When you first implement a Warehouse Builder repository, all optional features are enabled by default. You can modify these settings when you create the first workspace for the repository or you can modify the settings at a later time.
To manage the usage of optional features, complete the following steps:
Start the Repository Assistant. Select Start, Programs, ORACLE_HOME, Warehouse Builder, and then Administration.
If you are creating the first workspace for the repository, the Assistant will automatically display the Enable Optional Features page.
If you are modifying an existing repository, on the Choose Operation page, select Manage Optional Features.
Note:
This functionality is currently available in Oracle Warehouse Builder 11.2 Windows only. This functionality is planned to be added to Linux in the Oracle Warehouse Builder 11.2.0.2 Linux release.Select the options you want to make available to Warehouse Builder users.
For more information about each option, refer to the appropriate Oracle licensing information guide, listed at http://www.oracle.com/technology/products/warehouse/htdocs/licensing.html
The selections you make are enforced repository-wide and apply to all users. If a user is logged into the Warehouse Builder client when you make changes to on the Enable Optional Features page, the changes are enforced for that user the next time they log into the client.
The following is a limited list of known issues from previous releases. These issues were reported in a previous set of release notes and are now resolved in Oracle Warehouse Builder 11g Release 2 (11.2).
2577706: POST MAPPING PROCESS RUNS REGARDLESS OF SUCCESS/FAILURE OF MAPPING
2761711: FULL OUTER JOIN QUERIES TO TABLE FUNCTION GIVES WRONG NUMBER OF ROWS ON BULK FETCH
4558688: SCRIPT GENERATION FOR IMPORT OF METADATA FOR EXTERNAL TABLES FAILS FOR LONGER DEFINITIONS
4581172, 4658511: DEFERRED OBJECTS LISTED IN METAMODEL QUERY
5017820, 4915836: NON-EUROPEAN FONT GLYPHS ARE CORRUPTED IN DATA OBJECT EDITOR DIAGRAM EXPORT TO SVG
5176858: USER INPUT IN A CUSTOM DIALOG MAY TRIGGER THE INCORRECT OUTCOMING TRANSITION
5189802: EXECUTING A CUBE MAPPING MAY GENERATE ERROR ORA-20101
5212360: MAPPINGS CREATED IN OMB*PLUS MAY NEED AUTOLAYOUT WHEN EDITED MANUALLY
5372377: CANNOT SET DATE WHEN MIDDLE-TIER LOCALE IS DIFFERENT
7562355: SHOW SOURCE FOR GENERATED TABLE GIVES SPORADIC RESULTS
8283391: ICONSET CANNOT BE CHANGED FOR OBJECT INSTANCE IN THE UI
8596439: WAREHOUSE BUILDER ONLINE HELP LINKS FROM DESIGN CENTER START PAGE NOT WORKING
8788004: OWB DESIGN CENTER START PAGES CONTAIN BROKEN LINKS TO OWB ONLINE HELP
Oracle Warehouse Builder Release Notes, 11g Release 2 (11.2)
E10585-05
Copyright © 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.
 Copyright © 2000, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|