Menu ▾ ▴

#10 Asiento en Caja

finanzas
open-fixed
Francisco Morosini
Corrección funcional (7)
3
2012-03-27
2012-03-03
daniela arauco
No

Cuando se completa el pago se genera automáticamente el asiento contable. A pesar de que este se genera en la asignación,
En caja no pasa lo mismo, la asignación relacionada se queda pendiente de aplicar.

Discussion

  • daniela arauco

    daniela arauco - 2012-03-03
    • assigned_to: nobody --> xapiens
    • priority: 5 --> 3
     

  • Francisco Morosini

    Francisco Morosini - 2012-03-05

    se modifico porque no estaba considerando la transaccion del proceso completar al procesar. ya se actualizo para pruebas.

     

  • Francisco Morosini

    Francisco Morosini - 2012-03-05
    • status: open --> pending-fixed
     

  • Francisco Morosini

    Francisco Morosini - 2012-03-05
    • labels: 846397 --> Corrección funcional
    • milestone: --> finanzas
     

  • daniela arauco

    daniela arauco - 2012-03-06

    Pantalla de Ejemplo

     
    Ejemplo_Pago.doc

  • daniela arauco

    daniela arauco - 2012-03-06

    Mensaje Error:

    ------------------------------
    ===========> Doc_Allocation.post: [114]
    org.xendra.exceptions.ConversionRateException: conversion de 660.80 US Dollar a Nuevo Sol tipo: Venta para la fecha 7/03/2012 no existe
    at org.compiere.model.MConversionRate.convert(MConversionRate.java:110)
    at org.compiere.acct.Doc_Allocation.createFactPaymentLine(Doc_Allocation.java:1022)
    at org.compiere.acct.Doc_Allocation.createFacts(Doc_Allocation.java:370)
    at org.compiere.acct.Doc.postLogic(Doc.java:784)
    at org.compiere.acct.Doc.post(Doc.java:688)
    at org.compiere.acct.Doc.postImmediate(Doc.java:360)
    at org.compiere.process.DocumentEngine.postImmediate(DocumentEngine.java:1244)
    at org.compiere.model.MPayment.allocateIt(MPayment.java:2370)
    at org.compiere.model.MPayment.completeIt(MPayment.java:1986)
    at org.compiere.process.DocumentEngine.completeIt(DocumentEngine.java:453)
    at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:294)
    at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:258)
    at org.compiere.model.MPayment.processIt(MPayment.java:1770)
    at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:893)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:777)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    -------------------------------
    -----------> MWFActivity.run: MWFNode[202-(DocComplete),Action=DocumentAction=CO] [114]
    java.lang.Exception: no existe tipo de cambio Venta para la moneda $ en la fecha 2012-03-07 00:00:00.0
    at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:933)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:777)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    ===========> Trx.rollback: WFP_317db240-16aa-4058-a32e-b00d2c1ac90f [114]
    org.postgresql.util.PSQLException: ERROR: no such savepoint; State=3B001; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.rollback(AbstractJdbc3Connection.java:169)
    at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:829)
    at org.compiere.util.Trx.rollback(Trx.java:305)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:816)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    -------------------------------
    -----------> MWFActivity.save: beforeSave - MWFActivity[2630985,Node=(DocComplete),State=CT,AD_User_ID=100,2012-03-06 12:15:27.0] [114]
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:109)
    at com.mchange.v2.c3p0.impl.NewProxyConnection.setSavepoint(NewProxyConnection.java:1115)
    at org.compiere.util.Trx.setSavepoint(Trx.java:412)
    at org.compiere.model.PO.save(PO.java:2050)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:272)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:829)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    -----------> MWFEventAudit.save: beforeSave - X_AD_WF_EventAudit[1729831] [114]
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:109)
    at com.mchange.v2.c3p0.impl.NewProxyConnection.setSavepoint(NewProxyConnection.java:1115)
    at org.compiere.util.Trx.setSavepoint(Trx.java:412)
    at org.compiere.model.PO.save(PO.java:2050)
    at org.compiere.wf.MWFActivity.updateEventAudit(MWFActivity.java:322)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:273)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:829)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    ===========> Query.list: SELECT AD_Client_ID,AD_Message_ID,AD_Org_ID,AD_Table_ID,AD_User_ID,AD_WF_Activity_ID,AD_WF_Node_ID,AD_WF_Process_ID,AD_WF_Responsible_ID,AD_Workflow_ID,Created,CreatedBy,DateLastAlert,DynPriorityStart,EndWaitTime,IsActive,Priority,Processed,Processing,Record_ID,TextMsg,Updated,UpdatedBy,WFState FROM AD_WF_Activity WHERE (AD_WF_Process_ID=? AND Processed=?) [114]
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    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 com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.compiere.db.StatementProxy.invoke(StatementProxy.java:103)
    at $Proxy4.executeQuery(Unknown Source)
    at org.compiere.model.Query.createResultSet(Query.java:722)
    at org.compiere.model.Query.list(Query.java:234)
    at org.compiere.wf.MWFProcess.getActivities(MWFProcess.java:179)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:266)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:829)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    -------------------------------
    -----------> MWFActivity.run: MWFNode[201-(DocPrepare),Action=DocumentAction=PR] [114]
    org.xendra.exceptions.DBException: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
    at org.compiere.model.Query.list(Query.java:244)
    at org.compiere.wf.MWFProcess.getActivities(MWFProcess.java:179)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:266)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:829)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)
    caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    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 com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.compiere.db.StatementProxy.invoke(StatementProxy.java:103)
    at $Proxy4.executeQuery(Unknown Source)
    at org.compiere.model.Query.createResultSet(Query.java:722)
    at org.compiere.model.Query.list(Query.java:234)
    at org.compiere.wf.MWFProcess.getActivities(MWFProcess.java:179)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:266)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:829)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    ===========> Trx.rollback: WFP_317db240-16aa-4058-a32e-b00d2c1ac90f [114]
    org.postgresql.util.PSQLException: ERROR: no such savepoint; State=3B001; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.rollback(AbstractJdbc3Connection.java:169)
    at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:829)
    at org.compiere.util.Trx.rollback(Trx.java:305)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:816)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    -------------------------------
    -----------> MWFActivity.run: Cause [114]
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    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 com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.compiere.db.StatementProxy.invoke(StatementProxy.java:103)
    at $Proxy4.executeQuery(Unknown Source)
    at org.compiere.model.Query.createResultSet(Query.java:722)
    at org.compiere.model.Query.list(Query.java:234)
    at org.compiere.wf.MWFProcess.getActivities(MWFProcess.java:179)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:266)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:829)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

    ===========> MPayment.load: [WFP_317db240-16aa-4058-a32e-b00d2c1ac90f] - C_Payment_ID=2045984, SQL=SELECT IsReceipt,VoiceAuthCode,IsApproved,IsReconciled,CreditCardExpYY,CreditCardNumber,Created,A_Street,TrxType,R_RespMsg,IsActive,DocAction,Updated,R_PnRef_DC,C_Currency_ID,R_PnRef,Processed,R_CVV2Match,R_AuthCode_DC,PONum,C_PaymentBatch_ID,A_Ident_SSN,IsDelayedCapture,CreatedBy,CreditCardExpMM,WriteOffAmt,UpdatedBy,User1_ID,C_Project_ID,IsPrepayment,C_BOEConfirm_ID,A_Country,Description,C_Remote_ID,Ref_Payment_ID,Cashed,C_Cashflow_Group_ID,C_Payment_ID,Dest_BankAccount_ID,Dest_Payment_ID,Fact_ID,IsTransfer,IsTransferSource,reversal_id,C_BOE_ID,C_CashBook_ID,DeferredDate,Alias,C_BPartner_ID,C_DocType_ID,AD_Client_ID,AD_Org_ID,RenewedAmt,ChargeAmt,CheckNo,AccountNo,A_City,AD_OrgTrx_ID,A_EMail,A_Ident_DL,A_Name,A_State,A_Zip,C_Activity_ID,C_BankAccountDoc_ID,C_BankAccount_ID,C_BP_BankAccount_ID,C_Campaign_ID,C_Cash_ID,C_Charge_ID,C_ConversionType_ID,C_Invoice_ID,C_Order_ID,CreditCardType,CreditCardVV,DateAcct,DateTrx,DiscountAmt,DocStatus,DocumentNo,IsAllocated,IsOnline,IsOverUnderPayment,IsSelfService,Micr,OProcessing,Orig_TrxID,OverUnderAmt,PayAmt,Posted,Processing,R_AuthCode,R_AvsAddr,R_AvsZip,R_Info,RoutingNo,R_Result,Swipe,TaxAmt,TenderType,User2_ID FROM C_Payment WHERE C_Payment_ID=? [114]
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    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 com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.compiere.db.StatementProxy.invoke(StatementProxy.java:103)
    at $Proxy4.executeQuery(Unknown Source)
    at org.compiere.model.PO.load(PO.java:1348)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:833)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:367)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:278)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:279)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:794)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:499)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:701)
    at org.compiere.wf.MWorkflow.startWait(MWorkflow.java:731)

     

  • daniela arauco

    daniela arauco - 2012-03-06
    • status: pending-fixed --> open-fixed
     

  • Francisco Morosini

    Francisco Morosini - 2012-03-26
    • status: open-fixed --> pending-fixed
     

  • daniela arauco

    daniela arauco - 2012-03-27

    El documento queda en estado borrador (DR) y no se puede aplicar.

     

  • daniela arauco

    daniela arauco - 2012-03-27
    • status: pending-fixed --> open-fixed