IBM Support

IBM Content Manager DB2 Text Search - Error occurs when creating text indexes due to improper document constructor deployment

Troubleshooting


Problem

During DB2 Text Search text index creation, the error SQL -20427 occurs due to a failure of DB2 Text Search text index creation. One of the possible reasons for this failure is the improper deployment of the document constructor.

Symptom

You can get this error when you add a DB2 Text Search text search index for an
item type by using the system administration client. The server.log file
contains error messages similar to the following example:

10/03 19:32:44.938 GMT ; 2013/10/03 14:32:44.938 LCT ; 10172 PID;03193030415719
42:1417fcccc90:X7fab ICMADMIN CREATE INDEX failed
sqlcode -20427
sqlerrmc <"IQQR0007E The DB2_ICMNLSDB_TS393219_0000 collection cannot be". SQL >
sqlerrp <SQL10051>
ICMPLSCP ICMDEFINECOMPTYPE 01050 10/03 19:32:44.942 GMT ; 2013/10/03
14:32:44.942 LCT ; 10172 PID;03193030415719 42:1417fcccc90:X7fab ICMADMIN Exit
rc=7064 reason=0 extrc=-20427 extreason=0

Also, in the text search server trace of trace0 under installPath\log, you see
the following error:

QQR0007E The DB2_ICMNLSDB_TS333020_0000 collection cannot be created.
Causes of the problem:
IQQG0189E The constructor [ICMDCTOR] was not found.

For an integrated DB2 Text Search server configuration on Windows, this trace0
is under the C:\PROGRADATA\IBM\DB2\DB2COPY1\DB2\db2tss\log path. If your IBM
Content Manager Enterprise Edition is on UNIX, this path would be the
/home/db2inst1/sqllib/db2tss/log path.

[{"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"v8 - Library Server - Troubleshooting","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21988899

Page Feedback