|
Notes |
|
|
|
|
All test, running Openbravo under Vmware Server 2.0.1 and Vmware Workstation 6.5 |
|
|
|
|
|
This have been tested in 250VM, and 250 from sources and works fine. Can you confirm you test in those environments? |
|
|
|
|
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. |
|
|
|
|
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 |
|
|
|
|
|
Does the error still reproduces in Test Environment 2? |
|
|
|
|
|
Yes, the same error is reproduced in Test Environment 2. |
|
|
|
|
Does the Rebuild process finish?
Are you able to change the language to Spanish? |
|
|
|
|
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". |
|
|
|
|
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. |
|
|
|
|
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 |
|
|
|
|
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. |
|
|
|
|
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. |
|
|
|
|
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. |
|
|
|
|
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. |
|
|
|
|
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. |
|
|
|
|
Hi,
I Attach other log 20090610054601-apply.zip = Spanish translation install.
Result = ERROR, Duplicate primary key. |
|
|
|
|
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. |
|
|
|
|
@ 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.
|
|
|
|
|
|
|
|
|
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. |
|
|
|
|
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 |
|
|
|
|
|
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
|
|
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
|
|
2009-07-09 08:27
|
|
|
|
|
|
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
|
|
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. |
|
|
|
|
Tested with version 2.50MP3, no problem, installing the module Spanish Pack = Ok.
Everything solved.
Thanks! |
|
20090518001835-apply.zip (600,428) 2009-05-18 01:54
install-spanish-translation.log (14,899) 2009-05-25 14:09