Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0046278 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 02. Master data management | major | always | 2021-04-15 21:38 | 2021-06-02 09:51 | |||
Reporter | gsuarez | View Status | public | |||||
Assigned To | rqueralta | |||||||
Priority | high | Resolution | unable to reproduce | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | marvintm | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0046278: Move retail modulescript to core | |||||||
Description | In an environment WITHOUT having the WhiteValley dataset applied, upgrade to 20Q4.1. When doing update.database, it fails. | |||||||
Steps To Reproduce | 1. Environment 20Q4.1 without retail module installed. 2. Execute ant update.database. 3. View that the compilation fails. [java] 52337 [main] ERROR org.openbravo.retail.posterminal.modulescript.ConvertBrandIntoCharacteristicData - SQL error in query: INSERT INTO m_characteristic( m_characteristic_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, description, ad_tree_id, isvariant, isexplodeconf, em_obpos_filteronwebpos, em_obpos_useonwebpos) VALUES (?, ?,'0', 'Y', now(), '100', now(), '100', 'Brand', null, '899D83A7B7E24F57911A91AE82DCA496','N', 'Y', 'Y', 'Y') :org.postgresql.util.PSQLException: ERROR: inserción o actualización en la tabla «m_characteristic» viola la llave foránea «m_product_tree» [java] Detail: La llave (ad_tree_id)=(899D83A7B7E24F57911A91AE82DCA496) no está presente en la tabla «ad_tree». [java] 52340 [main] ERROR org.openbravo.retail.posterminal.modulescript.ConvertBrandIntoCharacteristic - Errors converting brand into characteristic | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0127367) vmromanos (manager) 2021-04-19 12:01 |
This module script can't be moved to Core because it has dependencies to the POS: INSERT INTO m_characteristic( m_characteristic_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, name, description, ad_tree_id, isvariant, isexplodeconf, *em_obpos_filteronwebpos, em_obpos_useonwebpos*) Anyway, I think the issue is not well reported. The error says that the ad_tree_id '899D83A7B7E24F57911A91AE82DCA496' is not present in the DB, however the module script did insert it (https://gitlab.com/openbravo/devel/pmods/org.openbravo.retail.posterminal/-/blame/master/src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/ConvertBrandIntoCharacteristic_data.xsql#L178 [^]) if it's not available. Assigned issue to Retail team, as the module script belongs to them. Things I have researched: 1. The ad_tree_id '899D83A7B7E24F57911A91AE82DCA496' is available in the white valley sampledata. Why using the same ID? 2. Maybe the problem is when deleting this sampledata, I mean maybe the module script works fine in a default installation, but if you try to run it after deleting the sampledata it fails (just guessing). |
(0128928) marvintm (developer) 2021-06-02 09:51 |
We haven't been able to reproduce this problem. |
Issue History | |||
Date Modified | Username | Field | Change |
2021-04-15 21:38 | gsuarez | New Issue | |
2021-04-15 21:38 | gsuarez | Assigned To | => Triage Finance |
2021-04-15 21:38 | gsuarez | Modules | => Core |
2021-04-15 21:38 | gsuarez | Resolution time | => 1620252000 |
2021-04-15 21:38 | gsuarez | Triggers an Emergency Pack | => No |
2021-04-19 11:51 | vmromanos | Assigned To | Triage Finance => Retail |
2021-04-19 12:01 | vmromanos | Note Added: 0127367 | |
2021-04-26 14:59 | rqueralta | Assigned To | Retail => rqueralta |
2021-06-02 09:51 | marvintm | Review Assigned To | => marvintm |
2021-06-02 09:51 | marvintm | Note Added: 0128928 | |
2021-06-02 09:51 | marvintm | Status | new => closed |
2021-06-02 09:51 | marvintm | Resolution | open => unable to reproduce |
Copyright © 2000 - 2009 MantisBT Group |