Operation at Server Failed.  Saving Source Definition with ORA-12899
Last updated on OCTOBER 08, 2013
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 to 7.1 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 08-Oct-2013.
In Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.1, when you try to define a new Data Source, you receive the following error when saving the new Data Source information in the Data Source Details screen:
 Operation at server failed.  Saving Source definition
failed.  For more information check the log file.
The following error appears in the revappserver.log in the $FIC_APP_HOME/common/FICServer/logs directory:
[REVELEUSLOG] Oct 22,10 10:40:59 : [SMSSERVICES][SMSServices] Error in executing BatchError while executing Update :Failed Executing Query. Reason: ORA-12899: value too large for column "<owner>"."ETLSOURCEDETAILS"."V_SRV_IP_ADDR" (actual: 23, maximum: 20)
As a result of the error, you cannot save the new Data Source.
Additionally, when you click on the "Test Source" button, the test is successful.
Steps to Reproduce:
- Go to Unified Metadata Manager > Technical Metadata Management > Data Integrator
- Go to Source Designer > Define Sources > Define Data Source
- Click on New
- Fill out all Data Source Details for an RDBMS source
- Click Save
The error appears.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms