Search This Blog

SBL-DAT-00520: Your entry for field '%1' is too long to fit in a UTF-8 encoded enterprise database. Please try again with a shorter entry.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.7.2.1 [18353]
Database: Oracle 9.2.0.4
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Microsoft Windows 2003 Server

This document was previously published as Siebel SR 38-1973641782.

Symptoms

Hello,

we have following problem and we need a workaround for it:

We are using the Communication Object and here the reply function. Now we can replay on an incoming email. If the email is send, the Email Body is also copied into the Comment field of the corresponding activity. (only the first 1500 characters, but thats fine) Now we have the problem, if the replay email body is > 4000 characters (including tabs, returns ...), and the email is send, nothing will be copied to the comment. For example:

1) On Reply the body is prefilled with "[THREAD ID XXX]"
2) Then the user changes the text "Hello Holger, ....... [THREAD ID XXX]" (> 4000 characters)
3) After send the comment only shows " [THREAD ID XXX]" and not the first 1500 characters of the email body. If the bdy is shorter than 4000 you can see ""Hello Holger, ....... " (1500 characters)

We can reproduce this with a standard siebel srf and we need a workaround, because we need the comment shown correctly, because the Body is only a field in Communication, but not in the Activities.

Solution

Message 1

On the log file CommOutboundMgr_2185 there is an error message “SBL-DAT-00520: Your entry for field 'Comment' is too long to fit in a UTF-8 encoded enterprise database”.

This issue has been caused by the expansion of the comment field on the Action BC to be a 16 K field (DTYPE_TEXT).

When placing text that is below 4000 characters then there is no error message, but anything above this causes an error even if the field has been set as long (DTYPE_TEXT to 16k). This related issue occurs only for Unicode (UTF-8) database.

The workaround is change Comments Field on the Action Business Component from DTYPE_TEXT to DTYPE_NOTE.


No comments:

Post a Comment