Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048500Retail ModulesRetail APIpublic2022-01-28 10:112022-03-22 17:47
Reportersebastien_liron 
Assigned Torqueralta 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product VersionRR20Q3.4 
Target VersionRR20Q3.4Fixed in VersionRR22Q2 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0048500: The json generated from order loader to give import entry is too big
DescriptionThe json generated from order loader to give import entry is too big

a lots of fields like inside the product object or the bp object that are not needed ( should not be at least).
this can create over 1M chars limit we have on the import entry field when we integrate orders with a lots of lines.
Steps To Reproduce- integrate an order like this one :

see file : FRA274_02740011860411074499_IN(1).json

- the json generated should looks like :

see file : FRA274_02740011860411074499_OUT (1).json
Proposed Solution
Additional Information
TagsNOR
Relationships
has duplicate defect 0050606RR22Q1.2 closed ranjith_qualiantech_com Jsoninfo column size in Error While Importing window should be increased to 40M 
related to defect 0048922 closed ranjith_qualiantech_com The json generated from order loader for responseJosn field too big 
Attached Files? FRA274_02740011860411074499_IN (1).json (962) 2022-01-28 10:11
https://issues.openbravo.com/file_download.php?file_id=16561&type=bug
? FRA274_02740011860411074499_OUT (1).json (22,250) 2022-01-28 10:11
https://issues.openbravo.com/file_download.php?file_id=16562&type=bug
? FRA274_02740011860411074499_IN (2).json (150,401) 2022-03-02 11:16
https://issues.openbravo.com/file_download.php?file_id=16688&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-01-28 10:11sebastien_lironNew Issue
2022-01-28 10:11sebastien_lironAssigned To => Retail
2022-01-28 10:11sebastien_lironFile Added: FRA274_02740011860411074499_IN (1).json
2022-01-28 10:11sebastien_lironTriggers an Emergency Pack => No
2022-01-28 10:11sebastien_lironFile Added: FRA274_02740011860411074499_OUT (1).json
2022-01-28 10:11sebastien_lironSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=23583#r23583
2022-01-28 10:12sebastien_lironSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=23584#r23584
2022-01-29 08:04rafarodaTag Attached: NOR
2022-02-03 07:08ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2022-02-03 14:11marvintmAssigned Toranjith_qualiantech_com => rqueralta
2022-03-02 11:16sebastien_lironFile Added: FRA274_02740011860411074499_IN (2).json
2022-03-02 11:17sebastien_lironNote Added: 0135380
2022-03-19 14:03hgbotNote Added: 0135864
2022-03-21 04:56rqueraltaStatusnew => scheduled
2022-03-22 07:37hgbotResolutionopen => fixed
2022-03-22 07:37hgbotStatusscheduled => closed
2022-03-22 07:37hgbotFixed in Version => PR22Q2
2022-03-22 07:37hgbotNote Added: 0135908
2022-03-22 07:37hgbotNote Added: 0135909
2022-03-22 17:42hgbotNote Added: 0135926
2022-03-22 17:43hgbotNote Added: 0135927
2022-03-22 17:47hgbotFixed in VersionPR22Q2 => RR22Q2
2022-03-22 17:47hgbotNote Added: 0135928
2022-03-22 17:47hgbotNote Added: 0135929
2022-03-22 17:47hgbotNote Added: 0135930
2022-03-22 17:47hgbotNote Added: 0135931
2022-03-29 12:26sebastien_lironRelationship addedrelated to 0048922
2022-10-31 07:18ranjith_qualiantech_comRelationship addedhas duplicate 0050606

Notes
(0135380)
sebastien_liron   
2022-03-02 11:17   
adding FRA274_02740011860411074499_IN (2).json file that is a real example of an order that create more than 1M chars, I dont have the out since it is not created in the DB, but should be reproducible in test env
(0135864)
hgbot   
2022-03-19 14:03   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/540 [^]
(0135908)
hgbot   
2022-03-22 07:37   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 7f96e93beb5ba7d70224d024a35e144193eaf374
Author: Rafael Queralta <rafaelcuba81@gmail.com>
Date: 19-03-2022 09:00:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/7f96e93beb5ba7d70224d024a35e144193eaf374 [^]

Fixed BUG-48500: Increased length of jsoninfo column

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0135909)
hgbot   
2022-03-22 07:37   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/540 [^]
(0135926)
hgbot   
2022-03-22 17:42   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/50 [^]
(0135927)
hgbot   
2022-03-22 17:43   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/749 [^]
(0135928)
hgbot   
2022-03-22 17:47   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 363d652d96f304ecf7c93dd6bba4aaad0b7a9544
Author: Rafael Queralta <rafaelcuba81@gmail.com>
Date: 22-03-2022 12:37:03
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/363d652d96f304ecf7c93dd6bba4aaad0b7a9544 [^]

Fixed BUG-48500: Increased length of jsoninfo column

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0135929)
hgbot   
2022-03-22 17:47   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/749 [^]
(0135930)
hgbot   
2022-03-22 17:47   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 844e1a8e024fa6cdeb9a5a05e97e51653eb09d0c
Author: Rafael Queralta <rafaelcuba81@gmail.com>
Date: 22-03-2022 12:41:19
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/844e1a8e024fa6cdeb9a5a05e97e51653eb09d0c [^]

Fixed BUG-48500: Increased length of jsoninfo column

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0135931)
hgbot   
2022-03-22 17:47   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/50 [^]