AWA Client Copy generates JWP forced trace files

Document ID : KB000122422
Last Modified Date : 05/12/2018
Show Technical Document Details
During Client Copy forced trace files from the JWP are being generated with an error in AWA:
Caused by: 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 ''. 

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 ' "DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001, SQLERRMC=4496712k\PROCESS_CONTROL/4496713k\DDS/4496775k\UTILITIES/449, DRIVER=4.19.66"' at ''. 

Interestingly, the error occurs after U00045134 Search index update on Client#NOCLIENT: partition #21 finished (0.410s) errors.
Automation Engine v12.2.0
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.
Upgrade the Automation Engine to one of the fixed versions:

Automation.Engine 12.2.1
Automation.Engine 12.3.0