--------------------------------------------------------------- Log Entry : 4/29/2024 11:26: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 (52, 20, 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:a97f0b28-5760-4adc-ba0e-0f8c4d508b8d Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 4/29/2024 5:10:01 PM - ------------------------------------------------------------- obj={"sName":"2904","sCode":"","sAltName":"294","sBarcode":"","sRegNo":"294","sInvNo":"","iAssetType":7,"iAssetSubCategory":6,"iCompany":1,"iLocation":33,"iSupplier":355,"iProject":22,"iWarehouse":16,"iPurchaseDate":"2024-04-01","fPurchaseValue":0,"fCumDeprValue":0,"fInsuredValue":0,"fScrapValue":0,"fITDeprRate":0,"fITAccr":0,"fQty":1,"sImagePath":"","image":null,"bDepreciable":true,"iDepreciation":1,"iUnitOfUsage":1,"fLifePeriod":0,"iDateOfCommencement":"2024-04-30","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":0,"iUser":11} --------------------------------------------------------------- Log Entry : 4/29/2024 5:15:34 PM - ------------------------------------------------------------- obj={"sName":"testAsset01","sCode":"","sAltName":"","sBarcode":"","sRegNo":"","sInvNo":"","iAssetType":34,"iAssetSubCategory":0,"iCompany":1,"iLocation":0,"iSupplier":0,"iProject":0,"iWarehouse":5,"iPurchaseDate":"2024-04-27","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-04-29","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":0,"iUser":0} --------------------------------------------------------------- Log Entry : 4/29/2024 5:16:09 PM - ------------------------------------------------------------- obj={"sName":"testAsset01","sCode":"30oct1a000792","sAltName":"","sBarcode":" ","sRegNo":" ","sInvNo":" ","iAssetType":34,"iAssetSubCategory":0,"iCompany":1,"iLocation":0,"iSupplier":0,"iProject":0,"iWarehouse":5,"iPurchaseDate":"2024-04-27","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-04-29","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":8513,"iUser":0} --------------------------------------------------------------- Log Entry : 4/29/2024 7:36:55 PM - ------------------------------------------------------------- obj={"sName":"29042024","sCode":"","sAltName":"2904","sBarcode":"","sRegNo":"111","sInvNo":"","iAssetType":34,"iAssetSubCategory":5,"iCompany":12,"iLocation":34,"iSupplier":422,"iProject":74,"iWarehouse":14,"iPurchaseDate":"2024-04-01","fPurchaseValue":0,"fCumDeprValue":0,"fInsuredValue":0,"fScrapValue":0,"fITDeprRate":0,"fITAccr":0,"fQty":1,"sImagePath":"","image":null,"bDepreciable":true,"iDepreciation":1,"iUnitOfUsage":1,"fLifePeriod":0,"iDateOfCommencement":"2024-04-30","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":0,"iUser":11}