000032960 - Account collection failing with ORA-12899: value too large for column "AVUSER"."STX_ACC_122_266"."CAS17" in RSA Via Lifecycle and Governance

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000032960
Applies ToRSA Product Set: Via Lifecycle and Governanace(Via L&G)
RSA Product/Service Type: All
IssueAny 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.

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.

ResolutionCurrently 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.