My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.