Hi,
I am getting the following exception while running the Quick Refund Entire Order. In simple-method createAcctgTransAndEntriesForIncomingPayment, following code fragment is setting the creditEntry.glAccountId from "payment.overrideGlAccountId" which is null and therefore, string literal "payment.overideGlAccountId" is passed causing value too long.. exception. <if-not-empty field-name="paymentApplication.overrideGlAccountId"> <set field="creditEntry.glAccountId" from-field="paymentApplication.overrideGlAccountId"/> <else> <set field="creditEntry.glAccountId" from-field="payment.overrideGlAccountId"/> </else> </if-not-empty> (ERROR: value too long for type character varying(20))) (Error while inserting: [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00002(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10008(java.lang.String)][amount,122.1(java.lang.Double)][createdStamp,2008-01-09 22:13:23.341(java.sql.Timestamp)][createdTxStamp,2008-01-09 22:13:20.446(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][glAccountId,payment.overrideGlAccountId(java.lang.String)][glAccountTypeId,CUSTOMER_CREDIT(java.lang.String)][lastUpdatedStamp,2008-01-09 22:13:23.341(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-09 22:13:20.446(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,122.1(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,10000(java.lang.String)][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][roleTypeId,BILL_FROM_VENDOR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.ACCTG_TRANS_ENTRY (ACCTG_TRANS_ID, ACCTG_TRANS_ENTRY_SEQ_ID, ACCTG_TRANS_ENTRY_TYPE_ID, DESCRIPTION, VOUCHER_REF, PARTY_ID, ROLE_TYPE_ID, THEIR_PARTY_ID, PRODUCT_ID, THEIR_PRODUCT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, AMOUNT, CURRENCY_UOM_ID, ORIG_AMOUNT, ORIG_CURRENCY_UOM_ID, DEBIT_CREDIT_FLAG, DUE_DATE, GROUP_ID, TAX_ID, RECONCILE_STATUS_ID, SETTLEMENT_TERM_ID, IS_SUMMARY, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(20)))))) [java] org.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:707) [java] org.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:745) [java] org.ofbiz.service.GenericDispatcher.runAsync(GenericDispatcher.java:229) [java] org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:116) [java] org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:119) [java] org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:158) [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:473) [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:208) [java] org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:150) [java] org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:239) [java] org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) [java] org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) [java] org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) [java] org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) [java] org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) [java] org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:375) [java] org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:208) [java] org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) [java] org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:334) [java] org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:454) [java] org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:281) [java] org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:193) [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:595) [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:688) [java] org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) [java] org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) [java] org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) [java] org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) [java] org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) [java] org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) [java] org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) [java] org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [java] org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) [java] org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) [java] org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542) [java] org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) [java] org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) [java] org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) [java] org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) [java] org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) [java] org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) [java] java.lang.Thread.run(Thread.java:595) Raj |
Raj,
thank you for the bug report; I don't think that the error was actually in that code snippet, but your bug report helped to quickly find and fix it; rev. 610477 Could you please confirm it is fixed? Thanks, Jacopo Raj Saini wrote: > Hi, > > I am getting the following exception while running the Quick Refund > Entire Order. > > In simple-method createAcctgTransAndEntriesForIncomingPayment, following > code fragment is setting the creditEntry.glAccountId from > "payment.overrideGlAccountId" which is null and therefore, string > literal "payment.overideGlAccountId" is passed causing value too long.. > exception. > > > <if-not-empty field-name="paymentApplication.overrideGlAccountId"> > <set field="creditEntry.glAccountId" > from-field="paymentApplication.overrideGlAccountId"/> > <else> > <set field="creditEntry.glAccountId" > from-field="payment.overrideGlAccountId"/> </else> > </if-not-empty> > > (ERROR: value too long for type character varying(20))) (Error while > inserting: > [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00002(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10008(java.lang.String)][amount,122.1(java.lang.Double)][createdStamp,2008-01-09 > 22:13:23.341(java.sql.Timestamp)][createdTxStamp,2008-01-09 > 22:13:20.446(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][glAccountId,payment.overrideGlAccountId(java.lang.String)][glAccountTypeId,CUSTOMER_CREDIT(java.lang.String)][lastUpdatedStamp,2008-01-09 > 22:13:23.341(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-09 > 22:13:20.446(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,122.1(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,10000(java.lang.String)][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][roleTypeId,BILL_FROM_VENDOR(java.lang.String)] > (SQL Exception while executing the following:INSERT INTO > public.ACCTG_TRANS_ENTRY (ACCTG_TRANS_ID, ACCTG_TRANS_ENTRY_SEQ_ID, > ACCTG_TRANS_ENTRY_TYPE_ID, DESCRIPTION, VOUCHER_REF, PARTY_ID, > ROLE_TYPE_ID, THEIR_PARTY_ID, PRODUCT_ID, THEIR_PRODUCT_ID, > GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, AMOUNT, > CURRENCY_UOM_ID, ORIG_AMOUNT, ORIG_CURRENCY_UOM_ID, DEBIT_CREDIT_FLAG, > DUE_DATE, GROUP_ID, TAX_ID, RECONCILE_STATUS_ID, SETTLEMENT_TERM_ID, > IS_SUMMARY, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type > character varying(20)))))) > [java] > org.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:707) > [java] > org.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:745) > [java] > org.ofbiz.service.GenericDispatcher.runAsync(GenericDispatcher.java:229) > [java] > org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:116) > [java] > org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:119) > [java] > org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:158) > [java] > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:473) > [java] > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:208) > [java] > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:150) > [java] > org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:239) > [java] org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) > [java] org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) > [java] > org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) > [java] > org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) > [java] > org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) > > [java] > org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) > [java] > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:375) > [java] > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:208) > [java] > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) > [java] > org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:334) > > [java] > org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:454) > [java] > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:281) > [java] > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:193) > [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:595) > [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:688) > [java] > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) > > [java] > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > > [java] > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) > [java] > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > > [java] > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > > [java] > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) > > [java] > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) > > [java] > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > > [java] > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) > > [java] > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) > > [java] > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542) > [java] > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) > [java] > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) > [java] > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) > > [java] > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) > > [java] > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) > > [java] > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) > > [java] java.lang.Thread.run(Thread.java:595) > > Raj |
Thanks Jacopo, it is working now.
Raj Jacopo Cappellato wrote: > Raj, > > thank you for the bug report; I don't think that the error was > actually in that code snippet, but your bug report helped to quickly > find and fix it; rev. 610477 > Could you please confirm it is fixed? > > Thanks, > > Jacopo > > > > Raj Saini wrote: >> Hi, >> >> I am getting the following exception while running the Quick Refund >> Entire Order. >> >> In simple-method createAcctgTransAndEntriesForIncomingPayment, >> following code fragment is setting the creditEntry.glAccountId from >> "payment.overrideGlAccountId" which is null and therefore, string >> literal "payment.overideGlAccountId" is passed causing value too >> long.. exception. >> >> >> <if-not-empty field-name="paymentApplication.overrideGlAccountId"> >> <set field="creditEntry.glAccountId" >> from-field="paymentApplication.overrideGlAccountId"/> >> <else> >> <set field="creditEntry.glAccountId" >> from-field="payment.overrideGlAccountId"/> </else> >> </if-not-empty> >> >> (ERROR: value too long for type character varying(20))) (Error while >> inserting: >> [GenericEntity:AcctgTransEntry][acctgTransEntrySeqId,00002(java.lang.String)][acctgTransEntryTypeId,_NA_(java.lang.String)][acctgTransId,10008(java.lang.String)][amount,122.1(java.lang.Double)][createdStamp,2008-01-09 >> 22:13:23.341(java.sql.Timestamp)][createdTxStamp,2008-01-09 >> 22:13:20.446(java.sql.Timestamp)][currencyUomId,USD(java.lang.String)][debitCreditFlag,C(java.lang.String)][glAccountId,payment.overrideGlAccountId(java.lang.String)][glAccountTypeId,CUSTOMER_CREDIT(java.lang.String)][lastUpdatedStamp,2008-01-09 >> 22:13:23.341(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-09 >> 22:13:20.446(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)][origAmount,122.1(java.lang.Double)][origCurrencyUomId,USD(java.lang.String)][partyId,10000(java.lang.String)][reconcileStatusId,AES_NOT_RECONCILED(java.lang.String)][roleTypeId,BILL_FROM_VENDOR(java.lang.String)] >> (SQL Exception while executing the following:INSERT INTO >> public.ACCTG_TRANS_ENTRY (ACCTG_TRANS_ID, ACCTG_TRANS_ENTRY_SEQ_ID, >> ACCTG_TRANS_ENTRY_TYPE_ID, DESCRIPTION, VOUCHER_REF, PARTY_ID, >> ROLE_TYPE_ID, THEIR_PARTY_ID, PRODUCT_ID, THEIR_PRODUCT_ID, >> GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, AMOUNT, >> CURRENCY_UOM_ID, ORIG_AMOUNT, ORIG_CURRENCY_UOM_ID, >> DEBIT_CREDIT_FLAG, DUE_DATE, GROUP_ID, TAX_ID, RECONCILE_STATUS_ID, >> SETTLEMENT_TERM_ID, IS_SUMMARY, LAST_UPDATED_STAMP, >> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?, ?) (ERROR: value too long for type character varying(20)))))) >> [java] >> org.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:707) >> [java] >> org.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:745) >> [java] >> org.ofbiz.service.GenericDispatcher.runAsync(GenericDispatcher.java:229) >> [java] >> org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:116) >> >> [java] >> org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:119) >> [java] >> org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:158) >> [java] >> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:473) >> [java] >> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:208) >> [java] >> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:150) >> [java] >> org.ofbiz.minilang.method.callops.CallService.exec(CallService.java:239) >> [java] >> org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:931) >> [java] org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) >> [java] >> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:105) >> [java] >> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:87) >> [java] >> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:76) >> >> [java] >> org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:51) >> >> [java] >> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:375) >> [java] >> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:208) >> [java] >> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136) >> [java] >> org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:334) >> >> [java] >> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:454) >> >> [java] >> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:281) >> >> [java] >> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:193) >> [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:595) >> [java] javax.servlet.http.HttpServlet.service(HttpServlet.java:688) >> [java] >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) >> >> [java] >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) >> >> [java] >> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:248) >> [java] >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) >> >> [java] >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) >> >> [java] >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) >> >> [java] >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) >> >> [java] >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> >> [java] >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) >> >> [java] >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) >> >> [java] >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542) >> >> [java] >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) >> >> [java] >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) >> >> [java] >> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) >> >> [java] >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) >> >> [java] >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) >> >> [java] >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) >> >> [java] java.lang.Thread.run(Thread.java:595) >> >> Raj > > |
Free forum by Nabble | Edit this page |