Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0009064 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | always | 2009-05-18 01:50 | 2009-08-28 14:54 | |||
Reporter | fgredruello | View Status | public | |||||
Assigned To | alostale | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 2ef5d9d87057 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_10-b33 | |||
OS Version | Ubuntu 8.10 | Database version | 8.3.7 | Ant version | 1.7.1 | |||
Product Version | 2.50MP1 | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0009064: Duplicate primary key in table AD_Element_Trl - Installing Spanish Translation Module | |||||||
Description | Installing module Spanish Translation from module management tool, when rebuild show an error: Duplicate primary key in table AD_Element_Trl. The sequence number for this table must be updated. Please contact your Openbravo Administrator. Try with: 2.50, 250MP1 and the same with virtual appliances VMWARE. | |||||||
Steps To Reproduce | - Download from sourceforge OpenbravoERP 2.50 Vmware appliance - Add virtual machine to inventory - Upgrade to 1Gb memory hardware - Power on virtual machine - Open browser, with user login Openbravo Openbravo Openbravo and password - Go to General Setup> Application> Management Module - Add modules - Spanish localization Pack - Rebuild pending changes | |||||||
Tags | No tags attached. | |||||||
Attached Files | 20090518001835-apply.zip [^] (600,428 bytes) 2009-05-18 01:54 install-spanish-translation.log [^] (14,899 bytes) 2009-05-25 14:09 20090610045021-apply.log [^] (32,309 bytes) 2009-06-10 05:42 20090610054601-apply.zip [^] (600,395 bytes) 2009-06-10 06:08 | |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |||||||||||||||
|
Notes | |
(0016429) fgredruello (reporter) 2009-05-18 16:03 |
All test, running Openbravo under Vmware Server 2.0.1 and Vmware Workstation 6.5 |
(0016501) psarobe (manager) 2009-05-20 12:10 |
This have been tested in 250VM, and 250 from sources and works fine. Can you confirm you test in those environments? |
(0016502) rafaroda (developer) 2009-05-20 12:12 |
Using pi I was able to install Spanish Translation module and operate the application in Spanish. Please double-check it and let us know your result. Severity has been downgraded to Major. |
(0016542) fgredruello (reporter) 2009-05-21 00:51 |
Test Environment 1: Base: Centos 5.3 - Vmware server 2.0.1 V. Machine: Ubuntu 8.10 Openbravo version: 2.50 from package .tgz; 2.50 and 2.50MP1 from mercurial repository Test Environment 2: Base: Windows vista x64 - Vmware Workstation 6.5 V.Machine: Image downloaded from sourceforge, openbravo vmware appliances Openbravo version: 2.50 y 2.50 MP1 |
(0016552) rafaroda (developer) 2009-05-21 11:03 |
Does the error still reproduces in Test Environment 2? |
(0016581) fgredruello (reporter) 2009-05-22 15:04 |
Yes, the same error is reproduced in Test Environment 2. |
(0016582) rafaroda (developer) 2009-05-22 15:55 |
Does the Rebuild process finish? Are you able to change the language to Spanish? |
(0016589) fgredruello (reporter) 2009-05-22 16:17 |
Yes, the rebuild process finish and prompt for restart de tomcat instance. After restart, reload browser, login to Openbravo and under user properties is avaible "Spanish" in language comboField. In the language option, I chose Spanish, refresh interface but has not effect and the interface is in "English". |
(0016622) rafaroda (developer) 2009-05-25 14:08 |
Hi, I've installed org.openbravo.localization.spain.referencedata.translation.esES-1.0.1.obx in pi without problem. See attached log. Please re-open this issue if you are able to reproduce it systematically with the last code revision of Openbravo ERP and the module. Thank you for your feedback. |
(0016661) fgredruello (reporter) 2009-05-26 15:13 |
Hi, I made the following tests, installing the module spanish localization in virtual appliances: 1 .- ERP 2.50 - VirtualBox Appliance - Result = OK Same steps as with VMWare. 2 .- ERP 2.50 - VMWare Appliance - Result = ERROR Host: Windows 2003 Server Vmware server version: 2.0.1 Steps to reproduce: - Download from sourceforge OpenbravoERP 2.50 Vmware appliance - Add virtual machine to inventory - Upgrade to 1Gb memory hardware - Power on virtual machine - Open browser, with user login Openbravo Openbravo Openbravo and password - Go to General Setup> Application> Management Module - Add modules - Spanish localization Pack - Rebuild pending changes Result = same error in the Rebuild Thank you. General Setup > Application > Module Management > Installation History Date and time Action User Module Name Log 26-05-2009 12:57:10 Build System System Build failed, message: Duplicate primary key in table AD_Message_Trl. The sequence number for this table must be updated. Please contact your Openbravo Administrator 26-05-2009 12:38:06 Install module Openbravo Alerts: Accounting Installed module Alerts: Accounting - 1.0.0 26-05-2009 12:38:06 Install module Openbravo Chart of accounts: PGC 2007 PYMEs Installed module Chart of accounts: PGC 2007 PYMEs - 1.0.0 26-05-2009 12:38:06 Install module Openbravo Translation: Spanish-Spain (es_ES) español-España Installed module Translation: Spanish-Spain (es_ES) español-España - 1.0.1 26-05-2009 12:38:06 Install module Openbravo Chart of accounts: PGC 2007 General Installed module Chart of accounts: PGC 2007 General - 1.0.0 26-05-2009 12:38:06 Install module Openbravo Taxes: configuration for Spain (Impuestos para España) Installed module Taxes: configuration for Spain (Impuestos para España) - 1.0.0 26-05-2009 12:38:06 Install module Openbravo Localization pack Spain (España) Installed module Localization pack Spain (España) - 1.0.2 |
(0017119) fgredruello (reporter) 2009-06-09 03:33 |
He probado también ha instalar OB 2.50 sobre Centos 5.3 x64, continúo con el mismo problema. Siempre es el mismo error, he perdido la cuenta de las instalaciones que llevo realizadas, pienso que tiene algo que ver con el paquete uuid y postgres. |
(0017121) rafaroda (developer) 2009-06-09 09:12 |
Juan Pablo, Do you know if some UUID problem could arise in the Virtual Appliance? * UUID not installed (I do not think that this is the problem). * UUID generation problem. Thanks. |
(0017123) jpabloae (reporter) 2009-06-09 09:26 |
Hi Rafa, We use a standard PostgreSQL 8.3.7 and a standard OSSP-UUID 1.6.2. So I would not expect anything special in the UUID generation of the appliance's PostgreSQL, compared to the defaults. |
(0017127) fgredruello (reporter) 2009-06-09 10:04 |
Hello, The last test I have done on vmware server 2.01, installing Centos 5.3 and Ubuntu 8.04 both 64 Bit. Installing all packages from source. Postgresql 8.3.7 Centos: uuid 1.6.2 - http://www.ossp.org/pkg/lib/uuid/ [^] Ubuntu: postgresql-contrib Tomcat 6.0.20 Ant 1.7.1 I could give you access to the machine, if you think that can help. I hope can be helpful. Thank you. |
(0017155) fgredruello (reporter) 2009-06-10 05:43 |
Hi, I installed the module "solitario" to test, with result = OK. This module insert any record in the database with UUID? This will discard any permissions problem? Attach log: 20090610045021-apply.log Sorry for my English ... :( Thank you. |
(0017156) fgredruello (reporter) 2009-06-10 06:10 |
Hi, I Attach other log 20090610054601-apply.zip = Spanish translation install. Result = ERROR, Duplicate primary key. |
(0017158) jpabloae (reporter) 2009-06-10 08:27 |
I cannot reproduce this issue in the 2.50MP1 appliance. Rafa: I don't think I can help on this issue, I recommend asking marvintm. |
(0017159) rafaroda (developer) 2009-06-10 08:59 |
@ fgredruello: thanks for the detailed information provided. Regarding UUID generation, it is done each time a new record is inserted in the database: no need to install a module, just insert data in any window of Openbravo ERP. @marvintm: could you please give any advice on this issue? Thanks. |
(0017425) rafaroda (developer) 2009-06-18 15:45 |
More info @ http://forge.openbravo.com/plugins/espforum/view.php?group_id=100&forumid=650010&topicid=6995088 [^] |
(0017721) networkb (developer) 2009-07-01 11:00 |
I have a similar problem when executing the very language process, at General Setup || Application || Language window after click on system language checkbox. I am using ubunto 8.04 and postgresql8.3.7 and postgres-contrib 8.3.7. |
(0017897) networkb (developer) 2009-07-03 17:06 |
I have solved the problem using uuid_generate_v4 instead of uuid_generate_v1 funciont. It seems that there is a problem generating uuid's using mac and time as the uuid_generate_v1 function does. The uuid_generate_v4 function does not use the mac and the time |
(0018035) alostale (manager) 2009-07-09 08:15 |
uuid_generate_v1 is used because is the more similar one to the Oracle's sys_guid(). Anyway I don't think there's problem in using uuid_generate_v4 |
(0018037) hgbot (developer) 2009-07-09 08:27 |
Repository: erp/devel/pi Changeset: 5298069c188b699f7dfc6c7a0c2ab67618d4a15a Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Jul 09 08:24:01 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/5298069c188b699f7dfc6c7a0c2ab67618d4a15a [^] fixed bug 0009064: Duplicate primary key in table AD_Element_Trl - Installing Spanish Translation Module Use uuid_generate_v4 instead of uuid_generate_v1 for PG UUID generation --- M src-db/database/model/prescript-PostgreSql.sql --- |
(0018038) hgbot (developer) 2009-07-09 08:27 |
Repository: erp/devel/pi Changeset: 2ef5d9d87057b471f00c8a44b2a0093fbdb18e4e Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Jul 09 08:26:31 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/2ef5d9d87057b471f00c8a44b2a0093fbdb18e4e [^] issue 9064: exclude uuid_generate_v4 from not exported functions --- M src-db/src/com/openbravo/db/OpenbravoExcludeFilter.java --- |
(0018043) rafaroda (developer) 2009-07-09 09:19 |
According to plujan, a bad configuration of the connection for the VMWare Virtual Machine can cause its MAC address to be 00:00:00:00:00:00 This increases the probability to generate similar UUID which seems to be happening. This would not happen in a properly configure VMWare Virtual Machine or in a properly configured server. Using uuid_generate_v4 function which does not use the MAC address, as the fix proposes should solve the problem. |
(0018365) plujan (manager) 2009-07-17 13:51 |
Installing of Pack for Spain succeed, although this verification is not enough since it never failed before. Reporter should try this fix in order to fully complete the validation. |
(0019267) fgredruello (reporter) 2009-08-28 14:54 |
Tested with version 2.50MP3, no problem, installing the module Spanish Pack = Ok. Everything solved. Thanks! |
Issue History | |||
Date Modified | Username | Field | Change |
2009-05-18 01:50 | fgredruello | New Issue | |
2009-05-18 01:50 | fgredruello | Assigned To | => rafaroda |
2009-05-18 01:53 | fgredruello | Issue Monitored: fgredruello | |
2009-05-18 01:54 | fgredruello | File Added: 20090518001835-apply.zip | |
2009-05-18 16:03 | fgredruello | Note Added: 0016429 | |
2009-05-20 12:10 | psarobe | Note Added: 0016501 | |
2009-05-20 12:10 | psarobe | Status | new => feedback |
2009-05-20 12:12 | rafaroda | Note Added: 0016502 | |
2009-05-20 12:12 | rafaroda | Severity | critical => major |
2009-05-21 00:51 | fgredruello | Note Added: 0016542 | |
2009-05-21 11:03 | rafaroda | Note Added: 0016552 | |
2009-05-22 15:04 | fgredruello | Note Added: 0016581 | |
2009-05-22 15:55 | rafaroda | Note Added: 0016582 | |
2009-05-22 16:17 | fgredruello | Note Added: 0016589 | |
2009-05-22 17:51 | rafaroda | Status | feedback => new |
2009-05-25 14:08 | rafaroda | Status | new => closed |
2009-05-25 14:08 | rafaroda | Note Added: 0016622 | |
2009-05-25 14:08 | rafaroda | Resolution | open => unable to reproduce |
2009-05-25 14:09 | rafaroda | File Added: install-spanish-translation.log | |
2009-05-26 00:00 | anonymous | sf_bug_id | 0 => 2796604 |
2009-05-26 15:13 | fgredruello | Note Added: 0016661 | |
2009-06-09 03:33 | fgredruello | Status | closed => new |
2009-06-09 03:33 | fgredruello | Resolution | unable to reproduce => open |
2009-06-09 03:33 | fgredruello | Note Added: 0017119 | |
2009-06-09 09:12 | rafaroda | Note Added: 0017121 | |
2009-06-09 09:12 | rafaroda | Assigned To | rafaroda => jpabloae |
2009-06-09 09:26 | jpabloae | Note Added: 0017123 | |
2009-06-09 10:04 | fgredruello | Note Added: 0017127 | |
2009-06-10 05:42 | fgredruello | File Added: 20090610045021-apply.log | |
2009-06-10 05:43 | fgredruello | Note Added: 0017155 | |
2009-06-10 06:08 | fgredruello | File Added: 20090610054601-apply.zip | |
2009-06-10 06:10 | fgredruello | Note Added: 0017156 | |
2009-06-10 08:27 | jpabloae | Note Added: 0017158 | |
2009-06-10 08:27 | jpabloae | Assigned To | jpabloae => rafaroda |
2009-06-10 08:59 | rafaroda | Note Added: 0017159 | |
2009-06-10 08:59 | rafaroda | Assigned To | rafaroda => marvintm |
2009-06-10 08:59 | rafaroda | Priority | normal => high |
2009-06-10 08:59 | rafaroda | Proposed Solution updated | |
2009-06-10 17:40 | psarobe | Status | new => feedback |
2009-06-18 15:45 | rafaroda | Note Added: 0017425 | |
2009-06-22 10:00 | rafaroda | Status | feedback => scheduled |
2009-06-22 10:00 | rafaroda | fix_in_branch | => pi |
2009-07-01 11:00 | networkb | Note Added: 0017721 | |
2009-07-01 11:00 | networkb | Priority | high => immediate |
2009-07-01 11:00 | networkb | fix_in_branch | pi => |
2009-07-03 16:13 | pjuvara | Priority | immediate => urgent |
2009-07-03 17:06 | networkb | Note Added: 0017897 | |
2009-07-06 13:29 | rafaroda | Relationship added | related to 0009737 |
2009-07-08 13:48 | pjuvara | Priority | urgent => immediate |
2009-07-08 15:40 | rafaroda | Assigned To | marvintm => alostale |
2009-07-08 15:40 | rafaroda | Category | F. Localization => A. Platform |
2009-07-09 08:15 | alostale | Note Added: 0018035 | |
2009-07-09 08:27 | hgbot | Checkin | |
2009-07-09 08:27 | hgbot | Note Added: 0018037 | |
2009-07-09 08:27 | hgbot | Status | scheduled => resolved |
2009-07-09 08:27 | hgbot | Resolution | open => fixed |
2009-07-09 08:27 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/5298069c188b699f7dfc6c7a0c2ab67618d4a15a [^] |
2009-07-09 08:27 | hgbot | Checkin | |
2009-07-09 08:27 | hgbot | Note Added: 0018038 | |
2009-07-09 08:27 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/5298069c188b699f7dfc6c7a0c2ab67618d4a15a [^] => http://code.openbravo.com/erp/devel/pi/rev/2ef5d9d87057b471f00c8a44b2a0093fbdb18e4e [^] |
2009-07-09 09:19 | rafaroda | Note Added: 0018043 | |
2009-07-17 13:51 | plujan | Status | resolved => closed |
2009-07-17 13:51 | plujan | Note Added: 0018365 | |
2009-08-28 14:54 | fgredruello | Note Added: 0019267 | |
2009-11-12 13:38 | rafaroda | Relationship added | related to 0010235 |
Copyright © 2000 - 2009 MantisBT Group |