Errors creating objects from uploaded shapefile

[GoogleCodeExporter]

MERIT allows users to bulk create works sites by uploading a shapefile then 
selecting individual features from the file and giving them names and 
descriptions.

The interaction looks something like:
POST /layers-service/shape/upload/shp  // Shapefile is post body

then 1..n 
POST /layers-service/shape/upload/shp/{shapefile id}/{feature sequence}  

What appears to be happening is that occasionally some of the 2nd set of calls 
are returning:  {"error":"Error writing to database. Check validity of wkt."}

It doesn't appear to be deterministic - i.e. I have uploaded the same shapefile 
multiple times and different features will fail (and different numbers of 
failures) will occur on each attempt.  See logs 
/usr/local/tomcat/shared/logs/01_layers_access_log.2014-05-27.txt around 
15:00-15:30 27/05/2014.  (response lengths of 61 bytes represent failures, 14 
is a success).  

I have tried several different shapefiles, including ones that have always 
worked previously so I suspect something related to the recent changes.

Original issue reported on code.google.com by chris.go...@gmail.com on 27 May 2014 at 5:44

[GoogleCodeExporter]

Original comment by chris.go...@gmail.com on 27 May 2014 at 5:44

[GoogleCodeExporter]

Assigning to Adam

Original comment by moyesyside on 27 May 2014 at 5:56

[GoogleCodeExporter]

Fixed for the error in the logs.  On dev and prod.

Original comment by adam.col...@gmail.com on 27 May 2014 at 7:03

• Changed state: OnDev

[GoogleCodeExporter]

That seems to have fixed it, at least on dev.  I'll give prod a try
tomorrow morning.

Original comment by chris.go...@gmail.com on 27 May 2014 at 7:16

[GoogleCodeExporter]

Attempted to load on prod ~9:38 this morning.
Calls to /layers-service/shape/wkt/{pid} appear to be returning correct WKT for 
the uploaded sites, however Calls to /layers-service/object/{pid} are returning 
200 OK with 0 byte content.

Original comment by chris.go...@gmail.com on 28 May 2014 at 12:04

[GoogleCodeExporter]

Fixed the configuration error and corrected the 73 objects that were not 
working with /layers-service/object/{pid}

Original comment by adam.col...@gmail.com on 28 May 2014 at 12:41

[GoogleCodeExporter]

Those sites are fixed now, thanks.

Original comment by chris.go...@gmail.com on 28 May 2014 at 4:14

[GoogleCodeExporter]

Original comment by adam.col...@gmail.com on 18 Jun 2014 at 3:08

• Changed state: Fixed