Long Integer “Out of rage”. :)
Unhandled script exception:
unhandled script exception: Long integer out of range. Results invalid. EXCEPTION_CLASS_SCRIPT_OUT_OF_RANGE SCRIPT_CMD_SET
Upgrade a source code of one of the customization on GL Transaction Entry window, and when tried to save record got error message “Long integer out of range”. There was not much code on the save button and on checking dexterity code it seems all was correct.
- Stored procedure prototype – all set
- Number of parameters – all set
- Confirm from backend, stored procedure have same number of parameters – all set
- JRNENTRY parameter data type is correctly defined as an Integer.
- From front passing correct value, confirm with warning messages- all set
- Then google the error and wend to link
In the issue Cause it says
The account index value for the GL account in the PM Tax Work table (PM10500) is greater than the small integer value of 32767, which is the largest value a small integer field will allow.
but I am not working on PM table, Yes! but definitely working with integer value and here get back to my stored procedure prototype code and yes got the reason why long integer was out of rage and giving error messages, instead of defining it as long integer, I have defined it only integer. Changed it to long integer, compiled and apply the chunk and everything is working now smoothly.
This was originally posted here.
*This post is locked for comments