WebGIS Discussions

Need a push in the right direction when configuring WebMap, Portal or SDI services? Looking for hints and tips, or just looking for Ideas and information? The WebGIS discussion board is where you start those discussions, connect and share information.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Occasional Contributor
Posts: 9
Registered: ‎07-09-2019

Webmap Publisher 2020 PostGIS New service source error

Hello everybody,

 

On attempt to create new POSTGIS service source in Webmap 2020 Essentials I am receiving error stating "no schema has been selected to create in".   Postgres Search_path shows "public".  My postgres database is fresh - empty for Webmap metadata and has only public shema.

Looking in Webmap publisher documention but there is no update on new version 2020 capability to store metadata in PostGRES.

 

 

Best regards,

Ervins

Highlighted
Super Contributor
Posts: 446
Registered: ‎10-12-2015

Re: Webmap Publisher 2020 PostGIS New service source error

Hi Ervins, 

I'm not so familiar with PostGIS, but with the SQL Server environment you have to use Database Utilities to create the standard GeoMedia Metadata tables in the database prior to using as a service source. I assume its a similar requirement.

https://hexagongeospatial.fluidtopics.net/reader/FqsYJDf8FOIave~S4FztXw/PijvMNLgg94sTnogQpuSLQ  (Use 'Create Metadata Tables')

https://hexagongeospatial.fluidtopics.net/reader/FqsYJDf8FOIave~S4FztXw/1gia7ZzkWuGPa8lkDF~vMg 

Shaun

Highlighted
Occasional Contributor
Posts: 9
Registered: ‎07-09-2019

Re: Webmap Publisher 2020 PostGIS New service source error

Hello,

 

The creation of metadata with Database Utilities into my PostGres/PostGis schema allows me to edit vector data in PostGIS with Geomedia desktop but does not change the situation with New POSTGIS service source error. I created the new Postgres schema again and added the metadata with Database utilities once more time. No positive result so far with Webmap metadata in Postgres.

 

Best regards,

Ervins

Highlighted
Technical Evangelist
Posts: 1,225
Registered: ‎09-11-2015

Re: Webmap Publisher 2020 PostGIS New service source error

Hi Ervins,

 

The PostGIS metadata capability was introduced already in 2018 Update 2 (see Release Guid here).

 

Could it be that there's rather a problem with user permissions in your PostGIS? I've found this discussion on the similar topic:

https://dba.stackexchange.com/questions/106057/error-no-schema-has-been-selected-to-create-in

 

Jan

Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial