OHADI: ORA-12899: Value Too Large For Column "EHA_HLI_WORK"."SNP_SESS_STEP_LV"."END_SHORT_VALUE" (Doc ID 1913997.1)

Last updated on OCTOBER 01, 2016

Applies to:

Oracle Healthcare Analytics Data Integration - Version 2.0.2 and later
Information in this document applies to any platform.

Symptoms

OHADI 2.0.2, with ODI. Users are entering codes in the SDE_ETL_LOAD_PARAM_G table PARAM_NAME = 'VAR_HLI_NICK_NAMES' / PARAM_VALUE column. They populate their values then run HLI MASTER_EXECUTION_PLAN Scenario LOAD_GLOBAL, and the ETL fails with the following error message:

Session Failed :953536 : oracle.odi.core.exception.OdiRuntimeException: com.sunopsis.dwg.SQLWorkReposException: ORA-12899: value too large for column "EHA_HLI_WORK"."SNP_SESS_STEP_LV"."END_SHORT_VALUE" (actual: 469, maximum: 250)

at oracle.odi.runtime.agent.execution.event.VariableTracker.handleEndStep(VariableTracker.java:186)
at oracle.odi.runtime.agent.execution.event.AbstractExecutionEventTracker.onEndStep(AbstractExecutionEventTracker.java:81)
at oracle.odi.runtime.agent.execution.event.ExecutionEventDispatcher.handleEndStep(ExecutionEventDispatcher.java:326)
at oracle.odi.runtime.agent.execution.event.ExecutionEventDispatcher.onEndStep(ExecutionEventDispatcher.java:310)
etc.

 

o Customer has values that are greater than 250 (string below is 469 characters):

"'CAP_CT_ICD9_1','CAP_CT_ICD9_2','CAP_CT_ICD9_3','CAP_CT_ICD9_4','ICD10CM-ICD9CM Reimbursement Map','ICD10CM-ICD9CM Reimbursement Null Map','ICD10CM-ICD9CM Approximate','ICD10CM-ICD9CM Approximate','ICD10CM-ICD9CM Equals','ICD10CM-ICD9CM No Map','ICD10PCS-ICD9 Approximate','ICD10PCS-ICD9 Equals','ICD10PCS-ICD9CM Procedure Reimbursement Map','ICD9CM-ICD10CM Approximate','ICD9CM-ICD10CM Equals','ICD9CM-ICD10CM No Map','ICD9-ICD10PCS Approximate','ICD9-ICD10PCS Equals'"

Results above were obtained from the query:

SELECT PARAM_VALUE FROM SDE_ETL_LOAD_PARAM_G WHERE PARAM_NAME='VAR_HLI_NICK_NAMES' AND PACKAGE_NAME='GLOBAL' AND SOURCE_SYSTEM='HLI';

o "EHA_HLI_WORK"."SNP_SESS_STEP_LV"."END_SHORT_VALUE" is an ODI object.
o OHADI processing is referencing this ODI object called SNP_SESS_STEP_LV"."END_SHORT_VALUE which is defined as VARCHAR(250)

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