My Oracle Support Banner

OBIA 11g: Unique Constraint (<prefix>.W_DOMAIN_MEMBER_GS_U1) Violated From SIAFAStudentAidAttributePackagePlan (Doc ID 2618757.1)

Last updated on JANUARY 13, 2020

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 to 11.1.1.10.1 [Release 11g]
Information in this document applies to any platform.
PeopleSoft source

Symptoms


Doing a domain load and encountering: Unique constraint (<prefix>.W_DOMAIN_MEMBER_GS_U1) violated from SIAFAStudentAidAttributePackagePlan...

ODI Session log shows the errors:

ODI-1217: Session SDE_PSFT_90_ADAPTOR_SDE_PSFT_DOMAINGENERAL_SIAFASTUDENTAIDATTRIBUTEPACKAGEPLAN (1793686700) fails with return code 1.
ODI-1226: Step SDE_PSFT_DomainGeneral_SIAFAStudentAidAttributePackagePlan.W_DOMAIN_MEMBER_GS fails after 1 attempt(s).
ODI-1240: Flow SDE_PSFT_DomainGeneral_SIAFAStudentAidAttributePackagePlan.W_DOMAIN_MEMBER_GS fails while performing a Integration operation. This flow loads target table W_DOMAIN_MEMBER_GS.
ODI-1228: Task SDE_PSFT_DomainGeneral_SIAFAStudentAidAttributePackagePlan.W_DOMAIN_MEMBER_GS (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<prefix>.W_DOMAIN_MEMBER_GS_U1) violated
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
...

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
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.