jgille

Changing Partitions on Attributes

Discussion created by jgille on Jun 17, 2010
Latest reply on Jun 21, 2010 by Chris_Hackett
We have partitioned the Project Object and have several attributes that are only available to one partition. When I try to change the partition on one of them to allow other partitions to use it I start getting some weird behavior. The attribute never shows up to add to a view and when I try to change the name of the attribute in the new partition, I get an error in the log saying that

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("CLARITY"."CMN_CAPTIONS_NLS"."PK_ID")

We're still on 12.0.4. Just wondering if others have seen this issue at all, or if it's a known defect in 12.0.4.

Our dev environment is on 12.0.6 and I'm not getting this same problem, but we have other outstanding issues with 12.0.6 that we are waiting to get resolved before we upgrade.

Thanks.

Outcomes