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 ]
|
|
 Relationships |
|
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. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |