Preface
Using Metadata Manager
- Using Metadata Manager Overview
  - Resource Types
- Metadata Manager Architecture
- Metadata Integration Process
- Working with Metadata Manager
- Metadata Manager Interface
  - Load Tab
  - Permissions Tab
Configuring Metadata Manager
- Configuring Metadata Manager Overview
- Step 1. Create and Configure the Metadata Manager Service
- Step 2. Install the Metadata Manager Agent
Application Resources
- SAP R/3 Resource Overview
- Configuring SAP R/3
- Creating an SAP R/3 Resource
  - SAP R/3 Configuration Properties
- Configuring the Component Inclusion List
- Reference
Business Glossary Resources
- Business Glossary Resources Overview
- Application Services Verification
- Creating a Business Glossary Resource
  - Business Glossary Connection Properties
- Business Glossary Objects Extracted
- Business Glossary Objects Not Extracted
Business Intelligence Resources
- Business Objects
- Cognos
- Microsoft Analysis and Reporting Services
- Microstrategy
- Oracle Business Intelligence Enterprise Edition
- Tableau
- Incremental Metadata Load
- Adding or Removing Metadata Files for a Resource
Custom Resources
- Configuring Custom Metadata Sources
- Creating a Custom Resource
- Configuring the Template Name
- Adding or Removing Metadata Files for a Resource
Data Integration Resources
- Informatica Platform Resources
- Microsoft SQL Server Integration Services Resources
- PowerCenter Resources
Data Modeling Resources
- Embarcadero ERStudio
- ERwin
- SAP PowerDesigner
- Adding or Removing Metadata Files for a Resource
- Reference for Data Modeling Resources
Database Management Resources
- Cloudera Navigator
- IBM DB2 for LUW
- IBM Db2 for z/OS
- IBM Informix
- JDBC
- Microsoft SQL Server
- Netezza
- Oracle
- Sybase ASE
- Teradata
- Configuring the Schema Inclusion List
- Data Lineage for Database Management Resources
  - Tables in Join Statements
  - SQL Inline Views
Universal Resources
- Universal Resources Overview
- Available Metadata Sources
- XConnect Creation
- Resource Creation
  - Step 1. Configure the Metadata Source
  - Step 2. Create the Resource
    - Metadata Extraction from a Source File
Managing Resources
- Managing Resources Overview
- Configure Connection Assignments
- Upload Rule Sets
  - Linking Rules Files
  - Uploading a Rule Set
- Purging Metadata
- Refreshing the Resources Panel
- Updating the Search Index
- Customizing the List of Words to Ignore in Searches
Loading and Monitoring Resources
- Loading and Monitoring Resources Overview
- Loading Resources
- Linking Objects Across Resources
- Monitoring Resources
- Logs and Log Files
- Troubleshooting Resource Loads
- Scheduling Resource Loads
Managing Permissions
- Managing Permissions Overview
- Configuring Permissions for Users and Groups
- Configuring Permissions on the Metadata Catalog
Resource Migration
- Resource Migration Overview
- Resource Migration Steps
- Step 1. Copy the Plug-in for a Universal XConnect
- Step 2. Migrate the Model
  - Exporting a Packaged or Universal Model
  - Importing a Packaged or Universal Model
- Step 3. Migrate the Resource Configuration
  - Exporting a Resource Configuration
  - Importing a Resource Configuration
- Step 4. Load the Resource
- Step 5. Migrate Resource Metadata
  - Exporting Resource Metadata
  - Importing Resource Metadata
Repository Migration
- Repository Migration Overview
- Migrating the Repository when Domain Names and Encryption Keys are the Same
- Migrating the Repository when Domain Names or Encryption Keys Differ
Appendix A: Metadata Manager Login
- Metadata Manager Login Overview
- Cookies
- Logging in to Metadata Manager
- Changing a Password
Appendix B: Metadata Manager Properties Files
- imm.properties
  - Metadata Manager Application Properties
  - Data Lineage Properties
- searchpriorities.xml
  - Search Result Configuration
  - Sample searchpriorities.xml File
Appendix C: Resource Configuration Files
- Resource Configuration Files Overview
- Resource Configuration File Format
- Passwords in Resource Configuration Files
- Secure JDBC Parameters in Resource Configuration Files
- Sample Resource Configuration File
Appendix D: Glossary
- Glossary of Terms

Metadata Manager Administrator Guide

10.5.7
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Troubleshooting Resource Loads

You can monitor a resource load run to determine whether it is successful. If a resource load fails, troubleshoot the failure and load the resource again.

I am trying to load a business intelligence or a data modeling resource, but the load fails because of inconsistencies in the model.: If the load fails because of inconsistencies in the model, perform one of the following actions:

Fix the inconsistencies in the model and reload the resources.
In the imm.properties file, change the
MitiValidationLevel
property value from basic to NONE. Restart the Metadata Manager Service and reload the resources.
I am trying to load a resource, but the load fails because Metadata Manager cannot find an IME file.: Check the value of the PowerCenter Integration Service Process property $PMSourceFileDir. Metadata Manager stores transformed metadata for packaged and universal resources in IME files in the
$PMRootDir/SrcFiles
directory. If the $PMSourceFileDir property is not set to
$PMRootDir/SrcFiles
, Metadata Manager cannot find the IME files.
When I try to load a PowerCenter resource where the PowerCenter repository type is IBM DB2, the load fails. I get the following error in the DB2CLI log file: "SQL0101N The statement is too long or complex.": Check the value of the DB2 statement heap size configuration parameter. Increase the STMTHEAP value up to 16,384 pages.
When I try to load a PowerCenter resource where the PowerCenter repository type is IBM DB2, the load fails with deadlocks on the DB2 database.: Check the values of the MAXLOCKS, LOCKLIST, and LOCKTIMEOUT DB2 configuration parameters.

Update the parameters as follows:

MAXLOCKS = 10 per application
LOCKLIST = 16,384 or greater
LOCKTIMEOUT = 60 or greater
When I load a Business Objects, Cognos, or OBIEE resource, Metadata Manager returns an out of memory error.: The Metadata Manager Agent can return this error if you extract a large amount of metadata from the metadata source. If you receive this error, perform either of the following actions:

Reduce the number of worker threads that the Metadata Manager Agent uses to extract metadata asynchronously from the metadata source. You can view and update the number of worker threads in the configuration properties when you create or edit a resource. If the number of worker threads is not set in the configuration properties, you can view the number of worker threads that the Metadata Manager Agent uses in the following log file:

<Metadata Manager Agent installation directory>\data\logs\logService\mimb<number>.log

Try to increase the maximum Java Virtual Machine (JVM) heap size that the Metadata Manger Agent can allocate. On 64-bit Windows, the Metadata Manager Agent can run a 64-bit JVM with a virtually unlimited maximum JVM heap size. On 32-bit Windows, configure multiple resources, each with a subset of the total models that you want to extract from the metadata source.
I am assigned the Load Resources privilege for the Metadata Manager Service, but I get an "insufficient privileges" error when I try to load Business Glossary resources.: To load Business Glossary resources, the Load Resource, Manage Resource, and View Model privileges are required. You also need write permission on any business glossary resource that you want to load.
When I load a Cloudera Navigator resource, Metadata Manager returns an out of memory error.: To load Cloudera Navigator resources, the maximum heap size for the Metadata Manager Service must be at least 4096 MB (4 GB). Some Cloudera distributions require an even larger heap size. To increase the maximum heap size, open the Administrator tool, select the Metadata Manager Service, and increase the value of the Max Heap Size
property.

Rename Saved Search

Table of Contents

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Troubleshooting Resource Loads

Troubleshooting Resource Loads