search

aodn / content

Tracks AODN Portal content and configuration issues
0 stars 0 forks source link

GetFeatureInfo failing for for auv_trajectory_map #371

Closed jonescc closed 5 years ago

jonescc commented 6 years ago

From the geoserver logs

Failed to execute statement SELECT "file_id","url","size","campaign_name","dive_name","time_coverage_start","time_coverage_end","colour","CDOM_b","CPHL_b","OPBS_b","PSAL_b","TEMP_b",encode(ST_AsBinary(CASE WHEN ST_HasArc("geom") THEN "geom" ELSE ST_Simplify(ST_Force2D("geom"), 1.3732905297274557E-4, true) END),'base64') as "geom" FROM "auv"."auv_trajectory_map" WHERE  "geom" && ST_GeomFromText('POLYGON ((115.70351221538459 -32.046540125200636, 115.70351221538459 -32.03418051043339, 115.71587184615383 -32.03418051043339, 115.71587184615383 -32.046540125200636, 115.70351221538459 -32.046540125200636))', 4326)
...
Caused by: java.sql.SQLException: org.postgresql.util.PSQLException: ERROR: column "CDOM_b" does not exist
  Position: 110
    at org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:155)
    at org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:619)
    ... 119 more
ggalibert commented 5 years ago

Does the problem still exist @jonescc ?

jonescc commented 5 years ago

No. Looks to have been resolved.