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

Document ID : KB000115730
Last Modified Date : 26/09/2018
Show Technical Document Details
Issue:
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.