IBM Support

DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704 error message when indexing LCSE content

Troubleshooting


Problem

DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704 error message when indexing LCSE content

Symptom

When using FileNet Content Engine Content Search Engine to index content the following error can be observed from either a WAS systemout.log or a p8_server_trace.log with the Database traceflag enabled;


DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=<Database name here>.INDEXPAIRS, DRIVER=3.62.56"
or
"DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: <Database name here>.INDEXPAIRS' in 4 milliseconds: SQL: "SELECT 1 FROM IndexPairs"
DEBUG com.filenet.api.exception.EngineRuntimeException: <CE Server Name>: DB_OBJECT_DOES_NOT_EXIST: The referenced database object cannot be located. SQL: "SELECT 1 FROM IndexPairs.

Cause

This occurs if anything related to IBM CSS (Content Search Services) is or was enabled on the object store (properties).

Resolving The Problem

Review the object store properties (IBM CSS tab) and ensure nothing related to CSS is not enabled.

[{"Product":{"code":"SSNW2F","label":"FileNet P8 Platform"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Content Search Engine","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"5.0;5.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

More support for:
FileNet P8 Platform

Software version:
5.0, 5.1

Operating system(s):
Windows, AIX, HP-UX, Linux, Solaris

Document number:
466481

Modified date:
17 June 2018

UID

swg21574663

Page Feedback