--------------------------------------------------------------- Log Entry : 4/20/2024 10:34:14 AM - ------------------------------------------------------------- obj={"sName":"TestAsset3","sCode":"","sAltName":"","sBarcode":"","sRegNo":"","sInvNo":"","iAssetType":5,"iAssetSubCategory":0,"iCompany":1,"iLocation":0,"iSupplier":0,"iProject":0,"iWarehouse":1,"iPurchaseDate":"2024-04-21","fPurchaseValue":0,"fCumDeprValue":0,"fInsuredValue":0,"fScrapValue":0,"fITDeprRate":0,"fITAccr":0,"fQty":3,"sImagePath":"","image":null,"bDepreciable":true,"iDepreciation":1,"iUnitOfUsage":0,"fLifePeriod":0,"iDateOfCommencement":"2024-04-20","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/20/2024 10:54:11 AM - ------------------------------------------------------------- SettingsController Method:GetActions System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_getAction'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetActions(Int32 mId) ClientConnectionId:26e3ba47-fe27-44ad-b86d-d13ad48070ec Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 4/20/2024 11:01:07 AM - ------------------------------------------------------------- SettingsController Method:DeleteUser System.NullReferenceException: Object reference not set to an instance of an object. at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.DeleteUser(List`1 uIds, Int32 iUser) --------------------------------------------------------------- Log Entry : 4/20/2024 11:01:19 AM - ------------------------------------------------------------- SettingsController Method:GetActions System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'xsp_getAction'. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.GetActions(Int32 mId) ClientConnectionId:1e650871-9d1d-40f6-9752-d06cf11459ae Error Number:2812,State:62,Class:16 --------------------------------------------------------------- Log Entry : 4/20/2024 11:02:31 AM - ------------------------------------------------------------- SettingsController Method:DeleteUser System.NullReferenceException: Object reference not set to an instance of an object. at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.DeleteUser(List`1 uIds, Int32 iUser) --------------------------------------------------------------- Log Entry : 4/20/2024 11:03:19 AM - ------------------------------------------------------------- SettingsController Method:DeleteUser System.NullReferenceException: Object reference not set to an instance of an object. at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.DeleteUser(List`1 uIds, Int32 iUser) --------------------------------------------------------------- Log Entry : 4/20/2024 11:04:42 AM - ------------------------------------------------------------- SettingsController Method:DeleteUser System.NullReferenceException: Object reference not set to an instance of an object. at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.DeleteUser(List`1 uIds, Int32 iUser) --------------------------------------------------------------- Log Entry : 4/20/2024 11:07:59 AM - ------------------------------------------------------------- SettingsController Method:DeleteUser System.NullReferenceException: Object reference not set to an instance of an object. at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.DeleteUser(List`1 uIds, Int32 iUser) --------------------------------------------------------------- Log Entry : 4/20/2024 11:10:06 AM - ------------------------------------------------------------- SettingsController Method:DeleteUser System.NullReferenceException: Object reference not set to an instance of an object. at Sang.Asset.WebAPI.Controllers.Sang.Asset.WebAPI.Controllers.SettingsController.DeleteUser(List`1 uIds, Int32 iUser) --------------------------------------------------------------- Log Entry : 4/20/2024 1:26:08 PM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ__t_s_Role__1295E5A92662E404'. Cannot insert duplicate key in object 'dbo.t_s_RoleHeader'. The duplicate key value is (string). 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:97127341-7b1b-4a10-8732-a55b7e9462bd Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 4/20/2024 1:33:40 PM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ__t_s_Role__1295E5A92662E404'. Cannot insert duplicate key in object 'dbo.t_s_RoleHeader'. The duplicate key value is (string). 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:64c49381-e7de-4d65-a591-77e243a2cbff Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 4/20/2024 1:40:59 PM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. 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:20c7d40f-2df6-4ea1-ac22-701c05dc8788 Error Number:3902,State:1,Class:16 --------------------------------------------------------------- Log Entry : 4/20/2024 1:41:09 PM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. 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:20c7d40f-2df6-4ea1-ac22-701c05dc8788 Error Number:3902,State:1,Class:16 --------------------------------------------------------------- Log Entry : 4/20/2024 1:41:56 PM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ__t_s_Role__1295E5A92662E404'. Cannot insert duplicate key in object 'dbo.t_s_RoleHeader'. The duplicate key value is (string). 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:20c7d40f-2df6-4ea1-ac22-701c05dc8788 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 4/20/2024 1:44:43 PM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ__t_s_Role__1295E5A92662E404'. Cannot insert duplicate key in object 'dbo.t_s_RoleHeader'. The duplicate key value is (string). 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:20c7d40f-2df6-4ea1-ac22-701c05dc8788 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 4/20/2024 2:00:27 PM - ------------------------------------------------------------- SettingsController Method:PostRole System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'UQ__t_s_Role__1295E5A92662E404'. Cannot insert duplicate key in object 'dbo.t_s_RoleHeader'. The duplicate key value is (string). 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:bb45c579-6d4c-48d1-97df-959925023902 Error Number:2627,State:1,Class:14 --------------------------------------------------------------- Log Entry : 4/20/2024 4:03:31 PM - ------------------------------------------------------------- obj={"sName":"testAsset4","sCode":"","sAltName":"","sBarcode":"","sRegNo":"","sInvNo":"","iAssetType":7,"iAssetSubCategory":0,"iCompany":1,"iLocation":0,"iSupplier":0,"iProject":0,"iWarehouse":1,"iPurchaseDate":"2024-04-22","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-26","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":0,"iUser":11}