geosolutions-it/evo-odas

invalid timestamp format in L8 products

Closed this issue · 0 comments

Current timestamp format in Landsat8 products is not valid for GeoServer.
When trying to ingest a L8 product in GeoServer I get the following exception:

Caused by: org.postgresql.util.PSQLException: ERROR: invalid input syntax for type timestamp: "08:10:57.0781150Z"
Position: 1125
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:1097)
at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:1079)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:323)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:323)
at org.geotools.jdbc.JDBCDataStore.insertNonPS(JDBCDataStore.java:1874)
at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1707)

Timestamp for S1 and S2 products is in the following format:
2018-01-01T00:00:00Z