Article - CS284373
Stock Level process is failing with error " Bulk load data conversion error (truncation) for row 14441, column 46 (SLPipelineVMRatio)" in Servigistics Parts Planning
Modified: 26-Apr-2018
Applies To
- Servigistics Service Parts Management 11.0.1.1
Description
- Stock Level process is failing with error " Bulk load data conversion error (truncation) for row 14441, column 46 (SLPipelineVMRatio)"
- Autopilot.log contains
- Task Stock Level Generation failed with message: StatementCallback; SQL [bulk insert [##IPCSTMP_L32604] from '\\172.17.1.85\Servigistics-prod\BULK_INS40788-1.txt' with (fieldterminator = '|', rowterminator = '|>
', keepnulls, tablock, maxerrors = 0
org.springframework.dao.TransientDataAccessResourceException: StatementCallback; SQL [bulk insert [##IPCSTMP_L32604] from '\\172.17.1.85\Servigistics-prod\BULK_INS40788-1.txt' with (fieldterminator = '|', rowterminator = '|>
', keepnulls, tablock, maxerrors = 0, rows_per_batch = 16474, datafiletype = 'widechar')]; Bulk load data conversion error (truncation) for row 14441, column 46 (SLPipelineVMRatio).; nested exception is java.sql.SQLException: Bulk load data conversion error (truncation) for row 14441, column 46 (SLPipelineVMRatio).
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:521)
at com.svg.core.dataprovider.bulkinsert.SqlServerBulkInsert$1.doInTransaction(SqlServerBulkInsert.java:30)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:51)
at com.svg.core.dataprovider.bulkinsert.SqlServerBulkInsert.doBulkInsert(SqlServerBulkInsert.java:27)
at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert.commitUpdates(AbstractBulkInsert.java:286)
at com.svg.core.dataprovider.bulkinsert.AbstractBulkInsert.flush(AbstractBulkInsert.java:190)
at com.svg.core.dataprovider.BulkOutput.flush(BulkOutput.java:158)
at com.svg.core.process.Output.writeResults(Output.java:115)
at com.svg.core.process.Connector.process(Connector.java:133)
at com.svg.planning.process.stocklevel.SLConnector.runLevels(SLConnector.java:96)
at com.svg.planning.process.stocklevel.SLConnector.process(SLConnector.java:71)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:88)
at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:26)
at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:76)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:51)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:73)
at com.svg.core.task.BatchTask.runConnector(BatchTask.java:84)
at com.svg.core.task.AbstractTask.run(AbstractTask.java:205)
at com.svg.core.task.BatchTask.run(BatchTask.java:70)
at sun.reflect.GeneratedMethodAccessor280.invoke(Unknown Source)
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:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy630.run(Unknown Source)
at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:409)
at java.lang.Thread.run(Thread.java:724)
at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43)
Caused by: java.sql.SQLException: Bulk load data conversion error (truncation) for row 14441, column 46 (SLPipelineVMRatio).
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241)
at sun.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.util.ReflectionUtils.invokeJdbcMethod(ReflectionUtils.java:224)
at com.svg.core.database.support.ProxyHandler$1.invoke(ProxyHandler.java:28)
at com.svg.core.database.support.QueryMethodInvoker.invoke(QueryMethodInvoker.java:36)
at com.svg.core.database.support.ProxyHandler.invoke(ProxyHandler.java:52)
at com.svg.core.database.support.StatementHandler.invoke(StatementHandler.java:41)
at com.sun.proxy.$Proxy187.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:511)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:509)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
... 38 more
- Task Stock Level Generation failed with message: StatementCallback; SQL [bulk insert [##IPCSTMP_L32604] from '\\172.17.1.85\Servigistics-prod\BULK_INS40788-1.txt' with (fieldterminator = '|', rowterminator = '|>
This is a printer-friendly version of Article 284373 and may be out of date. For the latest version click CS284373