콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다

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
6월 24
2634
1
1월 23
14735
0
11월 23
1195
0
5월 23
1952
2
6월 24
4167