تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
1 الرد
1930 أدوات العرض

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.


الصورة الرمزية
إهمال
أفضل إجابة

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.

الصورة الرمزية
إهمال
المنشورات ذات الصلة الردود أدوات العرض النشاط
3
يونيو 24
1864
1
يناير 23
13855
0
نوفمبر 23
834
0
مايو 23
1415
2
يونيو 24
3523