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, 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.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action3 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(Dictionary2 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](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(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
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, 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.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action3 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(Dictionary2 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](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(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(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, 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, 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.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action3 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(Dictionary2 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](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.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(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
— 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, Nullable1 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, Nullable1 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