My Oracle Support Banner

Data Selection Tool Migration Error; ORA-02292 (ASAP.FK_PPTS_PROV_PLAN_TASK_REL) (Doc ID 740171.1)

Last updated on JUNE 26, 2012

Applies to:

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

Symptoms

When a user attempts to Migrate a Provisioning Plan from one database instance to another using the Data Selection Tool, an integrity constraint error occurs.  Below are the messages received:

WARNING message in the GUI
-------------------------------------

Warning! A plan with the same name, Organization, Jurisdiction, and Service Type Group
already exists in the Target Database.

Are you sure you want to Overwrite it?




ERROR in the GUI
--------------------

Target Database Error during Migration Process. All changes for this operation will be cancelled.




ERROR in the Plan Migration Log
-----------------------------------

Error occurred, Migration Aborted!

ORA-02292: integrity constraint (ASAP.FK_PPTS_PROV_PLAN_TASK_REL) violated



STEPS


The issue can be reproduced at will with the following steps:


1. Using 6.0.13, copy a Provisioning Plan from a source database to a target database


BUSINESS IMPACT


Due to this issue, the Provisioning Plans cannot be copied from one database to another. The business will have to manually enter the Provisioning Plans in all instances.

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.