Troubleshooting
Problem
InfoSphere Data Quality Exception Console displays unexpected results in the Search and Exception Set panes if the exception set index is outdated (out of sync with exception sets) or corrupted.
Symptom
Unexpected results are displayed in the faceted search results and Exception Sets grid in InfoSphere Data Quality Exception Console.
Cause
The index is not successfully updated when exception sets were added, updated, or deleted. This might occur under the following circumstances:
- The metadata repository was down or offline while the index was being updated.
- The file system ran out of space while index was being updated.
- System errors occurred.
Diagnosing The Problem
- Unexpected results are displayed in the faceted search results and Exception Sets grid in InfoSphere Data Quality Exception Console.
- Server log files contain error messages or stack traces that indicate search failures.
Resolving The Problem
Rebuilding the index
Follow the steps listed below to rebuild exception set index by using the reindex REST API method for the InfoSphere Data Quality Exception Console:
1. Close all browser instances.
2. Open a new browser.
3. Enter the URL that corresponds tor the eindex REST API method for the InfoSphere Data Quality Exception Console in the following format:
https://<server>:<port>/ibm/iis/dqec/rest/reindex.
For example. if the server is local ("localhost") and the port is 9443, then the "reindex" URL will be:
4. Enter your user credentials for a user that has the Exception Management Administrator role.
Note: If the user doesn’t have the proper role, the following error message is displayed:
“The user was not authorized to perform the requested operation.”
4) When the re-indexing is finished, the following message is displayed:
"Successfully re-indexed all exception sets.”
5) Close the browser to log out.
Clearing the index data
If the re-index fails to complete, follow these steps to clear the index data:
1. Shutdown InfoSphere Information Server.
2. Manually clear the index by deleting all files and folders in the index “data” folder,
Note: The index data folder is different from the data folder. Be sure to delete only the files and subfolders in the index data folder:
WebSphere Application Server Liberty profile:
<install folder>\ASBServer\bin\EMC\emc_solr\emc\data
3) Restart IBM InfoSphere Information Server.
4) Repeat the steps to rebuild the index.
[{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m0z0000001gJcAAI","label":"DQEC - Data Quality Exception Console"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.3.1;11.5.0;11.7.0;11.7.1;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
29 April 2021
UID
swg21691829