Base solution for your next web application
Open Closed

Error when run update-database: Failed executing DbCommand UPDATE AbpEditions SET Discriminator = 'SubscribableEdition' #6683


User avatar
0
HIPT created

Hello, when I migrate asp.net core to oracle database, it throw error

Failed executing DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] UPDATE AbpEditions SET Discriminator = 'SubscribableEdition' Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist at   .(Int32 ) at   .      (Int32 ,    ) at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery() at   .ExecuteNonQuery() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action) ORA-00942: table or view does not exist

How can I fix it? Please help me !!!


4 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team

    Is it a brand new database?

  • User Avatar
    0
    HIPT created

    Yes, new database.

  • User Avatar
    0
    maliming created
    Support Team

    If you don't use zero. Just a simple project using EF core and oracle. Can the migration be successful?

  • User Avatar
    0
    HIPT created

    It's ok. I must migrate for new database. Thanks !