Skip to content

error invalid time zone region #1207

@rioda78

Description

@rioda78

environment
asp core 9
entityframeworkcore.firebird 12.0.0-beta1
project aspnet core blazor with identity default

when im try execute database update, it get error "Invalid time zone region: .21.5440". you can see detail error below

info: Microsoft.EntityFrameworkCore.Database.Command[20101] Executed DbCommand (33ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] EXECUTE BLOCK AS BEGIN BEGIN EXECUTE STATEMENT 'CREATE TABLE "__EFMigrationsLock" ( "Id" INT NOT NULL CONSTRAINT "PK___EFMigrationsLock" PRIMARY KEY, "Timestamp" TIMESTAMP NOT NULL )'; WHEN SQLSTATE '42S01' DO BEGIN END END END fail: Microsoft.EntityFrameworkCore.Database.Command[20102] Failed executing DbCommand (21ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] EXECUTE BLOCK RETURNS (ROWS_AFFECTED INT) AS BEGIN ROWS_AFFECTED = 1; BEGIN INSERT INTO "__EFMigrationsLock" ("Id", "Timestamp") VALUES (1, CAST('2024-12-21 11.42.21.5440' AS TIMESTAMP)); WHEN SQLSTATE '23000' DO BEGIN ROWS_AFFECTED = 0; END END SUSPEND; END Failed executing DbCommand (21ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] EXECUTE BLOCK RETURNS (ROWS_AFFECTED INT) AS BEGIN ROWS_AFFECTED = 1; BEGIN INSERT INTO "__EFMigrationsLock" ("Id", "Timestamp") VALUES (1, CAST('2024-12-21 11.42.21.5440' AS TIMESTAMP)); WHEN SQLSTATE '23000' DO BEGIN ROWS_AFFECTED = 0; END END SUSPEND; END FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Invalid time zone region: .21.5440 At block line: 7, col: 3 ---> FirebirdSql.Data.Common.IscException: Invalid time zone region: .21.5440 At block line: 7, col: 3 at FirebirdSql.Data.Client.Managed.IResponseExtensions.HandleResponseException(IResponse response) at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse(Int32 operation) at FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch() at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteScalar(RelationalCommandParameterObject parameterObject) at FirebirdSql.EntityFrameworkCore.Firebird.Migrations.Internal.FbHistoryRepository.AcquireDatabaseLock() at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) 

change project to net core 8 fix this error.

Metadata

Metadata

Assignees

Labels

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions