My Oracle Support Banner

Previously Working Object Migration Failing With OAuth Configuration Not Found HTTP Error Code: 401 (Doc ID 2668464.1)

Last updated on MAY 13, 2020

Applies to:

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

Symptoms

On 8.0.7.2, user ran object migration via Object Administration -> Object Migration -> Export Objects. This process works before but now fails to create DMP file and error is shown in the migration log as below.

Error:

Query Parmeters as provided -> VALIDATE_CERTIFICATE
Time taken for query execution -> 10 milliseconds.
serviceAccount fetched from Configuration : SYSADMN
[ERROR]~[NA] [NA] OAuth configuration not found.
[DEBUG]~[NA] [NA] Configuration connection has been requested.
[DEBUG]~[NA] [NA] DB connection has been requested for DBName: CONFIG
..etc
[DEBUG]~[NA] [NA] Configuration connection fetched successfully.
Transaction Status {"MESSAGE":"Exception has occured","STATUS":"Transaction failed"}
Exception occured java.lang.RuntimeException: Failed : HTTP error code : 401
 

Steps:
1. Navigate to Object Administration -> Object Migration -> Export Objects and ran any object migration and the process failed.
    This process works before, now it is failing for all objects.
2. Checked the exclude list of URLs and they are still in place.
3. Recently korn shell (ksh) was upgraded as below. 
    ksh --version
    version sh (AT&T Research) 93u+ 2012-08-01
    Linux team created softlink for lst to ensure it is working.
4. Ran the migration via script as below and the migration log is showing the same above error, no additional error on console.

    ./ObjectMigration_UI.sh "<INFODOM>_OFFLINE_OBJECT_MIGRATION_20200507_1" "RUN EXECUTABLE" "TASK1" "20200506" "<INFODOM>" "EDW" "<HOST>"



Changes

Password for SYSADMN was recently changed.

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
References


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