search

ralmsdeveloper / EntityFrameworkCore.FirebirdSQL

FirebirdSQL database provider for Entity Framework Core.
Other
44 stars 26 forks source link

Insert exception #22

Closed marek1972 closed 6 years ago

marek1972 commented 6 years ago

The issue

Insert new record to table

Steps to reproduce

In model:

public class Course
{
    [DatabaseGenerated(DatabaseGeneratedOption.None)]
    public int CourseID { get; set; }
    public int Credits { get; set; }
    [StringLength(100)]
    public string Title { get; set; }

    public ICollection<Enrollment> Enrollments { get; set; }
}

In controller: if (context.Courses.Count() == 0) { var courses = new List { new Course{CourseID=1050,Title="Chemistry",Credits=3}, }; context.Courses.AddRange(courses); int r = context.SaveChanges(); }

Error details

EXECUTE BLOCK ( p0 INTEGER=@p0,p1 INTEGER=@p1,p2 VARCHAR(100)=@p2)

INSERT INTO "Course" ("CourseID", "Credits", "Title") VALUES (:p0, :p1, :p2) RETURNING ROW_COUNT INTO :AffectedRows; SUSPEND; END;

Parameters: Name:@p0 Type:Integer Used Value:1050 Name:@p1 Type:Integer Used Value:3 Name:@p2 Type:VarChar Used Value:Chemistry

'dotnet.exe' (CoreCLR: clrhost): Loaded 'C:\Program Files\dotnet\shared\Microsoft.NETCore.App\2.0.5\System.Diagnostics.StackTrace.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'dotnet.exe' (CoreCLR: clrhost): Loaded 'C:\Program Files\dotnet\shared\Microsoft.NETCore.App\2.0.5\System.Reflection.Metadata.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. Microsoft.EntityFrameworkCore.Database.Command:Error: Failed executing DbCommand (51ms) [Parameters=[@p0='?', @p1='?', @p2='?' (Size = 100)], CommandType='Text', CommandTimeout='30'] EXECUTE BLOCK ( p0 INTEGER=@p0,p1 INTEGER=@p1,p2 VARCHAR(100)=@p2)

INSERT INTO "Course" ("CourseID", "Credits", "Title") VALUES (:p0, :p1, :p2) RETURNING ROW_COUNT INTO :AffectedRows; SUSPEND; END;

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error SQL error code = -104 Token unknown - line 4, column 1 INSERT ---> Dynamic SQL Error SQL error code = -104 Token unknown - line 4, column 1 INSERT at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 517 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext() 'dotnet.exe' (CoreCLR: clrhost): Loaded 'C:\Program Files\dotnet\shared\Microsoft.NETCore.App\2.0.5\System.Diagnostics.Tools.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. Application Insights Telemetry (unconfigured): {"name":"Microsoft.ApplicationInsights.Dev.Exception","time":"2018-01-15T07:59:49.3434173Z","tags":{"ai.application.ver":"1.0.0.0","ai.internal.sdkVersion":"aspnet5c:2.1.1"},"data":{"baseType":"ExceptionData","baseData":{"ver":2,"properties":{"commandText":"EXECUTE BLOCK ( \r\np0 INTEGER=@p0,p1 INTEGER=@p1,p2 VARCHAR(100)=@p2) \r\n\r\nINSERT INTO \"Course\" (\"CourseID\", \"Credits\", \"Title\")\r\nVALUES (:p0, :p1, :p2) RETURNING ROW_COUNT INTO :AffectedRows;\r\nSUSPEND;\r\nEND;","{OriginalFormat}":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","elapsed":"51","CategoryName":"Microsoft.EntityFrameworkCore.Database.Command","DeveloperMode":"true","parameters":"@p0='?', @p1='?', @p2='?' (Size = 100)","AspNetCoreEnvironment":"Development","Exception":"FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT ---> Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs:line 517\r\n at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()\r\n at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.d__17.MoveNext()","commandTimeout":"30","commandType":"Text"},"exceptions":[{"id":50664859,"typeName":"FirebirdSql.Data.FirebirdClient.FbException","message":"Failed executing DbCommand (51ms) [Parameters=[@p0='?', @p1='?', @p2='?' (Size = 100)], CommandType='Text', CommandTimeout='30']\r\nEXECUTE BLOCK ( \r\np0 INTEGER=@p0,p1 INTEGER=@p1,p2 VARCHAR(100)=@p2) \r\n\r\nINSERT INTO \"Course\" (\"CourseID\", \"Credits\", \"Title\")\r\nVALUES (:p0, :p1, :p2) RETURNING ROW_COUNT INTO :AffectedRows;\r\nSUSPEND;\r\nEND;","hasFullStack":true,"parsedStack":[{"level":0,"method":"FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs","line":517},{"level":1,"method":"System.Data.Common.DbCommand.ExecuteDbDataReaderAsync","assembly":"System.Data.Common, Version=4.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"},{"level":2,"method":"System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":3,"method":"System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":4,"method":"System.Runtime.CompilerServices.TaskAwaiter1.GetResult","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":5,"method":"Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand+<ExecuteAsync>d__17.MoveNext","assembly":"Microsoft.EntityFrameworkCore.Relational, Version=2.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60"}]},{"id":53330552,"outerId":50664859,"typeName":"FirebirdSql.Data.Common.IscException","message":"Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT","hasFullStack":true,"parsedStack":[{"level":0,"method":"FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\Client\\Managed\\Version10\\GdsDatabase.cs","line":556},{"level":1,"method":"FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\Client\\Managed\\Version10\\GdsDatabase.cs","line":595},{"level":2,"method":"FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\Client\\Managed\\Version10\\GdsDatabase.cs","line":600},{"level":3,"method":"FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\Client\\Managed\\Version11\\GdsStatement.cs","line":77},{"level":4,"method":"FirebirdSql.Data.FirebirdClient.FbCommand.Prepare","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs","line":1148},{"level":5,"method":"FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs","line":1171},{"level":6,"method":"FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs","line":511}]}],"severityLevel":"Error"}}} Microsoft.EntityFrameworkCore.Update:Error: An exception occurred in the database while saving changes for context type 'ContosoUniversity.Data.SchoolContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error SQL error code = -104 Token unknown - line 4, column 1 INSERT ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error SQL error code = -104 Token unknown - line 4, column 1 INSERT at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 556 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 595 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 600 at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:line 77 at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1148 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1171 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 511 --- End of inner exception stack trace --- at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 517 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.d__17.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at EntityFrameworkCore.FirebirdSql.Storage.Internal.FirebirdRelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at EntityFrameworkCore.FirebirdSql.Update.Internal.FbBatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error SQL error code = -104 Token unknown - line 4, column 1 INSERT ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error SQL error code = -104 Token unknown - line 4, column 1 INSERT at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 556 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 595 at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 600 at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:line 77 at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1148 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1171 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 511 --- End of inner exception stack trace --- at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 517 at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at EntityFrameworkCore.FirebirdSql.Storage.Internal.FirebirdRelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at EntityFrameworkCore.FirebirdSql.Update.Internal.FbBatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) Application Insights Telemetry (unconfigured): {"name":"Microsoft.ApplicationInsights.Dev.Exception","time":"2018-01-15T07:59:49.4704245Z","tags":{"ai.application.ver":"1.0.0.0","ai.internal.sdkVersion":"aspnet5c:2.1.1"},"data":{"baseType":"ExceptionData","baseData":{"ver":2,"properties":{"error":"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\Client\\Managed\\Version10\\GdsDatabase.cs:line 556\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\Client\\Managed\\Version10\\GdsDatabase.cs:line 595\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\Client\\Managed\\Version10\\GdsDatabase.cs:line 600\r\n at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\Client\\Managed\\Version11\\GdsStatement.cs:line 77\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs:line 1148\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs:line 1171\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs:line 511\r\n --- End of inner exception stack trace ---\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs:line 517\r\n at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()\r\n at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.d17.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()\r\n at EntityFrameworkCore.FirebirdSql.Storage.Internal.FirebirdRelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues)\r\n at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)\r\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)\r\n --- End of inner exception stack trace ---\r\n at EntityFrameworkCore.FirebirdSql.Update.Internal.FbBatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection)\r\n at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries)\r\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave)\r\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)\r\n at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)","{OriginalFormat}":"An exception occurred in the database while saving changes for context type '{contextType}'.{newline}{error}","CategoryName":"Microsoft.EntityFrameworkCore.Update","contextType":"ContosoUniversity.Data.SchoolContext","DeveloperMode":"true","AspNetCoreEnvironment":"Development","Exception":"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 556\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 595\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 600\r\n at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:line 77\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1148\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1171\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 511\r\n --- End of inner exception stack trace ---\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 517\r\n at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.d17.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()\r\n at EntityFrameworkCore.FirebirdSql.Storage.Internal.FirebirdRelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues)\r\n at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)\r\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)\r\n --- End of inner exception stack trace ---\r\n at EntityFrameworkCore.FirebirdSql.Update.Internal.FbBatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection)\r\n at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries)\r\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave)\r\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)\r\n at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)"},"exceptions":[{"id":10212927,"typeName":"Microsoft.EntityFrameworkCore.DbUpdateException","message":"An exception occurred in the database while saving changes for context type 'ContosoUniversity.Data.SchoolContext'.\r\nMicrosoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 556\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 595\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:line 600\r\n at FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:line 77\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1148\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1171\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 511\r\n --- End of inner exception stack trace ---\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 517\r\n at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()\r\n at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()\r\n at EntityFrameworkCore.FirebirdSql.Storage.Internal.FirebirdRelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues)\r\n at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)\r\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)\r\n --- End of inner exception stack trace ---\r\n at EntityFrameworkCore.FirebirdSql.Update.Internal.FbBatchExecutor.Execute(IEnumerable1 commandBatches, IRelationalConnection connection)\r\n at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IReadOnlyList1 entries)\r\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IReadOnlyList1 entriesToSave)\r\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)\r\n at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)","hasFullStack":true,"parsedStack":[{"level":0,"method":"EntityFrameworkCore.FirebirdSql.Update.Internal.FbBatchExecutor.Execute","assembly":"EntityFrameworkCore.FirebirdSql, Version=2.0.1.1, Culture=neutral, PublicKeyToken=590af85568ed71f5"},{"level":1,"method":"Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges","assembly":"Microsoft.EntityFrameworkCore.Relational, Version=2.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60"},{"level":2,"method":"Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges","assembly":"Microsoft.EntityFrameworkCore, Version=2.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60"},{"level":3,"method":"Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges","assembly":"Microsoft.EntityFrameworkCore, Version=2.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60"},{"level":4,"method":"Microsoft.EntityFrameworkCore.DbContext.SaveChanges","assembly":"Microsoft.EntityFrameworkCore, Version=2.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60"}]},{"id":50664859,"outerId":10212927,"typeName":"FirebirdSql.Data.FirebirdClient.FbException","message":"Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT","hasFullStack":true,"parsedStack":[{"level":0,"method":"FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\\Users\\Jiri\\Documents\\devel\\NETProvider\\working\\Provider\\src\\FirebirdSql.Data.FirebirdClient\\FirebirdClient\\FbCommand.cs","line":517},{"level":1,"method":"System.Data.Common.DbCommand.ExecuteDbDataReaderAsync","assembly":"System.Data.Common, Version=4.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"},{"level":2,"method":"System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":3,"method":"System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":4,"method":"System.Runtime.CompilerServices.TaskAwaiter1.GetResult","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":5,"method":"Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand+d__17.MoveNext","assembly":"Microsoft.EntityFrameworkCore.Relational, Version=2.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60"},{"level":6,"method":"System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":7,"method":"System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":8,"method":"System.Runtime.CompilerServices.TaskAwaiter`1.GetResult","assembly":"System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e"},{"level":9,"method":"EntityFrameworkCore.FirebirdSql.Storage.Internal.FirebirdRelationalCommand.Execute","assembly":"EntityFrameworkCore.FirebirdSql, Version=2.0.1.1, Culture=neutral, PublicKeyToken=590af85568ed71f5"},{"level":10,"method":"Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader","assembly":"Microsoft.EntityFrameworkCore.Relational, Version=2.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60"},{"level":11,"method":"Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute","assembly":"Microsoft.EntityFrameworkCore.Relational, Version=2.0.1.0, Culture=neutral, PublicKeyToken=adb9793829ddae60"}]},{"id":53330552,"outerId":50664859,"typeName":"FirebirdSql.Data.Common.IscException","message":"Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 4, column 1\r\nINSERT","hasFullStack":true,"parsedStack":[{"level":0,"method":"FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs","line":556},{"level":1,"method":"FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs","line":595},{"level":2,"method":"FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs","line":600},{"level":3,"method":"FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs","line":77},{"level":4,"method":"FirebirdSql.Data.FirebirdClient.FbCommand.Prepare","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs","line":1148},{"level":5,"method":"FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs","line":1171},{"level":6,"method":"FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader","assembly":"FirebirdSql.Data.FirebirdClient, Version=5.12.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c","fileName":"C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs","line":511}]}],"severityLevel":"Error"}}} Exception thrown: 'Microsoft.EntityFrameworkCore.DbUpdateException' in Microsoft.EntityFrameworkCore.dll

Further technical details

Firebird version: 2.5.7 EntityFrameworkCore.FirebirdSql version: 2.0.11.3

Other details about my project setup:

ralmsdeveloper commented 6 years ago

That was broken, I'm correcting!

marek1972 commented 6 years ago

Ok. Waiting for update. After test will send you comment.

ralmsdeveloper commented 6 years ago

Fixed in version 2.0.11.4, available in nuget!