The counter used to generate serial numbers for this part has reached its maximum

Are you certain somebody wasn’t zeroing out the counter through SSMS or even a BPM on a change in the prefix that zeroed out the counter?