AnsweredAssumed Answered

12.0.6 to 12.1 SP1 upgrade

Question asked by ArunMohan on Oct 19, 2011
Latest reply on Nov 23, 2011 by another_martink
Hello Team,

We are in the process of upgrading our dev environment from 12.0.6 to 12.1.SP1. The "AddMissingTaskODFCAConstraint" step in preupgrade is processing for more than 2 hours and still it is running. When we checked in the DB we found that it is processing the below query

INSERT INTO odf_ca_constraint

(ID, created_by, created_date, last_updated_by, last_updated_date,

partition_code)

SELECT prc.prid, :v0, :v1, :v2, :v3, c.partition_code

FROM prconstraint prc, prtask t, inv_projects p, odf_ca_project c

WHERE p.prid = c.ID

AND p.prid = t.prprojectid

AND t.prid = prc.prtaskid

AND prc.prid NOT IN (SELECT ID

FROM odf_ca_constraint)

But when we checked the odf_ca_constraint table no records got inserted for today date.

select count(1) from odf_ca_constraint where last_updated_date=trunc(sysdate).


When running the below query

SELECT *

FROM prconstraint prc, prtask t, inv_projects p, odf_ca_project c

WHERE p.prid = c.ID

AND p.prid = t.prprojectid

AND t.prid = prc.prtaskid

AND prc.prid NOT IN (SELECT ID

FROM odf_ca_constraint)

in the DB the query is running for almost half an hour and still running.


Any suggestions?

Thanks,

Arun.

Outcomes