Clarity

Version 14.2, On Demand.  Ran the Portfolio Sync job and received the following error: 

Portfolio Sync failed: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-22859: invalid modification of columns

Has anyone else received this and what was the resolution?

This is a problem where the code is trying to convert a CLOB field into a VARCHAR field data type.

This is being investigated as a case.

This issue has been resolved in 14.2 patch 1. 

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

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1807514.aspx

This issue is slightly different than the root cause in the KB identified by Liz.

For this specific case, after further investigation, we found that this issue is caused by a change in the data type from a LARGE STRING to a STRING.

Deleting the Large String attribute and creating a new attribute as a String type reusing the same attribute ID

We logged a bug : CLRT-79097 and found a possible workaround by deleting the new attribute (created the 2nd time) and then recreating the same attribute again a 3rd time with the data type of String ... . thereby causing the application not to think there is a change in the data types.

Reference

Portfolio Sync failed - Can't use Portfolios

Document ID:  TEC1348932