My Oracle Support Banner

java.lang.Exception: java.lang.Exception: Cannot import as Run has dependencies on PR2_RUN_EXECUTION_B table, while importing RUN (Doc ID 2522105.1)

Last updated on NOVEMBER 06, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.

Symptoms

While migrating a Run using command line utility getting below error in FUSIONSUBSYSTEMSService.log.

ERROR
-----------------------
04-07-18 04:48:22,052 AM]~[DEBUG]~[OFSAAPreparedStatementDecorator]~[logAndExecuteQuery]~Query -> SELECT PREB.V_RUN_ID FROM PR2_RUN_EXECUTION_B PREB WHERE NOT EXISTS (SELECT V_RUN_ID FROM PR2_RUN_B PRB WHERE PRB.V_RUN_ID = PREB.V_RUN_ID and PRB.V_INFODOM_NAME = PREB.V_INFODOM_NAME)
Time taken for query execution -> 13 milliseconds.
showMsg...[RunImport] Unable to enable FK constraint on PR2_RUN_EXECUTION_B due to dependency on following Run Id's: 1527238368312 1527238368312 1527238368312 1527238368312 1527238368312 1527238368312 1527238368312
showMsg...[RunImport] Cannot overwrite the following Runs due to dependency. Please try after resaving with different Run Name. 1527238368312 1527238368312 1527238368312 1527238368312 1527238368312 1527238368312 1527238368312
showMsg...[RunImport] Exception in executeRuns
showMsg...[RunImport] Exception When importing Runs
showMsg...java.lang.Exception: java.lang.Exception: Cannot import as Run has dependencies on PR2_RUN_EXECUTION_B table
 

 

Changes

 Run name is same in both source and target environment.

 

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


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