Number being changed in custom number field on assets
I spent a bit of time entering SIM ID information on our managed hotspots which we track in with FS Asset Management. This morning I checked out one of the quick reports I setup and I noticed that every single number in this field, for each device was changed to this seemingly random number.
This is 100% reproducible in our database. Add a number field to an asset and enter a SIM length number, for instance 89148000003477777742 upon updating/saving will be changed to 9223372036854775807. It happened on all ~40 records.
How should I proceed?
Thanks for reporting this scenario.
We could recreate this on our end.I have created this as a ticket and have passed this on to our Product team to address this concern soon.
We will keep you updated on ticket as well as on the forum.
Looks like 9223372036854775807 is the maximum value that can be set for a 64 bit integer type number fields in the product and since you are using a bigger number than that, it automatically reverts to the maximum value.
Looking at your usecase (entering SIM ID information), i guess you may not need any calculations to be performed on this and hence may i request you to use a text field for entering the SIM ID information.Let me know if this doesn't look like a good solution.
At the same time, we also understand that this scenario should have been gracefully handled with a message while you were trying to save the value, which should have saved you a lot of time and we are planning to do that soon.