Please, Share your knowledge we are stuck and can’t get past this error.
Error:1
Error: System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. —> System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func
3 operation, TInterceptionContext interceptionContext, Action3 executing, Action
3 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary2 identifierValues, List
1 generatedValues)
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
— End of inner exception stack trace —
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) at Ice.IceDataContext.SaveChanges(SaveOptions options) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 364 at Ice.IceDataContext.SaveChangesIfRowHasBeenChanged[TLinqRow](TLinqRow row) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 551 at Ice.Triggers.TriggerQueue.RunWriteTriggerInNewLevel(IceDataContext context, LinqRow modifiedRecord, LinqRow originalRecord, Boolean forAddedRow) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 181 at Ice.Triggers.TriggerQueue.<>c__DisplayClass11_0.<RunWriteTrigger>b__1() in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 155 at Ice.Triggers.TriggerQueue.RunAtNewLevel(Func
1 buildTriggerRunState, Action action) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 508
at Ice.Triggers.TriggerQueue.RunTriggers(IceDataContext context) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 90
at Ice.IceDataContext.RunUntilAllTriggersHaveExecuted() in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 580
at Ice.Triggers.TriggerQueue.RunAtNewLevel(Func`1 buildTriggerRunState, Action action) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 508
at Ice.IceDataContext.Validate[TLinqRow](TLinqRow row) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 337
at Erp.Internal.PE.COSAndWIPPre_Post.RealVariance() in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\CostCalculation.cs:line 3975
at Erp.Internal.PE.COSAndWIPPre_Post.BuildTWip() in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\CostCalculation.cs:line 1106
at Erp.Internal.PE.COSAndWIPPre_Post.RunProcess() in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\COSAndWIPPre_Post.cs:line 647
at Erp.Internal.PE.Pre_PostBase._RunProcess(Int64 instance_TaskNum, String groupID, PostingMode mode, Boolean skipPEDataInit) in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\Pre_PostBase\Pre_PostBase.cs:line 173
Error:2
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
Erp.Internal.PE.SystemException: System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. —> System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func
3 operation, TInterceptionContext interceptionContext, Action3 executing, Action
3 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary2 identifierValues, List
1 generatedValues)
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
— End of inner exception stack trace —
at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) at Ice.IceDataContext.SaveChanges(SaveOptions options) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 364 at Ice.IceDataContext.SaveChangesIfRowHasBeenChanged[TLinqRow](TLinqRow row) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 551 at Ice.Triggers.TriggerQueue.RunWriteTriggerInNewLevel(IceDataContext context, LinqRow modifiedRecord, LinqRow originalRecord, Boolean forAddedRow) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 181 at Ice.Triggers.TriggerQueue.<>c__DisplayClass11_0.<RunWriteTrigger>b__1() in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 155 at Ice.Triggers.TriggerQueue.RunAtNewLevel(Func
1 buildTriggerRunState, Action action) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 508
at Ice.Triggers.TriggerQueue.RunTriggers(IceDataContext context) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 90
at Ice.IceDataContext.RunUntilAllTriggersHaveExecuted() in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 580
at Ice.Triggers.TriggerQueue.RunAtNewLevel(Func1 buildTriggerRunState, Action action) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 508 at Ice.IceDataContext.Validate[TLinqRow](TLinqRow row) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 337 at Erp.Internal.PE.COSAndWIPPre_Post.RealVariance() in C:\_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\CostCalculation.cs:line 3975 at Erp.Internal.PE.COSAndWIPPre_Post.BuildTWip() in C:\_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\CostCalculation.cs:line 1106 at Erp.Internal.PE.COSAndWIPPre_Post.RunProcess() in C:\_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\COSAndWIPPre_Post.cs:line 647 at Erp.Internal.PE.Pre_PostBase._RunProcess(Int64 instance_TaskNum, String groupID, PostingMode mode, Boolean skipPEDataInit) in C:\_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\Pre_PostBase\Pre_PostBase.cs:line 173 ---> System.Exception: System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher
1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action
3 executing, Action3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary
2 identifierValues, List1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() --- End of inner exception stack trace --- at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func
1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)
at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
at Ice.IceDataContext.SaveChanges(SaveOptions options) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 364
at Ice.IceDataContext.SaveChangesIfRowHasBeenChanged[TLinqRow](TLinqRow row) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 551
at Ice.Triggers.TriggerQueue.RunWriteTriggerInNewLevel(IceDataContext context, LinqRow modifiedRecord, LinqRow originalRecord, Boolean forAddedRow) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 181
at Ice.Triggers.TriggerQueue.<>c__DisplayClass11_0.b__1() in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 155
at Ice.Triggers.TriggerQueue.RunAtNewLevel(Func1 buildTriggerRunState, Action action) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 508 at Ice.Triggers.TriggerQueue.RunTriggers(IceDataContext context) in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 90 at Ice.IceDataContext.RunUntilAllTriggersHaveExecuted() in C:\_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 580 at Ice.Triggers.TriggerQueue.RunAtNewLevel(Func
1 buildTriggerRunState, Action action) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 508
at Ice.IceDataContext.Validate[TLinqRow](TLinqRow row) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 337
at Erp.Internal.PE.COSAndWIPPre_Post.RealVariance() in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\CostCalculation.cs:line 3975
at Erp.Internal.PE.COSAndWIPPre_Post.BuildTWip() in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\CostCalculation.cs:line 1106
at Erp.Internal.PE.COSAndWIPPre_Post.RunProcess() in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\COSAndWIPPre_Post.cs:line 647
at Erp.Internal.PE.Pre_PostBase._RunProcess(Int64 instance_TaskNum, String groupID, PostingMode mode, Boolean skipPEDataInit) in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\Pre_PostBase\Pre_PostBase.cs:line 173
— End of inner exception stack trace —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Erp.Internal.PE.PEError.ProcessExceptionList(PostingStage peStage, Exception ex, Boolean suppressRethrow) in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\PEData\PEError.cs:line 264
at Erp.Internal.PE.Pre_PostBase._RunProcess(Int64 instance_TaskNum, String groupID, PostingMode mode, Boolean skipPEDataInit) in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\Pre_PostBase\Pre_PostBase.cs:line 180
at Erp.Internal.PE.COSAndWIPPre_Post.mainPrePost(PostingMode Mode, String DateType, Nullable1 StartDate, Nullable
1 CutOffDate, Boolean UseFiscal, Boolean GLPost, Boolean Simulation, String jobList, Int32 AssemblySeq, Int32 oprSeq, Decimal rcptQty, String callMode, String rcptPartNum, Boolean vAddPBCosts, String vPrjList, Decimal& MaterialCost, Decimal& SubContractCost, Decimal& LaborCost, Decimal& BurdenCost, Decimal& MaterialBurdenCost, Decimal& MtlMaterialCost, Decimal& MtlSubcontractCost, Decimal& MtlLaborCost, Decimal& MtlBurdenCost, Decimal& MtlODCCost, Int64 instance_TaskNum, String tranType, String bookID, Boolean currPlantOnly, Boolean ipUsePassedMfgVarRows) in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\COSAndWIPPre_Post.cs:line 610
at Erp.Internal.PE.COSAndWIPPre_Post.PrePost(PostingMode Mode, Nullable1 StartDate, Nullable
1 CutOffDate, Boolean UseFiscal, Boolean GLPost, Boolean Simulation, String jobList, Int32 AssemblySeq, Int32 oprSeq, Decimal rcptQty, String callMode, String rcptPartNum, Boolean vAddPBCosts, String vPrjList, Decimal& MaterialCost, Decimal& SubContractCost, Decimal& LaborCost, Decimal& BurdenCost, Decimal& MaterialBurdenCost, Decimal& MtlMaterialCost, Decimal& MtlSubcontractCost, Decimal& MtlLaborCost, Decimal& MtlBurdenCost, Decimal& MtlODCCost, Int64 instance_TaskNum, String tranType, String bookID, Boolean currPlantOnly) in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\PE\CosAndWip\COSAndWIPPre_Post.cs:line 540
at Erp.Internal.JC.CaptureCOSWIP._CaptureCOSWIP() in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\JC\CaptureCOSWIP\CaptureCOSWIP.cs:line 161
at Erp.Internal.JC.CaptureCOSWIP.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ERP\UD10.2.500.13\Source\Server\Internal\JC\CaptureCOSWIP\CaptureCOSWIP.cs:line 134
at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ICE\UD10.2.500.13FW\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 117
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_Releases\ICE\UD10.2.500.13FW\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 59
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_Releases\ICE\RL10.2.500.0FW\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\RL10.2.500.0FW\Source\Server\Services\Lib\RunTask\RunTask.cs:line 452