Openbravo Issue Tracking System - Retail Modules
View Issue Details
0054745Retail ModulesCopy Retail Storepublic2024-02-22 13:382024-03-13 07:10
ngarcia 
sreehari 
urgentmajoralways
closedfixed 
5
 
 
No
0054745: Copy Retail Store process fails if G/L Category records assigned to the origin org are not accessible for the new organization
Copy Retail Store process fails if G/L Category records assigned to the origin org are not accessible for the new organization

The G/L Category records are created within some datasets that also create Document Types and can be applied at the legal org level.

Although before launching the Copy Retail Store process, new G/L Category records are created within * or the newly created org (Initial Org Setup) the process fails too
In https://livebuilds.openbravo.com/context/retail_modules_pgsql_pi [^]

1) Create the Copy Store Parametrization, fill in all the fields
2) Change the organization of None G/L Category from * to Vall Blanca Store
3) Launch Copy Store process (attached the image with the parameters) and check it fails with

Process failed:
There were errors during the process, see the execution log for more details

ERROR: null value in column "gl_category_id" violates not-null constraint
  Detail: Failing row contains (B3802C1440D7475EAE53EC2B121616E1, 39363B0921BB4293B48383844325E84C, 20A9F471BF194836AECD3D08411E9E50, Y, 2024-02-22 12:31:50.713, 100, 2024-02-22 12:31:50.713, 100, TEST POS Order, VBS Order Confirmation, null, SOO, Y, WR, null, null, Y, A722DA6B309C41A29E6E003E69987855, null, null, N, 0, 259, N, null, N, N, N, null, null, null)
No tags attached.
png CopyStore.png (40,406) 2024-03-05 12:10
https://issues.openbravo.com/file_download.php?file_id=19520&type=bug
png
Issue History
2024-02-22 13:38ngarciaNew Issue
2024-02-22 13:38ngarciaAssigned To => Retail
2024-02-22 13:38ngarciaTriggers an Emergency Pack => No
2024-02-22 13:43PracticsIssue Monitored: Practics
2024-02-23 12:55ngarciaSummaryCopy Retail Store process fails if G/L Category records are not accessible for the new organization => Copy Retail Store process fails if G/L Category records assigned to the origin org are not accessible for the new organization
2024-02-23 12:55ngarciaDescription Updatedbug_revision_view_page.php?rev_id=27586#r27586
2024-03-05 11:17sreehariAssigned ToRetail => sreehari
2024-03-05 12:10ngarciaFile Added: CopyStore.png
2024-03-07 07:08sreehariStatusnew => scheduled
2024-03-12 14:12hgbotNote Added: 0162027
2024-03-12 14:13hgbotNote Added: 0162028
2024-03-13 07:10hgbotResolutionopen => fixed
2024-03-13 07:10hgbotStatusscheduled => closed
2024-03-13 07:10hgbotNote Added: 0162044
2024-03-13 07:10hgbotNote Added: 0162045
2024-03-13 07:10hgbotNote Added: 0162046
2024-03-13 07:10hgbotNote Added: 0162047

Notes
(0162027)
hgbot   
2024-03-12 14:12   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.copystore/-/merge_requests/58 [^]
(0162028)
hgbot   
2024-03-12 14:13   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1168 [^]
(0162044)
hgbot   
2024-03-13 07:10   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.copystore [^]
Changeset: d7fbd97a103e2dc7886883ffb6b3cc1e5a259022
Author: Sreehari Venkataraman <sreehari.venkataraman.ext@openbravo.com>
Date: 12-03-2024 14:59:50
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.copystore/-/commit/d7fbd97a103e2dc7886883ffb6b3cc1e5a259022 [^]

Fixes ISSUE-54745: Created handleProperty override for gLCategory
*it handles the orgTreeAccess and sets the original property else
*it creates a new category for the org and sets it

---
M src/org/openbravo/retail/copystore/process/DefaultPropertiesHandler.java
---
(0162045)
hgbot   
2024-03-13 07:10   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.copystore/-/merge_requests/58 [^]
(0162046)
hgbot   
2024-03-13 07:10   
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 60f2e193b0fbd59959361c1d2ee46f1e0c1f4658
Author: Sreehari Venkataraman <sreehari.venkataraman.ext@openbravo.com>
Date: 12-03-2024 18:36:22
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/60f2e193b0fbd59959361c1d2ee46f1e0c1f4658 [^]

Related ISSUE-54745: Changed the active status of DocBaseType Column
*Changed the active status of Document Category Field

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0162047)
hgbot   
2024-03-13 07:10   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1168 [^]