Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0056840Openbravo ERPA. Platformpublic2024-10-19 09:522024-10-21 10:35
AugustoMauch 
AugustoMauch 
urgentmajoralways
closedfixed 
5
 
PR24Q2.4PR24Q2.4 
Core
No
0056840: 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 => PR24Q2.4
2024-10-21 10:21hgbotNote Added: 0170658
2024-10-21 10:23hgbotNote Added: 0170659
2024-10-21 10:35hgbotResolutionopen => fixed
2024-10-21 10:35hgbotStatusscheduled => closed
2024-10-21 10:35hgbotNote Added: 0170660
2024-10-21 10:35hgbotNote Added: 0170661
2024-10-21 10:35hgbotNote Added: 0170662
2024-10-21 10:35hgbotFixed in Version => PR24Q2.4
2024-10-21 10:35hgbotNote Added: 0170663

Notes
(0170658)
hgbot   
2024-10-21 10:21   
Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/51 [^]
(0170659)
hgbot   
2024-10-21 10:23   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1399 [^]
(0170660)
hgbot   
2024-10-21 10:35   
Directly closing issue as related merge request is already approved.

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

Fixes ISSUE-56840: Fixes errors related to storing oids in ints - 24Q2

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

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

Fixes ISSUE-56840: Fixes errors related to storing oids in ints - 24Q2

---
A referencedata/sampledata/F_B_International_Group/C_UOM_MADEUP.xml
M src-db/database/lib/dbsourcemanager.jar
---