DB2 Configurations Require UseDatabaseShortIndexName Setting for Folders 7.5.1 Build 147, 148 (Doc ID 445675.1)

Last updated on NOVEMBER 03, 2016

Applies to:

DB2 Configurations Require UseDatabaseShortIndexName Setting for Folders 7.5.1 Build 147, 148

Date:

November 3, 2005

Product and Version:

Content Server Folders 7.5.1 build 147, 148

Symptoms

I am trying to install the Folders component and getting the following DOCMETA_XCOLLECTIONID error in the Content Server output:

'Folders' component,'2005_10_28 7.5.1 rev 147' version, extends folders feature(s) 'Helper'
component,'2005_3_28' version, extends Helper feature(s) 'Lists' component,'2005_1_25' version,
extends Lists feature(s) Service 'DELETE_BYREV_REVISION' Extended system 10.31
13:57:56.252 main !csDbUnableToExecuteSql,CREATE INDEX DocMeta_xCollectionID ON
DocMeta(xCollectionID)!$[IBM][CLI Driver][DB2/NT] SQL0107N The name
"DOCMETA_XCOLLECTIONID" is too long
. The maximum length is "18". SQLSTATE=42622 -
exception stack intradoc.data.DataException: !csDbUnableToExecuteSql,CREATE INDEX
DocMeta_xCollectionID ON DocMeta(xCollectionID)!$[IBM][CLI Driver][DB2/NT] SQL0107N The
name "DOCMETA_XCOLLECTIONID" is too long. The maximum length is "18".
SQLSTATE=42622 at intradoc.jdbc.JdbcWorkspace.executeSQL(Unknown Source) at
intradoc.jdbc.JdbcWorkspace.addIndex(Unknown Source) at
intradoc.server.utils.CompInstallUtils.addIndex(Unknown Source) at
FoldersInstallFilter.doInstall(FoldersInstallFilter.java:770) at
FoldersInstallFilter.doFilter(FoldersInstallFilter.java:188) at
intradoc.shared.PluginFilters.filter(Unknown Source) at
intradoc.server.IdcExtendedLoader.executeFilter(Unknown Source) at
intradoc.server.IdcExtendedLoader.extraAfterServicesLoadInit(Unknown Source) at
intradoc.server.IdcSystemLoader.loadServiceData(Unknown Source) at
intradoc.server.IdcServerManager.init(Unknown Source) at IdcServer.init(Unknown Source) at
IdcServer.main(Unknown Source) Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI
Driver][DB2/NT] SQL0107N The name "DOCMETA_XCOLLECTIONID" is too long. The maximum
length is "18". SQLSTATE=42622 at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException(Unknown Source) at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(Unknown Source) at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(Unknown Source) at
COM.ibm.db2.jdbc.net.DB2Statement.execute2(Unknown Source) at
COM.ibm.db2.jdbc.net.DB2Statement.executeUpdate(Unknown Source) ... 12 more SYNC!
xComments 255 SYNC! xCollectionID 19 SYNC! xHidden 30 SYNC! xReadOnly 30 SYNC!
xInhibitUpdate 30 SYNC! xTrashDeleter 30 SYNC! xTrashDeleteDate 20 SYNC! xTrashDeleteLoc
19 SYNC! xTrashDeleteName 255 Content Management System Server. Version 7.5.1
(050330) Copyright (C) 1996-2005 Stellent, Inc. All rights reserved. Ready and waiting for connection on port
2244, PID 23378 (idc42)

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