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
