Re: Error while running "Quick Refund Entire Order"

Wed, 09 Jan 2008 10:29:13 -0800 

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

Reply via email to