Oracle Utilities Analytics (OUA) 2.5.1.1.1 Install Issue (Doc ID 2037328.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.5.1.1.0 to 2.5.1.1.0 [Release 2.5]
Information in this document applies to any platform.

Goal

When running deployodi.sh, as part of the OUA 2.5.1.1.1 install, the following error occurs:

Jul 7, 2015 2:52:37 PM com.sunopsis.dwg.dbobj.SnpSession treatSession
SEVERE: Session B1_ODI_IMPORT_XML (1561602) fails with return code 7000.
ODI-1226: Step Import XML fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: com.sunopsis.core.SnpsDuplicateAKException: ODI-10212: Parent object SNP_PROJECT: 'Oracle Utilities BI' already has child SNP_SCEN: 'B1_F_BILLED_USAGE_VW 001'.
Technical details: SNP_SCEN : 'B1_F_BILLED_USAGE_VW 001' violates alternate key constraint AK_SNP_SCEN (SCEN_NAME,SCEN_VERSION) for values (B1_F_BILLED_USAGE_VW,001)

 

Solution

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