My Oracle Support Banner

ETL Exception While Copying Definition Error Attempting to Save T2T Extract (Doc ID 1621942.1)

Last updated on MAY 07, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On OFSAAI 7.3.2.2 when attempting to copy a T2T extract, the following error is thrown:

ERROR
ETL Exception while copying definition



The ETLService.log in the deployed Web Server directory shows the following error:

[ETLLOG] Feb 6,14 11:20:39 : [CLSUETLEXTRACTIONROUTER]COPY DEFINITION :: ETLAPLDW.ETLSRCDW.T2T_CASA << TO >> ETLAPLDW.ETLSRCDW.T2T_DEPOSITS
[ETLLOG] Feb 6,14 11:20:39 : [CLSUBNDUTILEXTRACTION]Copy Definition :ETLAPLDW|ETLSRCDW|T2T_CASA|ETLAPLDW|ETLSRCDW|T2T_DEPOSITS
[ETLLOG] Feb 6,14 11:20:39 : [NONE][ClsUBndUtilExtraction]:Exception while copying definition

Steps to reproduce

The issue can be reproduced at will with the following steps:

1. Unified Metadata Manager -> Data Integrator Framework -> Warehouse Designer -> Database Extracts:
2. Choose any extract
3. Right-Click and "Save As"
4. "[15246] Definition is copied. please do save the Definition"
5. Click on "OK"
6. Change the "Extract Name"
7. Attempt to save, error message appears:

ETL Exception while copying definition

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.