DB2 FOR LUW / DB2FORLUW / A50 - DB2

Test case: 
 
http://localhost:60653/OdataService/http/v1/client()?$filter=lcd 
_id eq 
'0970'&$top=10&$expand=alternate_name,case_defendant 
 
 
 
Error Output: 
 
 
 
<m:error 
 
xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/m 
etadata" 
> 
 
<m:code/> 
 
<m:message xml:lang="en-US">An error occurred while processing 
this 
request.</m:message> 
 
<m:innererror> 
 
<m:message> 
 
An error occurred while executing the command definition. See 
the inner 
exception for details. 
 
</m:message> 
 
<m:type>System.Data.EntityCommandExecutionException</m:type> 
 
<m:stacktrace> 
 
at 
 
System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCom 
mands(En 
tityCommand entityCommand, CommandBehavior behavior) at 
 
System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TR 
esultTyp 
e](ObjectContext context, ObjectParameterCollection 
parameterValues) at 
System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 
forMergeOption) 
at 
 
System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEn 
umerable 
<T>.GetEnumerator() at 
 
System.Data.Services.Providers.BasicExpandProvider.ExpandedQuery 
able`1.G 
etEnumerator() at 
 
System.Data.Services.Providers.BasicExpandProvider.ExpandedQuery 
able`1.S 
ystem.Collections.IEnumerable.GetEnumerator() at 
 
System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable 
 
enumerable) at System.Data.Services.QueryResultInfo.MoveNext() 
at 
System.Data.Services.DataService`1.SerializeResponseBody(Request 
Descript 
ion description, IDataService dataService, IODataResponseMessage 
 
responseMessage) at 
 
System.Data.Services.DataService`1.HandleNonBatchRequest(Request 
Descript 
ion description) at 
System.Data.Services.DataService`1.HandleRequest() 
</m:stacktrace> 
 
<m:internalexception> 
 
<m:message> 
 
ERROR [IX000] [IBM][IDS/UNIX64] Corresponding column types must 
be 
compatible for each UNION statement. 
 
</m:message> 
 
<m:type>IBM.Data.DB2.DB2Exception</m:type> 
 
<m:stacktrace> 
 
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior 
behavior, 
String method, DB2CursorType reqCursorType, Boolean 
abortOnOptValueChg, 
Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean 
 
skipInitialValidation) at 
 
IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior 
behavior, 
String method) at 
IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior 
behavior) at 
IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior 
behavior) at 
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior 
behavior) at 
 
System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCom 
mands(En 
tityCommand entityCommand, CommandBehavior behavior) 
 
</m:stacktrace> 
 
</m:internalexception> 
 
</m:innererror> 
 
</m:error>

**************************************************************** 
* USERS AFFECTED:                                              * 
* Informix DRDA users                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Client v10.5 fp3                              * 
****************************************************************

DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

This defect is first fixed in DB2 Client v10.5 fp3

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

29.10.2013
09.12.2013
09.12.2013