--------------------------------------------------------------- Log Entry : 2/15/2024 9:48:13 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1} --------------------------------------------------------------- Log Entry : 2/15/2024 9:48:13 AM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_Ins_StopCard' expects parameter '@dDate', which was not supplied. 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.PostStopCard() ClientConnectionId:a1b532e2-e67a-4163-a244-1707a5f7c538 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/15/2024 9:51:35 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":""} --------------------------------------------------------------- Log Entry : 2/15/2024 9:51:35 AM - ------------------------------------------------------------- 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.PostStopCard() --------------------------------------------------------------- Log Entry : 2/15/2024 9:52:55 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":""} --------------------------------------------------------------- Log Entry : 2/15/2024 9:52:55 AM - ------------------------------------------------------------- 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.PostStopCard() --------------------------------------------------------------- Log Entry : 2/15/2024 9:54:14 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":""} --------------------------------------------------------------- Log Entry : 2/15/2024 9:54:14 AM - ------------------------------------------------------------- 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.PostStopCard() --------------------------------------------------------------- Log Entry : 2/15/2024 9:54:15 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":""} --------------------------------------------------------------- Log Entry : 2/15/2024 9:54:15 AM - ------------------------------------------------------------- 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.PostStopCard() --------------------------------------------------------------- Log Entry : 2/15/2024 9:54:15 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":""} --------------------------------------------------------------- Log Entry : 2/15/2024 9:54:15 AM - ------------------------------------------------------------- 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.PostStopCard() --------------------------------------------------------------- Log Entry : 2/15/2024 9:54:43 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":1356,"ProjectCode":"nnj","Location":"fee","UserId":1100,"Activity":"HR Department","CorrectiveAction":"fefe","Observation":"fefe","iObserver":9,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114757.png","iType":1,"DocDate":""} --------------------------------------------------------------- Log Entry : 2/15/2024 9:54:43 AM - ------------------------------------------------------------- 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.PostStopCard() --------------------------------------------------------------- Log Entry : 2/15/2024 10:03:07 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":null} --------------------------------------------------------------- Log Entry : 2/15/2024 10:03:07 AM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_Ins_StopCard' expects parameter '@dDate', which was not supplied. 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.PostStopCard() ClientConnectionId:0bf7c50b-c846-4190-9fef-c03b3b074f47 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/15/2024 10:03:19 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8131,"Project":352,"ProjectCode":"004","Location":"dlh","UserId":1100,"Activity":"a","CorrectiveAction":"c","Observation":"o","iObserver":2602,"Images":"033439191342024.jpg;Screenshot 2024-02-05 114543.png","iType":1,"DocDate":null} --------------------------------------------------------------- Log Entry : 2/15/2024 10:03:19 AM - ------------------------------------------------------------- RayController Method:Ray System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_Ins_StopCard' expects parameter '@dDate', which was not supplied. 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.PostStopCard() ClientConnectionId:0bf7c50b-c846-4190-9fef-c03b3b074f47 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/15/2024 10:05:07 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":"2023-07-27"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:05:14 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg;Screenshot 2024-02-05 114543.png","iType":1,"DocDate":"2023-07-27"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:05:30 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":"2023-07-27"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:06:45 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8132,"Project":323,"ProjectCode":"123","Location":"dlh","UserId":1100,"Activity":"s","CorrectiveAction":"s","Observation":"o","iObserver":2603,"Images":"071225261122024.jpg","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:06:54 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8131,"Project":352,"ProjectCode":"004","Location":"dlh","UserId":1100,"Activity":"a","CorrectiveAction":"c","Observation":"o","iObserver":2602,"Images":"033439191342024.jpg;Screenshot 2024-02-05 114251.png","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:12:30 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8131,"Project":352,"ProjectCode":"004","Location":"dlh","UserId":1100,"Activity":"a","CorrectiveAction":"c","Observation":"o","iObserver":2602,"Images":"033439191342024.jpg;Screenshot 2024-02-05 114251.png","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:17:03 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":353,"ProjectCode":"005","Location":"HR Department","UserId":1100,"Activity":"HR Department","CorrectiveAction":"ygftt","Observation":"hbubv","iObserver":8,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114757.png","iType":2,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:17:31 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8134,"Project":353,"ProjectCode":"005","Location":"HR Department","UserId":1100,"Activity":"HR Department","CorrectiveAction":"ygftt","Observation":"hbubv","iObserver":39,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114757.png","iType":2,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:23:49 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":8131,"Project":352,"ProjectCode":"004","Location":"dlh","UserId":1100,"Activity":"a","CorrectiveAction":"c","Observation":"o","iObserver":2602,"Images":"033439191342024.jpg","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:24:36 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":7135,"Project":295,"ProjectCode":"ABU DHABI-COM-RESOURCES","Location":"Dl","UserId":1100,"Activity":"act","CorrectiveAction":"co","Observation":"ob","iObserver":3,"Images":"Screenshot 2024-02-13 162800.png;Screenshot 2024-02-13 163102.png","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:41:38 AM - ------------------------------------------------------------- AuthorizationEmail sended --------------------------------------------------------------- Log Entry : 2/15/2024 10:41:42 AM - ------------------------------------------------------------- AuthorizationEmail sended --------------------------------------------------------------- Log Entry : 2/15/2024 10:50:20 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":353,"ProjectCode":"005","Location":"fefe","UserId":1100,"Activity":"fefee","CorrectiveAction":"fefe","Observation":"fef","iObserver":9,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114757.png","iType":2,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 10:52:42 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":7133,"Project":187,"ProjectCode":"DEPARTMENTAL COST","Location":"Dlh ","UserId":1100,"Activity":"acv","CorrectiveAction":"cor","Observation":"obv","iObserver":2603,"Images":"1025420610252023.jpg","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 11:43:13 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":353,"ProjectCode":"005","Location":"rgr","UserId":1100,"Activity":"gr","CorrectiveAction":"grgr","Observation":"grg","iObserver":8,"Images":"Screenshot 2024-02-05 114543.png;Screenshot 2024-02-05 114649.png;Screenshot 2024-02-05 114757.png","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 11:57:44 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":1356,"ProjectCode":"nnj","Location":"fefe","UserId":1100,"Activity":"fef","CorrectiveAction":"fefefe","Observation":"fefe","iObserver":2,"Images":"Screenshot 2024-02-12 140414.png;Screenshot 2024-02-13 150829.png;Screenshot 2024-02-13 162800.png;Screenshot 2024-02-13 163102.png","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 2/15/2024 3:54:44 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":56,"DocDate":"2024-02-15","Project":295,"ProjectDes":"ABU DHABI-COM-RESOURCES","Location":"e","Client":"abu dhabi","SiteIncharge":255,"DetailsOfLG":"check","SlNoOfLG":"3","sGeneralComments":"test","InspectionBy":16,"InspectionDate":"2023-07-25","UserId":16,"Images":"lgic_16_14165514072023.jpg;lgic_16_22255225072023.jpg;lgic_16_22252425072023.jpg;lgic_16_22254625072023.jpg","Signature":"sign_lgic_14334014072023.jpg","Body":[{"SlNo":2,"Items":2,"Compliance":3,"Remarks":""},{"SlNo":3,"Items":3,"Compliance":3,"Remarks":""},{"SlNo":4,"Items":4,"Compliance":2,"Remarks":""},{"SlNo":5,"Items":5,"Compliance":1,"Remarks":""},{"SlNo":6,"Items":6,"Compliance":2,"Remarks":""},{"SlNo":7,"Items":7,"Compliance":3,"Remarks":""},{"SlNo":8,"Items":8,"Compliance":2,"Remarks":""},{"SlNo":9,"Items":9,"Compliance":3,"Remarks":""},{"SlNo":10,"Items":10,"Compliance":1,"Remarks":""}]}