--------------------------------------------------------------- Log Entry : 9/21/2024 9:21:38 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-09-21","Project":325,"ProjectDes":"DUBAI-COM-RESOURCES","Location":"A","UserId":2,"iTransId":0,"Signature":"","Body":[{"sObservation":"wx","iRiskLevel":2,"iActionBy":2,"sActionReq":"dccd","TargetDate":"2024-09-21","sPath":"","sActionBy_Code":"RU/011","sActionBy":"Praveenkumar Kumara Samy","sImages":"","iTransId":0,"ActionBy":2,"ActionReq":"dccd","Observation":"wx","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 9/21/2024 9:22:19 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-09-21","Project":317,"ProjectDes":"RU/021/22/PRJ","Location":"B","UserId":2,"iTransId":0,"Signature":"","Body":[{"sObservation":"qwe","iRiskLevel":3,"iActionBy":16,"sActionReq":"asd","TargetDate":"2024-09-21","sPath":"","sActionBy_Code":"RU/031","sActionBy":"Mirza Habeeb Baig","sImages":"","iTransId":0,"ActionBy":16,"ActionReq":"asd","Observation":"qwe","RiskLevel":3,"Images":""}]} --------------------------------------------------------------- Log Entry : 9/21/2024 9:22:30 AM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value '709,708' to data type int. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.Ray.Mob.Api.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Ray.Mob.Api.Controllers.RayController.DeleteHSE(String iTransId, Int32 UserId) ClientConnectionId:2c47b869-7fe3-40ee-9965-ffcb0030aa5f Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 9/21/2024 9:22:43 AM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value '709,708' to data type int. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.Ray.Mob.Api.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Ray.Mob.Api.Controllers.RayController.DeleteHSE(String iTransId, Int32 UserId) ClientConnectionId:2c47b869-7fe3-40ee-9965-ffcb0030aa5f Error Number:245,State:1,Class:16