--------------------------------------------------------------- Log Entry : 5/2/2024 5:32:25 PM - ------------------------------------------------------------- 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 (1, 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:a30c039c-db51-473d-a1ed-09304992253e Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/2/2024 5:32:36 PM - ------------------------------------------------------------- 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 (1, 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:a30c039c-db51-473d-a1ed-09304992253e Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/2/2024 5:33:39 PM - ------------------------------------------------------------- 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 (1, 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:a30c039c-db51-473d-a1ed-09304992253e Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/2/2024 5:34:25 PM - ------------------------------------------------------------- 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 (1, 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:a30c039c-db51-473d-a1ed-09304992253e Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 5/2/2024 6:37:57 PM - ------------------------------------------------------------- obj={"sName":"testAsset30","sCode":"","sAltName":"","sBarcode":"","sRegNo":"","sInvNo":"","iAssetType":34,"iAssetSubCategory":0,"iCompany":1,"iLocation":0,"iSupplier":0,"iProject":0,"iWarehouse":5,"iPurchaseDate":"2024-05-02","fPurchaseValue":0,"fCumDeprValue":0,"fInsuredValue":0,"fScrapValue":0,"fITDeprRate":0,"fITAccr":0,"fQty":1,"sImagePath":"","image":null,"bDepreciable":true,"iDepreciation":1,"iUnitOfUsage":0,"fLifePeriod":0,"iDateOfCommencement":"2024-05-03","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":0,"iUser":11} --------------------------------------------------------------- Log Entry : 5/2/2024 8:17:27 PM - ------------------------------------------------------------- obj={"sName":"testAsset31","sCode":"","sAltName":"","sBarcode":"","sRegNo":"","sInvNo":"","iAssetType":0,"iAssetSubCategory":0,"iCompany":1,"iLocation":0,"iSupplier":0,"iProject":0,"iWarehouse":5,"iPurchaseDate":"2024-05-02","fPurchaseValue":0,"fCumDeprValue":0,"fInsuredValue":0,"fScrapValue":0,"fITDeprRate":0,"fITAccr":0,"fQty":1,"sImagePath":"","image":null,"bDepreciable":true,"iDepreciation":1,"iUnitOfUsage":0,"fLifePeriod":0,"iDateOfCommencement":"2024-05-10","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":0,"iUser":11} --------------------------------------------------------------- Log Entry : 5/2/2024 8:19:01 PM - ------------------------------------------------------------- obj={"sName":"testAsset32","sCode":"","sAltName":"","sBarcode":"","sRegNo":"","sInvNo":"","iAssetType":34,"iAssetSubCategory":5,"iCompany":12,"iLocation":0,"iSupplier":0,"iProject":0,"iWarehouse":14,"iPurchaseDate":"2024-05-02","fPurchaseValue":0,"fCumDeprValue":0,"fInsuredValue":0,"fScrapValue":0,"fITDeprRate":0,"fITAccr":0,"fQty":4,"sImagePath":"","image":null,"bDepreciable":true,"iDepreciation":1,"iUnitOfUsage":0,"fLifePeriod":0,"iDateOfCommencement":"2024-05-10","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":0,"iUser":11}