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 FEBRUARY 20, 2023
Applies to:
Oracle Healthcare Analytics Data Integration - Version 2.0.2 and laterInformation 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
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 |