My Oracle Support Banner

Full collection rebuild is failing with "!syParameterNotFound,columnName varchar" (Doc ID 2399580.1)

Last updated on MAY 17, 2018

Applies to:

Oracle WebCenter Content - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

WebFileSize and VaultFileSize fields were set to optimized and sortable using Configuration Manager -> Advanced Search Design

Cause

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
Symptoms
Changes
Cause
Solution


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