Netezza – Out of Range Error

Reading Time: < 1 minute

Error:

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

Issue:

Query is trying to insert/update value 760486 in the column of a table which has a datatype of smallint or int2 but the value being inserted is greater than the smallint max limit.

Resolution:

Alter the column to int or bigint and try to insert/update the data again.