Monday, April 14, 2014

Oracle Webcenter Sites : java.sql.SQLException: ORA-12899: value too large for column "CSUSER"."TT1397223334151"."VALUE" (actual: 2306, maximum: 2000)

While installing the Oracle Webcenter Sites 11.1.1.6.0 or later you are getting the below error :
Exception executing prepared statement: INSERT INTO tt1397223334151 (NAME,LOCALE,VALUE) VALUES (?,?,?)NAME = fatwire/wem/admin/user/edit/DescriptionBodyLOCALE = ja_JPVALUE = <p>�存�れ�ユーザー���を変更�る�������ん。ユーザー�残り�プロパティ�修正����。</p><p>ACL: ユーザー�Browser�ElementReader�PageReader�UserReader�よ�xceleditor ACL��る��を確����。一般管�者�よ�サイト管�者�もxceladmin�必���。一般管�者��ら�TableEditor�よ�UserEditor(Engageを使用�る場��VisitorAdmin)�必���。ACL�詳細��<i>管�者ガイド</i>を�照������。</p><p>グループ: ��ユーザー�アプリケーション・リソースを管��る権�を必���る場��リソース�権�を��グループ�ユーザーを割り当���。グループを作��る������権�を構��る���<i>WEM�管�者ガイド</i>を�照������。</p><p>��ユーザー�アプリケーション�接続�る���(「サイト�ページ�ら)��サイト���ロールを両方�割り当���。</p>java.sql.SQLException: ORA-12899: value too large for column "CSUSER"."TT1397223334151"."VALUE" (actual: 2306, maximum: 2000)
Reason: In webcenter sites 11.1.1.6.0 and later, language pack is automatically installed and file.encoding is not set for weblogic server i.e. the JVM argument -Dfile.encoding=UTF-8 is not set.

Solution:

  1. Open startWeblogic.cmd in edit mode i.e. Oracle\Middleware\user_projects\domains\soa_domain\bin\startWeblogic.cmd
  2. Find -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS%.
  3. Then append "-Dfile.encoding=UTF-8"
  4. Final string look like this -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS% -Dfile.encoding=UTF-8.
  5. Save and start the server.
Note: For further information please followed the document 1539055.1 on oracle support.

No comments:

Post a Comment