Global Data Management Forum

Data Management Global

A hub for collaboration, learning, networking, and cultural exchange, and contributing to positive global engagement

 View Only
Back to discussions
Expand all | Collapse all

IBM.EntityFrameworkCore 3.1.0.300 code first approach DB2Exception (0x80004005)

  • 1.  IBM.EntityFrameworkCore 3.1.0.300 code first approach DB2Exception (0x80004005)

    Posted Mon October 12, 2020 09:58 AM

    Hi,

    I am trying to Scaffold-DbContext with vs2019 in Db2 version 9 .1 and it's giving below error.  Any help would be appreciated.


    note: I also tried IBM.EntityFrameworkCore 3.1.0.200 and it gives same error.

    ------------------------------------------------
    -- DDL Statements for table "GSIS "."YOKSISLOG"
    ------------------------------------------------


    CREATE TABLE "GSIS "."YOKSISLOG" (
    "TIMESTAMP" TIMESTAMP NOT NULL ,
    "TCKIMLIKNO" VARCHAR(11) NOT NULL ,
    "DESCRIPTION" VARCHAR(1000) NOT NULL ,
    "METHOD" VARCHAR(55) )
    IN "USERSPACE1" ;


    -- DDL Statements for primary key on Table "GSIS "."YOKSISLOG"

    ALTER TABLE "GSIS "."YOKSISLOG"
    ADD CONSTRAINT "CC1417423012498" PRIMARY KEY
    ("TIMESTAMP");

    PM> Scaffold-DbContext "Server=;Database=;UID=;PWD=" IBM.EntityFrameworkCore -o Models -schema gsis -t yoksislog -f
    Build started...
    Build succeeded.
    IBM.Data.DB2.Core.DB2Exception (0x80004005): ERROR [42703] [IBM][DB2/AIX64] SQL0206N "C.TYPESTRINGUNITS" is not valid in the context where it is used.
    at IBM.Data.DB2.Core.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
    at IBM.Data.DB2.Core.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method)
    at IBM.Data.DB2.Core.DB2Command.ExecuteReader(CommandBehavior behavior)
    at IBM.Data.DB2.Core.DB2Command.ExecuteReader()
    at IBM.EntityFrameworkCore.Scaffolding.Internal.Db2DatabaseModelFactory.GetColumns(IReadOnlyList`1 tables)
    at IBM.EntityFrameworkCore.Scaffolding.Internal.Db2DatabaseModelFactory.GetTables(Func`3 tableFilter)
    at IBM.EntityFrameworkCore.Scaffolding.Internal.Db2DatabaseModelFactory.Create(DbConnection connection, DatabaseModelFactoryOptions options)
    at IBM.EntityFrameworkCore.Scaffolding.Internal.Db2DatabaseModelFactory.Create(String connectionString, DatabaseModelFactoryOptions options)
    at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ReverseEngineerScaffolder.ScaffoldModel(String connectionString, DatabaseModelFactoryOptions databaseOptions, ModelReverseEngineerOptions modelOptions, ModelCodeGenerationOptions codeOptions)
    at Microsoft.EntityFrameworkCore.Design.Internal.DatabaseOperations.ScaffoldContext(String provider, String connectionString, String outputDir, String outputContextDir, String dbContextClassName, IEnumerable`1 schemas, IEnumerable`1 tables, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames)
    at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider, String connectionString, String outputDir, String outputDbContextDir, String dbContextClassName, IEnumerable`1 schemaFilters, IEnumerable`1 tableFilters, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames)
    at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContext.<>c__DisplayClass0_0.<.ctor>b__0()
    at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
    at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
    ERROR [42703] [IBM][DB2/AIX64] SQL0206N "C.TYPESTRINGUNITS" is not valid in the context where it is used.
    PM>




    ------------------------------
    ekrem özhan
    ------------------------------

    #DataManagementGlobal
    #DataServerDrivers


Related Content