Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008353
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Java Client POS] (No Category)criticalalways2009-03-30 20:212011-04-01 00:00
Reporterjaviexpo1View Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version2.30
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0008353: 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.
TagsNo tags attached.
Attached Files? file icon KettleLogFile [^] (31,988 bytes) 2009-03-30 20:44 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0015086)
javiexpo1 (reporter)
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 (reporter)
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 (developer)
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 (developer)
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 (developer)
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 (reporter)
2011-03-31 11:15

 Adrián,

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

Thanks.

- Issue History
Date Modified Username Field Change
2009-03-30 20:21 javiexpo1 New Issue
2009-03-30 20:21 javiexpo1 Assigned To => rafaroda
2009-03-30 20:44 javiexpo1 File Added: KettleLogFile
2009-03-31 12:40 psarobe Project Openbravo ERP => @2@
2009-03-31 13:51 javiexpo1 Note Added: 0015086
2009-03-31 14:03 javiexpo1 Note Added: 0015087
2009-04-01 11:15 hgbot Checkin
2009-04-01 11:15 hgbot Note Added: 0015106
2009-04-01 11:33 mirurita Assigned To rafaroda => mirurita
2009-04-01 16:17 hgbot Checkin
2009-04-01 16:17 hgbot Note Added: 0015112
2009-04-01 16:17 hgbot Status new => resolved
2009-04-01 16:17 hgbot Resolution open => fixed
2009-04-01 16:18 mirurita Note Added: 0015113
2009-04-01 16:27 adrianromero version 2.50beta =>
2009-04-01 16:27 adrianromero Target Version => 2.30
2011-03-31 11:14 dalsasua Assigned To mirurita => adrianromero
2011-03-31 11:15 dalsasua Note Added: 0035398
2011-03-31 18:12 adrianromero Status resolved => closed
2011-04-01 00:00 anonymous sf_bug_id 0 => 3265609
2012-11-07 09:40 priyam Category 01 - General => (No Category)

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker