Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0056838Openbravo ERPA. Platformpublic2024-10-19 09:522024-10-21 10:51
AugustoMauch 
AugustoMauch 
urgentmajoralways
closedfixed 
5
 
PR24Q4PR24Q4 
Core
No
0056838: compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272
Executing update.database command, error is happening when the postgresql OID assigned to functions is higher than max int value (2,147,483,647).

java.lang.NumberFormatException: For input string: "2177813260"
    at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.base/java.lang.Integer.parseInt(Integer.java:652)
    at java.base/java.lang.Integer.parseInt(Integer.java:770)
    at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.getOperatorClassName(PostgreSqlModelLoader.java:955)
    at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.readIndex(PostgreSqlModelLoader.java:932)
    at org.apache.ddlutils.platform.ModelLoaderBase$7.getRow(ModelLoaderBase.java:354)
    at org.apache.ddlutils.platform.ModelLoaderBase.readList(ModelLoaderBase.java:665)
    at org.apache.ddlutils.platform.ModelLoaderBase.readIndexes(ModelLoaderBase.java:351)
    at org.apache.ddlutils.platform.ModelLoaderBase.readTable(ModelLoaderBase.java:264)
    at org.apache.ddlutils.platform.ModelLoaderBase$1.getRow(ModelLoaderBase.java:207)
    at org.apache.ddlutils.platform.ModelLoaderBase.readList(ModelLoaderBase.java:665)
    at org.apache.ddlutils.platform.ModelLoaderBase.readTables(ModelLoaderBase.java:203)
    at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:162)
See it being reproduced in ci: https://builds.openbravo.com/job/try-pos2-checks-modules-pgsql/7200/testReport/ [^]
No tags attached.
blocks defect 0056837 closed AugustoMauch compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272 
Issue History
2024-10-19 09:57AugustoMauchTypedefect => backport
2024-10-19 09:57AugustoMauchTarget Version => PR24Q4
2024-10-21 10:46hgbotNote Added: 0170672
2024-10-21 10:47hgbotNote Added: 0170673
2024-10-21 10:51hgbotResolutionopen => fixed
2024-10-21 10:51hgbotStatusscheduled => closed
2024-10-21 10:51hgbotNote Added: 0170677
2024-10-21 10:51hgbotNote Added: 0170678
2024-10-21 10:51hgbotNote Added: 0170679
2024-10-21 10:51hgbotFixed in Version => PR24Q4
2024-10-21 10:51hgbotNote Added: 0170680

Notes
(0170672)
hgbot   
2024-10-21 10:46   
Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/53 [^]
(0170673)
hgbot   
2024-10-21 10:47   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1401 [^]
(0170677)
hgbot   
2024-10-21 10:51   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: 7f745bdbdfae131ca3c48955fc2c987ced66b197
Author: Augusto Mauch <a.mauch@orisha.com>
Date: 21-10-2024 10:46:01
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/7f745bdbdfae131ca3c48955fc2c987ced66b197 [^]

Fixes ISSUE-56838: Fixes errors related to storing oids in ints - 24Q4

---
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---
(0170678)
hgbot   
2024-10-21 10:51   
Merge request merged: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/53 [^]
(0170679)
hgbot   
2024-10-21 10:51   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1401 [^]
(0170680)
hgbot   
2024-10-21 10:51   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 1add13f75e45a39bbbd2d8de1ccc33541e9cdf96
Author: Augusto Mauch <a.mauch@orisha.com>
Date: 21-10-2024 10:46:37
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/1add13f75e45a39bbbd2d8de1ccc33541e9cdf96 [^]

Fixes ISSUE-56838: Fixes errors related to storing oids in ints - 24Q4

---
M src-db/database/lib/dbsourcemanager.jar
---