--------------------------------------------------------------- Log Entry : 7/27/2024 9:30:05 AM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":0,"Project":319,"Location":"gg","Date":"2024-07-27","Time":"09:26","IncidentType":3,"Severity_Rate":3,"Potential_Rate":2,"IncidentDescription":"5g","DamageDescription":"g","No_Injured_Person":"1","DetailsOfPersons":"gh","ImmediateCauses":"hnn","UnderlyingCauses":"ggg","UserId":1,"Images":"","sPath":"","Others":"","Body":[{"iResponsible":10,"sCloseDate":"dd","iAction":2,"sAction_Des":"c","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 10:13:45 AM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SA0009_RayMobApp_New" requested by the login. The login failed. Login failed for user 'sa'. at Sang.Ray.Mob.Api.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Ray.Mob.Api.Controllers.RayController.ReactUserLogin(String sLoginName, String sPassword) ClientConnectionId:918af194-e0a1-4071-a431-0aed70ecb741 Error Number:4060,State:1,Class:11 --------------------------------------------------------------- Log Entry : 7/27/2024 10:31:55 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-07-27","Project":319,"ProjectDes":"AL AIN-COM-RESOURCES","Location":"dlh","UserId":163,"iTransId":0,"Signature":"","Body":[{"sObservation":"OB","iRiskLevel":1,"iActionBy":9,"sActionReq":"aa","TargetDate":"2024-07-27","sPath":"","sActionBy_Code":"RU/023","sActionBy":"Vijil Israel Johnson","sImages":"","iTransId":0,"imageFiles":[{}],"ActionBy":9,"ActionReq":"aa","Observation":"OB","RiskLevel":1,"Images":"Screenshot (56).png"}]} --------------------------------------------------------------- Log Entry : 7/27/2024 11:26:37 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-07-27","Project":316,"ProjectDes":"RU/038/022/PRJ","Location":"Dubai","UserId":1,"iTransId":0,"Signature":"","Body":[{"sObservation":"Ob1","iRiskLevel":1,"iActionBy":20,"sActionReq":"Act1","TargetDate":"2024-07-27","sPath":"","sActionBy_Code":"RU/035","sActionBy":"Subramaniam Narayanaswami","sImages":"","iTransId":0,"imageFiles":[{},{}],"ActionBy":20,"ActionReq":"Act1","Observation":"Ob1","RiskLevel":1,"Images":"wafrah advnce.png;wafrah.png"}]} --------------------------------------------------------------- Log Entry : 7/27/2024 11:32:00 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-07-27","Project":316,"ProjectDes":"RU/038/022/PRJ","Location":"Dubai","UserId":1,"iTransId":639,"Signature":"","Body":[{"iTransId":639,"iTransDtId":873,"sObservation":"Ob1","iRiskLevel":1,"sActionReq":"Act1","iActionBy":20,"TargetDate":"2024-07-26","sImages":"wafrah advnce.png;wafrah.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","ActionBy":20,"ActionReq":"Act1","Observation":"Ob1","RiskLevel":1,"Images":"wafrah advnce.png;wafrah.pngundefined"},{"sObservation":"Ob2","iRiskLevel":2,"iActionBy":20,"sActionReq":"Act2","TargetDate":"2024-07-27","sPath":"","sActionBy_Code":"RU/035","sActionBy":"Subramaniam Narayanaswami","sImages":"","iTransId":0,"ActionBy":20,"ActionReq":"Act2","Observation":"Ob2","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 11:35:06 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-07-27","Project":316,"ProjectDes":"RU/038/022/PRJ","Location":"Dubai","UserId":1,"iTransId":639,"Signature":"","Body":[{"iTransId":639,"iTransDtId":874,"sObservation":"Ob1","iRiskLevel":1,"sActionReq":"Act1","iActionBy":20,"TargetDate":"2024-07-25","sImages":"wafrah advnce.png;wafrah.pngundefined","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","ActionBy":20,"ActionReq":"Act1","Observation":"Ob1","RiskLevel":1,"Images":"wafrah advnce.png;wafrah.pngundefinedundefined"},{"iTransId":639,"iTransDtId":875,"sObservation":"Ob2","iRiskLevel":2,"sActionReq":"Act2","iActionBy":20,"TargetDate":"2024-07-26","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","ActionBy":20,"ActionReq":"Act2","Observation":"Ob2","RiskLevel":2,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 7/27/2024 11:38:07 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-07-27","Project":316,"ProjectDes":"RU/038/022/PRJ","Location":"Dubai","UserId":1,"iTransId":639,"Signature":"","Body":[{"iTransId":639,"iTransDtId":876,"sObservation":"Ob1","iRiskLevel":1,"sActionReq":"Act1","iActionBy":20,"TargetDate":"2024-07-24","sImages":"wafrah advnce.png;wafrah.pngundefinedundefined","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","ActionBy":20,"ActionReq":"Act1","Observation":"Ob1","RiskLevel":1,"Images":"wafrah advnce.png;wafrah.pngundefinedundefinedundefined"},{"sObservation":"Ob2","iRiskLevel":2,"iActionBy":9,"sActionReq":"Act2","TargetDate":"2024-07-25","sPath":"","sActionBy_Code":"RU/023","sActionBy":"Vijil Israel Johnson","sImages":"","iTransId":639,"ActionBy":9,"ActionReq":"Act2","Observation":"Ob2","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 11:48:18 AM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":0,"Project":317,"Location":"Knr","Date":"2024-07-27","Time":"11:44","IncidentType":7,"Severity_Rate":4,"Potential_Rate":1,"IncidentDescription":"des","DamageDescription":"damage","No_Injured_Person":"1","DetailsOfPersons":"aa","ImmediateCauses":"imm","UnderlyingCauses":"causes","UserId":1,"Images":"wafrah.png;wafrah advnce.png","sPath":"","Others":"","Body":[{"iResponsible":16,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:11:25 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":107,"Project":317,"Location":"Knr","Date":"2024-07-27","Time":"11:44","IncidentType":7,"Severity_Rate":4,"Potential_Rate":1,"IncidentDescription":"des","DamageDescription":"damage","No_Injured_Person":1,"DetailsOfPersons":"aa","ImmediateCauses":"imm","UnderlyingCauses":"causes","UserId":1,"Images":"wafrah.png;wafrah advnce.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/Incident/","Others":"","Body":[{"iResponsible":16,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""},{"iResponsible":8,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:15:36 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":107,"Project":317,"Location":"Knr","Date":"2024-07-27","Time":"11:44","IncidentType":7,"Severity_Rate":4,"Potential_Rate":1,"IncidentDescription":"des","DamageDescription":"damage","No_Injured_Person":1,"DetailsOfPersons":"aa","ImmediateCauses":"imm","UnderlyingCauses":"causes","UserId":1,"Images":"wafrah.png;wafrah advnce.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/Incident/","Others":"","Body":[{"iResponsible":16,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""},{"iResponsible":20,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:17:29 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":107,"Project":317,"Location":"Knr","Date":"2024-07-27","Time":"11:44","IncidentType":7,"Severity_Rate":4,"Potential_Rate":1,"IncidentDescription":"des","DamageDescription":"damage","No_Injured_Person":1,"DetailsOfPersons":"aa","ImmediateCauses":"imm","UnderlyingCauses":"causes","UserId":1,"Images":"wafrah.png;wafrah advnce.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/Incident/","Others":"","Body":[{"iResponsible":16,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""},{"iResponsible":20,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:17:51 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":107,"Project":317,"Location":"Knr","Date":"2024-07-27","Time":"15:00","IncidentType":7,"Severity_Rate":4,"Potential_Rate":1,"IncidentDescription":"des","DamageDescription":"damage","No_Injured_Person":1,"DetailsOfPersons":"aa","ImmediateCauses":"imm","UnderlyingCauses":"causes","UserId":1,"Images":"wafrah.png;wafrah advnce.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/Incident/","Others":"","Body":[{"iResponsible":16,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""},{"iResponsible":20,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:18:17 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":107,"Project":319,"Location":"Knr","Date":"2024-07-27","Time":"15:00","IncidentType":7,"Severity_Rate":4,"Potential_Rate":1,"IncidentDescription":"des","DamageDescription":"damage","No_Injured_Person":1,"DetailsOfPersons":"aa","ImmediateCauses":"imm","UnderlyingCauses":"causes","UserId":1,"Images":"wafrah.png;wafrah advnce.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/Incident/","Others":"","Body":[{"iResponsible":16,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""},{"iResponsible":20,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:20:10 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":107,"Project":319,"Location":"Knr","Date":"2024-07-27","Time":"15:00","IncidentType":7,"Severity_Rate":4,"Potential_Rate":1,"IncidentDescription":"des","DamageDescription":"damage","No_Injured_Person":1,"DetailsOfPersons":"aa","ImmediateCauses":"imm","UnderlyingCauses":"causes","UserId":1,"Images":"wafrah.png;wafrah advnce.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/Incident/","Others":"","Body":[{"iResponsible":16,"sCloseDate":"27-07-2024","iAction":1,"sAction_Des":"ac","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:26:22 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":43,"DocDate":"2024-07-26","Project":317,"ProjectDes":"RU/021/22/PRJ","Location":"Kannur","SiteIncharge":8,"Client":"AADC","DetailsOfLG":"de","SlNoOfLG":"11","sGeneralComments":"test","UserId":1,"Images":"wafrah advnce.png;wafrah.png","Signature":"","Body":[]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:26:52 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":43,"DocDate":"2024-07-26","Project":295,"ProjectDes":"ABU DHABI-COM-RESOURCES","Location":"Kannur","SiteIncharge":21,"Client":"","DetailsOfLG":"de","SlNoOfLG":"11","sGeneralComments":"test","UserId":1,"Images":"wafrah advnce.png;wafrah.png","Signature":"","Body":[]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:31:04 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":0,"DocDate":"2024-07-26","Project":325,"ProjectDes":"DUBAI-COM-RESOURCES","Location":"Dubai","SiteIncharge":2602,"Client":"","DetailsOfLG":"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean m","SlNoOfLG":"11","sGeneralComments":"Test Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu","UserId":1,"Images":"","Signature":"","Body":[{},{},{},{},{},{},{},{},{},{}]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:34:06 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":44,"DocDate":"2024-07-26","Project":325,"ProjectDes":"DUBAI-COM-RESOURCES","Location":"Dubai","SiteIncharge":2602,"Client":"","DetailsOfLG":"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean m","SlNoOfLG":"11","sGeneralComments":"Test Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu","UserId":1,"Images":"wafrah advnce.png;wafrah.png","Signature":"","Body":[]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:34:43 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":44,"DocDate":"2024-07-26","Project":325,"ProjectDes":"DUBAI-COM-RESOURCES","Location":"Dubai","SiteIncharge":2602,"Client":"","DetailsOfLG":"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean m","SlNoOfLG":"11","sGeneralComments":"Test Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu","UserId":1,"Images":"wafrah advnce.png","Signature":"","Body":[]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:35:13 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":44,"DocDate":"2024-07-26","Project":325,"ProjectDes":"DUBAI-COM-RESOURCES","Location":"Dubai","SiteIncharge":2602,"Client":"","DetailsOfLG":"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean m","SlNoOfLG":"11","sGeneralComments":"Test Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu","UserId":1,"Images":"wafrah advnce.png","Signature":"","Body":[]} --------------------------------------------------------------- Log Entry : 7/27/2024 3:58:21 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":0,\"DocDate\":\"2024-07-27\",\"Project\":319,\"ProjectDes\":\"AL AIN-COM-RESOURCES\",\"Location\":\"Kannur\",\"SiteIncharge\":2460,\"Client\":\"\",\"sGeneralComments\":\"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu\",\"UserId\":1,\"Mark_Model\":\"MD 2\",\"DrivingLicenceExpiry\":\"2024-07-30\",\"RegistrationNo\":\"R-12345\",\"OperatorName\":\"OP1\",\"Images\":\"wafrah.png;max_para.png\",\"Signature\":\"\",\"Body\":[{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]}" --------------------------------------------------------------- Log Entry : 7/27/2024 3:59:24 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":25,\"DocDate\":\"2024-07-27\",\"Project\":317,\"ProjectDes\":\"RU/021/22/PRJ\",\"Location\":\"Kannur\",\"SiteIncharge\":2460,\"Client\":\"AADC\",\"sGeneralComments\":\"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu\",\"UserId\":1,\"Mark_Model\":\"MD 2\",\"DrivingLicenceExpiry\":\"2024-07-30\",\"RegistrationNo\":\"R-12345\",\"OperatorName\":\"OP1\",\"Images\":\"wafrah.png;max_para.png\",\"Signature\":\"\",\"Body\":[]}" --------------------------------------------------------------- Log Entry : 7/27/2024 4:03:39 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":25,\"DocDate\":\"2024-07-27\",\"Project\":317,\"ProjectDes\":\"RU/021/22/PRJ\",\"Location\":\"Kannur\",\"SiteIncharge\":2460,\"Client\":\"AADC\",\"sGeneralComments\":\"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu\",\"UserId\":1,\"Mark_Model\":\"MD 2\",\"DrivingLicenceExpiry\":\"2024-07-30\",\"RegistrationNo\":\"R-12345\",\"OperatorName\":\"OP1\",\"Images\":\"wafrah.png;max_para.png\",\"Signature\":\"\",\"Body\":[]}" --------------------------------------------------------------- Log Entry : 7/27/2024 4:04:19 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":25,\"DocDate\":\"2024-07-27\",\"Project\":295,\"ProjectDes\":\"ABU DHABI-COM-RESOURCES\",\"Location\":\"Kannur\",\"SiteIncharge\":2460,\"Client\":\"\",\"sGeneralComments\":\"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu\",\"UserId\":1,\"Mark_Model\":\"MD 2\",\"DrivingLicenceExpiry\":\"2024-07-30\",\"RegistrationNo\":\"R-12345\",\"OperatorName\":\"OP1\",\"Images\":\"wafrah.png;max_para.png\",\"Signature\":\"\",\"Body\":[]}" --------------------------------------------------------------- Log Entry : 7/27/2024 4:04:37 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":25,\"DocDate\":\"2024-07-27\",\"Project\":295,\"ProjectDes\":\"ABU DHABI-COM-RESOURCES\",\"Location\":\"Kannur\",\"SiteIncharge\":2460,\"Client\":\"\",\"sGeneralComments\":\"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec qu\",\"UserId\":1,\"Mark_Model\":\"MD 2\",\"DrivingLicenceExpiry\":\"2024-07-30\",\"RegistrationNo\":\"R-12345\",\"OperatorName\":\"OP1\",\"Images\":\"wafrah.png\",\"Signature\":\"\",\"Body\":[]}" --------------------------------------------------------------- Log Entry : 7/27/2024 4:19:13 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":226,"DocDate":"2024-07-25","Project":338,"ProjectDes":"ADF Relay Replacement","Location":"Africa","SiteIncharge":26,"Client":"ADF","sGeneralComments":"Test","UserId":1,"Images":"max_para.png;max_para.png","Signature":"","Body":[]} --------------------------------------------------------------- Log Entry : 7/27/2024 4:22:02 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":0,"DocDate":"2024-07-27","Project":317,"ProjectDes":"RU/021/22/PRJ","Location":"Kannur","SiteIncharge":21,"Client":"AADC","sGeneralComments":"comm","UserId":1,"Images":"","Signature":"","Body":[{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]} --------------------------------------------------------------- Log Entry : 7/27/2024 4:26:11 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":0,"DocDate":"2024-07-27","Project":187,"ProjectDes":"DEPARTMENTAL COST","Location":"Dubai","SiteIncharge":2594,"Client":"","sGeneralComments":"Comm","UserId":1,"Images":"wafrah.png","Signature":"","Body":[{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]} --------------------------------------------------------------- Log Entry : 7/27/2024 4:44:55 PM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value '44,42,43,41' 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.DeleteLGIC(String iTransId, Int32 UserId) ClientConnectionId:1203b899-f134-415a-910e-0586eeca8180 Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 7/27/2024 4:53:49 PM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value '638,639' 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:04df876f-08f4-4cc7-b01f-faac73d52157 Error Number:245,State:1,Class:16