DIH Target Datastore Refresh Hangs at Getting Master Rep Info (Doc ID 2231299.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.2 and later
Oracle Financial Services Asset Liability Management - Version 8.0.2 and later
Oracle Financial Services Profitability Management - Version 8.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.2 version, User Interface

When attempting to Refresh Target Datastore for DIH connector, the process hangs.

Error:
DIH.log from webserver location shows:

[20-01-17 16:07:56 PM] ~ INFO ~ DIHLOGGER ~ [TestADIRefresh][testAdiRefresh]<NOTE>--ADI committed. Proceeding to UDP mapping.
[20-01-17 16:08:38 PM] ~ INFO ~ DIHLOGGER ~ [LoadAdiList][loadAppAdiListMap]Number of ADIs - [208]
[20-01-17 16:08:39 PM] ~ INFO ~ DIHLOGGER ~ [TestADIRefresh][testAdiRefresh]<NOTE>--ADI Refresh has been completed at: 2017/01/20 16:08:39 . Total Time taken - [212] seconds
[20-01-17 16:08:39 PM] ~ INFO ~ DIHLOGGER ~ [RegisterAction][testAdiRefresh]<SUCCESS>--ADI Refresh was successful
[20-01-17 18:09:57 PM] ~ INFO ~ DIHLOGGER ~ [RegisterAction][publishTargetDataStores]Staring publish of Target Data Store
20-01-17 18:09:57 PM] ~ INFO ~ DIHLOGGER ~ [DataEntity][getDataEntities]Getting details for DataEntity -> [deId=200041, deCode=STG_RETENTION_OFFER_MASTER, dsId=200040, type=I, deDesc=STG_RETENTION_OFFER_MASTER]

...etc

end with below:
[20-01-17 18:10:35 PM] ~ INFO ~ DIHLOGGER ~ [DataEntity][getDataEntities]Getting details for DataEntity -> [deId=200296, deCode=STG_REPO_CONTRACTS, dsId=200040, type=I, deDesc=STG_REPO_CONTRACTS]
[20-01-17 18:10:36 PM] ~ INFO ~ DIHLOGGER ~ [OdiInstanceBuilder][getInstance]ODI COnnection details - SourceSettings [id=200020, odiUser=USER, odiPassword=xxxx, masRepDBUser=ODI_REPO, masRepDBDriver=oracle.jdbc.OracleDriver, masDBConn=jdbc:oracle:thin:@XXXXX:1521:orcl, workRep=WORKREP12, proj=DIH, folder=DIH, stageName=DIH, infoDBConn=jdbc:oracle:thin:@XXXXX:1521:orcl, infoUser=OFSAAATM, agentUrl=http://XXXXX:XXXX/oraclediagent]
[20-01-17 18:10:36 PM] ~ INFO ~ DIHLOGGER ~ [OdiInstanceBuilder][getInstance]getting master rep info


Steps:
1. ADI Refresh is successful.
2. Refresh Target Datastore hangs.
3. Setup Connector as below and when attempted to publish it hangs.
      ADI Definition: TEST_COUNTRY_CONN
      Insert Data on Staging
      Application: Profitability Management
      External Data Stores: TEST_STG_COUNTRY_MASTER
      Source: TEST_STG_COUNTRY_EDD
      Target: Country Master
      Mapping: Country Identifier, Country Name, Extraction Date

      Properties:
      Loading mechanism: SQLLDR
      ODI Folder: DIH
      Target Dump: /target/tmp
      Source Dump Location: /srv/tmp

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms