Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2021-02-22 20:212021-02-23 13:59
ReporterlbressanView Statuspublic 
Assigned ToRetail 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionPR20Q4.1SCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0045935: Errors when migrating brands to product characteristics when upgrading to 20Q4.1

DescriptionWhen you want to migrate to the latest version of OB 20Q4.1, the Marks migration module script fails: "". Note that the environment does not have the "org.openbravo.retail.sampledata" module installed. Then the error message is as follows:
"[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', 'Y') :org.postgresql.util.PSQLException: ERROR: insert or update on table "m_characteristic" violates foreign key "m_product_tree"
[java] Detail: key (ad_tree_id)=(899D83A7B7E24F57911A91AE82DCA496) is not present in table "ad_tree".
java] 52340 [main] ERROR org.openbravo.retail.posterminal.modulescript.ConvertBrandIntoCharacteristic - Errors converting brand into characteristic".

This is because the (ad_tree_id)=899D83A7B7E24F57911A91AE82DCA496) is inserted in the database when installing the module "org.openbravo.retail.sampledata" which is not a mandatory module when installing Retail in an environment.
Also note that if an environment does not have retail when upgrading to the new version of Openbravo, the brand window is no longer available, so you will not be able to add new brands and you will not be able to migrate brands to product characteristics, because the module script belongs to the retail module "org.openbravo.retail.posterminal".
Steps To Reproduce1. Note that you do not have the "org.openbravo.retail.sampledata" module installed.
2. Upgrading an OB environment to the latest version: note that you do not have the "org.openbravo.retail.sampledata" module installed.
3. Try to do the database update and the compile.

Expected behavior:
 a. The brand update module script should be outside of the retail module.

 b. The data used in the module script such as the ad_tree_id should be in a module that is always installed in the environment.
TagsNo tags attached.
Attached Filespng file icon grep.png [^] (34,222 bytes) 2021-02-22 20:21

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2021-02-22 20:21 lbressan New Issue
2021-02-22 20:21 lbressan Assigned To => Triage Finance
2021-02-22 20:21 lbressan File Added: grep.png
2021-02-22 20:21 lbressan Modules => Core
2021-02-22 20:21 lbressan Triggers an Emergency Pack => No
2021-02-23 09:33 dmiguelez Description Updated View Revisions
2021-02-23 09:42 Practics Issue Monitored: Practics
2021-02-23 10:34 dmiguelez Assigned To Triage Finance => Retail

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker