OBIA 11g: SDE_PSFT_90_ADAPTOR_SDE_PSFT_SIASCHOLARDIMENSION Failed With "ORA-12899: Value Too Large For Column"
(Doc ID 2379847.1)
Last updated on MARCH 10, 2021
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.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.
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