My Oracle Support Banner

Getting Model Upload Error 'There is a space in the Column name' When the Column Looks Correct in Erwin (Doc ID 2578216.1)

Last updated on AUGUST 16, 2019

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Data Foundation (FSDF)

Symptoms

In OFSAA Infrastructure (OFSAAI) > Data Model Maintenance, when attempting to upload a customized data model, you get the following errors in the model upload log from /<ftpshare>/<infodom>/logs:

FSI_D_INVESTMENTS_AGGR.
.
.
.
There is a space in the Column name .....TEST INCENTIVE 1


There is a space in the Column name .....TEST INCENTIVE 2

There is a space in the Column name .....TEST INCENTIVE 3
(n_run_skey NUMBER(10) DEFAULT NULL Null,test_incentive NUMBER(8,4) DEFAULT NULL Null,test_balance_1 NUMBER(8,4) DEFAULT NULL Null,test_balance_2 NUMBER(8,4) DEFAULT NULL Null,TEST_BALANCE_CHCR NUMBER(22,3) DEFAULT NULL Null,TEST INCENTIVE 1 NUMBER(22,3) DEFAULT NULL Null

etc.

When you review this column in Erwin Data Modeler, you do not see a space:

 

You do not understand what causes the error.  As a result of this error, the data model upload fails.

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