Full collection rebuild is failing with "!syParameterNotFound,columnName varchar"
Last updated on MAY 17, 2018
Applies to:Oracle WebCenter Content - Version 126.96.36.199.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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms