Account collection failing with ORA-12899: value too large for column "AVUSER"."STX_ACC_122_266"."CAS17" in RSA Via Lifecycle and Governance
3 years ago
Originally Published: 2016-04-20
Article Number
000064625
Applies To
RSA Product Set: Via Lifecycle and Governanace(Via L&G)
RSA Product/Service Type: All
 
Issue
Any account collection in Via L&G fails with ORA-12899: value too large for column  if the attribute being collected have more than 256 characters. Collection fails though you have enabled truncate large attribute in Admin > System > Truncate large attribute values.
Cause

CAS1 or CAS2 with 2048 bytes  are the only custom attributes currently in our system to support greater lengths. Any other attribute do not support to collect large values.

Resolution
Currently you can only collect large attributes in CAS1 or CAS2. If these attributes are already in use you can swap those large attributes with CAS1 or CAS2.

To swap the attributes Just hover to Admin > Attributes > Affected object say for example Account -> Edit
You will see that Attribute Name are editable. For example in below screenshot Notes attribute with Database ID CAS6 will not collect data with more that 256 characters.

User-added image

Just swap the names of CAS1 and  Notes attribute .

User-added image
Then edit your  collector and map the correct attribute.

 

Related Articles

Trending Articles

Don't see what you're looking for?