PIM(SAM) ALL :ORA-12899 ERROR occurred at multiple requests

Products

• CA Virtual Privilege Manager
• CA Privileged Identity Management Endpoint (PIM)
• CA Privileged Access Manager (PAM)

Issue/Introduction

Customer get ORA-12899 error during multiple Privileged Accounts requests. So, he extend size as following SQL:
alter table tasksession12 modify DESCRIPTION varchar2(512 char);
But after that, customer met same problem. ERROR: ORA-12899: value too large for column "ENTMCDB"."TASKSESSION12"."DESCRIPTION"(actual:573, maximum: 512)
 

Environment

Fist reported this problem on following Environment:
OS: Widnows 2008 R2
Prod: CA Privileged Identity Manager r12.8 CF2 for SAM
  CDB: ORACLE 11g R2 or another version which is supported by SAM
  User store: Embededded or ActiveDirectory.

But this problem is caused by Japanese Environment at ORACLE.  So, it may happen at all PIM version.

Cause

Description column is generated by SAM with each task type.
And strings which will be inserted into this column is cut off by API at Java class depending data type, size and Language.
 

Resolution

It should change data type from varchar2 to nvarchar2 as following:
SQL> ALTER TABLE tasksession12 MODIFY ( Description nvarchar2(512));
SQL> ALTER TABLE archive_tasksession12 MODIFY ( Description nvarchar2(512));

Additional Information

If customer is using MS SQLServer as CDB, Description column in tasksession12 table is 'nvarchar2(512)'.
So, this problem does not occur.