Skip to content

Netezza – Out of Range Error

Error:

720625(253) [25, INT2] out of range (-32768..+32767), “65535”[,]

Issue:

Query is trying to insert value 720625 in the 25th column of a table which has a datatype of smallint or int2 but the value being iserted is greated than the smallin max limit.

Resolution:

Alter the column to int and try to insert the data again.