|
Problem IC89073
|
Status: Closed |
EXCEPTION "CORRESPONDING COLUMN TYPES MUST BE COMPATIBLE FOR EAC H UNION STATEMENT." WHEN USING ENTITIES AND VISUAL STUDIO 2008 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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.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. |
| 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 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 V9.7 FP8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.12.2012
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
