INFO 17-06-2022 14:06:59 Microsoft.Hosting.Lifetime [1] - Now listening on: http://0.0.0.0:7500 INFO 17-06-2022 14:06:59 Microsoft.Hosting.Lifetime [1] - Application started. Press Ctrl+C to shut down. INFO 17-06-2022 14:06:59 Microsoft.Hosting.Lifetime [1] - Hosting environment: Production INFO 17-06-2022 14:06:59 Microsoft.Hosting.Lifetime [1] - Content root path: /root/CLM_API INFO 17-12-2022 14:12:36 Microsoft.Hosting.Lifetime [1] - Now listening on: http://0.0.0.0:7500 INFO 17-12-2022 14:12:36 Microsoft.Hosting.Lifetime [1] - Application started. Press Ctrl+C to shut down. INFO 17-12-2022 14:12:36 Microsoft.Hosting.Lifetime [1] - Hosting environment: Production INFO 17-12-2022 14:12:36 Microsoft.Hosting.Lifetime [1] - Content root path: /root/CLM_API INFO 17-27-2022 15:27:03 Microsoft.Hosting.Lifetime [2] - Application is shutting down... INFO 17-27-2022 15:27:57 Microsoft.Hosting.Lifetime [1] - Now listening on: http://0.0.0.0:7500 INFO 17-27-2022 15:27:57 Microsoft.Hosting.Lifetime [1] - Application started. Press Ctrl+C to shut down. INFO 17-27-2022 15:27:57 Microsoft.Hosting.Lifetime [1] - Hosting environment: Production INFO 17-27-2022 15:27:57 Microsoft.Hosting.Lifetime [1] - Content root path: /root/CLM_API ERROR 18-15-2022 14:15:37 Microsoft.EntityFrameworkCore.Database.Command [25] - Failed executing DbCommand (11ms) [Parameters=[@p0='?', @p1='?' (Size = 8), @p2='?', @p3='?' (Size = 26), @p4='?', @p5='?'], CommandType='Text', CommandTimeout='30'] INSERT INTO "Campaigns" ("AffiliateId", "CampaignName", "From", "Link", "ProductId", "To") VALUES (@p0, @p1, @p2, @p3, @p4, @p5); SELECT "CampaignId" FROM "Campaigns" WHERE changes() = 1 AND "rowid" = last_insert_rowid(); ERROR 18-15-2022 14:15:37 Microsoft.EntityFrameworkCore.Update [25] - An exception occurred in the database while saving changes for context type 'CLM_API.CLM_APIContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'UNIQUE constraint failed: Campaigns.CampaignName'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'UNIQUE constraint failed: Campaigns.CampaignName'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)