While installing the Oracle Webcenter Sites 11.1.1.6.0 or later you are getting the below error :
Solution:
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:
- Open startWeblogic.cmd in edit mode i.e. Oracle\Middleware\user_projects\domains\soa_domain\bin\startWeblogic.cmd
- Find -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS%.
- Then append "-Dfile.encoding=UTF-8"
- Final string look like this -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS% -Dfile.encoding=UTF-8.
- Save and start the server.
Note: For further information please followed the document 1539055.1 on oracle support.
No comments:
Post a Comment