Skip to Content
Menu
This question has been flagged

Hello,

I'm facing an issue while trying to access a particular menu in Odoo. The error message I'm encountering reads as follows:

psycopg2.errors.NumericValueOutOfRange: value "9053589890" is out of range for type integer


The above server error caused the following client error:
null

 To troubleshoot, I attempted direct database access to the model named "sale_rental_schedule". However, I couldn't locate the corresponding table in the database. Within this model, I only found two fields with integer type: 'id' and 'color'. Despite my efforts to change their types using a PostgreSQL query, I encountered the following error:

 ERROR: "sale_rental_schedule" is not a table, composite type, or foreign table SQL state: 42809


PS: The database is a migrated database from Odoo 14 to Odoo 16.

Could anyone provide guidance on how to resolve this issue and regain access to my model?

Any assistance would be greatly appreciated.


Avatar
Discard
Best Answer

Hi,

The error "psycopg2.errors.NumericValueOutOfRange: value '9053589890' is out of range for type integer" suggests that you're trying to insert a value into a PostgreSQL integer column that exceeds the maximum value allowed for the integer data type.

To resolve this issue, refer to the below link and choose the proper data format for your field. (You may need to change this column with INT to Bigint.)

https://www.postgresql.org/docs/current/datatype-numeric.html


Hope this helps.

Avatar
Discard
Related Posts Replies Views Activity
3
Jun 24
1835
1
Jan 23
13838
0
Nov 23
832
0
May 23
1413
2
Jun 24
3517