Install Fails with Error "ORA-12899: value too large for column" (Doc ID 1539055.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

Hello CS is successful, DB and Permissions are successful. CAS and WCS files are active in Weblogic
However 80% through the installation there is an error.


In the install_log.log:


CS.INSTALL][ERROR] CSSetupEngine.initReInitAction: Database Initialization Failed.
Initialization was attempted with wcDataSource as the DSN.
The URL that was passed in = http://localhost:7003/cs/CatalogManager.
Please Check your connection and property files settings.

[CS.INSTALL][ERROR] CSSetupEngine.initReInitAction:  Error received = Command failed:createtable
Can't create Sysinfo catalog

Initialization Error:  Response from system =

<!--FTCS|||result=failure|||reason=Command failed:createtable|||err=-22|||command=createtable|||params=|||-->
Can't create Sysinfo catalog<br>
<!--FTCS|||result=failure|||reason=Can't create Sysinfo catalog|||err=-100|||command=InitializeSystem|||params=|||--><br>ERROR: Unable to initialize system catalogs! <br><br>
Can't create Sysinfo catalog

 

In the sites.log:


[ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.install] ImportCatalogError import the table. Error Number=-105
[ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception executing prepared statement: INSERT INTO tt1361545797277 (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ã�®è©³ç´°ãï¿</p>
java.sql.SQLException: ORA-12899: value too large for column "WCUSER"."TT1361545797277"."VALUE" (actual: 2306, maximum: 2000)



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