Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0020743 | Openbravo ERP | A. Platform | public | 2012-06-13 11:19 | 2012-06-27 05:29 |
|
| Reporter | sureshbabu | |
| Assigned To | marvintm | |
| Priority | high | Severity | major | Reproducibility | random |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Community Appliance |
| Product Version | pi | |
| Target Version | 3.0MP13 | Fixed in Version | 3.0MP13 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | Internet Explorer |
| Modules | Openbravo 3.0 |
| Support ticket | |
| Regression level | Production - Confirmed Stable |
| Regression date | 2009-02-25 |
| Regression introduced in release | |
| Regression introduced by commit | http://code.openbravo.com/erp/devel/pi/rev/4930b9515f5167311d198cc6b06568f6262779e4 [^] |
| Triggers an Emergency Pack | No |
|
| Summary | 0020743: Reference data error appears when i rebuild the system after installing spanish localization pack |
| Description | Reference data error appears when i rebuild the system after installing spanish localization pack |
| Steps To Reproduce | 1) Login in as System Admin role
2) Navigate to module management window
3) In Add modules add, try to add Localization pack spain
4) After adding the module, then try to rebuild the system, by clicking the rebuild link
System throws error message as reference data issue
Note: Please look into the attached image for reference |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0007805 | | closed | alostale | Unistall a module with ad_process fails |
|
| Attached Files |  Reference data issue while rebuilding the system after installing the Spanish localization pack.png (171,176) 2012-06-13 11:19
https://issues.openbravo.com/file_download.php?file_id=5288&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-06-13 11:19 | sureshbabu | New Issue | |
| 2012-06-13 11:19 | sureshbabu | Assigned To | => alostale |
| 2012-06-13 11:19 | sureshbabu | File Added: Reference data issue while rebuilding the system after installing the Spanish localization pack.png | |
| 2012-06-13 11:19 | sureshbabu | Web browser | => Internet Explorer |
| 2012-06-13 11:19 | sureshbabu | Modules | => Openbravo 3.0 |
| 2012-06-13 11:21 | sureshbabu | Note Added: 0049800 | |
| 2012-06-14 12:02 | marvintm | Assigned To | alostale => marvintm |
| 2012-06-14 12:04 | marvintm | Note Added: 0049833 | |
| 2012-06-19 13:25 | shuehner | Web browser | Internet Explorer => Internet Explorer |
| 2012-06-19 13:25 | shuehner | Regression level | => Production - Confirmed Stable |
| 2012-06-19 13:25 | shuehner | Regression date | => 2009-02-25 |
| 2012-06-19 13:25 | shuehner | Regression introduced by commit | => http://code.openbravo.com/erp/devel/pi/rev/4930b9515f5167311d198cc6b06568f6262779e4 [^] |
| 2012-06-19 13:25 | shuehner | Target Version | => 3.0MP13 |
| 2012-06-19 15:30 | alostale | Relationship added | related to 0007805 |
| 2012-06-22 09:08 | marvintm | Note Added: 0050010 | |
| 2012-06-22 09:11 | hgbot | Checkin | |
| 2012-06-22 09:11 | hgbot | Note Added: 0050012 | |
| 2012-06-22 09:11 | hgbot | Status | new => resolved |
| 2012-06-22 09:11 | hgbot | Resolution | open => fixed |
| 2012-06-22 09:11 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/889f630ff69db889a5acc53f17d0be858ac16e93 [^] |
| 2012-06-25 10:07 | AugustoMauch | Note Added: 0050055 | |
| 2012-06-25 10:07 | AugustoMauch | Status | resolved => closed |
| 2012-06-25 10:07 | AugustoMauch | Fixed in Version | => 3.0MP13 |
| 2012-06-27 05:29 | hudsonbot | Checkin | |
| 2012-06-27 05:29 | hudsonbot | Note Added: 0050157 | |
|
Notes |
|
|
|
|
I am not getting the error always.(Randomly the above issue raises) |
|
|
|
|
The issue can be reproduced by:
- Installing the Spanish Localization Pack.
- Uninstalling it.
- Installing it again. This last rebuild will fail. |
|
|
|
|
There are actually two different errors here:
- There is a foreign key marked as "on delete cascade" in the AD_Ref_data_Loaded table, pointing to the ad_module table. This foreign key is wrong, and is responsible for creating the error in case a module with reference data is installed, uninstalled, and installed back again.
- Also, the process which applies reference data doesn't take into account the ad_ref_data_loaded table when working with data at system level. This is also wrong, because it can lead to errors in case the access level of the table is "System/Client". A separate issue for this was logged here: https://issues.openbravo.com/view.php?id=20822. [^] Note that this second problem is not a regression: DAL never checked for ad_ref_data_loaded in system-level entities.
The first error will be fixed as part of this issue. The second error breaks the process for sampledata in MP10-MP11, but doesn't break it in MP12 and subsequent versions because the ids of the regions were changed. |
|
|
|
(0050012)
|
|
hgbot
|
|
2012-06-22 09:11
|
|
Repository: erp/devel/pi
Changeset: 889f630ff69db889a5acc53f17d0be858ac16e93
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Jun 22 09:11:05 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/889f630ff69db889a5acc53f17d0be858ac16e93 [^]
Fixed issue 20743. Removed wrong foreign key.
This foreign key basically killed all ad_ref_data_loaded information in case the module which contained the original reference data was uninstalled. If the user then installed the module again, and tried to apply the dataset, the process failed.
---
M src-db/database/model/tables/AD_REF_DATA_LOADED.xml
---
|
|
|
|
|
|
Code reviewed and verified in pi@e62a369d2763 |
|
|
|
|
|