OFSAA Missing New Tables, Views, or Columns or [2623] Operation at server failed [3124] Error while processing request Error When Choosing Entities in T2T Screen
(Doc ID 1348564.1)
Last updated on AUGUST 12, 2024
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.8 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Data Mapping
Table to Table (T2T)
Data Management Tools (DMT)
Symptoms
On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI), when attempting to choose a _V view from the Data Integrator, Choose entity screen the FSI_AMORTIZATION_TYPE_MLS_V does not appear in the list.
The following error may appear on the screen:
ERROR
[2623] Operation at server failed. [3124] Error while processing request
In addition, there may be errors in the Web Server ETLService.log like the following:
[ETLLOG] Oct 25,18 12:18:11 : [CLSUETLEXTRACTIONROUTER]Fetching column details for...ASSET_PFT_BI_COLUMNS
[ETLLOG] Oct 25,18 12:18:11 : [CLSUETLENTITYSOURCE]Table passed is::ASSET_PFT_BI_COLUMNS
[ETLLOG] Oct 25,18 12:18:14 : [CLSUETLENTITYSOURCE]Error in fetching source model .
[ETLLOG] Oct 25,18 12:18:14 : [CLSUETLEXTRACTIONROUTER]asdfad34[S][ETL.UTIL.ERR_PROCN_REQ]en_US
[ETLLOG] Oct 25,18 12:18:14 : [CLSUETLENTITYSOURCE]Reason :[3124] Error while processing request
[ETLLOG] Oct 25,18 12:18:14 : [CLSUETLEXTRACTIONROUTER]asdfad34[S][ETL.UTIL.ERR_PROCN_REQ]en_US
EXPECTED BEHAVIOR
Expect to see all views and tables and columns in the source Atomic schema to appear.
1. Unified Metadata Manager -> Data Integrator Framework -> Warehouse Designer -> Database Extract
2. Open a seeded Staging T2T extract
3. Click Edit
4. Click Choose Entity
5. Scroll through the list
Changes
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 |
Changes |
Cause |
Solution |
OFSAAI 7.2 / 7.3 versions: |
OFSAAI 7.3.3.x - 7.3.5.x versions: |
OFSAAI 8.0 - 8.0.5 versions: |
OFSAAI 8.0.6+ versions: |