Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010562Openbravo ERPA. Platformpublic2009-09-11 13:312009-10-16 00:00
vmromanos 
alostale 
urgentmajoralways
closedfixed 
20Ubuntu 8.04
pi 
 
Core
No
0010562: Upgrading packs with new modules doesn't work
Upgrading a pack with new modules doesn't work. The new modules are not installed and the old ones are not upgraded. Moreover, in a step of the process below, the application installs a modules without a mandatory dependency.

Please see the steps to reproduce to understand it better

1- I have installed the Spanish Localization Pack 1.0.2.
2- A new version of the pack is available which includes more modules.
3- I try to upgrade my package, the Module Management console shows the new version of the pack with the new modules inside. I mark it to update, I rebuild the system.
4- When I go again to the Module Management console, I see that the new modules of the pack are not installed and the modules inside (from the previous version of the pack) have not been updated. However the pack version is updated.
5- I search again for updates, new version of the modules are detected (see mmc.png). I mark the updates and rebuild the system again. The installation seems to be OK, except for this error:

SQL Command failed with: ERROR: no existe la restricción «admoduledependency_admodule2»
-- END
ALTER TABLE AD_MODULE_DEPENDENCY
DROP CONSTRAINT ADMODULEDEPENDENCY_ADMODULE2

6- Again in the Module Management console, I click for updates and another module is displayed to be upgraded (see mmc1.png). But the most import thing is that one of the modules (Taxes for Spain version 1.0.5) has been installed without a mandatory dependency (the Spanish tax module improved 0.0.5), which is available in the Central repository and in the new version of the Spanish Localization Pack (see nodependency.png)

7- I rebuild the system again. Two errors appear again in the log:

SQL Command failed with: ERROR: no existe la restricción «admoduledependency_admodule2»
-- END
ALTER TABLE AD_MODULE_DEPENDENCY
DROP CONSTRAINT ADMODULEDEPENDENCY_ADMODULE2

SQL Command failed with: ERROR: inserción o actualización en la tabla «ad_module_dependency» viola la llave foránea «admoduledependency_admodule2»
Detail: La llave (ad_dependent_module_id)=(109C0BBA336D49F7AC5BD4B5D75D33D8) no está presente en la tabla «ad_module».
-- END

8- I go again to the Module management console, scan for updates and not updates are detected.


The final situation is that the new modules of the package are not installed and I have an installed module without a mandatory dependency.
No tags attached.
related to defect 00106772.50MP7 closed alostale Dependencies are not working well under some circumstances 
png mmc.png (215,415) 2009-09-11 13:31
https://issues.openbravo.com/file_download.php?file_id=1740&type=bug
png

png mmc1.png (279,905) 2009-09-11 13:32
https://issues.openbravo.com/file_download.php?file_id=1741&type=bug
png nodependency.png (197,465) 2009-09-11 13:32
https://issues.openbravo.com/file_download.php?file_id=1742&type=bug
png
Issue History
2009-09-11 13:31vmromanosNew Issue
2009-09-11 13:31vmromanosAssigned To => rafaroda
2009-09-11 13:31vmromanosFile Added: mmc.png
2009-09-11 13:32vmromanosFile Added: mmc1.png
2009-09-11 13:32vmromanosFile Added: nodependency.png
2009-09-11 15:40rafarodaAssigned Torafaroda => alostale
2009-09-11 15:40rafarodaPriorityimmediate => urgent
2009-09-11 15:40rafarodaStatusnew => scheduled
2009-10-05 11:19alostaleRelationship addedrelated to 0010677
2009-10-05 15:00alostaleStatusscheduled => resolved
2009-10-05 15:00alostaleFixed in SCM revision => --
2009-10-05 15:00alostaleResolutionopen => fixed
2009-10-05 15:00alostaleNote Added: 0020707
2009-10-15 19:01marvintmStatusresolved => closed
2009-10-15 19:01marvintmNote Added: 0021088
2009-10-16 00:00anonymoussf_bug_id0 => 2880175

Notes
(0020707)
alostale   
2009-10-05 15:00   
This is an issue with CR which has been solved.
(0021088)
marvintm   
2009-10-15 19:01   
I installed Spanish Localization Pack 1.0.2. After that, I clicked on "Scan for updates", and got a newer version, which included more modules.

I installed it, and the additional modules were installed just fine. I rebuilt the system, and the process was completed without any problems.