Oracle® Enterprise Data Quality

Release Notes

Release 11g R1 (11.1.1.7)

E49523-02

May 2014

This document contains the release information for Oracle Enterprise Data Quality (EDQ) Release 11g R1 (11.1.1.7) and includes the following:

- Section 1, "New Features and Improvements"

- Section 2, "Bugs Resolved"

- Section 3, "Known Issues and Workarounds"

- Section 4, "Upgrading Considerations"

Oracle recommends you review its contents before installing or working with the product.

1 New Features and Improvements

The following sections describe the new features introduced in each release, as well as, improvements:

- Section 1.1, "Release 11g R1 (11.1.1.7.4)"

- Section 1.2, "Release 11g R1 (11.1.1.7.3)"

1.1 Release 11g R1 (11.1.1.7.4)

This section addresses Release 11g R1 (11.1.1.7.4).

1.1.1 DIR-13859: Allow the Automated Purging of All Results for Stateless Batch Match Processing

If you use EDQ to provide stateless batch matching jobs and there is no need to keep any results of processing in the EDQ repository database, you must clean up all results related to a job once it completes. This is very important if each batch job runs with its own run label; meaning the results of previous jobs will not be overwritten when a new job runs. Currently, EDQ match processors write a lot of input data and cluster tables to the database and this is only cleared when a purge rule runs. Since the purge rules do not allow a '0 hours' configuration, this can only happen an hour after job completion, leading to undesirable database space usage.

Purge rules in the Server Console have been improved to include the option to purge immediately, making it possible to clear out results for jobs on completion where required.

1.1.2 DIR-13871: Ability to Write to Reference Data

Requested enhancement for the ability to write to a Reference Data set using a Writer in a process, in the same way as Staged Data. If the Reference Data set has a uniqueness constraint that the data in a process would break if written, the process will fail.

You can now configure a Writer processor in Director to write to a Reference Data set.

1.1.3 DIR-13873: Ability to Choose Whether or Not to Package Reference Data When Publishing a Processor

In some cases, it is desirable to publish processors that require the presence of a named reference data set, even when the option that uses the reference data set is not exposed in the published processor. This enables the publication of a series of processors that all use a common reference data set (for example, installed at the System level) for shared 'internal' functionality, such as punctuation normalization without passing on the ability for an end user to change to use a different set, and in a way that enables modification of the Reference Data set. This promotes improved reuse since a change to the reference data set will automatically be picked up by all published processors using it.

You can now choose whether or not to package Reference Data sets that are used in a created processor when publishing it to the Tool Palette.

1.1.4 18224386: Support for Graceful Shutdown in WebLogic Server

A new requirement to support the graceful shutdown for EDQ when this procedure ('Shutdown when work completes') is invoked in WebLogic Server. This means that access to the EDQ server is immediately disallowed, but any currently running real-time jobs are shutdown gracefully, and any currently running batch jobs are completed before shutting the server down.

EDQ now respects the 'Shutdown when work completes' command in WebLogic Server. When an EDQ Server is shutdown in this way in WebLogic Server, it immediately transfers to a SUSPENDED state, shuts down all real-time jobs and UI sessions, and stops listening for new batch jobs (where a JMS queue is used to submit batch jobs to the server). The server does not shutdown until any batch jobs and system tasks that are running when the graceful shutdown procedure is invoked have completed.

1.2 Release 11g R1 (11.1.1.7.3)

This section addresses Release 11g R1 (11.1.1.7.3).

1.2.1 DIR-11164: New Reference Published Processors

The key features of the new Reference Published processors are:

- They are maintained centrally so any changes made to the original are automatically updated in any instances of the processor elsewhere in the system.

- Users can view the configuration of these processors though cannot change them unless they have the required security permission to do so.

- Locked Reference Published processors cannot be unlocked by any end user regardless of their permission level. Only the original can be edited.

1.2.2 DIR-13609: New Subversion Release 1.7 Support

The EDQ integration with Apache Subversion now supports release 1.7 in addition to the 1.6 release.

1.2.3 DIR-13699: Subversion Integration Provides New Diff Capability

The EDQ integration with Subversion now provides the ability to compare your workspace with base and head revisions in tree to easily identify the differences.

1.2.4 DIR-13353: New Installation Process Using Oracle Universal Installer

You can now use the Oracle Universal Installer, an automated installation process for all supported operating systems, to install EDQ.

1.2.5 DIR-13891: New Language Support

All EDQ graphical user interfaces (GUI) are now localized into Chinese, Japanese, Korean and Brazilian Portuguese. These languages are in addition to the previously supported languages, U.S. English, French, Italian, German, and Spanish.

All documentation, including the Online Help, is U.S. English only.

1.2.6 DIR-11200: New Job Editor Support for Blocking Triggers

The Job Editor now supports the definition of 'blocking' triggers that will wait for the triggered action to complete before continuing.

1.2.7 DIR-13631: New Server Administration Utility Application

The Server Administration Utility Application replaces Functional Pack selection, the location of the configuration folder, and database connection properties.

1.2.8 DIR-13622, 13623: Oracle Application Development Framework Integration

The Administration, Web Service Tester, and Dashboard user applications have been rewritten using Oracle Application Development Framework for improved security. You can access the EDQ Launchpad with the following URL:

http://server name:port number/edq

The default launchpad URL was changed from /dndirector. Existing connections are forwarded meaning that when your browse to http://servername/9002:dndirector you are redirected to the new launchpad URL. You may want to update any existing browser bookmarks.

1.2.9 DIR-13792: Oracle Fusion Middleware Audit Framework Integration

Integration with the Oracle Fusion Middleware Audit Framework now allows you to audit modifications to user and security settings, and changes made to configuration using Director.

1.2.10 DIR-11351: In List Matching Comparison

The In List comparison provides a way of making the application of a match rule conditional on one or both identifier values in a comparison being matched with a single value or list of values.

1.2.11 DIR-2163: Automated Results Purge

Where jobs are run using Run Labels, the results for a given set of staged data (either a snapshot or written staged data), a given process, a given job, or all results for a given project can now be purged on an automated basis.

1.2.12 DIR-13011: Case Management Workflow Improvements

The flexibility of workflows in Case Management Administration has been extended to allow the availability of transitions to users to be made dependent on the attributes of the case or alert, and new rules based on previous transitions that have been made on the Case or Alert by the same user. This enables the enforcement of '4-eye' workflow requirements.

1.2.13 DIR-10175: Case Management Aggregate Reporting

Reports in Case Management now allow you to aggregate values into groups for reporting purposes. This makes it possible to report on more attributes, such as Dates.

1.2.14 DIR-13350: Oracle Platform Security Services and LDAP Integration

The product has been fully integrated to use Oracle Platform Security Services for LDAP integrations and for Web Service security.

1.2.15 DIR-13386: Data Interfaces Now Support Array Data Types

Data Interfaces now allow you to use array types to improve process reuse where arrays are used.

1.2.16 DIR-13146: Ability to Launch Web Service Tester from Director

It is now possible to launch the Web Service Tester from within the Director GUI using the context menu of a connected server.

1.2.17 DIR-13379, 13659: Process Task Options and Data Interface Mappings in Jobs

You can now externalize process task options and data interface mappings configured in a job, and so override the settings at runtime:

1.2.18 DIR-13574: Split Match Cluster Processing in Real-Time

When a real-time matching record produced more than one cluster value, the cluster groups were processed on the same single thread as the message executor. Now a thread pool processes match cluster groups from any of the executors, which allows for faster processing of complicated match clusters (load permitting.)

1.2.19 DIR-13319, 13371: Copy and Paste Multiple Groups and Comparisons Between Match Processors

You can now select multiple match groups then copy and paste these groups between match processors. Copying the match rule groups ensures rules that all rules are copied with them (similar to the rule copy and paste feature), and it copies the names of the comparisons.

Additionally, you can copy and paste multiple comparisons between match processors.

1.2.20 DIR-12045: Multiple Attribute Handling in Data Type Converters

All five data type converters now support multiple attributes. Failure of conversion of one value (or for nulls if configured) results in a failure for that complete record.

1.2.21 DIR-13550: Ability to Filter Match Rules by Name

You can now filter all of the rules in a match processor across all the match groups by its name. This filtering change allows case-insensitive filtering of rules based on the rule name.

1.2.22 DIR-13648: Addition of Run Profiles to Director

You can now run a job in Director using a Run Profile (not a Run Label) and inspect all of the results that are produced.

1.2.23 DIR-13347: Extend Pattern Generation and Parse Tokenization of Reference Data to Full Unicode Range

Previously, the pattern generation and parse tokenization maps were limited to the latin range. This has been changed to extend them to the full Unicode range.

1.2.24 DIR-13549: Job Manager Enhancements

The Job Manager has been redesigned to implement numerous enhancements including:

- Ability to add notes to the Job Canvas

- Improved navigation of multiple phases

- Job Canvas can be used in design mode

- Job opening and progress feedback has been optimized

- Job Tool Palette now supports multiple selections

1.2.25 DIR-13650: Ability to Search Case Transitions

The ability to filter Cases and Alerts by allowable transitions has been added.

1.2.26 DIR-13651: Addition of Negate Option to Case Filter Criteria

The ability to use a Negate option when defining filters in Case Management was added.

1.2.27 DIR-13283, 10355, 10008: Improved Case Management Filtering and Reporting Performance

Use of the Lucene indexing has been furthered to produce greatly improved performance in Case Management when performing reports and filters on large data volumes.

After running a report and drilling down on a given value, clicking the Back to Report button no longer reruns. This is a result of the indexing performance improvements.

Previously, the number of results for a filter exceeded 100 the total number of results was not reported. The was changed so that the title bar now reports the total number of results, as well as how many are displayed.

1.2.28 DIR-13844: Ability to Configure and Automatically Start a Job with a Run Profile

You can now automatically configure and start a job that uses a Run Profile with the Autorun functionality.

1.2.29 DIR-10988: Ability to Search Case Management History

You can now search the Case Management history using filters to find Cases and Alerts that have ever been modified or commented on by a given user.

1.2.30 DIR-13594: Addition of Review and Match Group Limits

To avoid a Matching job running out of memory while trying to load review groups and match groups for output processing, reviewing and case generation limits have been added. By default, this limit is not enabled so that you can set the limit that works in your environment. When you enable the review group limit functionality, relationships are not be generated for any groups when the limit is reached.

1.2.31 DIR-12087, 13696: Improved Director Canvas

Previously, the selection within the Canvas Overview pane could only be moved by dragging the currently selected area, which made it difficult to use with large processes. This has been improved so that clicking anywhere within the Canvas Overview pane shifts the Canvas to that location.

The Maximize Canvas button functionality has been improved so that the Tool Palette is no longer closed when you maximize the Canvas.

1.2.32 DIR-12104: Addition of Case Management Case Source Duplicate Option

A duplicate option is now available on the Case Management Admin Case Sources list, which creates a new source based on the old one. It also copies any relevant display data though disposes of any historic display or metadata information for the source because it is now a new source.

1.2.33 DIR-10388: Addition of Attachment Table to System Information Data Store

The Attachments table has been added to the list of tables that can be queried in the System Information data store. For example, you could use this table selection to check which Cases have attachments or to report on which users are uploading attachments most frequently.

1.2.34 DIR-13552: Ability to Select Multiple Match Rules and Groups

The ability to select multiple match rules and groups has been added. This allows bulk reordering or deleting groups and viewing and editing the match rules from more than one group.

1.2.35 DIR-11158: Ability to Set Time to Midnight

A new configuration option, Set time to midnight?, has been added to the Add Current Date processor to control whether the processing time will be added to the record, or whether to always set the time to midnight.

2 Bugs Resolved

The following sections describe the bugs resolved in each release:

- Section 2.1, "Release 11g R1 (11.1.1.7.4)"

- Section 2.2, "Release 11g R1 (11.1.1.7.3)"

2.1 Release 11g R1 (11.1.1.7.4)

This section addresses Release 11g R1 (11.1.1.7.4).

2.1.1 Bug 18329095: Subversion Integration – Process Compare Not Showing Changes

When EDQ is integrated with Subversion, the functionality to compare a modified process in Director against a previous version never shows any changes.

The process comparison has been fixed. Changes in the process are now reported correctly when comparing against a different version.For example, the base or latest committed version.

2.1.2 Bug 18314849: Case Management Report Hanging When Aggregating on a Date Attribute with an Offset

Reports in Case Management that aggregated date values with an offset were not being calculated correctly, resulting in some reports that would 'hang' (never complete).

The offsets when reporting on aggregated Date values were fixed to work correctly.

2.1.3 Bug 18314314: Case Management Report Drill Downs Not Working with Null Values

When an attribute included in a Report view in Case Management contains a Null value, the cases or alerts are counted correctly in the report, but drilling down on the number does not take the user to the cases or alerts in question.

The drill down logic has been fixed to find cases or alerts with Null values when drilling down on a cell in a report.

2.1.4 Bug 18202212: Case Management Report Different After Upgrade from EDQ 9.0

In EDQ 9.0, a report that specified a Case Source and reported on workflow states would only show states valid for the workflow used by the case source. After upgrade, the report shows states in other workflows.

Reporting has been fixed to ensure that states for other workflows do not appear if a case source (and so a workflow) is selected.

2.1.5 Bug 18201908: EDQ Should be Deployed in 'NOSTAGE' Mode to Support Patching Using OPatch

EDQ is currently deployed in 'STAGE' mode which means that patches applied using OPatch do not take effect immediately.

EDQ is now deployed in 'NOSTAGE' mode.

2.1.6 Bug 18201594: Case Management Filter Execution Error Running Imported Filter Using Extended Attribute

An imported filter specifying the value of an Extended Attribute causes an error when searching for cases.

Filtering on Extended Attributes has been fixed.

2.1.7 Bug 18187489: Default deployment on WebLogic Server Should Disable Prepared Statement Cache

The default deployment of EDQ on WebLogic Server currently sets the prepared statement cache for all its Data Sources (including the connections to the EDQ repository databases) to a default value of 10. This is undesirable for performance reasons.

The default deployment of EDQ on WebLogic Server has been altered to disable the statement cache by default (by setting the value to 0).

2.1.8 Bug 18181291: Illegal Argument Exception in Dashboard Administration

Where multiple user sessions are open in Dashboard Administration it is possible for a user to encounter an illegal argument exception when making a change. The exception encountered is:

java.lang.IllegalArgumentException: Comparison method violates its general contract!'

The sorting of tree nodes in Dashboard Administration has been fixed to ensure that the exception does not occur.

2.1.9 Bug 18139626: Java Security Exception Launching EDQ Java WebStart Client Applications

From Java version 7, update 51, Java WebStart applications without JAR Manifest file attributes cannot be launched using the default security settings.

Manifest attributes have been added to allow the applications to launch with the default Java security setting.

2.1.10 Bug 18139586: Address Verification Version Check Incorrect

The Address Verification connector processor that ships with EDQ includes a check for a minimum version of the EDQ Address Verification API (Loqate) that failed to parse the version number correctly. Although no released versions of EDQ Address Verification include a version number that will wrongly trigger the failure of the version check, the check has been corrected to avoid any compatibility issues with future releases of EDQ Address Verification.

The version number check of the Address Verification processor has been modified to parse the Loqate version number correctly.

2.1.11 Bug 18069727: Error in Parse Processor After Java Upgrade

After upgrading to Java version 7 update 45 or later, processes with Parse processors with some types of Reclassification rules can trigger the following severe error:

runtime process terminated uncleanly: Comparison method violates its general contract!

The upgraded Java version performs tighter checks that comparators that are equal return an equal value. The Parse processor has been fixed such that this is always the case.

2.1.12 Bug 17998796: Application Error When Altering an Externalized Processor Option in a Compound Processor

When changing an externalized option in a member processor of a compound processor to 'New', the following application error occurs:

IllegalArgumentException: argument type mismatch

The check performed when an option is changed has been fixed to ensure this does not occur.

2.1.13 Bug 17959243: EDQ Data Source Connections in WebLogic Server Should Not Use Global Transactions for Performance Reasons

The default deployment of EDQ sets up the Data Sources in WebLogic Server that connect to the EDQ Repository Databases to use global transactions (global-transactions-protocol is set to 1). This is undesirable for performance reasons.

The default deployment of EDQ now sets up Data Sources with global transactions turned off.

2.1.14 Bug 17959001: Cases/Alerts Not Returning when Searching on Recently Modified Alerts Within a Time Range

Searches in Case Management looking for recently modified cases and alerts within a date/time range are not returning the correct results, due to the search indexes not being updated correctly

The search index commit process has been modified to ensure the correct results are returned.

2.1.15 Bug 17958421: EDQ WebLogic Configuration Wizard Showing Invalid Options for Database Configuration

The EDQ WebLogic Configuration Wizard, used to configure a WebLogic domain for EDQ, shows invalid options such as 'non-Oracle' and 'Oracle XA' when setting up database connections.

The configuration templates for EDQ have been modified to include the correct database.xml file to ensure that only valid and correctly named database options appear.

2.1.16 Bug 17949900: Exports Job Factory MBeans Have No Descriptions

The Job Factory and Results Set Export Job Factory mbeans do not have any descriptions, meaning they are effectively undocumented.

Descriptions have been added to the mbeans so that their use is clear in WebLogic Server or in other consoles connecting to the JMX interface.

2.1.17 Bug 17948633: Match Results Not Presented in Results Browser if Written Output Disabled

Match processors with written output (such as Match Groups or Merged Output) disabled run correctly but results are not visible in the Director Results Browser (unless or until the output is enabled).

The results catalog has been fixed to ensure that match results are visible in Director.

2.1.18 Bug 17934659: Case Management Not Generating Errors in Some Circumstances Where an Error Occurs During Case Creation

In certain circumstances, an error can occur during the case generation phase caused by an environment issue such as lack of file space or network connectivity though not caught, leading to an incomplete publication of cases and alerts.

The error handling during case generation has been improved to ensure that such errors are caught and to prevent partial case and alert publication.

2.1.19 Bug 17875325: Logs Flooded with Warning Messages with Aggressive Purge Policy

Where an aggressive results purge policy is configured, such as purging all results over an hour old, a busy server may generate huge numbers of warning messages where the purger is attempting to delete tables that are locked by running jobs.

Logging was changed not to log warning messages where the purger attempts to delete tables for running jobs.

2.1.20 Bug 17875035: Null Pointer Exception in Purger Leading to Redundant SEVERE Error in Log

As the purger runs as a standalone task, it is possible for it to attempt to delete tables owned by configuration objects (such as, staged data sets) that have since been deleted, with the tables deleted during that process. Where this occurs, a SEVERE error is logged, but the error is redundant.

The purger has been changed to check that the tables it is tasked to delete still exist.

2.1.21 Bug 17871347: Purge Rules Do Not Purge Data for Jobs That Write No Staged Data

Purge rules are not deleting internal results tables (such as, those used by Match processors) for jobs that are not configured to write any staged data at all. This can lead to unwanted growth of the results database when running jobs with many run labels.

The purge logic has been fixed to ensure that it removes tables for in-scope jobs even if no staged data sets were written.

2.1.22 Bug 17870822: JMS Trigger Diagnostics Should Show More Information

If an error occurs processing an AQ destination, a JMS exception occurs with important information displayed in linked exceptions. This is not being logged by the JMS trigger framework.

The JMS trigger framework logging output has been modified to include such exceptions.

2.1.23 Bug 17850011: WSDL Links Incorrect on Web Services Page when Using JRF Web Service Stack

EDQ on WebLogic Server can be configured to use the platform (JRF) web service stack. Where this is the case, the WSDL paths to the web services change to use a wss prefix rather than a webservices prefix. This change is not reflected on the Web Services page on the EDQ Launchpad.

The Web Services web page has been changed to determine the URLs correctly depending on the underlying stack.

2.1.24 Bug 17835359: Null Pointer Exception in Job Manager when Reordering Phases

A Null Pointer Exception can occur in the Job Manager when drag and drop is used to reorder phases, followed by adding a task.

The ability to reorder phases using drag and drop (rather than the buttons) has been removed in order to ensure this does not occur and also to avoid accidental phase reordering.

2.1.25 Bug 17811760: Cluster Skip Report Edge Case

If the number of records in a cluster exactly matches an absolute cluster size limit, comparisons are not performed though the cluster may be considered as 'processed' not skipped.

The logic for processing clusters was fixed to ensure it can never skip a group 1 record early.

2.1.26 Bug 17780878: Error Running Case Management premigrate Check During Upgrade

The 11.1.1.7.3 premigrate command in the migration.jar file, run in order to check that the Case Management data can be upgraded without issues, returns an Illegal Argument Exception.

The premigrate command has been fixed to run without error.

2.1.27 Bug 17770667: Provider and Consumer Links on the Web Services Page Do Not Work on WebLogic Server

The Provider and Consumer links under 'Available Operations' on the Web Services web page do not work on WebLogic Server.

The links have been fixed.

2.1.28 Bug 17740513: Null Pointer Exception Clicking on 'Get Service' with No Web Service Selected in Web Service Tester

Clicking the Get Service button in the Web Service Tester with no web service selected (using Select in the drop-down list) causes a Null Pointer Exception.

The Get Service button is no longer enabled unless a web service is selected.

2.1.29 Bug 17714503: Numbers of Cases and Alerts User Does Not Have Permission to View Included in Case Management Reports

In EDQ 11.1.1.7.3, reports of cases and alerts in Case Management include numbers of cases and alerts that the logged in user does not have permission to view. The user cannot drill down and view the cases or alerts and they should also not appear in reports or lists.

Permission restrictions have been built in to the reports.

2.1.30 Bug 17738506: Errors Running EDQ in Turkish Locale

The display case of data types ('String'/'Number'/'Date') in snapshot XML files and other places in EDQ is driven from the Java locale. In a Turkish locale, the case conversion leads to a problem defining configuration and capturing data.

The Java locale is no longer used for comparing table and file names.

2.1.31 Bug 17627126: Transporter Exception Encountered Logging into Server Console

After jobs are invoked from Director, it is possible for users to encounter a Transporter Exception when logging into Server Console due to errors in the promulgation of progress messages.

The progress reporter was fixed to ensure the error does not occur.

2.1.32 Bug 17626995: Null Pointer Exception in Match Review

In some circumstances, switching back to reviewing a group from reviewing its merged output causes a Null Pointer Exception in the client.

The Match Review UI was fixed to ensure there can be discrepancies between the expected and actual relationship table models.

2.1.33 Bug 17626429: Workaround Needed to Display EDQ Launchpad on an AIX/WebLogic Server Installation Using Java 7

An additional manual step (the addition of a file) is needed in order to install EDQ on an AIX/WebLogic server using Java 7 such that the EDQ Launchpad displays correctly.

The additional file is now installed by default meaning no additional steps are required.

2.1.34 Bug 17620765: Exception when Entering Certain Characters in the Job Manager Tool Palette Search Box

An Illegal State Exception occurs when entering a space, a letter, then a backspace in the Job Manager Tool Palette search box.

The Job Manager Tool Palette search facility has been fixed.

2.1.35 Bug 17614286: Null Pointer Exception in Case Management when Attempting to Save a Filter with Derived State or Source Id Set to 'None'

Attempting to save a filter with either Source Id or the Derived State attribute set to 'None' causes a Null Pointer Exception.

Case Management has been fixed to work correctly in these cases.

2.1.36 Bug 17580188: Reinstate the 'Refresh' Button in Case Management

The Refresh button in Case Management was removed in 11.1.1.7.3 because it did not work correctly in all instances.

The Refresh button has been reinstated and works correctly.

2.1.37 Bug 17447758: It Should Be Possible to Start an EDQ Managed Server in WebLogic Server Using a Start Managed Server Script Without Manual Steps

Starting an EDQ managed server without the node manager running does not work unless suitable memory and configuration settings are added to the environment configuration. In a default installation, the start Managed Server script should work with no need for additional steps.

The configuration template for EDQ was modified to include default settings in the setDomainEnv script that mean the start Managed Server script can be used. The Oracle Enterprise Data Quality Installation Guide Release 11g R1 (11.1.1.7) has been updated to include additional information about starting an EDQ managed server.

2.1.38 Bug 16961939: Null Pointer Exception Running a Match Publishing to Case Management and Running with Intelligent Execution Enabled After Upgrade to EDQ 11

After upgrading an older version of EDQ to version 11, a match processor configured to publish to Case Management that is run in a process with intelligent execution enabled may trigger a Null Pointer Exception when run.

Error handling has been improved so that if a user attempts to run such a job with Intelligent Execution enabled, an error message is generated to suggest disabling it. The documentation for EDQ 11g already states that jobs need to be run with intelligent execution disabled at least once in order to generate new results tables.

2.2 Release 11g R1 (11.1.1.7.3)

This section addresses Release 11g R1 (11.1.1.7.3).

2.2.1 BugDB # 13108707: Locked Resources Fail to Unlock After a Job Error Due to Missing Data Stores

When running a job in Director and any of the required data sources do not exist, the respective snapshots error as expected. However, the resources that were being used by the job are left in a locked state forcing a restart of your application server to reset the lock. The has been corrected so that when a job fails no resources are left locked.

2.2.2 BugDB # 13575513: If flags.xml Is Missing the EDQ Server Cannot Start

When the flags.xml file is missing from the oedq.home/casemanagement directory, a NullPointerException error occurred during startup and the EDQ Server does not complete initialization. If this is the case, a message is now displayed to alert you that the file is missing and the error is written to the server log file.

2.2.3 BugDB # 14323577: Inconsistent Results are Produced with Replacements

When there are duplicate entries by lookup key used for value replacements, the replacement used could vary between process runs. The has been corrected with changes implemented in the Replace and Replace All widget logic.

2.2.4 BugDB # 14541312: Filter Settings in Case Management

The Case Management user interface did not correctly refresh the Source Attributes section. The only occurred when switching between two data sources where an attribute existed in multiple data items (for example, Id.) The new source attribute selection model has removed the chance for this problem to occur.

2.2.5 BugDB # 16267112: Replace Exports to Oracle Databases Fail If the Table Is In a Different Schema

If an Oracle data source is created with a schema specified and an export using the primary key replace option is attempted on a table in the schema, the export fails even if the user has been granted DELETE privilege on the table. The has been corrected by adding privileges to the export.

2.2.6 BugDB # 16469508: CLASSCAST Exception Running Lookup and Return with Dates

When running a lookup and return with dates, an exception could occur. The has been corrected so that dates can be correctly used in a lookup and return process.

3 Known Issues and Workarounds

The following sections describe known issues and any workarounds that exist in the Release 11g R1 (11.1.1.7).

3.1 BugDB # 16961939 - Processes May Fail on First Run After Upgrade If Intelligent Execution Is Used

As EDQ 11 has fully refactored results tables, all process tasks in jobs that have previous results (upgraded from an old version of EDQ) must be run with Intelligent Execution turned off to generate new results tables in the correct format. Process tasks that run with Intelligent Execution turned on will generate an error. This does not affect any processes that do not have results generated from previous versions.

3.2 BugDB # 17508509: Errors May Occur When Selecting Rule Link for New Summaries in Dashboard

A link is still displayed to the publishing summary of a rule even if the user does not have permission to view that summary. An error is displayed when the user clicks on the link.

3.3 BugDB # 17516557: Dashboard Web Page Can Be Rendered Unresponsive When the Browser Back Button is Used

If you are using the Dashboard and you attempt to return to the previous page using your browser Back button, the Dashboard web page may become unresponsive. To correct, you close and restart your browser then restart the EDQ Dashboard.

3.4 BugDB # 17195131: Exception Inserting Multi-Byte Characters in Reference Data Editor with JDK 6u45

You may encounter an error attempting to insert multi-byte characters into the Reference Data editor in Director if you are running Java version 6 update 45. This bug has been resolved in later releases of Java.

3.5 BugDB # 17433120: Cannot Input Korean Characters in Output Attribute Prefix Text Box on Address Verification Processor

Korean characters cannot be input or pasted into the Output Attribute Prefix text box on the Options tab of the Address Verification processor.

3.6 BugDB # 17548242: Director Error May Occur When Selecting the Processor Option in Compound Processor

An error may occur in certain circumstances when you attempt to publish an option from a member processor of a 'compound' processor. This forces Director to close so you must restart it.

3.7 BugDB # 17554758: User Sessions Dialog Gradually Enlarges in Window 7 Using Internet Explorer 8

The User Sessions dialog gradually enlarges horizontally each time you select a record and may double in size if you select in excess of 100 records.

3.8 BugDB # 17193608: IME Not Always Disabled on Password Field

If you are running EDQ on a version of Java prior to 1.7 update 40, the Input Method Editors (IME) in Window was not always being disabled on the password field when logging into EDQ applications leading to login errors. This can be resolved by updating to Java 1.7 update 40.

3.9 BugDB # 17029960: Extended Attributes Displaying Percent % Character

Extended attributes in Case management are displaying a percent (%) character at the beginning of attribute names and not rendering the attribute correctly. You can correct this by copying the flags.xml and flags.properties files from your ...\oedq_home\casemanagement directory to your ...\oedq_local_home\casemanagement directory or by importing a case source.

3.10 BugDB # 17626429: Inability to Start EDQ Applications After Installing on AIX

If you are running an AIX and WebLogic environment using Java 7 (for example, an IBM JDK using Java 7 rather than Java 6), an additional post-installation step is needed after installing EDQ so that the product works correctly. For the specific post-installation step, see Oracle Enterprise Data Quality Installation Guide Release 11g R1 (11.1.1.7).

4 Upgrading Considerations

Earlier versions of EDQ can be upgraded to EDQ Release 11g R1 (11.1.1.7) using the instructions provided in the Oracle Enterprise Data Quality Installation Guide Release 11g R1 (11.1.1.7).

After upgrading to EDQ 11, make sure that all jobs that have existing results (in the upgraded EDQ results database) are run with Intelligent Execution turned off on all process tasks, in order to generate new results tables.

Process tasks that run with Intelligent Execution turned on will generate an error if results tables already exist.

Due to the fix for "BugDB # 14323577: Inconsistent Results are Produced with Replacements", EDQ Release 11g R1 (11.1.1.7) is less tolerant of Reference Data rows (or Staged or External Data rows used in a Lookup) that are duplicated by lookup key (on a case insensitive basis), and an error occurs when such rows are used in a Replace processor. The recommended solution to this error is to fix your data by deduplicating it. For example, you can run your data through a process in EDQ using the Group and Merge processor to remove any duplicates, and then repackage the Reference Data.

However, if you want to revert to the previous behavior in order to workaround the issue, it is possible to do so by adding the following line to director.properties:

replace.transform.allow.duplicate.key = true

5 Related Documents

For more information, see the following documents in the Oracle Enterprise Data Quality documentation set:

- Oracle Enterprise Data Quality Installation Guide Release 11g R1 (11.1.1.7)

- Oracle Enterprise Data Quality Architecture Guide Release 11g R1 (11.1.1.7)

See the latest version of this and all documents in the Oracle Enterprise Data Quality Documentation website at

http://download.oracle.com/docs/cd/E48549_01/index.htm

6 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle Enterprise Data Quality Release Notes, Release 11g R1 (11.1.1.7)

E49523-02

Copyright © 2013, 2014, 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 is software or related documentation that 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 America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware 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 that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware 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.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2014, Oracle and/or its affiliates. All rights reserved.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

License Restrictions Warranty/Consequential Damages Disclaimer

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.

Warranty Disclaimer

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.

Restricted Rights Notice

If this is software or related documentation that 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 END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware 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 that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Third-Party Content, Products, and Services Disclaimer

This software or hardware 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.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.