My Oracle Support Banner

H2T task failing due to ORA-00972 error (Doc ID 2601655.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.0 version, Database

When attempting to execute H2T task,
the following error occurs.

ERROR
-----------------------
ue Jul 16 12:30:22 EDT 2019 [ClsUUtlETLLoaderUtil] : creating log table : BEGIN DBMS_ERRLOG.CREATE_ERROR_LOG(dml_table_name =>'STG_INSTRUMENT_CONTRACT_MASTER', err_log_table_name =>'STG_INSTRUMENT_CONTRACT_MASTER$' ); END;
Tue Jul 16 12:30:22 EDT 2019 [ClsUUtlETLLoaderUtil] : ORA-00972: identifier is too long
ORA-06512: at "SYS.DBMS_UTILITY", line 833
ORA-06512: at "SYS.DBMS_ERRLOG", line 191
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to define H2T to load data into table of length greater than 30 characters

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot execute H2T.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.