Database Column size issue
I have been getting many reconciliation errors when running the host connection discovery job and found the following in the reconciliation log. It appears that I need to increase the size of the column below but not sure which CI / Attribute it is referring to. Any ideas?
Can't execute BATCH prepared statement [UPDATE CDM_UNIX_1 SET A_HOST_OSRELEASE = ?, A_HOST_KEY = ?, A_HOST_ISCOMPLETE = ?, A_DATA_UPDATED_BY = ? WHERE CMDB_ID = ?], failed prior to DB execution due to exception: com.mercury.jdbc.oraclebase.ddc: [mercury][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "UCMDB"."CDM_UNIX_1"."A_HOST_OSRELEASE" (actual: 506, maximum: 256)
Re: Database Column size issue
The column is host_osrelease and it is configured to be 256 characters wide. The error shows actual 506 characters which seems excessive for this field. This is the type of values that I have in my system:
I suggest you investigate the job and look at the communication log to determine why it is returning such long values for that attribute.