DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* Common .Net provider users                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 Client v 10.1 fp3                             * 
****************************************************************

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in db2_v101fp3

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC97286 
follow-up : 

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

12.03.2013
28.10.2013
28.10.2013