Failed to import autotrack from CAA Error ORA-12899: value too large for column "UNC_UIDASH"."IDASH_AUTOTRACK"."DETAIL"

Products

• iDash Workload Automation for CA 7

Issue/Introduction

Receiving the following message in the idash log file [ERROR] idashdb-import-CAA-thread-3:com.ca.idash.core.db.etl.AbstractTableImporter: Failed to import autotrack from CAA Error ORA-12899: value too large for column "UNC_UIDASH"."IDASH_AUTOTRACK"."DETAIL" (actual: 2245, maximum: 2000)

Resolution

Need to enlarge the detail column in the iDash database.. Here is the query to do so:

       ALTER TABLE idash_autotrack MODIFY DETAIL varchar2(4000) ;

4000 is the max size for this data type we wouldn't recommend anything smaller than 3000.

Depending on the size of the autotrack table in the iDash database, this may take some time to accomplish.