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.