GMSC Discussions

[mzebrows]

Hi,

I'm trying to add to configuration some new features from postgres database. But in GMSC 2016 console I can't see any tables from my database.(While in other applications i.e database utulities I can see it) What can be the reason?

[pkrejcir]

GMSC does not use GeoMedia metadata, but it strongly requires a feature class to have a geometry field named "geometry_spa". Check if that cannot be the problem.

Pavel

[mzebrows]

I've made this feature class in GeoMedia and used Output to Feature Class function to copy it to postgres. Field geometry looks as follows:

[mzebrows]

Moreover, when I register class manually using New Feature-Database - it works and can be displayed on the map. So why the same table is not visible on the available tables list, when using Import Feature From-Database? 

[mzebrows]

I've found another interesting table, that was also copied to postgres by GeoMedia. I've configured feature in gmsc2016 and after displaying on the map I can see the error:

2018-04-11 11:42:39 SEVERE: The following tile can't be loaded because of an exception! [OnlineFeatureTile[feature=11, identifier=00004a, bounds=[365821.98,655750.68,439157.84,615125.78]]] --> [pool-14-thread-4] com.intergraph.web.core.data.loader.ParallelFeatureLoader$1.call
java.io.IOException: The MapService returns the following status code: 500 The MapService returns an Internal Server Error.
at com.intergraph.web.core.data.loader.LiveDataLoader.handleHttpResponse(LiveDataLoader.java:266)
at com.intergraph.web.core.data.loader.LiveDataLoader.download(LiveDataLoader.java:202)
at com.intergraph.web.core.data.loader.LiveDataLoader.processTile(LiveDataLoader.java:116)
at com.intergraph.web.core.data.loader.ParallelFeatureLoader$1.call(ParallelFeatureLoader.java:63)
at com.intergraph.web.core.data.loader.ParallelFeatureLoader$1.call(ParallelFeatureLoader.java:57)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

[sclow · Accepted solution]

Hi mzebrows,

Are the postgis tables in the 'public' schema or some other schema in your PostgreSQL database?

There is a known issue that GMSC is not seeing tables from PostgreSQL database outside of the 'public' schema on version 2016. This is affecting the 'Import Feature From' database functionality.

GMSC 2018 contains the resolution to this bug and the forthcoming GMSC 2016 EP 4 will as well.

[mzebrows]

Ok, that explains why I cannot see this tables.