Hey Luis, please keep the discussion on the list :)
I don't have a copy of the dataset as the work was done for my previous employer. But the structure of the table for ps was flat-out single table. Given the exception `<ows:ExceptionText>Feature type :ProtectedSiteType unknown</ows:ExceptionText>` I'd guess there's a problem with getting the xsd or missing namespace declarations. Also, note the missing namespace identifier in front of ProtectedSiteType. Do the xsds get cached on app-schema-cache path? if yes then you can troubleshoot by modifying the ps xsd to include only the bare minimum and then adding parts back bit-by-bit to narrow down which element is causin the problem. All the best, Tõnis Kontakt Gucho (<[email protected]>) kirjutas kuupäeval K, 12. detsember 2018 kell 10:54: [..] > Well, this is where I´m having an error, and I think it is becasue ether > the table structure or the data I´m inserting on the table. If you have by > any change a copy of your table dictionary or table structure (column > definition), that I could look at to check with my table, and some data for > testing I will be really grateful, and I will have this project done and > close. > > I hope I´m not bothering you too much with this request. > > Regards > Luis Acedo > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> > Libre > de virus. www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> > <#m_-1260150697762427057_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > On Thu, Dec 6, 2018 at 11:42 AM Tõnis Kärdi <[email protected]> wrote: > >> Hey Luis, >> >> some time has passed and I can't remember exactly, but a couple of >> possible pointers for no-top-element: >> - you'll need to declare all required xml namespaces in >> appschema/namespaces >> - add them as ("secondary" I think they were called) workspaces in the >> GS data dir aswell. >> - and watch out for misspellings (e.g <prefix>qmd</prefix> vs >> <prefix>gmd</prefix> :) ) >> >> If you'd like to take a look at a working example of inspire ps using >> GeoServer appschema then there's >> >> https://github.com/e-gov/kem-inspire/blob/reporting/src/data/ps/ProtectedSite/ProtectedSite.appschema >> available with all the required (+ more) data dir contents aswell. The >> service itself based on this app-schema can be reached through >> >> https://gsavalik.envir.ee/geoserver/ps/ows?service=WFS&version=2.0.0&request=GetFeature&count=1&typename=ps:ProtectedSite >> >> Hope this helps and all the best, >> Tõnis >> >> >> Kontakt ljacedo (<[email protected]>) kirjutas kuupäeval K, 5. >> detsember 2018 kell 19:18: >> > >> > Hello, >> > >> > Please help: >> > >> > I´m trying to do the same think you have done, and Im getting the same >> > error. >> > I have check and dobule check my namespace to see if there is a problem >> and >> > still I get the same error. >> > >> > Here is my namespace in ProtectedSite mapping file xml: >> > <namespaces> >> > <Namespace> >> > <prefix>ps</prefix> >> > >> > <uri>"http://inspire.ec.europa.eu/schemas/ps/4.0";</uri> >> > </Namespace> >> > <Namespace> >> > <prefix>base</prefix> >> > >> > <uri>"http://inspire.ec.europa.eu/schemas/base/3.3";</uri> >> > </Namespace> >> > <Namespace> >> > <prefix>gn</prefix> >> > >> > <uri>"http://inspire.ec.europa.eu/schemas/gn/4.0";</uri> >> > </Namespace> >> > <Namespace> >> > <prefix>qmd</prefix> >> > <uri>"http://www.isotc211.org/2005/gmd";</uri> >> > </Namespace> >> > <Namespace> >> > <prefix>gml</prefix> >> > <uri>"http://www.opengis.net/gml/3.2";</uri> >> > </Namespace> >> > </namespaces> >> > >> > This is the FeatureTypeMapping in ProtectedSite Mapping file: >> > <FeatureTypeMapping> >> > <sourceDataStore>bd_oracle</sourceDataStore> >> > <sourceType>PROTECTEDSITE</sourceType> >> > <targetElement>ps:ProtectedSite</targetElement> >> > <attributeMappings> >> > <AttributeMapping> >> > >> > <targetAttribute>ps:legalFoundationDate</targetAttribute> >> > <sourceExpression> >> > >> > <OCQL>LEGALFOUNDATIONDATE</OCQL> >> > </sourceExpression> >> > </AttributeMapping> >> > </attributeMappings> >> > </FeatureTypeMapping> >> > >> > Also, Here is the targetTypes (I don't think this could be a problem) >> > <targetTypes> >> > <FeatureType> >> > <schemaUri>./ProtectedSites.xsd</schemaUri> >> > </FeatureType> >> > </targetTypes> >> > >> > The error log shows as follow: >> > 2018-12-04 14:16:38,201 INFO [org.geoserver] - Loaded store >> 'ProtectedSite', >> > enabled >> > 2018-12-04 14:16:38,201 INFO [org.geoserver] - Loaded data store >> > 'ProtectedSite' >> > 2018-12-04 14:17:22,839 WARN [data.complex] - No top level element >> found in >> > schemas: {"http://inspire.ec.europa.eu/schemas/ps/4.0"}ProtectedSite >> > 2018-12-04 14:17:22,839 WARN [complex.config] - Error creating >> app-schema >> > data store for 'ps:ProtectedSite', caused by: No top level element >> found in >> > schemas: {"http://inspire.ec.europa.eu/schemas/ps/4.0"}ProtectedSite >> > 2018-12-04 14:17:22,842 WARN [org.geoserver] - Error connecting to >> > 'ProtectedSite'. Disabling. >> > 2018-12-04 14:17:22,842 INFO [org.geoserver] - >> > java.io.IOException: java.util.NoSuchElementException: No top level >> element >> > found in schemas: >> > {"http://inspire.ec.europa.eu/schemas/ps/4.0"}ProtectedSite >> > >> > If you could give some guiden on this matter I would appreciate >> > >> > Thanks >> > Luis Acedo >> > -- @tkardi skype: tonis.kardi
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
