6Kare

Açıklama:

Emakin'de bir formda SQL veritabanına kayıt girilen bir adımda aksiyon alındığında aşağıdaki hata loglanıyorsa: 

2015-12-22 10:35:42.8249|ERROR|Worker.WorkItem|36|Exception occured while processing workitem ab0a77c0-fb60-47d6-ba35-71b46b5b9b84.|AltiKare.Data.Access.DataAccessException: "INSERT INTO [rkirlangicMesMesaiBilgileri]([rkirlangicMesMesaiBilgileri].[Id],[rkirlangicMesMesaiBilgileri].[PersonelId],[rkirlangicMesMesaiBilgileri].[BaslangicSaati],[rkirlangicMesMesaiBilgileri].[TahminiBitisSaati],[rkirlangicMesMesaiBilgileri].[MesaiSuresi],[rkirlangicMesMesaiBilgileri].[GerceklesenBaslangicSaati],[rkirlangicMesMesaiBilgileri].[GerceklesenMesaiSuresi],[rkirlangicMesMesaiBilgileri].[Aciklama],[rkirlangicMesMesaiBilgileri].[FormNo],[rkirlangicMesMesaiBilgileri].[Durum]) VALUES(@Id,@PersonelId,@BaslangicSaati,@TahminiBitisSaati,@MesaiSuresi,@GerceklesenBaslangicSaati,@GerceklesenMesaiSuresi,@Aciklama,@FormNo,@Durum)" command has failed ---> 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.SqlInternalConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at AltiKare.Data.Access.AbstractAdapter.ExecuteNonQuery(String commandText, ParameterValueCollection values)
   --- End of inner exception stack trace ---
   at AltiKare.Data.Access.AbstractAdapter.ExecuteNonQuery(String commandText, ParameterValueCollection values)
   at AltiKare.Data.Access.AbstractAdapter.Execute(Insert insertCommand, ParameterValueCollection values)
   at AltiKare.Data.Access.Insert.Execute(Database database, ParameterValueCollection values)
   at AltiKare.Data.Repository.Server.DataTableOperation.Upsert(DataRow row, DataRow parent)
   at AltiKare.Data.Repository.Server.DataTableOperation.Execute(DataTable dataTable, DataTableOperation parentOperation, DataRow parentRow)
   at AltiKare.Data.Repository.Server.SaveDataContext.SaveData(DataTable table, DataTableOperation parentOperation, DataRow parentRow)
   at AltiKare.Data.Repository.Server.DataStore.SaveData(DataTable data)
   at AltiKare.Scripting.Execution.DatabaseProxy.ImportFromXml(ObjectInstance options)
   at binder_for_AltiKare.Scripting.Execution.DatabaseProxy.ImportFromXml(ScriptEngine , Object , Object[] )
   at Jurassic.Compiler.Binder.Call(ScriptEngine engine, Object thisObject, Object[] arguments)
   at Jurassic.Library.ClrFunction.CallLateBound(Object thisObject, Object[] arguments)
   at eval(ScriptEngine , Scope , Object )
   at Jurassic.Compiler.EvalMethodGenerator.Execute()
   at Jurassic.ScriptEngine.Evaluate(ScriptSource source)
   at AltiKare.Scripting.Execution.ScriptContext.Run(ScriptEngine engine, String code)
   at AltiKare.Workflow.Business.Server.Logic.WorkItem.RunPostwork()
   at AltiKare.Workflow.Business.Server.Logic.WorkItem.Process()
   at AltiKare.Workflow.Business.Server.Logic.WorkerTaskCommittedWorkItem.Complete()

Bu hata veritabanındaki bir alana kaydedilmek istenen verinin alanın karakter limitini aşmasından kaynaklanmaktadır.

Çözüm:

Veritabanındaki alanın karakter boyutunu arttırın.