Full collection rebuild is failing with "!syParameterNotFound,columnName varchar"
(Doc ID 2399580.1)
Last updated on DECEMBER 18, 2023
Applies to:Oracle WebCenter Content - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Getting a "syParameterNotFound,columnName varchar" error when trying to do a Full Collection Rebuild.
The following stack trace was found in the UCM diagnostic log.
Compared the WebFileSize entry to an out of the box search collection configuration and found that the out of box configuration had the following differences:
1. baseTable:Documents instead of DocMeta
2. SearchFieldAPString:apTitleWebFileSize instead of SearchFieldAPString:Web File Size
3. SearchFieldWWString:wwWebFileSize instead of SearchFieldWWString:Web File Size
4. idcComponentName:Default instead of idcComponentName:IDEM_GeneralEnhancements. User verified it was a custom component that was enabled, but no longer installed.
The user opened Configuration Manager -> Advanced Search Design and found that the optimized field is checked and disabled for edit. User stated that they optimized both WebFileSize and VaultFileSize fields before in Advanced Search Design, but no longer able edit it.
WebFileSize and VaultFileSize fields were set to optimized and sortable using Configuration Manager -> Advanced Search Design
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document