The web response contained unexpected sections. ID=15

Topics: General, OData Library, WCF Data Services
Apr 18, 2013 at 11:12 AM

I am getting the following exception in .net when one of the changeset is failed in my batch request.

"The web response contained unexpected sections. ID=15"

I even tried adding Content-ID header with random integer value but it started giving me "ID=16" error.

Below is the response that is send from server.

HTTP/1.1 202 Accepted
Server: Apache-Coyote/1.1
DataServiceVersion: 1.0
Content-Type: multipart/mixed;boundary=batchresponse_dae79838-d0e1-4f29-95fe-e52402880444
Date: Thu, 18 Apr 2013 07:06:24 GMT
Cache-Control: proxy-revalidate
Transfer-Encoding: chunked
Proxy-Connection: Keep-Alive
Connection: Keep-Alive

Content-Type: multipart/mixed; boundary=changesetresponse_9e35bfcf-63bf-48fe-b121-28159e976ebf


HTTP/1.1 500 Internal Server Error


Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.teiid.jdbc.TeiidSQLException: TEIID30504 FLOUNDER: Insert on GDI Basin failed
Error Code: 30504
Call: INSERT INTO "Basin" ("basin_name", "TEIID_MULTI_DATA_SOURCE_COLUMN", "basin_abbrev", "basin_area", "basin_area_ouom", "basin_id", "basin_type", "hc_potential", "lat", "lon", "on_off_shore", "orig_crs_id", "orig_x_lon", "orig_y_lat", "parent_basin", "remark", "x", "y") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [test1234, FLOUNDER, null, null, null, 0, null, null, null, null, null, null, null, null, null, null, null, null]
Query: InsertObjectQuery({Basin [[test1234, FLOUNDER]: 471446491]})