[2387] Operation at Server Failed. [3633] Saving Source Definition with ORA-12899 (Doc ID 1261886.1)

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.

Symptoms

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:

[2387] Operation at server failed. [3633] Saving Source definition
failed. [4547] 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:

  1. Go to Unified Metadata Manager > Technical Metadata Management > Data Integrator
  2. Go to Source Designer > Define Sources > Define Data Source
  3. Click on New
  4. Fill out all Data Source Details for an RDBMS source
  5. Click Save

The error appears.

Cause

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