If the size of an attribute is changed, the Portfolio Synchronization job fails

Document ID : KB000030680
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

If an attribute size is increased, the temporary tables used in the Portfolio Synchronization job is not updated and thus the Portfolio Synchronization job fails with the following error message.  This is an Oracle-specific issue.

ORA-01451: column to be modified to NULL cannot be modified to NULL 

Steps to Reproduce:

  1. Create a string attribute (size 50) on the Idea object, any NPIO or Project investment object 
  2. Run the Portfolio Synchronization job for a portfolio 
  3. Increase the attribute size, to 100 for example 
  4. Run the Portfolio Synchronization job again
  5. Examine the BG-CA.LOG file for error message from the job 
Expected Result: That the adjustment will work and the temp table for the investment will be updated correctly and there won't be an error encountered
Actual Result: The adjustment to the temp table fails and there isn't any logging to show the problem statements and the Portfolio Synchronization run fails with a system error  

   

Solution:

WORKAROUND:

None. 

STATUS/RESOLUTION:

CLRT-77468
Resolved in CA PPM 14.2 Generic Patch.  Reference TEC1398937