Hi all,
I've deployed the project to Linux using docker compose, the only problem I'm facing is the DB migration since I can't find the Migrator.exe file. I tried to use the run-migrator.ps1 script but I got this error while building the image:
=> ERROR [mycompanyname.abpzerotemplate.migrator build 7/10] RUN dotnet restore "src/Bone.Migrator/Bone.Migrator.csproj" 1.4s
------
> [mycompanyname.abpzerotemplate.migrator build 7/10] RUN dotnet restore "src/Bone.Migrator/Bone.Migrator.csproj":
1.055 Determining projects to restore...
1.252 /usr/share/dotnet/sdk/6.0.414/Sdks/Microsoft.NET.Sdk/targets/Microsoft.NET.TargetFrameworkInference.targets(144,5): error NETSDK1045: The current .NET SDK does not support targeting .NET 7.0. Either target .NET 6.0 or lower, or use a version of the .NET SDK that supports .NET 7.0. [/src/src/Bone.EntityFrameworkCore/Bone.EntityFrameworkCore.csproj]
1.255 /usr/share/dotnet/sdk/6.0.414/Sdks/Microsoft.NET.Sdk/targets/Microsoft.NET.TargetFrameworkInference.targets(144,5): error NETSDK1045: The current .NET SDK does not support targeting .NET 7.0. Either target .NET 6.0 or lower, or use a version of the .NET SDK that supports .NET 7.0. [/src/src/Bone.Core/Bone.Core.csproj]
1.286 /usr/share/dotnet/sdk/6.0.414/Sdks/Microsoft.NET.Sdk/targets/Microsoft.NET.TargetFrameworkInference.targets(144,5): error NETSDK1045: The current .NET SDK does not support targeting .NET 7.0. Either target .NET 6.0 or lower, or use a version of the .NET SDK that supports .NET 7.0. [/src/src/Bone.Migrator/Bone.Migrator.csproj]
------
failed to solve: process "/bin/sh -c dotnet restore \"src/Bone.Migrator/Bone.Migrator.csproj\"" did not complete successfully: exit code: 1
What is the best way to migrate the production DB when the project is hosted in a Linux machine?
Why I can't find the Migrator.exe file?
Hi all,
We face issues while deploying the app to a Linux server. We've tried multiple methods to deploy the app. First, we tested the build-mvc.ps1 script on a Windows machine to build the docker images, and they've been built successfully and using the following connection string we were able to run the app successfully:
Server=HOST_NAME,1433;Initial Catalog=DATABASE;Persist Security Info=False;User ID=USERNAME;Password=PASSWORD;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
But when we tried to follow the same instructions on a Linux machine we faced an issue with the connection string:
Abp.BackgroundJobs.BackgroundJobManager - System.ArgumentException: Couldn't set initial catalog (Parameter 'initial catalog')
---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
What we've missed in the deployment process, we will appreciate your help.
Hi, I am trying to use Postgres on the latest zero version but when updating the database I get this error
`Failed executing DbCommand (225ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
CREATE UNIQUE INDEX "IX_AppSubscriptionPaymentsExtensionData_SubscriptionPaymentId_Key_IsDeleted" ON "AppSubscriptionPaymentsExtensionData" ("SubscriptionPaymentId", "Key", "IsDeleted") WHERE [IsDeleted] = 0;
Npgsql.PostgresException (0x80004005): 42601: syntax error at or near "["
POSITION: 193
at Npgsql.Internal.NpgsqlConnector.g__ReadMessageLong|234_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
at Npgsql.NpgsqlDataReader.NextResult()
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteNonQuery()
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable1 migrationCommands, IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Exception data:
Severity: ERROR
SqlState: 42601
MessageText: syntax error at or near "["
Position: 193
File: scan.l
Line: 1188
Routine: scanner_yyerror
42601: syntax error at or near "["`
I think its in this block of code
migrationBuilder.CreateIndex(
name: "IX_AppSubscriptionPaymentsExtensionData_SubscriptionPaymentId_~",
table: "AppSubscriptionPaymentsExtensionData",
columns: new[] { "SubscriptionPaymentId", "Key", "IsDeleted" },
unique: true,
filter: "[IsDeleted] = 0");
Thanks in advance,