<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">John, <br>
<br>
I took a quick look in the logs, and I see something about a SQL
query maybe based on a non-existant table (probably not likely the
cause though):<br>
<br>
Caused by: java.io.IOException: Error occured calculating bounds<br>
at
org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1173)<br>
at
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:501)<br>
... 96 more<br>
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"nmfs_st.communities_pgs20130920" does not exist<br>
Position: 82<br>
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
<br>
And also something about a database connection problem, that may
be more likely the cause:<br>
<br>
Caused by: java.io.IOException: Error occured on rollback<br>
at
org.geotools.jdbc.JDBCTransactionState.rollback(JDBCTransactionState.java:100)<br>
at
org.geotools.data.DefaultTransaction.rollback(DefaultTransaction.java:225)<br>
at
org.geoserver.catalog.rest.DataStoreFileResource.handlePut(DataStoreFileResource.java:365)<br>
... 87 more<br>
Caused by: java.sql.SQLException: Connection is closed.<br>
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:185)<br>
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:322)<br>
at
org.geotools.jdbc.JDBCTransactionState.rollback(JDBCTransactionState.java:97)<br>
... 89 more<br>
<br>
Can you try the upload again? I disabled/re-enabled the data
store, which might help.<br>
<br>
Micah<br>
<br>
On 9/27/2013 10:43 AM, John Kennedy - NOAA Affiliate wrote:<br>
</div>
<blockquote
cite="mid:CAB8+QonN-+q5-Pq0x-+jzV=X-KoPpx5ZKfEfspcfKexqV__naw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hi Micah,</div>
<div><br>
</div>
<div>I attempted to load a shape file this morning using
hpcc_data_request.py scritp and I'm getting a Response 500
error from GeoServer. Any ideas?</div>
<div><br>
</div>
<div>Cheers,</div>
<div>John</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>John F. Kennedy, PhD, CPG<br>
</div>
<div>
<div dir="ltr">
<div>
<div>GIS Specialist</div>
</div>
<div>Contractor: Caelum Corp.</div>
<div>NOAA Fisheries Office of Science and Technology<br>
1315 East-West Highway<br>
SSMC3 Rm 9518<br>
Silver Spring, MD 20910<br>
301-427-8149</div>
<div><br>
</div>
<div>Comments? Have I been of assistance? Please let my
supervisors know. :~)</div>
<div>Tim Haverland - NOAA Federal <<a
moz-do-not-send="true"
href="mailto:Tim.Haverland@noaa.gov" target="_blank">Tim.Haverland@noaa.gov</a>><br>
</div>
<div>Hussain Jabalpurwala - NOAA Affiliate <<a
moz-do-not-send="true"
href="mailto:hussain.jabalpurwala@noaa.gov"
target="_blank">hussain.jabalpurwala@noaa.gov</a>><br>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>