Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
1906 Vistas

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
Descartar
Mejor respuesta

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
3
jun 24
1829
1
ene 23
13814
0
nov 23
832
0
may 23
1409
2
jun 24
3508