My Oracle Support Banner

Getting SQL Errors, Invalid column name 'subType' When Configure Add New OCE Mapping (Doc ID 2743254.1)

Last updated on JANUARY 20, 2021

Applies to:

Oracle WebCenter Sites - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Content and Experience Configure Add New OCE Mapping throws SQL errors

When attempt to "Add New OCE Mapping" from the Admin menu -> Oracle Content and Experience -> Export Mapping -> Configure page and select the checkbox for a flex family asset type, it does not populate the SubTypes container on the page.

This is logged several times in the sites.log (seems to occur for each of our Flex Family assets):

java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'subType'.

The column name in the OCEMapping table is "subtype" (lowercase "t").

Changes

 

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
References


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