IBM Support

IC89073: EXCEPTION "CORRESPONDING COLUMN TYPES MUST BE COMPATIBLE FOR EAC H UNION STATEMENT." WHEN USING ENTITIES AND VISUAL STUDIO 2008

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When using Visual Studio 2008 and entity framework, the
    following exception is thrown when an attempt it made to
    generate an Entity Data Model from the database:
    
    An exception of type
    
    'Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.Mo
    delBuild
    erEngine+GenerateSSDLException' occurred while attempting to
    update from
    the database.  The exception message is: 'An error occurred
    while
    executing the command definition. See the inner exception for
    details.
    ERROR [IX000][IBM][IDS/UNIX64] Corresponding column types must
    be
    compatible for each UNION statement.
    
    The same procedure works fine with Visual Studio 2010.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IBM Data Server Driver 9.7 on Windows with Visual   *
    * Studio 2008                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When using Visual Studio 2008 and entity framework, the      *
    * following exception is thrown when an attempt it made to     *
    * generate an Entity Data Model from the database:             *
    *                                                              *
    * An exception of type                                         *
    *                                                              *
    * 'Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engin *
    * e.Mo                                                         *
    * delBuild                                                     *
    * erEngine+GenerateSSDLException' occurred while attempting to *
    * update from                                                  *
    * the database.  The exception message is: 'An error occurred  *
    * while                                                        *
    * executing the command definition. See the inner exception    *
    * for                                                          *
    * details.                                                     *
    * ERROR [IX000][IBM][IDS/UNIX64] Corresponding column types    *
    * must                                                         *
    * be                                                           *
    * compatible for each UNION statement.                         *
    *                                                              *
    * The same procedure works fine with Visual Studio 2010.       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 FP8 or higher                            *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 V9.7 FP8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89073

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-12

  • Closed date

    2013-04-01

  • Last modified date

    2013-04-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC89073

Modified date: 01 April 2013