Current platform:
OS: Win 2003
RBPM: 3.6.1
DB: Oracle 11g R2

Upgrade to:
OS: Win 2008R2
RBPM: 4.0.1 (Advanced)
DB: Oracle 11g R2

When we're running the IDMUserApp.jar installer on the new server, the
database upgrade fails with the error:
23.apr.2012 08:00:35 liquibase.commandline.Main main
SEVERE: Error executing SQL ALTER TABLE AFACTIVITY ADD CONSTRAINT
FK_ACTIVITY_PROC FOREIGN KEY (REQUESTID) REFERENCES AFPROCESS(REQUESTID)
ON DELETE CASCADE
liquibase.exception.MigrationFailedException: Migration failed for
change set DbConstraints.xml::3600::IDMRBPM:
Reason: liquibase.exception.JDBCException: Error executing SQL
ALTER TABLE AFACTIVITY ADD CONSTRAINT FK_ACTIVITY_PROC FOREIGN KEY
(REQUESTID) REFERENCES AFPROCESS(REQUESTID) ON DELETE CASCADE:
Caused By: Error executing SQL ALTER TABLE AFACTIVITY ADD
CONSTRAINT FK_ACTIVITY_PROC FOREIGN KEY (REQUESTID) REFERENCES
AFPROCESS(REQUESTID) ON DELETE CASCADE:
Caused By: ORA-02298: cannot validate
(IDPORTAL.FK_ACTIVITY_PROC) - parent keys not found

I've read the posts on oracle forums about this error in general, but
don't feel like a manual cleanup should be needed for this task.
Any ideas on why this is happening?


--
seik
------------------------------------------------------------------------
seik's Profile: http://forums.novell.com/member.php?userid=45699
View this thread: http://forums.novell.com/showthread.php?t=454937