My Oracle Support Banner

Sites 11g Install Fail With ORA-12899 (Doc ID 2226017.1)

Last updated on OCTOBER 19, 2020

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.  sites.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>large_example_value</p>
java.sql.SQLException: ORA-12899: value too large for column "CSUSER"."TT1484240179824"."VALUE" (actual: 2306, maximum: 2000)

2.  install_log.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=<jsessionid_cookie>; 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> <servername> <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> <servername> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1484313149925> <BEA-001128> <Connection for pool "CSUSERDS" has been closed.>
<Warning> <JDBC> <servername> <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> <servername> <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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.