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> |
