--------------------------------------------------------------- Log Entry : 2/21/2024 9:05:16 AM - ------------------------------------------------------------- RayController Method:PostQHSE {"iTransId":0,"DocDate":"2024-02-21","Project":3370,"ProjectDes":"hngb","Location":"aa","Client":"","SiteIncharge":2602,"Activity":"act","sGeneralComments":"genr","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/21/2024 11:10:22 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1356,"ProjectDes":"jniji","Location":"loc","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"a","iRiskLevel":2,"iActionBy":9,"sActionReq":"a","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/023","sActionBy":"Vijil Israel Johnson","sImages":"","iTransId":0,"ActionBy":9,"ActionReq":"a","Observation":"a","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 2/21/2024 11:11:44 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1356,"ProjectDes":"jniji","Location":"loc11","UserId":1100,"iTransId":8602,"Signature":"","Body":[{"iTransId":8602,"iTransDtId":8534,"sObservation":"a","iRiskLevel":2,"sActionReq":"a","iActionBy":9,"TargetDate":"21-02-2024","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Vijil Israel Johnson","sActionBy_Code":"RU/023","ActionBy":9,"ActionReq":"a","Observation":"a","RiskLevel":2,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 11:11:44 AM - ------------------------------------------------------------- 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:52b6b837-12f7-4278-b22b-2576dc9fd31c Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 11:12:49 AM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1356,"ProjectDes":"jniji","Location":"loc11","UserId":1100,"iTransId":8602,"Signature":"","Body":[{"iTransId":8602,"iTransDtId":8534,"sObservation":"a","iRiskLevel":2,"sActionReq":"a","iActionBy":9,"TargetDate":"21-02-2024","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Vijil Israel Johnson","sActionBy_Code":"RU/023","ActionBy":9,"ActionReq":"a","Observation":"a","RiskLevel":2,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 11:12:49 AM - ------------------------------------------------------------- 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:8aaaec09-7211-4b76-9d9a-975d9baf3878 Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 11:45:52 AM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":0,"Project":1356,"Location":"LOC","Date":"2024-02-21","Time":"11:16","IncidentType":1,"Severity_Rate":4,"Potential_Rate":4,"IncidentDescription":"descriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescription","DamageDescription":"descriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescriptiondescription","No_Injured_Person":"1","DetailsOfPersons":"1","ImmediateCauses":"a","UnderlyingCauses":"under","UserId":1100,"Images":"","sPath":"","Others":"","Body":[]} --------------------------------------------------------------- Log Entry : 2/21/2024 11:45:52 AM - ------------------------------------------------------------- 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/21/2024 11:45:53 AM - ------------------------------------------------------------- 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/21/2024 11:57:22 AM - ------------------------------------------------------------- RayController Method:Ray Newtonsoft.Json.JsonSerializationException: Error converting value {null} to type 'System.Int32'. Path 'Details[3].Discussed', line 1, position 397. ---> 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/21/2024 1:51:22 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":295,"ProjectDes":"ABU DHABI-COM-RESOURCES","Location":"sharjah","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"vncv","iRiskLevel":2,"iActionBy":2,"sActionReq":"fdsf","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/011","sActionBy":"Praveenkumar Kumara Samy","sImages":"","iTransId":0,"ActionBy":2,"ActionReq":"fdsf","Observation":"vncv","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 2/21/2024 1:51:51 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1361,"ProjectDes":"3r","Location":"sharjah","UserId":1100,"iTransId":8603,"Signature":"","Body":[{"iTransId":8603,"iTransDtId":8537,"sObservation":"vncv","iRiskLevel":2,"sActionReq":"fdsf","iActionBy":2,"TargetDate":"21-02-2024","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Praveenkumar Kumara Samy","sActionBy_Code":"RU/011","ActionBy":2,"ActionReq":"fdsf","Observation":"vncv","RiskLevel":2,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 1:51:51 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:f5ad84d8-9e4b-4352-bed1-38f2241a05dc Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 1:52:00 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":353,"ProjectDes":",mjutgh","Location":"sharjah","UserId":1100,"iTransId":8603,"Signature":"","Body":[{"iTransId":8603,"iTransDtId":8537,"sObservation":"vncv","iRiskLevel":2,"sActionReq":"fdsf","iActionBy":2,"TargetDate":"21-02-2024","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Praveenkumar Kumara Samy","sActionBy_Code":"RU/011","ActionBy":2,"ActionReq":"fdsf","Observation":"vncv","RiskLevel":2,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 1:52:00 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:f5ad84d8-9e4b-4352-bed1-38f2241a05dc Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 1:52:11 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":187,"ProjectDes":"DEPARTMENTAL COST","Location":"sharjah","UserId":1100,"iTransId":8603,"Signature":"","Body":[{"iTransId":8603,"iTransDtId":8537,"sObservation":"vncv","iRiskLevel":2,"sActionReq":"fdsf","iActionBy":2,"TargetDate":"21-02-2024","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Praveenkumar Kumara Samy","sActionBy_Code":"RU/011","ActionBy":2,"ActionReq":"fdsf","Observation":"vncv","RiskLevel":2,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 1:52:11 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:f5ad84d8-9e4b-4352-bed1-38f2241a05dc Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 1:52:57 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1361,"ProjectDes":"3r","Location":"oman","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"rty","iRiskLevel":3,"iActionBy":11,"sActionReq":"wer","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/025","sActionBy":"Rijwan Khan","sImages":"","iTransId":0,"ActionBy":11,"ActionReq":"wer","Observation":"rty","RiskLevel":3,"Images":""}]} --------------------------------------------------------------- Log Entry : 2/21/2024 1:58:21 PM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":295,"ProjectCode":"ABU DHABI-COM-RESOURCES","Location":"ajman","UserId":1100,"Activity":"wwww","CorrectiveAction":"kk","Observation":"dfsf","iObserver":16,"Images":"","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/21/2024 1:58:52 PM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8142,"Project":295,"ProjectCode":"ABU DHABI-COM-RESOURCES","Location":"ajman","UserId":1100,"Activity":"wwww","CorrectiveAction":"kk","Observation":"dfsf","iObserver":16,"Images":"","iType":2,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/21/2024 2:00:15 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":2077,"DocDate":"2024-02-15","Project":253,"ProjectDes":"RU/712/20/PRJ","Location":"uaq","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/21/2024 2:01:31 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":0,"DocDate":"2024-02-21","Project":187,"ProjectDes":"DEPARTMENTAL COST","Location":"raq","SiteIncharge":238,"Client":"client 3","DetailsOfLG":"78","SlNoOfLG":"890","sGeneralComments":"fgfdf","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":1,"Compliance":0,"Remarks":""},{"SlNo":2,"Items":2,"Compliance":0,"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/21/2024 2:08:57 PM - ------------------------------------------------------------- RayController Method:PostQHSE {"iTransId":0,"DocDate":"2024-02-21","Project":23,"ProjectDes":"IT Department","Location":"us","Client":"","SiteIncharge":62,"Activity":"fdd","sGeneralComments":"dg","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/21/2024 2:09:53 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-20","Project":3370,"ProjectDes":"hngb","Location":"gxz","UserId":1100,"iTransId":8593,"Signature":"","Body":[{"iTransId":8593,"iTransDtId":8520,"sObservation":"a","iRiskLevel":1,"sActionReq":"s","iActionBy":2602,"TargetDate":"20-02-2024","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"sijina","sActionBy_Code":"RU/602","ActionBy":2602,"ActionReq":"s","Observation":"a","RiskLevel":1,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 2:09:54 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:14d9ba24-c2ac-4d7b-885a-bd7dfaa0dfd0 Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 2:10:29 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":3370,"ProjectDes":"hngb","Location":"gz","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"n","iRiskLevel":2,"iActionBy":2603,"sActionReq":"j","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/603","sActionBy":"sijina-test","sImages":"","iTransId":0,"ActionBy":2603,"ActionReq":"j","Observation":"n","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 2/21/2024 2:11:18 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":0,"DocDate":"2024-02-21","Project":23,"ProjectDes":"IT Department","Location":"up","SiteIncharge":73,"Client":"","sGeneralComments":"jggfj","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/21/2024 3:20:31 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1361,"ProjectDes":"3r","Location":"oman","UserId":1100,"iTransId":8604,"Signature":"","Body":[{"sObservation":"rty","iRiskLevel":3,"iActionBy":11,"sActionReq":"wer","TargetDate":"21-02-2024","sPath":"","sActionBy_Code":"RU/025","sActionBy":"Rijwan Khan","sImages":"","iTransId":8604,"imageFiles":[{}],"ActionBy":11,"ActionReq":"wer","Observation":"rty","RiskLevel":3,"Images":"Screenshot 2024-02-05 114543.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:20:31 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:f5ad84d8-9e4b-4352-bed1-38f2241a05dc Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 3:21:47 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":353,"ProjectDes":",mjutgh","Location":"cscssc","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"cscs","iRiskLevel":1,"iActionBy":8,"sActionReq":"cscs","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/022","sActionBy":"Sudheer Thirumalmel Kalarickal","sImages":"","iTransId":0,"imageFiles":[{}],"ActionBy":8,"ActionReq":"cscs","Observation":"cscs","RiskLevel":1,"Images":"Screenshot 2024-02-05 114757.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:22:00 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":353,"ProjectDes":",mjutgh","Location":"cscssc","UserId":1100,"iTransId":8606,"Signature":"","Body":[{"sObservation":"cscs","iRiskLevel":1,"iActionBy":8,"sActionReq":"cscs","TargetDate":"21-02-2024","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy_Code":"RU/022","sActionBy":"Sudheer Thirumalmel Kalarickal","sImages":"Screenshot 2024-02-05 114757.png","iTransId":8606,"imageFiles":[{}],"ActionBy":8,"ActionReq":"cscs","Observation":"cscs","RiskLevel":1,"Images":"Screenshot 2024-02-05 114757.png;Screenshot 2024-02-05 114251.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:22:00 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:f5ad84d8-9e4b-4352-bed1-38f2241a05dc Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 3:22:40 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1356,"ProjectDes":"jniji","Location":"hn","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"ob","iRiskLevel":2,"iActionBy":9,"sActionReq":"s","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/023","sActionBy":"Vijil Israel Johnson","sImages":"","iTransId":0,"imageFiles":[{}],"ActionBy":9,"ActionReq":"s","Observation":"ob","RiskLevel":2,"Images":"gn.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:22:57 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1356,"ProjectDes":"jniji","Location":"hn","UserId":1100,"iTransId":8607,"Signature":"","Body":[{"sObservation":"ob","iRiskLevel":1,"iActionBy":9,"sActionReq":"s","TargetDate":"21-02-2024","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy_Code":"RU/023","sActionBy":"Vijil Israel Johnson","sImages":"gn.png","iTransId":8607,"ActionBy":9,"ActionReq":"s","Observation":"ob","RiskLevel":1,"Images":"gn.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:22:57 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:9f47c87c-f194-430d-b047-066a299e04ca Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 3:23:56 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":3370,"ProjectDes":"hngb","Location":"gz","UserId":1100,"iTransId":8605,"Signature":"","Body":[{"sObservation":"n","iRiskLevel":2,"iActionBy":2603,"sActionReq":"j","TargetDate":"21-02-2024","sPath":"","sActionBy_Code":"RU/603","sActionBy":"sijina-test","sImages":"","iTransId":8605,"imageFiles":[{}],"ActionBy":2603,"ActionReq":"j","Observation":"n","RiskLevel":2,"Images":"gn.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:23:56 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:f5ad84d8-9e4b-4352-bed1-38f2241a05dc Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 3:26:44 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":353,"ProjectDes":",mjutgh","Location":"grgr","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"grrg","iRiskLevel":2,"iActionBy":8,"sActionReq":"grgr","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/022","sActionBy":"Sudheer Thirumalmel Kalarickal","sImages":"","iTransId":0,"imageFiles":[{},{}],"ActionBy":8,"ActionReq":"grgr","Observation":"grrg","RiskLevel":2,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:27:38 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":353,"ProjectDes":",mjutgh","Location":"grgr","UserId":1100,"iTransId":8608,"Signature":"","Body":[{"sObservation":"grrg","iRiskLevel":3,"iActionBy":8,"sActionReq":"grgr","TargetDate":"21-02-2024","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy_Code":"RU/022","sActionBy":"Sudheer Thirumalmel Kalarickal","sImages":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png","iTransId":8608,"ActionBy":8,"ActionReq":"grgr","Observation":"grrg","RiskLevel":3,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:27: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:931c9c94-8a80-436c-b88b-138ab8564bea Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 3:28:59 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1356,"ProjectDes":"jniji","Location":"fb","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"h","iRiskLevel":1,"iActionBy":2602,"sActionReq":"h","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/602","sActionBy":"sijina","sImages":"","iTransId":0,"imageFiles":[{}],"ActionBy":2602,"ActionReq":"h","Observation":"h","RiskLevel":1,"Images":"gn.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:42:28 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-20","Project":353,"ProjectDes":",mjutgh","Location":"gj","UserId":1100,"iTransId":8594,"Signature":"","Body":[{"iTransId":8594,"iTransDtId":8521,"sObservation":"f","iRiskLevel":1,"sActionReq":"s","iActionBy":2602,"TargetDate":"20-02-2024","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"sijina","sActionBy_Code":"RU/602","ActionBy":2602,"ActionReq":"s","Observation":"f","RiskLevel":1,"Images":"undefined"},{"sObservation":"ddef","iRiskLevel":2,"iActionBy":8,"sActionReq":"fefe","TargetDate":"2024-02-21","sPath":"","sActionBy_Code":"RU/022","sActionBy":"Sudheer Thirumalmel Kalarickal","sImages":"","iTransId":0,"ActionBy":8,"ActionReq":"fefe","Observation":"ddef","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:42:29 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:9f47c87c-f194-430d-b047-066a299e04ca Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 3:45:08 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2023-10-07","Project":306,"ProjectDes":"123","Location":"Loc1","UserId":1100,"iTransId":8561,"Signature":"","Body":[{"iTransId":8561,"iTransDtId":8427,"sObservation":"Test","iRiskLevel":2,"sActionReq":"User1","iActionBy":37,"TargetDate":"04-02-2023","sImages":"1.jpg","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Shamsher Hyder Rafique","sActionBy_Code":"RU/052","ActionBy":37,"ActionReq":"User1","Observation":"Test","RiskLevel":2,"Images":"1.jpgundefined"},{"iTransId":8561,"iTransDtId":8428,"sObservation":"Test","iRiskLevel":1,"sActionReq":"Test1","iActionBy":17,"TargetDate":"04-02-2023","sImages":"","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Rajasekaran Vaithiyanathan","sActionBy_Code":"RU/032","ActionBy":17,"ActionReq":"Test1","Observation":"Test","RiskLevel":1,"Images":"undefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 3:46:15 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2023-10-07","Project":306,"ProjectDes":"123","Location":"Loc1","UserId":1100,"iTransId":8560,"Signature":"","Body":[{"iTransId":8560,"iTransDtId":8511,"sObservation":"Test","iRiskLevel":2,"sActionReq":"User1","iActionBy":37,"TargetDate":"04-02-2023","sImages":"1.jpgundefined","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Shamsher Hyder Rafique","sActionBy_Code":"RU/052","ActionBy":37,"ActionReq":"User1","Observation":"Test","RiskLevel":2,"Images":"1.jpgundefinedundefined"},{"iTransId":8560,"iTransDtId":8512,"sObservation":"Test","iRiskLevel":3,"sActionReq":"Test1","iActionBy":17,"TargetDate":"04-02-2023","sImages":"Screenshot 2024-02-05 114543.png","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Rajasekaran Vaithiyanathan","sActionBy_Code":"RU/032","ActionBy":17,"ActionReq":"Test1","Observation":"Test","RiskLevel":3,"Images":"Screenshot 2024-02-05 114543.pngundefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 4:02:36 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2023-10-07","Project":306,"ProjectDes":"123","Location":"Loc1","UserId":1100,"iTransId":8560,"Signature":"","Body":[{"iTransId":8560,"iTransDtId":8556,"sObservation":"Test","iRiskLevel":2,"sActionReq":"User1","iActionBy":37,"TargetDate":"02-04-2023","sImages":"1.jpgundefinedundefined","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Shamsher Hyder Rafique","sActionBy_Code":"RU/052","ActionBy":37,"ActionReq":"User1","Observation":"Test","RiskLevel":2,"Images":"1.jpgundefinedundefinedundefined"},{"iTransId":8560,"iTransDtId":8557,"sObservation":"Test","iRiskLevel":3,"sActionReq":"Test1","iActionBy":17,"TargetDate":"02-04-2023","sImages":"Screenshot 2024-02-05 114543.pngundefined","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Rajasekaran Vaithiyanathan","sActionBy_Code":"RU/032","ActionBy":17,"ActionReq":"Test1","Observation":"Test","RiskLevel":3,"Images":"Screenshot 2024-02-05 114543.pngundefinedundefined"},{"sObservation":"5y5y","iRiskLevel":2,"iActionBy":9,"sActionReq":"y5y5","TargetDate":"21-02-2024","sPath":"","sActionBy_Code":"RU/023","sActionBy":"Vijil Israel Johnson","sImages":"","iTransId":0,"imageFiles":[{}],"ActionBy":9,"ActionReq":"y5y5","Observation":"5y5y","RiskLevel":2,"Images":"Screenshot 2024-02-05 114649.png"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 4:02:36 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:c1a71c5c-cc83-4b80-847f-1e7658a8926d Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 4:05:02 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":295,"ProjectDes":"ABU DHABI-COM-RESOURCES","Location":"ggr","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"grgr","iRiskLevel":2,"iActionBy":8,"sActionReq":"grgr","TargetDate":"21-02-2024","sPath":"","sActionBy_Code":"RU/022","sActionBy":"Sudheer Thirumalmel Kalarickal","sImages":"","iTransId":0,"ActionBy":8,"ActionReq":"grgr","Observation":"grgr","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 2/21/2024 4:05:02 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:a72d2095-7ab6-4c8f-8f21-ce46f0a70cbb Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 2/21/2024 4:07:23 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"07-10-2023","Project":306,"ProjectDes":"123","Location":"Loc1","UserId":1100,"iTransId":8561,"Signature":"","Body":[{"iTransId":8561,"iTransDtId":8554,"sObservation":"Test","iRiskLevel":2,"sActionReq":"User1","iActionBy":37,"TargetDate":"02-04-2023","sImages":"1.jpgundefined","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Shamsher Hyder Rafique","sActionBy_Code":"RU/052","ActionBy":37,"ActionReq":"User1","Observation":"Test","RiskLevel":2,"Images":"1.jpgundefinedundefined"},{"iTransId":8561,"iTransDtId":8555,"sObservation":"Test","iRiskLevel":1,"sActionReq":"Test1","iActionBy":17,"TargetDate":"02-04-2023","sImages":"undefined","sPath":"http://103.120.178.195/Sang.Ray.Mob.Api/rayimage/HSE/","sActionBy":"Rajasekaran Vaithiyanathan","sActionBy_Code":"RU/032","ActionBy":17,"ActionReq":"Test1","Observation":"Test","RiskLevel":1,"Images":"undefinedundefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 4:07:40 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"21-02-2024","Project":1356,"ProjectDes":"jniji","Location":"h5h","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"htth","iRiskLevel":1,"iActionBy":8,"sActionReq":"htht","TargetDate":"21-02-2024","sPath":"","sActionBy_Code":"RU/022","sActionBy":"Sudheer Thirumalmel Kalarickal","sImages":"","iTransId":0,"ActionBy":8,"ActionReq":"htht","Observation":"htth","RiskLevel":1,"Images":""}]} --------------------------------------------------------------- Log Entry : 2/21/2024 4:07:40 PM - ------------------------------------------------------------- RayController Method:Ray System.FormatException: Failed to convert parameter value from a String to a DateTime. ---> System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value, IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) at System.Data.SqlClient.SqlParameter.GetCoercedValue() at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) at System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) at System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) 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() --------------------------------------------------------------- Log Entry : 2/21/2024 4:17:18 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-02-21","Project":1356,"ProjectDes":"jniji","Location":"fb","UserId":1100,"iTransId":8609,"Signature":"","Body":[{"iTransId":8609,"iTransDtId":8552,"sObservation":"h","iRiskLevel":1,"sActionReq":"h","iActionBy":2602,"TargetDate":"21-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":"h","Observation":"h","RiskLevel":1,"Images":"gn.pngundefined"}]} --------------------------------------------------------------- Log Entry : 2/21/2024 4:17:19 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:a3c4120a-c304-4f2c-a5b9-59b19ec1a749 Error Number:242,State:3,Class:16