Sites 11g Install Fail With ORA-12899

(Doc ID 2226017.1)

Last updated on JANUARY 24, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

Sites 11.1.1.8 install failing with log showing "ORA-12899: value too large for column" and it is not related to the following 2 KMs:
"ORA-12899: value too large for column", But the Data Should Fit (Doc ID 1581776.1)
Install Fails with Error "ORA-12899: value too large for column" (Doc ID 1539055.1)

1.  install_log.log had the following error:
[2017-01-12 11:01:44,942 CST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO tt1484240179824 (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 "CSUSER"."TT1484240179824"."VALUE" (actual: 2306, maximum: 2000)

2.  sites.log had the following error:
[2017-01-12 11:01:44.520][CS.INSTALL][INFO] ActionHandler.ExecuteCommand: ExecuteCommand success for http://<hostname>:<port>/servlet/Install?COMMANDNAME=IMPORTCATALOG&USERNAME=ContentServer&PASSWORD=<hidden password value>&CATALOGDIRECTORY=E:/Software/Sites11v8/LanguagePacks/Xcelerate/Populate/ja_JP&INCLUDEFILES=SystemLocaleString.html:LocaleMap.html&ELEMENTDIRECTORY=E:/Oracle/Middleware/Shared/elements
[2017-01-12 11:01:45.177][CS.INSTALL][ERROR] ActionHandlerExecuteCommand: ExecuteCommand failed for http://<hostname>:<port>/servlet/Install?COMMANDNAME=IMPORTCATALOG&USERNAME=ContentServer&PASSWORD=<hidden password value>&CATALOGFILE=E:/Software/Sites11v8/LanguagePacks/wem/Populate/ja_JP/SystemLocaleString.html&ELEMENTDIRECTORY=E:/Oracle/Middleware/Shared/elements
The response that was received =
HTTP/1.1 200 OK
HOST_SERVICE: FutureTenseContentServer:11.1.1.8.0
Transfer-Encoding: chunked
Date: Thu, 12 Jan 2017 17:01:44 GMT
Set-Cookie: JSESSIONID=dTQqY32Y45p4K9JdQyHm1lXTpQr9m103KStqLWv4xnbnG1XSzVQl!1196287436; path=/servlet; HttpOnly
Content-Type: text/html; charset=UTF-8
X-Powered-By: Servlet/2.5 JSP/2.1

<!--FTCS|||result=success|||reason=|||err=12|||command=mirrorgetconfig|||params=columnslowercase=true&CSVersion=11.1.1.8.0&databasetype=Oracle&mirrorprotocolversion=3|||-->
<!--FTCS|||result=failure|||reason=Unknown Reason|||err=-300|||command=ImportCatalog|||params=|||-->
[2017-01-12 11:01:45.223][CS.INSTALL][ERROR] ActionHandlerExecuteCommand: Error Importing E:/Software/Sites11v8/LanguagePacks/wem/Populate/ja_JP/SystemLocaleString.html
[2017-01-12 11:01:45.239][CS.INSTALL][ERROR] Worker.run.
Install failed.
Please check log file.

3.  The AdminServer.log file, there are JDBC connection issues:

<Error> <JDBC> <prow12orap01> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1484313149910> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "CSUSERDS" failed with exception: "oracle.jdbc.xa.OracleXAException".>
<Info> <JDBC> <prow12orap01> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1484313149925> <BEA-001128> <Connection for pool "CSUSERDS" has been closed.>
<Warning> <JDBC> <prow12orap01> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1484313150956> <BEA-001129> <Received exception while creating connection for pool "CSUSERDS": IO Error: The Network Adapter could not establish the connection.>
<Info> <JDBC> <prow12orap01> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1484313150956> <BEA-001156> <Stack trace associated with message 001129 follows:

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms