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

Last updated on SEPTEMBER 30, 2022

Applies to:

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

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