Join Index on table causing 2616 overflow error.

Database
Teradata Employee

Join Index on table causing 2616 overflow error.

Hello,

I have a table that is defined with an Aggregate Join Index. The AJI was created successfully after table was populated with data. But when we try to insert/update the data into the table it gives a 2616 - Numeric overflow error. We dropped the AJI and then did the insert/update and then recreated the AJI on it and it worked fine.

Thanks,
Indrajit