Problem:

[INTERNAL] After upgrading from TM ART Central 3.0 to 3.6 why do I encounter the error ORA-02291: integrity constraint (TM_ART.FK_SV_TSD_SV_TIMESERIES) violated - parent key not found ORA-06512 and how can I resolve this?

Resolution:

If you have recently upgraded to BMC TM ART Central 3.6 and you encounter the following error message in the ApplicaitonServer.log file

Error OV 2008-11-06 13:25:38 CENTRAL ProjectResultWriterThread-20 java.sql.BatchUpdateException: ORA-02291: integrity constraint (TM_ART.FK_SV_TSD_SV_TIMESERIES) violated - parent key not found ORA-06512: at line 1 at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294) at com.segue.scc.util.jdbc.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:215) at com.segue.vision.entities.ProjectHealthCache.flushToDatabase(ProjectHealthCache.java:150) at com.segue.vision.entities.ProjectHealthCache.flushDirty(ProjectHealthCache.java:99) at com.segue.vision.appserver.result.ProjectResultWriterThread.run(ProjectResultWriterThread.java:97)

Then this is an indication that “Measure head records” have been lost in the TM ART DB. This issue has been known to occur after Borland development provided a patch to the BMC Customer CAT to improve the upgrade process from TM ART Central 3.0 to TM ART Central 3.6. The error can be resolved by installing the patch “PATXZ.3.6.00.C14.zip” which re-creates lost Measure head records in the 3.6 database.