UpdateIntegrationEvent XML API Throws Error "ORA-02291: integrity constraint (ASAP.PFXFK_GA_EV_NO__SE_RE_GA_EV) violated - parent key not found" (Doc ID 1965953.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

UpdateIntegrationEvent XML API Throws following Error when event notes tag is passed in the XML structure with preference "Allow to Maintain Gateway Event Notes" set As "Y"

Message: The server encountered the following Exception: IntegrationEventManager::Error in setEventDetail - Unable to retrieve table: IntegrationEventManager::SQL Error in InsertGatewayEventNotes - ORA-02291: integrity constraint (ASAP.PFXFK_GA_EV_NO__SE_RE_GA_EV) violated - parent key not found.Error

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