Sites 11g Install Fail With ORA-12899
(Doc ID 2226017.1)
Last updated on NOVEMBER 03, 2023
Applies to:
Oracle WebCenter Sites - Version 11.1.1.8.0 and laterInformation 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)'> <
<Info> <JDBC> <servername> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <
<Warning> <JDBC> <servername> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <
<Info> <JDBC> <servername> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <
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 |