Preface
Introduction
- Data Archive Overview
  - Features
  - Benefits
- Data Archive Use Cases
Accessing Data Archive
- Data Archive URL
- Log In and Out of Data Archive
- Update User Profile
Working with Data Archive
- Data Archive Editions
- Organization of Menus
- Predefined List of Values (LOVs)
- Online Help
Scheduling Jobs
- Scheduling Jobs Overview
- Standalone Jobs
- Scheduling Jobs
- Job Logs
  - Delete From Source Step Log
- Monitoring Jobs
- Pausing Jobs
  - Delete From Source Step
- Searching Jobs
  - Quick Search
  - Advanced Search
Viewing the Dashboard
- Viewing the Dashboard Overview
- Scheduling a Job for DGA_DATA_COLLECTION
Creating Data Archive Projects
- Setting Up Data Archive Projects
- Viewing and Editing Data Archive Projects
- Running the Data Vault Loader Job
  - Run the Data Vault Loader Job
  - Troubleshooting Data Vault Loader
- Troubleshooting Data Archive Projects
Salesforce Archiving
- Salesforce Archiving Overview
  - Salesforce Archiving Process
- Step 1. Install the Salesforce Accelerator
- Step 2. Configure Salesforce Permissions
- Step 3. Import Salesforce Metadata and Configure Entities
- Step 4. Create a Salesforce Source Connection
- Step 5. Create the Salesforce Archive Project
- Refresh Schema for Salesforce Standalone Job
- Salesforce Limitations
SAP Application Retirement
- SAP Application Retirement Overview
- SAP Application Retirement Process
- SAP Smart Retirement
  - Running the SAP Smart Retirement Standalone Job
- Retirement Job
- Attachment Retirement
  - Attachment Storage
  - Attachment Viewing
- Data Visualization Reports
- Troubleshooting SAP Application Retirement
  - Message Format
  - Frequently Asked Questions
Creating Retirement Archive Projects
- Creating Retirement Archive Projects Overview
- Identifying Retirement Application
- Defining a Source Connection
- Defining a Target Repository
  - Adding Entities
  - Defining Retention and Access
  - Review and Approve
  - Confirming Retirement Run
  - Copying a Retirement Project
- Application Migration
- Application Migration Process
- Source (Pre-Production) Environment Tasks
  - Step 1. Add the Migration Administrator Role
  - Step 2. Run the Export Informatica Data Vault Metadata Job
  - Step 3. Create a Target Connection
  - Step 4. Run the Migrate Data Archive Metadata Job
- Target (Production) Environment Tasks
  - Prerequisites
  - Step 1. Add the Migration Administrator Role
  - Step 2. Update the Data Vault Connection
  - Step 3. Move the .Tar and SCT Data Files
  - Step 4. Update the ssa.ini File
  - Step 5. Run the Import Informatica Data Vault Metadata Job
  - Step 6. Recreate Indexes
- Report Migration
- Migrating Published Resources
- Step 1. Download the Reports and Catalog from the Source
- Step 2. Edit the Catalog Connection Details
- Step 3. Edit the Catalog Table Section
- Step 4. Edit the Schema Name in Imported SQLs
- Step 5. Rename the Existing Catalog
- Step 6. Create a Report Folder and Publish
- Step 7. Run a Migrated Report from Data Archive
- Migrating Real Path Resources
- Step 1. Download the Reports and Catalog
- Step 2. Edit the Catalog Connection Details
- Step 3. Create a Report Folder and Publish
- Step 4. Create a Report Folder in the Target File System
- Step 5. Copy the Reports and Catalog from the Source to Target Systems
- Step 6. Map the Folder to the Target File System
- Step 7. Select the Migrated Target Connection in the Patient Archives
- Troubleshooting Retirement Archive Projects
Integrated Validation for Archive and Retirement Projects
- Integrated Validation Overview
- Integrated Validation Process
- Row Checksum
- Column Checksum
- Validation Review
  - Validation Review User Interface
  - Validation Report Elements
- Enabling Integrated Validation for a Retirement Project
- Enabling Integrated Validation for an Archive Project
- Reviewing the Validation
- Running the Validation Report
- Integrated Validation Standalone Job
  - Running the Integrated Validation Standalone Job
Retention Management
- Retention Management Overview
- Retention Management Process
- Retention Management Example
- Retention Policies
- Retention Policy Changes
- Purge Expired Records Job
  - Purge Expired Records Job Parameters
  - Running the Purge Expired Records Job
- Retention Management Reports
- Retention Management when Archiving to EMC Centera
External Attachments
- External Attachments Overview
- Archive External Attachments to a Database
- Archive or Retire External Attachments to the Data Vault
Data Archive Restore
- Data Archive Restore Overview
- Restore Methods
- Data Vault Restore
- Data Vault Restore to an Empty Database or Database Archive
  - Restoring to an Empty Database or Database Archive
- Data Vault Restore to an Existing Production Database
- Database Archive Restore
- External Attachments Restore
  - External Attachments from the Data Vault
  - External Attachments from a Database Archive
Data Discovery Portal
- Data Discovery Portal Overview
- Search Data Vault
  - Examples of Search Queries
  - Searching Across Applications in Data Vault
- Search Within an Entity in Data Vault
- Browse Data
- Legal Hold
- Tags
- Troubleshooting the Data Discovery Portal
Data Visualization
- Data Visualization Overview
- Data Visualization User Interface
- Data Visualization Process
- Report Creation
- Report Permissions
- Assigning a User or Access Role to a Report
- Editing Report Permissions for a User or Access Role
- Deleting a User or Access Role From a Report
- Assigning Permissions for Multiple Reports
- Deleting Permissions for Multiple Reports
- Running and Exporting a Report
- Deleting a Report
- Copying Reports
  - Copying SAP Application Retirement Reports
- Troubleshooting
- Designer Application
Oracle E-Business Suite Retirement Reports
- Retirement Reports Overview
- Prerequisites
- Accounts Receivable Reports
- Accounts Payable Reports
- Purchasing Reports
  - Purchase Order Details Report
    - Report Parameters
    - Report Tables and Views
- General Ledger Reports
  - Chart of Accounts - Detail Listing Report
    - Report Parameters
    - Report Tables and Views
  - Journal Batch Summary Report
    - Report Parameters
    - Report Tables and Views
- Saving the Reports to the Archive Folder
- Running a Report
JD Edwards Enterprise Retirement Reports
- Retirement Reports Overview
- Prerequisites
- Accounts Payable Reports
- Procurement Management Reports
- General Accounting Reports
- Accounts Receivable Reports
- Sales Order Management Reports
- Inventory Reports
  - Item Master Directory Report
    - Report Parameters
    - Report Tables
- Address Book Reports
  - One Line Per Address Report
    - Report Parameters
    - Report Tables
- Saving the Reports to the Archive Folder
- Running a Report
Oracle PeopleSoft Applications Retirement Reports
- Retirement Reports Overview
- Prerequisites
- Accounts Payable Reports
- Purchase Order Reports
- Accounts Receivable Reports
- General Ledger Reports
- Saving the Reports to the Archive Folder
- Running a Report
Smart Partitioning
- Smart Partitioning Overview
- Smart Partitioning Process
- Smart Partitioning Example
Smart Partitioning Data Classifications
- Smart Partitioning Data Classifications Overview
- Single-dimensional Data Classification
- Multidimensional Data Classification
- Dimension Slices
  - Time Dimension Formulas
- Creating a Data Classification
- Creating a Dimension Slice
Smart Partitioning Segmentation Policies
- Smart Partitioning Segmentation Policies Overview
- Segmentation Policy Process
- Segmentation Policy Properties
- Creating a Segmentation Policy
- Business Rule Analysis Reports
  - Creating a Business Rule Analysis Report
- Segment Creation for Implemented Segmentation Policies
- Segment Management
- Segment Sets
  - Creating a Segment Set
Smart Partitioning Access Policies
- Smart Partitioning Access Policies Overview
- Default Access Policy
- Oracle E-Business Suite User Access Policy
- PeopleSoft User Access Policy
- Database User Access Policy
- OS User Access Policy
- Program Access Policy
- Access Policy Properties
- Creating an Access Policy
Language Settings
- Language Settings Overview
- Changing Browser Language Settings
Appendix A: Data Vault Datatype Conversion
- Data Vault Datatype Conversion Overview
- Data Vault
- Datatype Conversion Errors
  - Converting Datatypes for Unsupported Datatype Errors
  - Converting Datatypes for Conversion Errors
Appendix B: Special Characters in Data Vault
- Special Characters in Data Vault
  - Supported Special Characters
Appendix C: SAP Application Retirement Supported HR Clusters
- SAP Application Retirement Supported HR Clusters Overview
- PCL1 Cluster IDs
- PCL2 Cluster IDs
- PCL3 Cluster IDs
- PCL4 Cluster IDs
- PCL5 Cluster IDs
Appendix D: Glossary
- access policy
- administrator
- application
- application module
- application version
- archive
- archive action
- archive (Database)
- archive definition
- archive engine
- archive (File)
- archive project
- business rule
- business table
- column level retention
- custom object
- dashboard
- Data Archive
- Data Archive metadata
- data classification
- data destination
- Data Model Metadata
- Data Privacy
- data source
- Data Subset
- data target
- Data Vault access role
- de-referencing
- dimension
- dimension rule
- dimension slice
- entity
- ERP application
- expiration date
- expression-based retention
- formula
- general retention
- history database
- home database
- interim
- job
- metadata
- production database
- restore (Cycle)
- restore (Full)
- restore (Transaction)
- retention management
- retention policy
- security group
- segment
- segment set
- segmentation group
- segmentation policy
- smart partitioning
- staging schema
- standard object
- system-defined role
- system profile
- transaction data
- translation column
- user
- user profile

User Guide

6.4.4
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Frequently Asked Questions

The following list explains how to troubleshoot and resolve issues that might occur during the SAP application retirement process.

When I run the retirement job, the job immediately completes with an error.

The job log includes the following message:

java.lang.NoClassDefFoundError: com/sap/mw/jco/IMetaData

The error occurs because the

sapjaco.jar

file is missing in the ILM application server. Verify that the SAP Java Connector installation is correct.

Perform the following steps to verify the SAP Java Connector installation:

From the command line, navigate to the following directory:

<Data Archive installation>/webapp/WEB-INF/lib

Enter the following command:

java –jar sapjco.jar

If the installation is correct, you see the path to the SAP Java Connector library file, such as

C:\SAPJCO\sapjcorfc.dll

If the installation is not correct, you see a

Library Not Found

message in the path for to the SAP Java Connector library file.

If the installation is not correct, perform the following steps to resolve the error:

Verify that you installed the SAP Java Connector.

Copy the

sapjaco.jar

file from the root directory of the SAP Java Connector installation and paste to the following directory:

<Data Archive installation>/webapp/WEB-INF/lib

Restart the ILM application server.

When I run the retirement job, I receive an error that the maximum value was exceeded for no results from the SAP system.

For every package of rows that the job processes, the job waits for a response from the SAP system. The job uses the response time configured in the

conf.properties

file and the package size specified in the job parameters. If the SAP system does not respond within the configured maximum response time, the job fails.

The SAP system may not respond for one or more of the following reasons:

The maximum amount of SAP memory was exceeded. The SAP system terminated the process. The SAP system may run out of memory because the package size that is configured in the job is too high.

The SAP system takes a long time to read the data from the database because of the configured package size.

The network latency is high.

To resolve the error, in the SAP system, use transaction

SM50

to verify if the process is still running. If the process is still running, then restart the job in Data Archive.

If the process is not running, perform one or more of the following tasks:

Use SAP transactions

SM37

ST22

, and

SM21

to analyze the logs.

Decrease the package size in the job parameters.

Increase the

informia.MaxNoResultsIteration

parameter in the

conf.properties

file.

The job log indicates that the Data Vault Loader received an exception due to an early end of buffer and the load was aborted.: The error may occur because the SAP application is hosted on Windows.

Perform the following steps to resolve the error:
Configure the
informia.isSAPOnWindows
property to
Y
in the
conf.properties
file.
Reboot the ILM application server.
Create a new retirement project.

Rename Saved Search

Table of Contents

User Guide

User Guide

Frequently Asked Questions

Frequently Asked Questions