OBIA 11g: SDE_PSFT_90_ADAPTOR_SDE_PSFT_SIASCHOLARDIMENSION Failed With "ORA-12899: Value Too Large For Column"
Last updated on APRIL 04, 2018
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.2 and later
Information in this document applies to any platform.
SDE_PSFT_90_ADAPTOR_SDE_PSFT_SIASCHOLARDIMENSION failed with following error.
Caused By: java.sql.SQLException: ORA-12899: value too large for column
"OBIA_DW"."W_SIA_SCHOLAR_DS"."GENDER_CODE" (actual: 14, maximum: 1)
"OBIA_DW"."W_SIA_SCHOLAR_DS"."GENDER_CODE" is Varchar2(1)
Code needs to be corrected.
The source have 1 character. The problem is in the source query assigning
'_UNASSIGNED_' to null character causing the field to be bigger than 1.
This is where the problem is. Is replacing '__UNASSIGNED__' to where the
data is null that's why is greater than one character.
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