Troubleshooting
Problem
When you export crawled, analyzed, or searched documents to a relational database, the export fails and “SQL error: SQLCODE=-286, SQLSTATE=42727” is written to the system log in the ES_NODE_ROOT/logs directory.
Cause
Your database mapping file defines a table with more columns than can be contained in the current database table that you created.
Resolving The Problem
Delete the database that you created and recreate it with a larger page size. For example, enter the command CREATE DB database_name PAGESIZE size.
To determine the page size to specify, check the value of the SQLERRMC parameter in the error message that appears in the export audit log in the ES_NODE_ROOT/logs/audit directory. For example, if the following message appears in the audit log, create a database with a page size of 8192 or higher:
com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192 ;DB2ADMIN, DRIVER=3.50.152
Was this topic helpful?
Document Information
Modified date:
23 June 2018
UID
swg21414318