Adding Unicode text to the TABLE_ACT_ENTRY.ADDNL_INFO field can throw an error if the DB is not set up as a Unicode DB (Article # 320)
View products that this article applies to.
Problem:
An ORA-12899: value too large for column "TABLE_ACT_ENTRY"."ADDNL_INFO" (actual: 260, maximum: 255) error can occur when calling the FChoice.Toolkits.Clarify.Support.SupportToolkit.LogCaseNote if the data being passed has 255 characters that include Unicode characters.
Resolution:
Programmatically change the encoding of the string being passed before this method is invoked.
For example, do:
caseNoteString = Encoding.ASCII.GetString( Encoding.ASCII.GetBytes( caseNoteString ) );
Then use caseNoteString as Notes on input to LogCaseNote. This will allow LogCaseNote routine to properly truncate the text to 255 characters. It is important to note however that any Unicode characters in the string may be changed to question marks.
Resolution:
Increase the size of table_act_entry.addnl_info to 765 bytes. This is enough space to store up to 255 3-byte-Unicode-characters.
This change could be made either by using Dovetail Schema Editor or Clarify ddcomp tool.
Resolution:
Upgrade the database to Unicode-enabled making sure to follow Clarify standards.
Applies To:
-
Dovetail SDK – Dovetail Software Development Kit for Clarify