Openbravo Issue Tracking System - Java Client POS
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008353Java Client POS(No Category)public2009-03-30 20:212011-04-01 00:00
Reporterjaviexpo1 
Assigned Toadrianromero 
PrioritynormalSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version 
Target Version2.30Fixed in Version 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
OBNetwork customer
Support ticket
Regression introduced in release
Summary0008353: Error Running Syncronization betwwen Openbravo 2.50 and OpenbravoPOS 2.30
DescriptionWhen the RUN SYNCRONIZATION.kjb file is imported and running in Kettle - Spoon 3.1.0 the following exception apear and the Syncronization process FAIL:

2009/03/30 13:08:48 - TAXES JOB - Starting entry [Taxes]
2009/03/30 13:08:48 - Taxes - Loading transformation from XML file [file:///home/javier/Kettle/trunk/transformations/Taxes.ktr [^]]
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : org.pentaho.di.core.exception.KettleException:
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Unexpected error during transformation metadata load
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) :
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Error reading information from file
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : The element type "hop" must be terminated by the matching end-tag "</hop>".
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) :
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) :
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:800)
2009/03/30 13:08:48 - Thread[TAXES JOB (TAXES JOB (Thread-190)),5,main] - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:434

*************************************************************************************

If you check the corresponding Transformation Taxes.ktr, it cannot be oppening from Kettle because the following error appear:

Error reading information from file
The element type "hop" must be terminated by the matching end-tag "</hop>".

Steps To Reproduce1. Download the lates version of each .kjb and .ktr file from /trunk/transformation in the SVN Repository for Openbravo POS.

2. Import RUN SYNCRONIZATION.kjb into Kettle and Run it.

3. At the TAXES JOB the process stop with the exception.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? KettleLogFile (31,988) 2009-03-30 20:44
https://issues.openbravo.com/file_download.php?file_id=1094&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-03-30 20:21javiexpo1New Issue
2009-03-30 20:21javiexpo1Assigned To => rafaroda
2009-03-30 20:44javiexpo1File Added: KettleLogFile
2009-03-31 12:40psarobeProjectOpenbravo ERP => @2@
2009-03-31 13:51javiexpo1Note Added: 0015086
2009-03-31 14:03javiexpo1Note Added: 0015087
2009-04-01 11:15hgbotCheckin
2009-04-01 11:15hgbotNote Added: 0015106
2009-04-01 11:33miruritaAssigned Torafaroda => mirurita
2009-04-01 16:17hgbotCheckin
2009-04-01 16:17hgbotNote Added: 0015112
2009-04-01 16:17hgbotStatusnew => resolved
2009-04-01 16:17hgbotResolutionopen => fixed
2009-04-01 16:18miruritaNote Added: 0015113
2009-04-01 16:27adrianromeroversion2.50beta =>
2009-04-01 16:27adrianromeroTarget Version => 2.30
2011-03-31 11:14dalsasuaAssigned Tomirurita => adrianromero
2011-03-31 11:15dalsasuaNote Added: 0035398
2011-03-31 18:12adrianromeroStatusresolved => closed
2011-04-01 00:00anonymoussf_bug_id0 => 3265609
2012-11-07 09:40priyamCategory01 - General => (No Category)

Notes
(0015086)
javiexpo1   
2009-03-31 13:51   
Ya logre determinar que era lo que pasaba, al parecer el archivo se habia copiado mal desde el Trunk y habia hehco la conversion del caracter "<" a "<", lo cual generaba el error en la transformacion de que el tipo de elemento "hop" deberia terminar con su correspondiente tag </hop>; Al modificar el "<" por el caracter "<" funciono. Sin embargo existen otras valdaciones dentro de las transformaciones del jobs RUN SYNCRHOTNIZATION.kjb que tube que realizar tanto a nivel de la transformación como a nivel de la Base de Datos del Openbravo POS 2.30
(0015087)
javiexpo1   
2009-03-31 14:03   
Dentro de las modificaciones que hay que realizar tenemos:
* Ahyque colocar un valor pordefecto en la definicion de las columnas que son de un tipo de dato boolean como por ejemplo:

________________________________________
Columna | Tabla | Valor Defecto |
-----------------------------------------
ISCOM | PRODUCT | false |
ISSCALE | PRODUCT | false |
VISIBLE | CUSTOMER | true |
RATECASCADE | TAXES | false |
-----------------------------------------


Adicional a esto es necesario durante la carga que los nombres de los impuestos no coicidan de ninguna forma debido a que existen en la tbla TAXES un idice UNIQUE, denominado taxes_name_inx, el cual no permite que se registre dos impuestos con el mismo nombre sobre la tabla TAXES.

La otra cosa que hay que tener en cuenta es que no es cargaran los PRODUCTOS si se coloca en la configuracion del archivo kettle.properties el id de la organización igual a cero ("erp.org = 0"), si se hace esto los PRODUCTOS no son cargados en el Openbravo POS 2.30.

Sin más que agregar espero sea de ayuda esta inforamción.
(0015106)
hgbot   
2009-04-01 11:15   
Repository: openbravopos
Revision: 571
Author: mirurita
Date: 2009-04-01 11:15:39 +0200 (Wed, 01 Apr 2009)

Issue 0008353: Error Running Syncronization betwwen Openbravo 2.50
and OpenbravoPOS 2.30

---
U trunk/transformations/Taxes.ktr
---

https://dev.openbravo.com/websvn/openbravopos/?rev=571&sc=1 [^]
(0015112)
hgbot   
2009-04-01 16:17   
Repository: openbravopos
Revision: 572
Author: mirurita
Date: 2009-04-01 16:17:52 +0200 (Wed, 01 Apr 2009)

Fixes issue 0008353: Error Running Syncronization betwwen Openbravo 2.50
and OpenbravoPOS 2.30

---
U trunk/transformations/Taxes.ktr
---

https://dev.openbravo.com/websvn/openbravopos/?rev=572&sc=1 [^]
(0015113)
mirurita   
2009-04-01 16:18   
Hello Javier,

THe Taxes.ktr file was not formed correctly: a <hop> tag wasn't closed.
If I access to the websvn through [1] and I copy the file content and I create my own Taxes.ktr with this content the problem appear as you described.
However, if I get the transformation checking it out [2], I was able to open the file without problems in Spoon.
Now the this issue is resolved. Please try with the fix.

In this fix [3] I modified the database creation scripts and upgrades: the ISCOM, ISSCALE, VISIBLE y RATECASCADE fields have a default value. This is not available in the Openbravo POS 2.30 beta sources. You need to get latest svn revision.

Openbravo POS is more restrictive than Openbravo ERP in the taxes table. In Openbravo POS is mandatory to have different tax names. So, is not possible to synchronize taxes with same name.

Finally, if you define the variable 'erp.org=0', is necessary to have configured the External Point of Sale with this organization. Try to modify the organization to 0 (is the * symbol) in the External Point of Sale window.

Thanks for the feedback.

Regards,
Mikel Irurita

-----------------------------------------------------------------------------------------------------
Hola Javier,

En el archivo XML Taxes.ktr estaba mal formado: había un tag <hop> sin cerrar.
Si accedía mediante [1] y copiaba el contenido, al chequearlo aparecía el error que comentas. Sin embargo al obtenerlo mediante un check out [2], podía abrirlo sin problemas.
Ya ha sido solucionado. Puedes probarlo.

En esta corrección [3] modifiqué los scripts de creación de base de datos y los actualizadores, de manera que los campos ISCOM, ISSCALE, VISIBLE y RATECASCADE ahora tienen un valor por defecto. Estas modificaciones no están disponibles en Openbravo POS 2.30 beta. Si te interesan puedes obtenerlas desde la última revisión de subversion.

En Openbravo POS somos más restrictivos que en Openbravo ERP respecto al nombre de las TAXES. En Openbravo POS obligamos a que los nombres sean únicos. Por lo tanto, habrá problemas al intentar sincronizar dos impuestos con el mismo nombre.

Por último, el problema es que si defines la variable 'erp.org= 0' tal y como está configurado es necesario que tengas un External Point of Sale definido para todas las organizaciones (símbolo *). Prueba modificando la organización al configurar el External Point of Sale.

Gracias por el feedback.

Un saludo,
Mikel Irurita.


[1] https://dev.openbravo.com/websvn/openbravopos/trunk/transformations/Taxes.ktr [^]
[2] http://wiki.openbravo.com/wiki/OpenbravoPOS_Developer_guide#Obtaining_the_sources_from_SVN [^]
[3] https://issues.openbravo.com/view.php?id=7550 [^]
(0035398)
dalsasua   
2011-03-31 11:15   
Adrián,

Given that it's a critical issue, can you please check it works and close it?

Thanks.