[Geoserver-users] Error adding Geoserver 2.8 ImageMosaicJDBC data store

Hello!

I’m trying to add an ImageMosaicJDBC data store to my Geoserver 2.8.0 instance, but am receiving this error:

Error: could not list layers for this store, an error occurred retrieving them: Failed to create reader from …. and hints null.

I’ve spent some time searching for solutions, but thus far have been stumped. A little background about the process:

-Followed this link as tutorial/Mastering Geoserver book:
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

-local Geoserver version (2.8.0) matches ImageMosaicJDBC Plugin version (gt-imagemosaic-jdbc-14.0), which is the 2.8.0 extension jar

-able to create ImagePyramid in local data directory using same dataset, able to preview layer created from ImagePyramid

Dataset:

3 inch imagery from USGS covering small section of Maryland

Preprocessing:

-ImagePyramid processed using gdal_retile

-ImageMosaicJDBC imported to Postgres using raster2pgsql
-populated public schema with md_3inch, o_2_md_3inch, o_4_md_3inch, o_8_md_3inch, o_16_md_3inch

Metadata table:

CREATE TABLE watersuite_raster_metadata ( coverage_name character varying(254) NOT NULL, tiletable character varying(254) NOT NULL, minx double precision, miny double precision, maxx double precision, maxy double precision, resx double precision, resy double precision, CONSTRAINT watersuite_raster_metadata_pkey PRIMARY KEY (coverage_name, tiletable)

-Metadata table populated with record for each table.

XML Configuration files:

connect.pgraster.xml.inc

mapping.pgraster.xml.inc

md3inch.pgraster.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE ImageMosaicJDBCConfig [ ]> &mapping; &connect;

Any help would be greatly appreciated!

···

Ty Swavely
GIS Analyst
Corona Environmental Consulting

Hi

Can you

  • Remove the store
  • Stop Geoserver and remove the logs/geoserver.log file
  • Start GeoServer
  • Switch the GeoServer Debug Level to “Geotools Debugging”,
  • Add your store
  • Send me the logs/geoserver.log file (zipped or gzipped)

Cheers
Christian

···

On Wed, Jan 6, 2016 at 11:41 PM, Ty Swavely <tswavely@anonymised.com> wrote:

Hello!

I’m trying to add an ImageMosaicJDBC data store to my Geoserver 2.8.0 instance, but am receiving this error:

Error: could not list layers for this store, an error occurred retrieving them: Failed to create reader from …. and hints null.

I’ve spent some time searching for solutions, but thus far have been stumped. A little background about the process:

-Followed this link as tutorial/Mastering Geoserver book:
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

-local Geoserver version (2.8.0) matches ImageMosaicJDBC Plugin version (gt-imagemosaic-jdbc-14.0), which is the 2.8.0 extension jar

-able to create ImagePyramid in local data directory using same dataset, able to preview layer created from ImagePyramid

Dataset:

3 inch imagery from USGS covering small section of Maryland

Preprocessing:

-ImagePyramid processed using gdal_retile

-ImageMosaicJDBC imported to Postgres using raster2pgsql
-populated public schema with md_3inch, o_2_md_3inch, o_4_md_3inch, o_8_md_3inch, o_16_md_3inch

Metadata table:

CREATE TABLE watersuite_raster_metadata ( coverage_name character varying(254) NOT NULL, tiletable character varying(254) NOT NULL, minx double precision, miny double precision, maxx double precision, maxy double precision, resx double precision, resy double precision, CONSTRAINT watersuite_raster_metadata_pkey PRIMARY KEY (coverage_name, tiletable)

-Metadata table populated with record for each table.

XML Configuration files:

connect.pgraster.xml.inc

mapping.pgraster.xml.inc

md3inch.pgraster.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE ImageMosaicJDBCConfig [ ]> &mapping; &connect;

Any help would be greatly appreciated!

Ty Swavely
GIS Analyst
Corona Environmental Consulting



Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH