0009064: Duplicate primary key in table AD_Element_Trl - Installing Spanish Translation Module

(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

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!