[Kristiam Alvarez]

Descargue Libertya para instalarlo en windows 7 todo bien, descargue el codigo fuente como siempre lo he realizado configure el eclipse y realice las primeras pruebas todo bien, pero cuando uso el TPV para realizar facturas al credito hace todo el procedimiento pero no realiza la factura ni descarga el producto. Solo cuando es al contado. En la otra parte del la instalación si realiza todo el proceso, pero al correr con codigo fuente no lo realiza y no he realizado ningun cambio sobre el mismo los errores de la consola son estos:

Aclaro al activar la tarjeta de credito ya no me aparece el medio de cobro el el TPV y no me deja cobrar de ninguna forma. Alguien tiene alguna idea de lo que puede estar pasando.

===========> MPOS.get_Value: Column not found – IsAllowCreditCardCashRetirement [11]
===========> MPOS.get_Value: En Po.Get_value, retornado un nulo [11]
===========> MPOS.get_Value: Column not found – CreditCardCashRetirement_Charge_ID [11]
===========> MPOS.get_Value: En Po.Get_value, retornado un nulo [11]
===========> MPOS.get_Value: Column not found – CreditCardCashRetirement_DocType_ID [11]
===========> MPOS.get_Value: En Po.Get_value, retornado un nulo [11]
===========> MPOS.get_Value: Column not found – CreditCardCashRetirement_Product_ID [11]
===========> MPOS.get_Value: En Po.Get_value, retornado un nulo [11]
===========> AccessSqlParser.getTableInfo: parse – could not remove ON C_BPartner, AD_User c, C_BPartner_Location l, C_Location a foo ON l.C_BPartner_Location_ID = foo.C_BPartner_Location_ID [18]
===========> AccessSqlParser.getTableInfo: parse – could not remove ON C_BPartner, AD_User c, C_BPartner_Location l, C_Location a foo ON l.C_BPartner_Location_ID = foo.C_BPartner_Location_ID [19]

---

> Msg.getMsg: NOT found: Imprimiendo Ticket, Por favor espere [11]
TPV DEBUG ==> 2014-11-12 08:39:13.977 – Chequeando saldo y crédito
TPV DEBUG ==> 2014-11-12 08:39:14.68 – Creando Pedido (MOrder)
TPV DEBUG ==> 2014-11-12 08:39:14.727 – Guardando el Pedido (Encabezado, sin líneas aún)
TPV DEBUG ==> 2014-11-12 08:39:15.179 – Guardando línea #1
TPV DEBUG ==> 2014-11-12 08:39:15.367 – Guardando el Pedido (Encabezado, con líneas ya creadas)
TPV DEBUG ==> 2014-11-12 08:39:15.383 – Aplicando descuentos al Pedido (DiscountCalculator)
TPV DEBUG ==> 2014-11-12 08:39:15.383 – Guardando el Pedido nuevamente (luego de aplicar descuentos)
TPV DEBUG ==> 2014-11-12 08:39:15.398 – Completando el pedido
TPV DEBUG ==> 2014-11-12 08:39:15.57 – Guardando el pedido (luego de completar)
TPV DEBUG ==> 2014-11-12 08:39:15.57 – Creando Factura (MInvoice)
TPV DEBUG ==> 2014-11-12 08:39:15.851 – Guardando línea #10
===========> MPaymentTerm.get_Value: Column not found – ApplicationDate [20]
===========> MPaymentTerm.get_Value: En Po.Get_value, retornado un nulo [20]
===========> MInvoice.get_Value: Column not found – DateRecepted [20]
===========> MInvoice.get_Value: En Po.Get_value, retornado un nulo [20]
===========> MPaymentTerm.get_Value: Column not found – ApplicationDate [20]
===========> MPaymentTerm.get_Value: En Po.Get_value, retornado un nulo [20]
===========> MInvoice.get_Value: Column not found – DateRecepted [20]
===========> MInvoice.get_Value: En Po.Get_value, retornado un nulo [20]
===========> MInvoice.get_Value: Column not found – UpdateOrderQty [20]
===========> MInvoice.get_Value: En Po.Get_value, retornado un nulo [20]
===========> MInvoice.get_Value: Column not found – UpdateOrderQty [20]
===========> MInvoice.get_Value: En Po.Get_value, retornado un nulo [20]
TPV DEBUG ==> 2014-11-12 08:39:16.254 – Chequeando Factura
TPV DEBUG ==> 2014-11-12 08:39:16.254 – Guardando los descuentos
TPV DEBUG ==> 2014-11-12 08:39:16.254 – Creando Remito (MInOut)
TPV DEBUG ==> 2014-11-12 08:39:16.676 – Guardando línea #10
===========> MInOut.get_Value: Column not found – C_DocTypeTarget_ID [20]
===========> MInOut.get_Value: En Po.Get_value, retornado un nulo [20]
===========> MDocType.get_Value: Column not found – IsWarehouseClosureControl [20]
===========> MDocType.get_Value: En Po.Get_value, retornado un nulo [20]
TPV DEBUG ==> 2014-11-12 08:39:17.012 – Creando Allocation
===========> MSequence.getDocumentNo: C_DocType_ID=0 [20]
===========> MSequence.getDocumentNo: C_DocType_ID=0 [20]
TPV DEBUG ==> 2014-11-12 08:39:17.179 – Creando los pagos (MPayment & MCashLine)
TPV DEBUG ==> 2014-11-12 08:39:17.179 – Completando el allocation

---

> MAllocationHdr.saveUpdate: DocumentNo updated: 1000009 -> 1000009^ [20]
TPV DEBUG ==> 2014-11-12 08:39:17.207 – Acciones de cuenta corriente
TPV DEBUG ==> 2014-11-12 08:39:17.268 – Actualizando crédito de la Entidad Comercial
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 1.
at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.cc.OnCreditCurrentAccountBalanceData.loadBalanceData(OnCreditCurrentAccountBalanceData.java:41)
at org.openXpertya.cc.CurrentAccountBalanceStrategy.getBalanceData(CurrentAccountBalanceStrategy.java:110)
at org.openXpertya.cc.BalanceLocalStrategy.updateBPBalance(BalanceLocalStrategy.java:69)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:347)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:372)
at org.openXpertya.cc.CurrentAccountManager.afterProcessDocument(CurrentAccountManager.java:242)
at org.openXpertya.pos.ctrl.PoSOnline.afterProcessDocuments(PoSOnline.java:1189)
at org.openXpertya.pos.ctrl.PoSOnline.completeOrder(PoSOnline.java:406)
at org.openXpertya.pos.ctrl.PoSModel.completeOrder(PoSModel.java:87)
at org.openXpertya.pos.view.PoSMainForm$58.construct(PoSMainForm.java:5158)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:47)
at java.lang.Thread.run(Unknown Source)
===========> DB.getSQLObject: SELECT COALESCE(COUNT(C_BPartner_ID),0) FROM C_BPartner WHERE Value = ? AND AD_Client_ID = ? AND C_BPartner_ID <> 1012191 [20]
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 1.; State=22023; ErrorCode=0
at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.util.DB.getSQLObject(DB.java:1128)
at org.openXpertya.util.DB.getSQLObject(DB.java:1112)
at org.openXpertya.model.PO.sameColumnValueValidation(PO.java:4706)
at org.openXpertya.model.MBPartner.beforeSave(MBPartner.java:1325)
at org.openXpertya.model.PO.doBeforeSave(PO.java:3977)
at org.openXpertya.plugin.handlersPO.PluginPOBeforeSaveHandler.processActualAction(PluginPOBeforeSaveHandler.java:22)
at org.openXpertya.plugin.handlersPO.PluginPOHandler.processPO(PluginPOHandler.java:72)
at org.openXpertya.model.PO.handlePersistence(PO.java:3972)
at org.openXpertya.model.PO.save(PO.java:1801)
at org.openXpertya.cc.BalanceLocalStrategy.updateBPBalance(BalanceLocalStrategy.java:75)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:347)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:372)
at org.openXpertya.cc.CurrentAccountManager.afterProcessDocument(CurrentAccountManager.java:242)
at org.openXpertya.pos.ctrl.PoSOnline.afterProcessDocuments(PoSOnline.java:1189)
at org.openXpertya.pos.ctrl.PoSOnline.completeOrder(PoSOnline.java:406)
at org.openXpertya.pos.ctrl.PoSModel.completeOrder(PoSModel.java:87)
at org.openXpertya.pos.view.PoSMainForm$58.construct(PoSMainForm.java:5158)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:47)

===========> MBPartner.save: beforeSave – MBPartner[ID=1012191,Value=1000000,Name=JUAN JOSE PEREZ MELGAR,Open=0] [20]
java.lang.NullPointerException
at org.openXpertya.model.PO.sameColumnValueValidation(PO.java:4708)
at org.openXpertya.model.MBPartner.beforeSave(MBPartner.java:1325)
at org.openXpertya.model.PO.doBeforeSave(PO.java:3977)
at org.openXpertya.plugin.handlersPO.PluginPOBeforeSaveHandler.processActualAction(PluginPOBeforeSaveHandler.java:22)
at org.openXpertya.plugin.handlersPO.PluginPOHandler.processPO(PluginPOHandler.java:72)
at org.openXpertya.model.PO.handlePersistence(PO.java:3972)
at org.openXpertya.model.PO.save(PO.java:1801)
at org.openXpertya.cc.BalanceLocalStrategy.updateBPBalance(BalanceLocalStrategy.java:75)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:347)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:372)
at org.openXpertya.cc.CurrentAccountManager.afterProcessDocument(CurrentAccountManager.java:242)
at org.openXpertya.pos.ctrl.PoSOnline.afterProcessDocuments(PoSOnline.java:1189)
at org.openXpertya.pos.ctrl.PoSOnline.completeOrder(PoSOnline.java:406)
at org.openXpertya.pos.ctrl.PoSModel.completeOrder(PoSModel.java:87)
at org.openXpertya.pos.view.PoSMainForm$58.construct(PoSMainForm.java:5158)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:47)

===========> PO.find: ERROR finding from table C_BPartner [20]
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 1.
at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.model.PO.find(PO.java:3841)
at org.openXpertya.model.PO.findFirst(PO.java:3895)
at org.openXpertya.cc.CurrentAccountStrategy.getPO(CurrentAccountStrategy.java:75)
at org.openXpertya.cc.CurrentAccountStrategy.getBPartner(CurrentAccountStrategy.java:29)
at org.openXpertya.cc.BalanceLocalStrategy.setCurrentAccountStatus(BalanceLocalStrategy.java:120)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:351)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:372)
at org.openXpertya.cc.CurrentAccountManager.afterProcessDocument(CurrentAccountManager.java:242)
at org.openXpertya.pos.ctrl.PoSOnline.afterProcessDocuments(PoSOnline.java:1189)
at org.openXpertya.pos.ctrl.PoSOnline.completeOrder(PoSOnline.java:406)
at org.openXpertya.pos.ctrl.PoSModel.completeOrder(PoSModel.java:87)
at org.openXpertya.pos.view.PoSMainForm$58.construct(PoSMainForm.java:5158)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:47)
at java.lang.Thread.run(Unknown Source)
===========> PO.find: ERROR finding from table AD_Org [20]
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 1.
at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.model.PO.find(PO.java:3841)
at org.openXpertya.model.PO.findFirst(PO.java:3895)
at org.openXpertya.cc.CurrentAccountStrategy.getPO(CurrentAccountStrategy.java:75)
at org.openXpertya.cc.CurrentAccountStrategy.getOrg(CurrentAccountStrategy.java:51)
at org.openXpertya.cc.BalanceLocalStrategy.setCurrentAccountStatus(BalanceLocalStrategy.java:122)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:351)
at org.openXpertya.cc.BalanceLocalStrategy.afterProcessDocument(BalanceLocalStrategy.java:372)
at org.openXpertya.cc.CurrentAccountManager.afterProcessDocument(CurrentAccountManager.java:242)
at org.openXpertya.pos.ctrl.PoSOnline.afterProcessDocuments(PoSOnline.java:1189)
at org.openXpertya.pos.ctrl.PoSOnline.completeOrder(PoSOnline.java:406)
at org.openXpertya.pos.ctrl.PoSModel.completeOrder(PoSModel.java:87)
at org.openXpertya.pos.view.PoSMainForm$58.construct(PoSMainForm.java:5158)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:47)
at java.lang.Thread.run(Unknown Source)
===========> PoSConnectionState.afterProcessDocuments: null [20]
TPV DEBUG ==> 2014-11-12 08:39:17.337 – Commit de Transaccion
TPV DEBUG ==> 2014-11-12 08:39:17.337 – Impresion de venta
===========> MInvoice.load: NO Data found for C_Invoice_ID=1021729 [21]
java.lang.Exception
at org.openXpertya.model.PO.load(PO.java:1317)
at org.openXpertya.model.PO.load(PO.java:1246)
at org.openXpertya.model.PO.initialize(PO.java:228)
at org.openXpertya.model.PO.(PO.java:214)
at org.openXpertya.model.PO.(PO.java:165)
at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:16)
at org.openXpertya.model.MInvoice.(MInvoice.java:765)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.openXpertya.model.M_Table.getPO(M_Table.java:560)
at org.openXpertya.apps.ProcessCtl.initilizeProcessInfoAditionals(ProcessCtl.java:369)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:536)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:293)

===========> MInvoice.load: NO Data found for C_Invoice_ID=1021729 [21]
java.lang.Exception
at org.openXpertya.model.PO.load(PO.java:1317)
at org.openXpertya.model.PO.load(PO.java:1246)
at org.openXpertya.model.PO.initialize(PO.java:228)
at org.openXpertya.model.PO.(PO.java:214)
at org.openXpertya.model.PO.(PO.java:165)
at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:16)
at org.openXpertya.model.MInvoice.(MInvoice.java:765)
at org.openXpertya.JasperReport.LaunchInvoice.createReport(LaunchInvoice.java:106)
at org.openXpertya.JasperReport.LaunchInvoice.doIt(LaunchInvoice.java:101)
at org.openXpertya.process.SvrProcess.process(SvrProcess.java:159)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:115)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:603)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:293)

---

> SvrProcess.process: java.lang.NullPointerException [21]

[Saulo Gil]

La primer línea del stack trace describe cual es el problema:

Code:

MPOS.get_Value: Column not found – IsAllowCreditCardCashRetirement [11]

Aparentemente estás utilizando una versión reciente de Libertya contra una base de datos no tan reciente.

Te recomiendo utilizar el tag code o adjuntar archivos a la hora de mandar logs largos al foro, así es más fácil de leer para todos.

Saludos!

[Kristiam Alvarez]

Y donde podría descargar esa base de datos aparentemente estoy utilizando la versión 14:02 que seria la última.

[Federico Cristina]

Buenas,

Tal como sugiere mand1nga, es probable que tengas un desfazaje entre binarios y base de datos. Todas las semanas se realiza un dump de la base de datos de desarrollo y se vuelca a sourceforge:

http://sourceforge.net/projects/libertya/files/libertya/dev/dumps/

Compará la fecha de la revisión SVN sobre la que estás parado con la fecha de los dumps a fin de determinar qué dump deberías utilizar.

Saludos,
Federico

[Kristiam Alvarez]

Gracias a todos tienen toda la razón falta de atención ahora funciona excelente otra vez gracias

[Autor]

Entradas