This discussion is archived
5 Replies Latest reply: Dec 2, 2013 10:40 PM by tejalmistry RSS

Database Error - Language Packs Webcenter Sites - Bundled Patch 1 (11.1.1)

VJ Nair Newbie
Currently Being Moderated
Hi,

Environment

OS: Windows 7 x64
Database : Oracle XE
Webcenter Sites version: 11g Release 1 (11.1.1) Bundled Patch 1

While installing the language packs , the following error is encuntered

[2012-11-09 16:23:07,399 IST] [INFO ] [http-bio-8081-exec-9] [fatwire.logging.cs.install] ImportCatalog successfully imported file. C:\temp\WCSitesServer\Sites\LanguagePacks\Xcelerate\Populate\ja_JP\SystemLocaleString.html
[2012-11-09 16:23:07,399 IST] [INFO ] [http-bio-8081-exec-9] [fatwire.logging.cs.install] ImportCatalog Sucessfully imported catalog C:/temp/WCSitesServer/Sites/LanguagePacks/Xcelerate/Populate/ja_JP
[2012-11-09 16:23:07,486 IST] [ERROR] [http-bio-8081-exec-8] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO tt1352458320644 (NAME,LOCALE,VALUE) VALUES (?,?,?)
NAME = fatwire/wem/admin/user/edit/DescriptionBody
LOCALE = ja_JP
VALUE = <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 "FCDB_SITES_MGMT_USER1"."TT1352458320644"."VALUE" (actual: 2306, maximum: 2000)

     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
     at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)
     at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1367)
     at COM.FutureTense.Servlet.JDBCTable.access$000(JDBCTable.java:68)
     at COM.FutureTense.Servlet.JDBCTable$1.execute(JDBCTable.java:1319)
     at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
     at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1324)
     at COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1211)
     at COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:943)
     at COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1272)
     at COM.FutureTense.CatalogManager.CatalogEngine._replaceRows(CatalogEngine.java:1668)
     at COM.FutureTense.CatalogManager.CatalogEngine.access$400(CatalogEngine.java:44)
     at COM.FutureTense.CatalogManager.CatalogEngine$4.execute(CatalogEngine.java:1546)
     at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
     at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows_trans(CatalogEngine.java:1556)
     at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows(CatalogEngine.java:1353)
     at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:1987)
     at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3351)
     at COM.FutureTense.Common.CS.CatalogManager(CS.java:1503)
     at COM.FutureTense.Common.CS.CatalogManager(CS.java:1457)
     at COM.FutureTense.Apps.Install.command.ImportCatalog.doIt(ImportCatalog.java:522)
     at COM.FutureTense.Apps.Install.command.ImportCatalog.importCatalogFile(ImportCatalog.java:329)
     at COM.FutureTense.Apps.Install.command.ImportCatalog.doImport(ImportCatalog.java:266)
     at COM.FutureTense.Apps.Install.command.ImportCatalog.exec(ImportCatalog.java:189)
     at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130)
     at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479)
     at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104)
     at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123)
     at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:454)
     at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
     at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:192)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:695)
     at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
     at java.lang.Thread.run(Thread.java:662)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points