Known Issues Articles

 

Known Issue#: 9590

Topic/Category: DB Export

Ephesoft version(s) Affected: All

Issue:

A generic error log of MS SQL database “Data truncation” is logged. This error tells then Ephesoft is trying to insert longer string then defined for the column. Please refer below error logs:

//——

Caused by: com.ephesoft.dcma.core.DCMAException: DB Export Plugin: Problem occured in exporting batch document level fields to database Error occured in executing query

at com.ephesoft.dcma.dbexport.service.DbExportServiceImpl.dbExport(DbExportServiceImpl.java:55)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:55)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at com.sun.proxy.$Proxy150.dbExport(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.activiti.engine.impl.javax.el.BeanELResolver.invoke(BeanELResolver.java:483)

… 102 more

Caused by: com.ephesoft.dcma.core.exception.DCMAApplicationException: DB Export Plugin: Problem occured in exporting batch document level fields to database Error occured in executing query

at com.ephesoft.dcma.dbexport.DbExporter.exportBatchToDb(DbExporter.java:89)

at com.ephesoft.dcma.dbexport.service.DbExportServiceImpl.dbExport(DbExportServiceImpl.java:51)

… 120 more

Caused by: com.ephesoft.dcma.core.exception.DCMAApplicationException: Error occured in executing query

at com.ephesoft.dcma.dbexport.util.DBExportUtil.insertItems(DBExportUtil.java:539)

at com.ephesoft.dcma.dbexport.DbExporter.exportBatchToDB(DbExporter.java:102)

at com.ephesoft.dcma.dbexport.DbExporter.exportBatchToDb(DbExporter.java:83)

… 121 more

Caused by: java.sql.DataTruncation: Data truncation

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:382)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)

at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)

at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)

at com.ephesoft.dcma.dbexport.util.DBExportUtil.exportToDB(DBExportUtil.java:553)

at com.ephesoft.dcma.dbexport.util.DBExportUtil.insertItems(DBExportUtil.java:526)

… 123 more

 

Root Cause:

Database table mapped to batch class BC5 for DB export Export_Invoice_line_Items contains column Description whose length is limited to 50 characters

image002

Solution:

Alter the table length to fit the string being exported.

Updates:

Ex: 1/1/14 – Patch was provided for v3.1.2.5, Permanent solution will be included in v3.1.2.6 or higher

 

< Back| Known Issues Main Page | Next Known Issue #? >

 

 

 

Was this article helpful to you?

Walter Lee

Comments are closed.