ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error with DATA MODEL ORA-12899: value too large

book

Article ID: 145713

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have an error when doing the DATA MODEL : ORA-12899: value too large for column "GTREP"."GTREP_ENTITY_RELATIONSHIP"."REL_DESC" (actual: 257, maximum: 254)

 

Can I change the length of the field length to 300?

 

 

Here is the log file

    c.c.t.d.e.DataModelEngine:  Analyzing foreign key relationships of scanned tables for job ID 2813

2020-02-11 16:08:49.958 UTC [INFO ] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                           c.c.t.e.ModellingEngine:  isJobCancelled:  job: 2813: status of job as reported by the job engine: Running

2020-02-11 16:08:49.959 UTC [INFO ] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                         c.c.t.d.e.DataModelEngine:  Checking table SAT_SCAEN_CARACTERISTIQUE_ENTREPRISE (225181)

2020-02-11 16:08:49.959 UTC [INFO ] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                         c.c.t.d.e.DataModelEngine:    SAT_SCAEN_CARACTERISTIQUE_ENTREPRISE|HUB_PERSONNE_DESJARDINS_OPERATIONNELLE_HKEY -> HUB_HPDOP_PERSONNE_DESJARDINS_OPERATIONNELLE|HUB_PERSONNE_DESJARDINS_OPERATIONNELLE_HKEY

2020-02-11 16:08:49.964 UTC [DEBUG] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                         c.c.t.d.e.DataModelEngine:  Adding relationship between parent table ORACLE_ORA865UD_DVAP1Q/DVAP1Q/DVAP1Q/SAT_SCAEN_CARACTERISTIQUE_ENTREPRISE(225181) with column HUB_PERSONNE_DESJARDINS_OPERATIONNELLE_HKEY(7255576) and child table ORACLE_ORA865UD_DVAP1Q/DVAP1Q/DVAP1Q/HUB_HPDOP_PERSONNE_DESJARDINS_OPERATIONNELLE(225172) with column HUB_PERSONNE_DESJARDINS_OPERATIONNELLE_HKEY(7255431), cardinality: ZERO_OR_MORE - ZERO_OR_MORE

2020-02-11 16:08:50.017 UTC [WARN ] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                      o.h.e.j.s.SqlExceptionHelper:  SQL Error: 12899, SQLState: 72000

2020-02-11 16:08:50.017 UTC [ERROR] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                      o.h.e.j.s.SqlExceptionHelper:  ORA-12899: value too large for column "GTREP"."GTREP_ENTITY_RELATIONSHIP"."REL_DESC" (actual: 257, maximum: 254)


2020-02-11 16:08:50.072 UTC [ERROR] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                 o.h.i.ExceptionMapperStandardImpl:  HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not execute statement]

2020-02-11 16:08:50.079 UTC [ERROR] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                             c.c.t.e.LocoException:  postProcess:  post processing failed with an exception: exception raised: post processing failed with an exception: Exception raised: JpaSystemException: could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement

2020-02-11 16:08:50.085 UTC [ERROR] [ModellingEngine-DATADISCOVERY-jobId-2813] --- [U:][M:][P:]                             c.c.t.e.LocoException:  stack dump:

java.sql.SQLException: ORA-12899: value too large for column "GTREP"."GTREP_ENTITY_RELATIONSHIP"."REL_DESC" (actual: 257, maximum: 254)


at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)



Cause

GTREP_ENTITY_RELATIONSHIP"."REL_DESC" (actual width: 257, maximum: 254)

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

TDMWeb-4.8.179.0.zip has the fix.  The new width is 2000