AWA Client Copy generates JWP forced trace files

Document ID : KB000122422
Last Modified Date : 05/12/2018
Show Technical Document Details
Issue:
During Client Copy forced trace files from the JWP are being generated with an error in AWA:
Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001, SQLERRMC=3827002k\PROCESS_CONTROL/3827003k\DDS/3827065k\UTILITIES/382, DRIVER=4.19.66

This is the complete error details:
U00045014 Exception 'java.lang.RuntimeException: "Error getting folderpath for id 4478488. using NO_FOLDER"' at 'com.automic.search.lucene.documentbuilder.FolderLinkDocumentBuilder.convertPathToACLPath():106'. 

U00045015 The previous error was caused by 'com.automic.database.api.DBException: "WITH paths (ofs_oh_idnr_f, ofs_oh_idnr_o, lev, oh_name) AS ( SELECT ofs_oh_idnr_f, ofs_oh_idnr_o, 1, oh_name FROM ofs, oh WHERE ofs_oh_idnr_o = oh_idnr AND OFS_OH_Idnr_O = ? UNION ALL SELECT f.ofs_oh_idnr_f, f.ofs_oh_idnr_o, lev + 1, o.oh_name || '/' || p.oh_name FROM ofs f, oh o, paths p WHERE p.ofs_oh_idnr_f = f.ofs_oh_idnr_o AND f.ofs_oh_idnr_o = o.oh_idnr ) SELECT oh_name FROM paths WHERE lev = (select max(lev) from paths) 

Value "4496712k\PROCESS_CONTROL/4496713k\DDS/4496775k\UTILITIES/449" is too long.. SQLCODE=-433, SQLSTATE=22001, DRIVER=4.19.66"' at 'com.automic.database.impl.DBConnectionImpl.executeInternal():432'. 

U00045015 The previous error was caused by 'com.ibm.db2.jcc.am.SqlDataException: "DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001, SQLERRMC=4496712k\PROCESS_CONTROL/4496713k\DDS/4496775k\UTILITIES/449, DRIVER=4.19.66"' at 'com.ibm.db2.jcc.am.kd.a():739'. 

Interestingly, the error occurs after U00045134 Search index update on Client#NOCLIENT: partition #21 finished (0.410s) errors.
Environment:
Automation Engine v12.2.0
Cause:
The JWP fails to index an AE object if the object is in a nested folder structure that has a long path (more than 200 characters).

When this occurs, the log file contains the error message "Error getting folderpath for id <ID>" followed by "Value <TRUNCATED_PATH> is too long. SQLCODE=-433, SQLSTATE=22001...", and objects in this folder cannot be found in the Automic Web Interface (AWI) search.

Objects in DB2 are now indexed correctly.
Resolution:
Upgrade the Automation Engine to one of the fixed versions:

Automation.Engine 12.2.1
Automation.Engine 12.3.0