--------------------------------------------------------------- Log Entry : 2/20/2024 9:53:33 AM - ------------------------------------------------------------- RayController Method:PostHSE {"iTransId":0,"DocDate":"2024-02-20","Project":3370,"ProjectDes":"hngb","Location":"g","UserId":1100,"Signature":"sign09533020022024.jpg","Body":[{"Observation":"a","RiskLevel":1,"ActionReq":"s","ActionBy":2602,"TargetDate":"2024-02-20","Images":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 9:55:46 AM - ------------------------------------------------------------- RayController Method:PostHSE {"iTransId":0,"DocDate":"2024-02-20","Project":353,"ProjectDes":",mjutgh","Location":"gj","UserId":1100,"Signature":"sign09554220022024.jpg","Body":[{"Observation":"f","RiskLevel":1,"ActionReq":"s","ActionBy":2602,"TargetDate":"2024-02-20","Images":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 10:04:57 AM - ------------------------------------------------------------- RayController Method:PostHSE {"iTransId":8531,"DocDate":"2024-01-19","Project":353,"ProjectDes":",mjutgh","Location":"g","UserId":1080,"Signature":"sign12073919012024.jpg","Body":[{"Observation":"d","RiskLevel":2,"ActionReq":"n","ActionBy":2552,"TargetDate":"2024-01-19","Images":"12073319012024.jpg"}]} --------------------------------------------------------------- Log Entry : 2/20/2024 10:45:15 AM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":0,"iHSETransDtId":5809,"Date":"2024-02-20","Status":3,"Remarks":"in progress","UserId":1100,"Images":""} --------------------------------------------------------------- Log Entry : 2/20/2024 10:46:21 AM - ------------------------------------------------------------- RayController Method:PostHSE {"iTransId":0,"DocDate":"2024-02-20","Project":3370,"ProjectDes":"hngb","Location":"dlh","UserId":1080,"Signature":"sign10461820022024.jpg","Body":[{"Observation":"a","RiskLevel":3,"ActionReq":"sij","ActionBy":2552,"TargetDate":"2024-02-20","Images":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 10:46:53 AM - ------------------------------------------------------------- RayController Method:PostHSE {"iTransId":0,"DocDate":"2024-02-20","Project":295,"ProjectDes":"ABU DHABI-COM-RESOURCES","Location":"gh","UserId":1080,"Signature":"sign10465020022024.jpg","Body":[{"Observation":"a","RiskLevel":2,"ActionReq":"a","ActionBy":2552,"TargetDate":"2024-02-20","Images":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 10:47:29 AM - ------------------------------------------------------------- RayController Method:PostHSE {"iTransId":0,"DocDate":"2024-02-20","Project":332,"ProjectDes":"dlh123","Location":"gh","UserId":1080,"Signature":"sign10472620022024.jpg","Body":[{"Observation":"a","RiskLevel":3,"ActionReq":"g","ActionBy":2552,"TargetDate":"2024-02-20","Images":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 10:47:55 AM - ------------------------------------------------------------- RayController Method:PostHSE {"iTransId":0,"DocDate":"2024-02-20","Project":295,"ProjectDes":"ABU DHABI-COM-RESOURCES","Location":"g","UserId":1080,"Signature":"sign10475220022024.jpg","Body":[{"Observation":"h","RiskLevel":3,"ActionReq":"g","ActionBy":2552,"TargetDate":"2024-02-20","Images":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 10:48:27 AM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":0,"iHSETransDtId":8526,"Date":"2024-02-20","Status":1,"Remarks":"open stats","UserId":1100,"Images":""} --------------------------------------------------------------- Log Entry : 2/20/2024 10:48:39 AM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":0,"iHSETransDtId":8525,"Date":"2024-02-20","Status":3,"Remarks":"in pgres","UserId":1100,"Images":""} --------------------------------------------------------------- Log Entry : 2/20/2024 10:48:51 AM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":0,"iHSETransDtId":8524,"Date":"2024-02-20","Status":4,"Remarks":"onhld","UserId":1100,"Images":""} --------------------------------------------------------------- Log Entry : 2/20/2024 10:49:05 AM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":0,"iHSETransDtId":8522,"Date":"2024-02-20","Status":5,"Remarks":"rslvd","UserId":1100,"Images":""} --------------------------------------------------------------- Log Entry : 2/20/2024 11:46:24 AM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":0,\"DocDate\":\"2024-02-20\",\"Project\":3370,\"ProjectDes\":\"hngb\",\"Location\":\"Dlh\",\"SiteIncharge\":2602,\"Client\":\"abc\",\"sGeneralComments\":\"gnrl cmmnts\",\"UserId\":1100,\"Mark_Model\":\"mke\",\"DrivingLicenceExpiry\":\"2024-02-02\",\"RegistrationNo\":\"hnb7\",\"OperatorName\":\"operator nme\",\"Images\":\"\",\"Signature\":\"\",\"Body\":[{\"SlNo\":1,\"Items\":70,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":2,\"Items\":71,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":3,\"Items\":72,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":4,\"Items\":73,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":5,\"Items\":74,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":6,\"Items\":75,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":7,\"Items\":76,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":8,\"Items\":77,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":9,\"Items\":78,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":10,\"Items\":79,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 2/20/2024 11:50:12 AM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":2054,\"DocDate\":\"2024-02-20\",\"Project\":3370,\"ProjectDes\":\"hngb\",\"Location\":\"Dlh\",\"SiteIncharge\":2602,\"Client\":\"abc\",\"sGeneralComments\":\"gnrl cmmnts\",\"UserId\":1100,\"Mark_Model\":\"mke\",\"DrivingLicenceExpiry\":\"2024-02-02\",\"RegistrationNo\":\"hnb7\",\"OperatorName\":\"operator nme\",\"Images\":\"\",\"Signature\":\"\",\"Body\":[{\"SlNo\":1,\"Items\":70,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":2,\"Items\":71,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":3,\"Items\":72,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":4,\"Items\":73,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":5,\"Items\":74,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":6,\"Items\":75,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":7,\"Items\":76,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":8,\"Items\":77,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":9,\"Items\":78,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":10,\"Items\":79,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 2/20/2024 11:55:23 AM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":2054,\"DocDate\":\"2024-02-20\",\"Project\":3370,\"ProjectDes\":\"hngb\",\"Location\":\"Dlh\",\"SiteIncharge\":2602,\"Client\":\"abc\",\"sGeneralComments\":\"gnrl cmmnts\",\"UserId\":1100,\"Mark_Model\":\"mke\",\"DrivingLicenceExpiry\":\"2024-02-02\",\"RegistrationNo\":\"hnb7\",\"OperatorName\":\"operator nme\",\"Images\":\"gn.png\",\"Signature\":\"\",\"Body\":[{\"SlNo\":1,\"Items\":70,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":2,\"Items\":71,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":3,\"Items\":72,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":4,\"Items\":73,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":5,\"Items\":74,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":6,\"Items\":75,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":7,\"Items\":76,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":8,\"Items\":77,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":9,\"Items\":78,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":10,\"Items\":79,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 2/20/2024 12:27:28 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":0,"iHSETransDtId":0,"Date":"string","Status":0,"Remarks":"string","UserId":0,"Images":"string"} --------------------------------------------------------------- Log Entry : 2/20/2024 12:27:28 PM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. 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.PostCloseHSE(CloseHSE obj) ClientConnectionId:c666be4d-63e8-475c-a6b1-2667477b3e17 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/20/2024 12:32:04 PM - ------------------------------------------------------------- RayController Method:Ray System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.Collections.ArrayList.get_Item(Int32 index) at System.Collections.Specialized.NameValueCollection.GetKey(Int32 index) at System.Web.HttpValueCollection.Get(Int32 index) at Sang.Ray.Mob.Api.Controllers.RayController.FileUpload() --------------------------------------------------------------- Log Entry : 2/20/2024 2:36:58 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"rrt","UserId":1100,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 2:36:58 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"rrt","UserId":1100,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 2:36:58 PM - ------------------------------------------------------------- {"iType":4} --------------------------------------------------------------- Log Entry : 2/20/2024 2:36:58 PM - ------------------------------------------------------------- RayController Method:Ray System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Sang.Ray.Mob.Api.Controllers.RayController.FileUpload() --------------------------------------------------------------- Log Entry : 2/20/2024 2:36:58 PM - ------------------------------------------------------------- {"iType":4} --------------------------------------------------------------- Log Entry : 2/20/2024 2:36:58 PM - ------------------------------------------------------------- RayController Method:Ray System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Sang.Ray.Mob.Api.Controllers.RayController.FileUpload() --------------------------------------------------------------- Log Entry : 2/20/2024 2:38:20 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"gy","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 2:38:20 PM - ------------------------------------------------------------- {"iType":4} --------------------------------------------------------------- Log Entry : 2/20/2024 2:38:20 PM - ------------------------------------------------------------- RayController Method:Ray System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Sang.Ray.Mob.Api.Controllers.RayController.FileUpload() --------------------------------------------------------------- Log Entry : 2/20/2024 2:38:57 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"gy","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 2:38:58 PM - ------------------------------------------------------------- {"iType":4} --------------------------------------------------------------- Log Entry : 2/20/2024 2:38:58 PM - ------------------------------------------------------------- RayController Method:Ray System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Sang.Ray.Mob.Api.Controllers.RayController.FileUpload() --------------------------------------------------------------- Log Entry : 2/20/2024 2:41:44 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"gy","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 2:41:44 PM - ------------------------------------------------------------- {"iType":4} --------------------------------------------------------------- Log Entry : 2/20/2024 2:41:44 PM - ------------------------------------------------------------- RayController Method:Ray System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Sang.Ray.Mob.Api.Controllers.RayController.FileUpload() --------------------------------------------------------------- Log Entry : 2/20/2024 2:42:52 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":8523,"iHSETransDtId":0,"Date":"2024-02-20","Status":1,"Remarks":"dwwdw","UserId":1100,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114757.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 2:42:53 PM - ------------------------------------------------------------- {"iType":4} --------------------------------------------------------------- Log Entry : 2/20/2024 2:42:53 PM - ------------------------------------------------------------- RayController Method:Ray System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Sang.Ray.Mob.Api.Controllers.RayController.FileUpload() --------------------------------------------------------------- Log Entry : 2/20/2024 3:21:07 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2023-10-09","Project":295,"ProjectDes":"ABU DHABI-COM-RESOURCES","Location":"Loc1","UserId":1100,"iTransId":8551,"Signature":"","Body":[{"sObservation":"Test","iRiskLevel":2,"iActionBy":37,"sActionReq":"User1","TargetDate":"04-02-2023","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy_Code":"RU/052","sActionBy":"Shamsher Hyder Rafique","sImages":"1.jpg","iTransId":8551,"imageFiles":[{}],"ActionBy":37,"ActionReq":"User1","Observation":"Test","RiskLevel":2,"Images":"1.jpg;Screenshot 2024-02-05 114649.png"},{"sObservation":"Test","iRiskLevel":2,"iActionBy":17,"sActionReq":"Test1","TargetDate":"04-02-2023","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy_Code":"RU/032","sActionBy":"Rajasekaran Vaithiyanathan","sImages":"3.jpg","iTransId":8551,"imageFiles":[{}],"ActionBy":17,"ActionReq":"Test1","Observation":"Test","RiskLevel":2,"Images":"3.jpg;Screenshot 2024-02-05 114757.png"}]} --------------------------------------------------------------- Log Entry : 2/20/2024 3:30:53 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"rgrrg","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 3:30:53 PM - ------------------------------------------------------------- {"iType":4} --------------------------------------------------------------- Log Entry : 2/20/2024 3:30:53 PM - ------------------------------------------------------------- RayController Method:Ray System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Sang.Ray.Mob.Api.Controllers.RayController.FileUpload() --------------------------------------------------------------- Log Entry : 2/20/2024 3:38:46 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"ffefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 3:38:46 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"ffefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 3:38:46 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 3:38:46 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"ffefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 3:38:46 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 3:38:46 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 3:38:46 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"ffefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 3:38:46 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 3:39:31 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"ffefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 3:39:32 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 3:39:34 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"ffefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 3:39:34 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 3:39:35 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"ffefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 3:39:35 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 4:09:51 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"fefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 4:09:51 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 4:09:56 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"fefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 4:09:56 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 4:11:42 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"fefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 4:11:43 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 4:14:06 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"fefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114649.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 4:14:06 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 4:16:56 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":5809,"iHSETransDtId":5809,"Date":"2023-07-27","Status":3,"Remarks":"fefe","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114649.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 4:16:57 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 4:17:43 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":8524,"iHSETransDtId":8524,"Date":"2024-02-20","Status":4,"Remarks":"t4t4t4","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 4:17:44 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 4:18:32 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":8524,"iHSETransDtId":8524,"Date":"2024-02-20","Status":4,"Remarks":"t4t4t4","UserId":1100,"Images":"Screenshot 2024-02-05 114251.png;Screenshot 2024-02-05 114251.png"} --------------------------------------------------------------- Log Entry : 2/20/2024 4:18:32 PM - ------------------------------------------------------------- 4 --------------------------------------------------------------- Log Entry : 2/20/2024 5:23:37 PM - ------------------------------------------------------------- AuthorizationEmail sended --------------------------------------------------------------- Log Entry : 2/20/2024 5:23:51 PM - ------------------------------------------------------------- AuthorizationEmail sended --------------------------------------------------------------- Log Entry : 2/20/2024 5:48:07 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-19","Project":353,"ProjectDes":",mjutgh","Location":"abc","UserId":1100,"iTransId":0,"Signature":"","Body":[]} --------------------------------------------------------------- Log Entry : 2/20/2024 5:50:38 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":187,"ProjectDes":"DEPARTMENTAL COST","Location":"uae","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"adf","iRiskLevel":2,"iActionBy":2553,"sActionReq":"fdfd","TargetDate":"2024-02-22","sPath":"","sActionBy_Code":"RU/538","sActionBy":"Amrutha","sImages":"","iTransId":0,"ActionBy":2553,"ActionReq":"fdfd","Observation":"adf","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 5:51:38 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":329,"ProjectDes":"todayproj","Location":"us","UserId":1100,"iTransId":8600,"Signature":"","Body":[{"iTransId":8600,"iTransDtId":8529,"sObservation":"adf","iRiskLevel":2,"sActionReq":"fdfd","iActionBy":2553,"TargetDate":"22-02-2024","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Amrutha","sActionBy_Code":"RU/538","ActionBy":2553,"ActionReq":"fdfd","Observation":"adf","RiskLevel":2,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 2/20/2024 5:51:38 PM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 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, 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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Ray.Mob.Api.General.DBHelper.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Ray.Mob.Api.Controllers.RayController.PostHSE() ClientConnectionId:09c70f08-6c0e-48e8-bddf-0bf4075375db Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/20/2024 5:59:33 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-20","Project":36,"ProjectDes":"GENERAL","Location":"florida","UserId":1100,"iTransId":0,"Signature":"","Body":[]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:02:55 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-20","Project":3370,"ProjectDes":"hngb","Location":"GB","UserId":1100,"iTransId":8592,"Signature":"","Body":[{"iTransId":8592,"iTransDtId":8519,"sObservation":"nn","iRiskLevel":2,"sActionReq":"mm","iActionBy":2602,"TargetDate":"17-02-2024","sImages":"gn.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"sijina","sActionBy_Code":"RU/602","ActionBy":2602,"ActionReq":"mm","Observation":"nn","RiskLevel":2,"Images":"gn.pngundefined"}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:02:55 PM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 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, 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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Ray.Mob.Api.General.DBHelper.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Ray.Mob.Api.Controllers.RayController.PostHSE() ClientConnectionId:5d557e03-2990-4d73-bec7-7febc2654ad2 Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/20/2024 6:03:12 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-20","Project":3370,"ProjectDes":"hngb","Location":"GB","UserId":1100,"iTransId":8592,"Signature":"","Body":[{"iTransId":8592,"iTransDtId":8519,"sObservation":"nn","iRiskLevel":2,"sActionReq":"mm","iActionBy":2602,"TargetDate":"17-02-2024","sImages":"gn.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"sijina","sActionBy_Code":"RU/602","ActionBy":2602,"ActionReq":"mm","Observation":"nn","RiskLevel":2,"Images":"gn.pngundefined"}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:03:12 PM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 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, 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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Ray.Mob.Api.General.DBHelper.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Ray.Mob.Api.Controllers.RayController.PostHSE() ClientConnectionId:5d557e03-2990-4d73-bec7-7febc2654ad2 Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/20/2024 6:03:22 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-14","Project":3370,"ProjectDes":"hngb","Location":"GB","UserId":1100,"iTransId":8592,"Signature":"","Body":[{"iTransId":8592,"iTransDtId":8519,"sObservation":"nn","iRiskLevel":2,"sActionReq":"mm","iActionBy":2602,"TargetDate":"17-02-2024","sImages":"gn.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"sijina","sActionBy_Code":"RU/602","ActionBy":2602,"ActionReq":"mm","Observation":"nn","RiskLevel":2,"Images":"gn.pngundefined"}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:03:22 PM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 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, 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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Ray.Mob.Api.General.DBHelper.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Ray.Mob.Api.Controllers.RayController.PostHSE() ClientConnectionId:5d557e03-2990-4d73-bec7-7febc2654ad2 Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/20/2024 6:10:57 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":0,"Project":22,"Location":"dubai","Date":"2024-02-20","Time":"08:13","IncidentType":2,"Severity_Rate":2,"Potential_Rate":3,"IncidentDescription":"tyry","DamageDescription":"dsf","No_Injured_Person":"5","DetailsOfPersons":"a,b,c,d","ImmediateCauses":"ffgfjg","UnderlyingCauses":"ioio","UserId":1100,"Images":"","sPath":"","Others":"","Body":[{"iResponsible":9,"sCloseDate":"20-2-2024","iAction":1,"sAction_Des":"xys","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:10:58 PM - ------------------------------------------------------------- RayController Method: Ray CrystalDecisions.Shared.CrystalReportsException: Load report failed. ---> System.Runtime.InteropServices.COMException: The maximum report processing jobs limit configured by your system administrator has been reached. at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() --- End of inner exception stack trace --- at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) at Sang.Ray.Mob.Api.Controllers.RayController.CrystalPrint(Int32 iTransId) --------------------------------------------------------------- Log Entry : 2/20/2024 6:10:58 PM - ------------------------------------------------------------- RayController Method: Ray System.IO.FileNotFoundException: Could not find file 'c:\windows\system32\inetsrv\Load report failed'. File name: 'c:\windows\system32\inetsrv\Load report failed' at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at System.Net.Mail.AttachmentBase.SetContentFromFile(String fileName, String mediaType) at Sang.Ray.Mob.Api.Controllers.RayController.d__37.MoveNext() --------------------------------------------------------------- Log Entry : 2/20/2024 6:13:31 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":7152,"Project":187,"Location":"abudhabi","Date":"2024-02-20","Time":"08:13","IncidentType":2,"Severity_Rate":2,"Potential_Rate":4,"IncidentDescription":"tyry","DamageDescription":"dsf","No_Injured_Person":"10","DetailsOfPersons":"a,b,c,d","ImmediateCauses":"ffgfjg","UnderlyingCauses":"ioio","UserId":1100,"Images":"","sPath":"","Others":"","Body":[{"iResponsible":9,"sCloseDate":"20-2-2024","iAction":1,"sAction_Des":"xys","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:13:32 PM - ------------------------------------------------------------- RayController Method: Ray CrystalDecisions.Shared.CrystalReportsException: Load report failed. ---> System.Runtime.InteropServices.COMException: The maximum report processing jobs limit configured by your system administrator has been reached. at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() --- End of inner exception stack trace --- at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) at Sang.Ray.Mob.Api.Controllers.RayController.CrystalPrint(Int32 iTransId) --------------------------------------------------------------- Log Entry : 2/20/2024 6:13:32 PM - ------------------------------------------------------------- RayController Method: Ray System.IO.FileNotFoundException: Could not find file 'c:\windows\system32\inetsrv\Load report failed'. File name: 'c:\windows\system32\inetsrv\Load report failed' at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at System.Net.Mail.AttachmentBase.SetContentFromFile(String fileName, String mediaType) at Sang.Ray.Mob.Api.Controllers.RayController.d__37.MoveNext() --------------------------------------------------------------- Log Entry : 2/20/2024 6:20:30 PM - ------------------------------------------------------------- AuthorizationEmail sended --------------------------------------------------------------- Log Entry : 2/20/2024 6:25:17 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":0,"Project":21,"Location":"dxb","Date":"2024-02-20","Time":"18:24","IncidentType":5,"Severity_Rate":3,"Potential_Rate":3,"IncidentDescription":"sf","DamageDescription":"dgd","No_Injured_Person":"2","DetailsOfPersons":"a","ImmediateCauses":"r","UnderlyingCauses":"ku","UserId":1100,"Images":"","sPath":"","Others":"","Body":[{"iResponsible":2,"sCloseDate":"29-2-2024","iAction":2,"sAction_Des":"fgfd","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:25:18 PM - ------------------------------------------------------------- RayController Method: Ray CrystalDecisions.Shared.CrystalReportsException: Load report failed. ---> System.Runtime.InteropServices.COMException: The maximum report processing jobs limit configured by your system administrator has been reached. at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() --- End of inner exception stack trace --- at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) at Sang.Ray.Mob.Api.Controllers.RayController.CrystalPrint(Int32 iTransId) --------------------------------------------------------------- Log Entry : 2/20/2024 6:25:18 PM - ------------------------------------------------------------- RayController Method: Ray System.IO.FileNotFoundException: Could not find file 'c:\windows\system32\inetsrv\Load report failed'. File name: 'c:\windows\system32\inetsrv\Load report failed' at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at System.Net.Mail.AttachmentBase.SetContentFromFile(String fileName, String mediaType) at Sang.Ray.Mob.Api.Controllers.RayController.d__37.MoveNext() --------------------------------------------------------------- Log Entry : 2/20/2024 6:27:16 PM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":295,"ProjectCode":"ABU DHABI-COM-RESOURCES","Location":"uae","UserId":1100,"Activity":"tuy","CorrectiveAction":"sere","Observation":"sdf","iObserver":20,"Images":"","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/20/2024 6:29:29 PM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8141,"Project":336,"ProjectCode":"1256","Location":"uae","UserId":1100,"Activity":"tuy","CorrectiveAction":"sere","Observation":"sdf","iObserver":21,"Images":"","iType":2,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/20/2024 6:37:31 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":0,"DocDate":"2024-02-20","Project":342,"ProjectDes":"rw","Location":"dubai","SiteIncharge":254,"Client":"","DetailsOfLG":"dg","SlNoOfLG":"ddsf","sGeneralComments":"dfd","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":1,"Compliance":2,"Remarks":""},{"SlNo":2,"Items":2,"Compliance":3,"Remarks":""},{"SlNo":3,"Items":3,"Compliance":1,"Remarks":""},{"SlNo":4,"Items":4,"Compliance":2,"Remarks":""},{"SlNo":5,"Items":5,"Compliance":3,"Remarks":""},{"SlNo":6,"Items":6,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":7,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":8,"Compliance":3,"Remarks":""},{"SlNo":9,"Items":9,"Compliance":3,"Remarks":""},{"SlNo":10,"Items":10,"Compliance":2,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:38:15 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":2077,"DocDate":"2024-02-15","Project":253,"ProjectDes":"RU/712/20/PRJ","Location":"dubai","SiteIncharge":8,"Client":"","DetailsOfLG":"dg","SlNoOfLG":"ddsf","sGeneralComments":"dfd","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":1,"Compliance":2,"Remarks":""},{"SlNo":2,"Items":2,"Compliance":3,"Remarks":""},{"SlNo":3,"Items":3,"Compliance":1,"Remarks":""},{"SlNo":4,"Items":4,"Compliance":2,"Remarks":""},{"SlNo":5,"Items":5,"Compliance":3,"Remarks":""},{"SlNo":6,"Items":6,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":7,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":8,"Compliance":3,"Remarks":""},{"SlNo":9,"Items":9,"Compliance":3,"Remarks":""},{"SlNo":10,"Items":10,"Compliance":2,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:53:21 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":0,"DocDate":"2024-02-20","Project":9,"ProjectDes":"RAY UAE (FINANCE)","Location":"US","SiteIncharge":20,"Client":"treesa tester","DetailsOfLG":"GHGFH","SlNoOfLG":"LLL","sGeneralComments":"DSGFDG","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":1,"Compliance":1,"Remarks":""},{"SlNo":2,"Items":2,"Compliance":2,"Remarks":""},{"SlNo":3,"Items":3,"Compliance":0,"Remarks":""},{"SlNo":4,"Items":4,"Compliance":0,"Remarks":""},{"SlNo":5,"Items":5,"Compliance":0,"Remarks":""},{"SlNo":6,"Items":6,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":7,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":8,"Compliance":0,"Remarks":""},{"SlNo":9,"Items":9,"Compliance":0,"Remarks":""},{"SlNo":10,"Items":10,"Compliance":0,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:56:37 PM - ------------------------------------------------------------- RayController Method:PostQHSE {"iTransId":0,"DocDate":"2024-02-20","Project":18,"ProjectDes":"Project Department","Location":"fhgfjgf","Client":"","SiteIncharge":2580,"Activity":"dgfd","sGeneralComments":"ffdh","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":11,"Compliance":0,"Remarks":""},{"SlNo":2,"Items":12,"Compliance":0,"Remarks":""},{"SlNo":3,"Items":13,"Compliance":0,"Remarks":""},{"SlNo":4,"Items":14,"Compliance":0,"Remarks":""},{"SlNo":5,"Items":15,"Compliance":0,"Remarks":""},{"SlNo":6,"Items":16,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":17,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":18,"Compliance":0,"Remarks":""},{"SlNo":9,"Items":19,"Compliance":0,"Remarks":""},{"SlNo":10,"Items":20,"Compliance":0,"Remarks":""},{"SlNo":11,"Items":21,"Compliance":0,"Remarks":""},{"SlNo":12,"Items":22,"Compliance":0,"Remarks":""},{"SlNo":13,"Items":23,"Compliance":0,"Remarks":""},{"SlNo":14,"Items":24,"Compliance":0,"Remarks":""},{"SlNo":15,"Items":25,"Compliance":0,"Remarks":""},{"SlNo":16,"Items":26,"Compliance":0,"Remarks":""},{"SlNo":17,"Items":27,"Compliance":0,"Remarks":""},{"SlNo":18,"Items":28,"Compliance":0,"Remarks":""},{"SlNo":19,"Items":29,"Compliance":0,"Remarks":""},{"SlNo":20,"Items":30,"Compliance":0,"Remarks":""},{"SlNo":21,"Items":31,"Compliance":0,"Remarks":""},{"SlNo":22,"Items":32,"Compliance":0,"Remarks":""},{"SlNo":23,"Items":33,"Compliance":0,"Remarks":""},{"SlNo":24,"Items":34,"Compliance":0,"Remarks":""},{"SlNo":25,"Items":35,"Compliance":0,"Remarks":""},{"SlNo":26,"Items":36,"Compliance":0,"Remarks":""},{"SlNo":27,"Items":37,"Compliance":0,"Remarks":""},{"SlNo":28,"Items":38,"Compliance":0,"Remarks":""},{"SlNo":29,"Items":39,"Compliance":0,"Remarks":""},{"SlNo":30,"Items":40,"Compliance":0,"Remarks":""},{"SlNo":31,"Items":41,"Compliance":0,"Remarks":""},{"SlNo":32,"Items":42,"Compliance":0,"Remarks":""},{"SlNo":33,"Items":43,"Compliance":0,"Remarks":""},{"SlNo":34,"Items":44,"Compliance":0,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 6:58:05 PM - ------------------------------------------------------------- RayController Method:PostQHSE {"iTransId":2041,"DocDate":"2024-02-20","Project":187,"ProjectDes":"DEPARTMENTAL COST","Location":"fhgfjgf","Client":"","SiteIncharge":2580,"Activity":"dgfd","sGeneralComments":"ffdh","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":11,"Compliance":0,"Remarks":""},{"SlNo":2,"Items":12,"Compliance":0,"Remarks":""},{"SlNo":3,"Items":13,"Compliance":0,"Remarks":""},{"SlNo":4,"Items":14,"Compliance":0,"Remarks":""},{"SlNo":5,"Items":15,"Compliance":0,"Remarks":""},{"SlNo":6,"Items":16,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":17,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":18,"Compliance":0,"Remarks":""},{"SlNo":9,"Items":19,"Compliance":0,"Remarks":""},{"SlNo":10,"Items":20,"Compliance":0,"Remarks":""},{"SlNo":11,"Items":21,"Compliance":0,"Remarks":""},{"SlNo":12,"Items":22,"Compliance":0,"Remarks":""},{"SlNo":13,"Items":23,"Compliance":0,"Remarks":""},{"SlNo":14,"Items":24,"Compliance":0,"Remarks":""},{"SlNo":15,"Items":25,"Compliance":0,"Remarks":""},{"SlNo":16,"Items":26,"Compliance":0,"Remarks":""},{"SlNo":17,"Items":27,"Compliance":0,"Remarks":""},{"SlNo":18,"Items":28,"Compliance":0,"Remarks":""},{"SlNo":19,"Items":29,"Compliance":0,"Remarks":""},{"SlNo":20,"Items":30,"Compliance":0,"Remarks":""},{"SlNo":21,"Items":31,"Compliance":0,"Remarks":""},{"SlNo":22,"Items":32,"Compliance":0,"Remarks":""},{"SlNo":23,"Items":33,"Compliance":0,"Remarks":""},{"SlNo":24,"Items":34,"Compliance":0,"Remarks":""},{"SlNo":25,"Items":35,"Compliance":0,"Remarks":""},{"SlNo":26,"Items":36,"Compliance":0,"Remarks":""},{"SlNo":27,"Items":37,"Compliance":0,"Remarks":""},{"SlNo":28,"Items":38,"Compliance":0,"Remarks":""},{"SlNo":29,"Items":39,"Compliance":0,"Remarks":""},{"SlNo":30,"Items":40,"Compliance":0,"Remarks":""},{"SlNo":31,"Items":41,"Compliance":0,"Remarks":""},{"SlNo":32,"Items":42,"Compliance":0,"Remarks":""},{"SlNo":33,"Items":43,"Compliance":0,"Remarks":""},{"SlNo":34,"Items":44,"Compliance":0,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 7:01:21 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":0,"DocDate":"2024-02-20","Project":18,"ProjectDes":"Project Department","Location":"kol","SiteIncharge":2580,"Client":"","sGeneralComments":"ng","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":52,"Compliance":0,"Remarks":""},{"SlNo":2,"Items":53,"Compliance":0,"Remarks":""},{"SlNo":3,"Items":54,"Compliance":0,"Remarks":""},{"SlNo":4,"Items":55,"Compliance":0,"Remarks":""},{"SlNo":5,"Items":56,"Compliance":0,"Remarks":""},{"SlNo":6,"Items":57,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":58,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":59,"Compliance":0,"Remarks":""},{"SlNo":9,"Items":60,"Compliance":0,"Remarks":""},{"SlNo":10,"Items":61,"Compliance":0,"Remarks":""},{"SlNo":11,"Items":62,"Compliance":0,"Remarks":""},{"SlNo":12,"Items":63,"Compliance":0,"Remarks":""},{"SlNo":13,"Items":64,"Compliance":0,"Remarks":""},{"SlNo":14,"Items":65,"Compliance":0,"Remarks":""},{"SlNo":15,"Items":66,"Compliance":0,"Remarks":""},{"SlNo":16,"Items":67,"Compliance":0,"Remarks":""},{"SlNo":17,"Items":68,"Compliance":0,"Remarks":""},{"SlNo":18,"Items":69,"Compliance":0,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 7:01:49 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":2038,"DocDate":"2024-02-20","Project":11,"ProjectDes":"Procurement","Location":"kol","SiteIncharge":2580,"Client":"tester","sGeneralComments":"ng","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":52,"Compliance":0,"Remarks":""},{"SlNo":2,"Items":53,"Compliance":0,"Remarks":""},{"SlNo":3,"Items":54,"Compliance":0,"Remarks":""},{"SlNo":4,"Items":55,"Compliance":0,"Remarks":""},{"SlNo":5,"Items":56,"Compliance":0,"Remarks":""},{"SlNo":6,"Items":57,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":58,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":59,"Compliance":0,"Remarks":""},{"SlNo":9,"Items":60,"Compliance":0,"Remarks":""},{"SlNo":10,"Items":61,"Compliance":0,"Remarks":""},{"SlNo":11,"Items":62,"Compliance":0,"Remarks":""},{"SlNo":12,"Items":63,"Compliance":0,"Remarks":""},{"SlNo":13,"Items":64,"Compliance":0,"Remarks":""},{"SlNo":14,"Items":65,"Compliance":0,"Remarks":""},{"SlNo":15,"Items":66,"Compliance":0,"Remarks":""},{"SlNo":16,"Items":67,"Compliance":0,"Remarks":""},{"SlNo":17,"Items":68,"Compliance":0,"Remarks":""},{"SlNo":18,"Items":69,"Compliance":0,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 7:06:01 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":2036,"DocDate":"2024-02-17","Project":295,"ProjectDes":"ABU DHABI-COM-RESOURCES","Location":"y6y6y6","SiteIncharge":11,"Client":"abu dhabi","sGeneralComments":"y6y6y","UserId":1100,"Images":"Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114757.png","Signature":"","Body":[{"SlNo":1,"Items":70,"Compliance":1,"Remarks":""},{"SlNo":2,"Items":71,"Compliance":3,"Remarks":""},{"SlNo":3,"Items":72,"Compliance":2,"Remarks":""},{"SlNo":4,"Items":73,"Compliance":0,"Remarks":""},{"SlNo":5,"Items":74,"Compliance":0,"Remarks":""},{"SlNo":6,"Items":75,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":76,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":77,"Compliance":0,"Remarks":""},{"SlNo":9,"Items":78,"Compliance":0,"Remarks":""},{"SlNo":10,"Items":79,"Compliance":0,"Remarks":""},{"SlNo":11,"Items":80,"Compliance":0,"Remarks":""},{"SlNo":12,"Items":81,"Compliance":0,"Remarks":""},{"SlNo":13,"Items":82,"Compliance":0,"Remarks":""},{"SlNo":14,"Items":83,"Compliance":0,"Remarks":""},{"SlNo":15,"Items":84,"Compliance":0,"Remarks":""},{"SlNo":16,"Items":85,"Compliance":0,"Remarks":""},{"SlNo":17,"Items":86,"Compliance":0,"Remarks":""},{"SlNo":18,"Items":87,"Compliance":0,"Remarks":""},{"SlNo":19,"Items":88,"Compliance":0,"Remarks":""},{"SlNo":20,"Items":89,"Compliance":0,"Remarks":""},{"SlNo":21,"Items":90,"Compliance":3,"Remarks":""},{"SlNo":22,"Items":91,"Compliance":0,"Remarks":""},{"SlNo":23,"Items":92,"Compliance":0,"Remarks":""},{"SlNo":24,"Items":93,"Compliance":0,"Remarks":""},{"SlNo":25,"Items":95,"Compliance":0,"Remarks":""},{"SlNo":26,"Items":96,"Compliance":0,"Remarks":""},{"SlNo":27,"Items":97,"Compliance":0,"Remarks":""},{"SlNo":28,"Items":98,"Compliance":0,"Remarks":""},{"SlNo":29,"Items":99,"Compliance":0,"Remarks":""},{"SlNo":30,"Items":100,"Compliance":0,"Remarks":""},{"SlNo":31,"Items":101,"Compliance":0,"Remarks":""},{"SlNo":32,"Items":102,"Compliance":0,"Remarks":""},{"SlNo":33,"Items":103,"Compliance":0,"Remarks":""},{"SlNo":34,"Items":104,"Compliance":0,"Remarks":""},{"SlNo":35,"Items":105,"Compliance":0,"Remarks":""},{"SlNo":36,"Items":151,"Compliance":0,"Remarks":""},{"SlNo":37,"Items":152,"Compliance":0,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 7:06:32 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":0,"DocDate":"2024-02-20","Project":22,"ProjectDes":"Finance Department","Location":"dxb","SiteIncharge":16,"Client":"","sGeneralComments":"ffd","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":52,"Compliance":0,"Remarks":""},{"SlNo":2,"Items":53,"Compliance":0,"Remarks":""},{"SlNo":3,"Items":54,"Compliance":0,"Remarks":""},{"SlNo":4,"Items":55,"Compliance":0,"Remarks":""},{"SlNo":5,"Items":56,"Compliance":0,"Remarks":""},{"SlNo":6,"Items":57,"Compliance":0,"Remarks":""},{"SlNo":7,"Items":58,"Compliance":0,"Remarks":""},{"SlNo":8,"Items":59,"Compliance":0,"Remarks":""},{"SlNo":9,"Items":60,"Compliance":0,"Remarks":""},{"SlNo":10,"Items":61,"Compliance":0,"Remarks":""},{"SlNo":11,"Items":62,"Compliance":0,"Remarks":""},{"SlNo":12,"Items":63,"Compliance":0,"Remarks":""},{"SlNo":13,"Items":64,"Compliance":0,"Remarks":""},{"SlNo":14,"Items":65,"Compliance":0,"Remarks":""},{"SlNo":15,"Items":66,"Compliance":0,"Remarks":""},{"SlNo":16,"Items":67,"Compliance":0,"Remarks":""},{"SlNo":17,"Items":68,"Compliance":0,"Remarks":""},{"SlNo":18,"Items":69,"Compliance":0,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 2/20/2024 7:10:05 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":0,\"DocDate\":\"2024-02-20\",\"Project\":1361,\"ProjectDes\":\"3r\",\"Location\":\"auh\",\"SiteIncharge\":2,\"Client\":\"txd\",\"sGeneralComments\":\"vcn\",\"UserId\":1100,\"Mark_Model\":\"ghg\",\"DrivingLicenceExpiry\":\"275760-05-25\",\"RegistrationNo\":\"56547\",\"OperatorName\":\"rynv\",\"Images\":\"\",\"Signature\":\"\",\"Body\":[{\"SlNo\":1,\"Items\":70,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":2,\"Items\":71,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":3,\"Items\":72,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":4,\"Items\":73,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":5,\"Items\":74,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":6,\"Items\":75,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":7,\"Items\":76,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":8,\"Items\":77,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":9,\"Items\":78,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":10,\"Items\":79,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 2/20/2024 7:10:05 PM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. 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, 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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Ray.Mob.Api.General.DBHelper.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Ray.Mob.Api.Controllers.RayController.PostMCC() ClientConnectionId:19fd1787-2306-4c1a-ac3a-5c1572855a73 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/20/2024 7:10:19 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":0,\"DocDate\":\"2024-02-20\",\"Project\":23,\"ProjectDes\":\"IT Department\",\"Location\":\"auh\",\"SiteIncharge\":2,\"Client\":\"\",\"sGeneralComments\":\"vcn\",\"UserId\":1100,\"Mark_Model\":\"ghg\",\"DrivingLicenceExpiry\":\"275760-05-25\",\"RegistrationNo\":\"56547\",\"OperatorName\":\"rynv\",\"Images\":\"\",\"Signature\":\"\",\"Body\":[{\"SlNo\":1,\"Items\":70,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":2,\"Items\":71,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":3,\"Items\":72,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":4,\"Items\":73,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":5,\"Items\":74,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":6,\"Items\":75,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":7,\"Items\":76,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":8,\"Items\":77,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":9,\"Items\":78,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":10,\"Items\":79,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 2/20/2024 7:10:19 PM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. 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, 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.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Ray.Mob.Api.General.DBHelper.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Ray.Mob.Api.Controllers.RayController.PostMCC() ClientConnectionId:c84e8422-8d70-49a7-855f-2494d5f94594 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/20/2024 7:11:35 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":2053,\"DocDate\":\"2024-02-19\",\"Project\":1361,\"ProjectDes\":\"3r\",\"Location\":\"cvdvd\",\"SiteIncharge\":11,\"Client\":\"txd\",\"sGeneralComments\":\"fefe\",\"UserId\":1100,\"Mark_Model\":\"dwdw\",\"DrivingLicenceExpiry\":\"2024-02-20\",\"RegistrationNo\":\"dfwfw5\",\"OperatorName\":\"fwfw\",\"Images\":\"Screenshot 2024-02-16 142840.png;Screenshot 2024-02-16 142903.png\",\"Signature\":\"\",\"Body\":[{\"SlNo\":1,\"Items\":70,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":2,\"Items\":71,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":3,\"Items\":72,\"Compliance\":1,\"Remarks\":\"brr\",\"ActionTaken\":\"hthht\"},{\"SlNo\":4,\"Items\":73,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":5,\"Items\":74,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":6,\"Items\":75,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":7,\"Items\":76,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":8,\"Items\":77,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":9,\"Items\":78,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":10,\"Items\":79,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":0,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 2/20/2024 7:12:09 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":2052,\"DocDate\":\"2024-01-19\",\"Project\":18,\"ProjectDes\":\"Project Department\",\"Location\":\"dlh\",\"SiteIncharge\":8,\"Client\":\"\",\"sGeneralComments\":\"f\",\"UserId\":1100,\"Mark_Model\":\"h\",\"DrivingLicenceExpiry\":\"2024-01-20\",\"RegistrationNo\":\"g\",\"OperatorName\":\"s\",\"Images\":\"mcc_1079_15450719012024.jpg\",\"Signature\":\"sign_mcc_15451019012024.jpg\",\"Body\":[{\"SlNo\":1,\"Items\":70,\"Compliance\":1,\"Remarks\":\"t4t4t4\",\"ActionTaken\":\"\"},{\"SlNo\":2,\"Items\":71,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":3,\"Items\":72,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"t4t4t4\"},{\"SlNo\":4,\"Items\":73,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":5,\"Items\":74,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":6,\"Items\":75,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":7,\"Items\":76,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":8,\"Items\":77,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":9,\"Items\":78,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":10,\"Items\":79,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 2/20/2024 7:15:05 PM - ------------------------------------------------------------- RayController Method:Ray Newtonsoft.Json.JsonSerializationException: Error converting value {null} to type 'System.Int32'. Path 'Details[0].Discussed', line 1, position 293. ---> System.InvalidCastException: Null object cannot be converted to a value type. at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.EnsureType(JsonReader reader, Object value, CultureInfo culture, JsonContract contract, Type targetType) --- End of inner exception stack trace --- at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.EnsureType(JsonReader reader, Object value, CultureInfo culture, JsonContract contract, Type targetType) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.SetPropertyValue(JsonProperty property, JsonConverter propertyConverter, JsonContainerContract containerContract, JsonProperty containerProperty, JsonReader reader, Object target) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateList(IList list, JsonReader reader, JsonArrayContract contract, JsonProperty containerProperty, String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateList(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, Object existingValue, String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.SetPropertyValue(JsonProperty property, JsonConverter propertyConverter, JsonContainerContract containerContract, JsonProperty containerProperty, JsonReader reader, Object target) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent) at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType) at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.Ray.Mob.Api.Controllers.RayController.PostTBT() --------------------------------------------------------------- Log Entry : 2/20/2024 7:15:30 PM - ------------------------------------------------------------- RayController Method:Ray Newtonsoft.Json.JsonSerializationException: Error converting value {null} to type 'System.Int32'. Path 'Details[4].Discussed', line 1, position 441. ---> System.InvalidCastException: Null object cannot be converted to a value type. at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.EnsureType(JsonReader reader, Object value, CultureInfo culture, JsonContract contract, Type targetType) --- End of inner exception stack trace --- at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.EnsureType(JsonReader reader, Object value, CultureInfo culture, JsonContract contract, Type targetType) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.SetPropertyValue(JsonProperty property, JsonConverter propertyConverter, JsonContainerContract containerContract, JsonProperty containerProperty, JsonReader reader, Object target) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateList(IList list, JsonReader reader, JsonArrayContract contract, JsonProperty containerProperty, String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateList(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, Object existingValue, String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.SetPropertyValue(JsonProperty property, JsonConverter propertyConverter, JsonContainerContract containerContract, JsonProperty containerProperty, JsonReader reader, Object target) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue) at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent) at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType) at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.Ray.Mob.Api.Controllers.RayController.PostTBT()