Limit reached on PSVERSION.VERSION field
Peter Morris (guest) 04 Dec 2018 22:12
Hi,
We've reached the limit of an int field (int -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) 4 Bytes)
SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'UPM'
2147483647
and getting the error "Arithmetic overflow error converting expression to data type int." when running an application engine job to create user profiles.
What can we do? Our immediate thoughts are to
1. Change int to bigint for the field VERSION on table PSVERSION
2. Reset the Version number for UPM to 0
However, we do not know the impact of doing this.
Also contacted Oracle for resolution
Peter
