--------------------------------------------------------------- Log Entry : 5/14/2024 9:49:02 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (57, 22, 6). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:48ccda3f-ade1-4226-85f5-391eb0d2dc46 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 9:49:25 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (58, 22, 6). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:48ccda3f-ade1-4226-85f5-391eb0d2dc46 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:10:50 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (59, 18, 13). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:9f85d1ab-ccc3-40ba-8d90-6eb232bd5cc7 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:11:06 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (59, 18, 13). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:9f85d1ab-ccc3-40ba-8d90-6eb232bd5cc7 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:21:05 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (60, 1, 19). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:43cea27c-5e95-494d-9a59-d369673bb214 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:23:07 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (60, 1, 19). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:43cea27c-5e95-494d-9a59-d369673bb214 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:40:31 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (62, 1, 19). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:40:48 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (62, 1, 19). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:249adb57-4185-416f-92c9-0fed4d8d5c64 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:42:40 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:42:52 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:a68fca99-9f9b-4844-bd95-a4fb0edbed3e Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:43:02 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:a68fca99-9f9b-4844-bd95-a4fb0edbed3e Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:44:34 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:44:42 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:45:10 AM - ------------------------------------------------------------- {"iTransId":0,"iDocNo":0,"iDocType":0,"iDate":"string","iAccount":0,"iApproved":0,"iSuspended":0,"iUser":0,"sNarration":"string","sCustomer":"string","TransBody":[{"iTransDtId":0,"iFixedAsset":0,"iTag1":0,"iTag2":0,"iTag3":0,"iTag4":0,"iTag5":0,"iTag6":0,"iTag7":0,"iTag8":0,"iTag9":0,"iTag10":0,"fRate":0.0,"fQty":0.0,"fVat":0.0,"iAssetType":0,"sRemarks":"string","sName":"string","sTaxCode":"string","sPoNo":"string","iLinkId":0,"iApproved":0,"iReturnDate":"string"}]} --------------------------------------------------------------- Log Entry : 5/14/2024 10:45:10 AM - ------------------------------------------------------------- TransactionController Method:PostTrans System.IndexOutOfRangeException: Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index) at Sang.Asset.WebAPI.Controllers.TransactionController.PostTrans(TransViewModel obj) --------------------------------------------------------------- Log Entry : 5/14/2024 10:46:14 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (64, 5, 1). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:47:21 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:48:33 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:a68fca99-9f9b-4844-bd95-a4fb0edbed3e Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:49:30 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:51:19 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:54:27 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (66, 9, 1). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:a68fca99-9f9b-4844-bd95-a4fb0edbed3e Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 10:55:38 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:55:53 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:62d9afb6-eeac-4168-8968-0d5c26e8d5f8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:56:26 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:a68fca99-9f9b-4844-bd95-a4fb0edbed3e Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:58:38 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:a68fca99-9f9b-4844-bd95-a4fb0edbed3e Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 10:58:43 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:a68fca99-9f9b-4844-bd95-a4fb0edbed3e Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:06:52 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:44192334-0cb2-4034-872c-5a075acf4128 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:06:54 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:44192334-0cb2-4034-872c-5a075acf4128 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:09:33 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:44192334-0cb2-4034-872c-5a075acf4128 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:10:32 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:44192334-0cb2-4034-872c-5a075acf4128 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:11:15 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:44192334-0cb2-4034-872c-5a075acf4128 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:15:11 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:bc55dfb8-c90e-4a45-b609-4840e213a9d8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:15:19 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:bc55dfb8-c90e-4a45-b609-4840e213a9d8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:15:33 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:44192334-0cb2-4034-872c-5a075acf4128 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:16:02 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:bc55dfb8-c90e-4a45-b609-4840e213a9d8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:16:35 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:6608a589-fbe3-41df-92fb-65b4e56c602d Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:22:31 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:6608a589-fbe3-41df-92fb-65b4e56c602d Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:23:37 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:6608a589-fbe3-41df-92fb-65b4e56c602d Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:23:53 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:bc55dfb8-c90e-4a45-b609-4840e213a9d8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:24:13 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:bc55dfb8-c90e-4a45-b609-4840e213a9d8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:26:42 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:6608a589-fbe3-41df-92fb-65b4e56c602d Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:26:59 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:bc55dfb8-c90e-4a45-b609-4840e213a9d8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:27:10 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:6608a589-fbe3-41df-92fb-65b4e56c602d Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:27:28 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:6608a589-fbe3-41df-92fb-65b4e56c602d Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:28:44 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:bc55dfb8-c90e-4a45-b609-4840e213a9d8 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:30:23 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:6608a589-fbe3-41df-92fb-65b4e56c602d Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:30:30 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:7c9d1d38-8db3-4e16-91e7-25a826a4a5e4 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:46:36 AM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:5139c908-7059-4f52-a420-b6069728cb91 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 11:52:57 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (68, 5, 1). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:1a89075b-3a8b-4db7-bb28-a12a3da4f060 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 11:53:07 AM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'pk_t_s_RoleDetails'. Cannot insert duplicate key in object 'dbo.t_s_RoleDetails'. The duplicate key value is (68, 5, 1). 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.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.PostRole(Role obj) ClientConnectionId:1a89075b-3a8b-4db7-bb28-a12a3da4f060 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/14/2024 12:13:23 PM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:4ba8d650-005e-4875-9276-12bdfa2cd53f Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 12:15:35 PM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:ec917b59-9a04-4545-9045-0e1362849667 Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 12:20:32 PM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:99d6f496-91c7-4227-97fb-c4528d4d069e Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 12:20:59 PM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:99d6f496-91c7-4227-97fb-c4528d4d069e Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 12:42:07 PM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:9aab6e91-d914-4226-a581-9d18a2802e2f Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 5/14/2024 4:53:00 PM - ------------------------------------------------------------- SettingsController Method:GetRoleList System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_s_GetRoleList_React'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetRoleList() ClientConnectionId:cba51c86-279a-4eaa-877a-bf6cb94408a2 Error Number:2812,State:62,Class:16