1 2 Previous Next 22 Replies Latest reply: Jun 21, 2012 9:49 AM by Steven Hawkins RSS

importing google geolocation service as relational table

luca gioppo Novice

Is it possible to import the google geolocation service that respond to query like this one:

 

http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=true

 

as a relational table?

The actual procedure to get a webservice from URL expect a WSDL adn the one's that build a XML document just get a XSD is it possible to just get data from the HTTP URL?

Thanks

Luca

  • 1. Re: importing google geolocation service as relational table
    Ted Jones Apprentice

    Luca,

     

    Yes.. we have automated this in Designer 7.7.x. Use the "File Soure (XML) >> Source and View Model" importer. Click Next and then select the "XML file via remote URL" radio button. Click Next and create a Connection Profile using that URL. Follow the rest of the wizard... i.e. add the elements you want returned, select models and projects, etc.

     

    The end result will be a new virtual table with a transformation that looks something like this:

     

    SELECT

            long_name AS long_name, short_name AS short_name, type AS type

        FROM

            (EXEC geocode.invokeHttp('GET', null, 'http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=true')) AS f, XMLTABLE('/GeocodeResponse' PASSING XMLPARSE(DOCUMENT result) COLUMNS long_name string PATH 'result/address_component/long_name/text()', short_name string PATH 'result/address_component/short_name/text()', type string PATH 'result/address_component/type/text()') AS A

     

    Let me know if you have any questions...

    Thanks,

    Ted

  • 2. Re: importing google geolocation service as relational table
    luca gioppo Novice

    On the connection profile step I get this when I try to paste the URL:

    <Missing message for key "XmlProfileDetailsWizardPage.NotXmlUrl.Message" in: org.teiid.designer.datatools.ui.i18n>

     

    Luca

  • 3. Re: importing google geolocation service as relational table
    Ted Jones Apprentice

    Make sure you selected the "XML file via remote URL" radio button on the first page of the wizard. You are using the local file CP. That missing message is a bug though.

     

    Thanks,

    Ted

  • 4. Re: importing google geolocation service as relational table
    luca gioppo Novice

    Ok that error was from Designer 7.6 using 7.7 nightly I'm going on but ...

    is there a reason for  in the Import From XML File Source dialog in the View Model Definition panel in the Name I get reverse writing?

    Maybe the nightly build ?

    I correct myself almost all input got reversed.

     

    The process is finished and terminated well as you described.

    Now is there a way to parametrize URL query parameters?

    The target is to create a table from a address list of people where I have just the address, but would like to add also GPS data so I'd like to join the virtual table from the URL with the address one so that I can have a new virtual table with address and long and lat columns.

     

    Luca

  • 5. Re: importing google geolocation service as relational table
    luca gioppo Novice

    Tryed to create a VDB based on the models generated from the Google geolocation stuff but got this error:

     

    11:22:27,961 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC00001: Failed to start service jboss.deploym

    ent.unit."geocode.vdb".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."geocode.vdb".INST

    ALL: Failed to process phase INSTALL of deployment "geocode.vdb"

            at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-a

    s-server-7.1.1.Final.jar:7.1.1.Final]

            at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-ms

    c-1.0.2.GA.jar:1.0.2.GA]

            at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.G

    A.jar:1.0.2.GA]

            at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_04]

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_04]

            at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

    Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: TEIID50077 The parent translator type "elgo

    og_ws" was not found in configuration "geocode.vdb"

            at org.teiid.jboss.VDBDeployer.deploy(VDBDeployer.java:125)

            at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-a

    s-server-7.1.1.Final.jar:7.1.1.Final]

            ... 5 more

     

    Now the VDB pretend to find around this elgoog_ws (note that all the names got reversed by the nightly build version of the tool it was google and not elgoog).

    But I have no elgoog_ws around where is the bug or what am I doing wrong?

    Luca

  • 6. Re: importing google geolocation service as relational table
    luca gioppo Novice

    Tryed to remove the translator type leaving empty, but it complains ...

    Now tryed with "ws".

    It seems it likes it ...

    now it complains about:

     

    11:40:26,898 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4) Data Source elgoog not accessible.

    11:40:26,914 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40006 VDB geocode.1 is set to "inactive"

     

    Maybe I have to add a datasource for the web service in the sandalone-teiid.xml much like a normal DB connection ... how?

  • 7. Re: importing google geolocation service as relational table
    Ramesh Reddy Master

    Take look at the "docs/teiid/datasources/web-service" directory for couple different ways you can create a connection factory for the web service. Also for the supplying the parameters take look at "querystring" function

     

    https://docs.jboss.org/author/display/TEIID/String+Functions

     

    build the query string and pass it in the "request" paramater on the "invokeHttp" method. I will see if I can find an example.

     

    Ramesh..

  • 8. Re: importing google geolocation service as relational table
    luca gioppo Novice

    Perfect!!!

    It works.

    Now going for parametric results.

    A bit more documentation on the invokeHttp method could be usefull.

    For example the request parameter should be an object ...

    How do we build it?

    Now I have the URL in the endpoint and could use your suggestion for building a dynamic URL using the QueryString function, but have to understand how to pass parameters to the SELECT

     

    Now I have this transformation (built by designer)

    SELECT

            A.lat AS lat, A.lng AS lng

        FROM

            (EXEC elgoog.invokeHttp('GET', null, 'http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=true')) AS f, XMLTABLE('/GeocodeResponse' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS lat string PATH 'result/geometry/location/lat/text()', lng string PATH 'result/geometry/location/lng/text()') AS A

     

     

    Could be transformed in

    SELECT

            A.lat AS lat, A.lng AS lng

        FROM

            (EXEC elgoog.invokeHttp('GET', null,

    QUERYSTRING\('http://maps.googleapis.com/maps/api/geocode/xml', '1600+Amphitheatre+Parkway,+Mountain+View,+CA' as "address", 'true' as sensor)

    )) AS f, XMLTABLE('/GeocodeResponse' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS lat string PATH 'result/geometry/location/lat/text()', lng string PATH 'result/geometry/location/lng/text()') AS A

     

    But how to transform 

    '1600+Amphitheatre+Parkway,+Mountain+View,+CA'

    and

    'true' in parameters coming from outside have no clue

  • 9. Re: importing google geolocation service as relational table
    Ramesh Reddy Master

    Try this.

     

    QUERYSTRING('http://maps.googleapis.com/maps/api/geocode/xml', '1600 Amphitheatre Parkway, Mountain View, CA' as address, 'true' as sensor)
    

     

    Yes, we need to improve some documentation around this. May be you can help us providing a documentation patch?

     

    Thanks.

     

    Ramesh..

  • 10. Re: importing google geolocation service as relational table
    luca gioppo Novice

    I'll try to add some new documentation as soon as I manage to have a working example.

    Right now I'm having a peculiar situation:

    I've created a new view table based on an exixting table coming from oracle where I have address info and using invokehttp function to get from google the longitude latitude

    I managed to create the table and see the VDB WORKING with squirrelsql but it retrieved the following error:

     

    Error: Error Code:TEIID30328 Message:Remote org.teiid.api.exception.query.ExpressionEvaluationException: Error Code:TEIID30328 Message:TEIID30328 Unable to evaluate (SELECT A.lat AS lat FROM (EXEC elgoog.invokeHttp('GET', null, QUERYSTRING('http://maps.googleapis.com/maps/api/geocode/xml', concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(l.CIVICO, ','), l.TIPO_VIA), ' '), l.NOME_VIA), ','), i.COMUNE), ','), i.PROVINCIA), ','), 'Italy') AS address, 'true' AS sensor))) AS f, XMLTABLE('/GeocodeResponse' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS lat string PATH 'result/geometry/location/lat/text()', lng string PATH 'result/geometry/location/lng/text()') AS A LIMIT 2): Error Code:TEIID30344 Message:Error Code:TEIID30171 Message:TEIID30171 Unexpected multi-valued result was returned for XMLTable column "lat".  Path expressions for non-XML type columns should return at most a single result.

    SQLState:  TEIID30328

     

    Obviously I forgot to take just the first result so I added the "limit 1" to the statement and redeployed.

    Now I get this error and I do not manage to throw it away and I do not know why it happens.

    The standalone-teiid.xml is configured and worked so ...

     

     

    11:59:46,054 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31080 View geos.maps validation error: [Q

    ueryResolverException] TEIID30064: Error Code:TEIID30064 Message:Error Code:TEIID30352 Message:ELGOOG.INVOKEHTTP does no

    t exist.

    1 [QueryMetadataException] TEIID30352: Error Code:TEIID30352 Message:ELGOOG.INVOKEHTTP does not exist.

    11:59:46,085 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31080 View siss_view.my_localization vali

    dation error: [QueryResolverException] TEIID30064: Error Code:TEIID30064 Message:Error Code:TEIID30352 Message:ELGOOG.IN

    VOKEHTTP does not exist.

    1 [QueryMetadataException] TEIID30352: Error Code:TEIID30352 Message:ELGOOG.INVOKEHTTP does not exist.

    11:59:46,257 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40073 The metadata for the VDB geocode.1 is loaded

    , however it is not valid. Check models for errors. Correct the metadata and re-deploy.

    11:59:46,257 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40006 VDB geocode.1 is set to "inactive"

     

    Possible ideas:

    1) it looks for a capitalized reference, but is lower case in the VDB

    2) it does not load the resource adapter in time for loadinfg the vdb (this is  just to add a second hint :-))

  • 11. Re: importing google geolocation service as relational table
    luca gioppo Novice

    There must be some issues on TEIID version 8 because after a restart (no modifications done) I get this:

    12:10:53,914 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View geos.maps validation error: [QueryResolverException] TEIID30064: Error Code:TEIID30064 Message:Error Code:TEIID30352 Message:ELGOOG.INVOKEHTTP does not exist.

    1 [QueryMetadataException] TEIID30352: Error Code:TEIID30352 Message:ELGOOG.INVOKEHTTP does not exist.

    12:10:53,929 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.my_localization validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_INCIDENTI AS i

    12:10:53,929 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.CSI_LOG_AUDIT validation error: [QueryResolverException]Group does not exist: SISS.SISS.CSI_LOG_AUDIT

    12:10:53,929 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.MDRT_60C6F$ validation error: [QueryResolverException]Group does not exist: SISS.SISS."MDRT_60C6F$"

    12:10:53,929 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_ALLEGATI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_ALLEGATI

    12:10:53,929 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_ALTRI_ELEM_STRADA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_ALTRI_ELEM_STRADA

    12:10:53,945 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_CARATT_LUOGO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_CARATT_LUOGO

    12:10:53,945 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_CIRCOSTANZE_ISTAT validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_CIRCOSTANZE_ISTAT

    12:10:53,945 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_COMUNI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_COMUNI

    12:10:53,945 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_DANNI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_DANNI

    12:10:53,945 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_DOCUMENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_DOCUMENTI

    12:10:53,945 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_ESITI_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_ESITI_INCIDENTI

    12:10:53,960 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_ESTENSIONE_STRADA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_ESTENSIONE_STRADA

    12:10:53,960 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_INCIDENTI

    12:10:53,960 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_LOCALIZZ_INCIDENTE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_LOCALIZZ_INCIDENTE

    12:10:53,960 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_MEZZI_SOCCORSO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_MEZZI_SOCCORSO

    12:10:53,960 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_OPERE_ARTE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_OPERE_ARTE

    12:10:53,960 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_ORGANO_RILEVAZIONE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_ORGANO_RILEVAZIONE

    12:10:53,976 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_OSPEDALI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_OSPEDALI

    12:10:53,976 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_OSSERVAZIONE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_OSSERVAZIONE

    12:10:53,976 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_OSTRUZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_OSTRUZIONI

    12:10:53,992 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_PEDONI_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_PEDONI_INCIDENTI

    12:10:53,992 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_PROVINCE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_PROVINCE

    12:10:53,992 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_RIMORCHI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_RIMORCHI

    12:10:53,992 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_SCHEDE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_SCHEDE

    12:10:53,992 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_SEGNALAZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_SEGNALAZIONI

    12:10:53,992 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_SIGLA_STRADA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_SIGLA_STRADA

    12:10:54,007 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_TIPO_DICHIARAZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_TIPO_DICHIARAZIONI

    12:10:54,007 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_D_VEICOLI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_D_VEICOLI

    12:10:54,007 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_EXP_D_EXPORT validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_EXP_D_EXPORT

    12:10:54,007 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_EXP_D_LOG validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_EXP_D_LOG

    12:10:54,007 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_EXP_T_EXPORT validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_EXP_T_EXPORT

    12:10:54,007 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_EXP_T_LOG validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_EXP_T_LOG

    12:10:54,007 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_IMP_D_CAMPI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_IMP_D_CAMPI

    12:10:54,023 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_IMP_D_IMPORT validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_IMP_D_IMPORT

    12:10:54,023 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_IMP_D_LOG validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_IMP_D_LOG

    12:10:54,023 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_IMP_MTD_CAMPI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_IMP_MTD_CAMPI

    12:10:54,023 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_IMP_T_IMPORT validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_IMP_T_IMPORT

    12:10:54,023 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_IMP_T_LOG validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_IMP_T_LOG

    12:10:54,023 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_IMP_TMP_IMPORT validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_IMP_TMP_IMPORT

    12:10:54,023 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_CAMPI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_CAMPI

    12:10:54,039 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_CATEGORIE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_CATEGORIE

    12:10:54,039 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_CATEGORIE_CAMPI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_CATEGORIE_CAMPI

    12:10:54,039 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_COLONNA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_COLONNA

    12:10:54,039 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_COLONNE_CAMPI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_COLONNE_CAMPI

    12:10:54,039 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_CONTROLLI_WARN validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_CONTROLLI_WARN

    12:10:54,039 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_MESSAGGI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_MESSAGGI

    12:10:54,039 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_PAGINE_WEB validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_PAGINE_WEB

    12:10:54,054 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_SEZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_SEZIONI

    12:10:54,054 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_SOTTOSEZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_SOTTOSEZIONI

    12:10:54,054 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_TAVOLA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_TAVOLA

    12:10:54,054 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_UC_CATEGORIE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_UC_CATEGORIE

    12:10:54,054 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_MTD_UC_CLASSIFICAZIONE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_MTD_UC_CLASSIFICAZIONE

    12:10:54,070 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_R_PEDONI_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_R_PEDONI_INCIDENTI

    12:10:54,070 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_R_SIGLA_TIPOLOGIA_STRADA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_R_SIGLA_TIPOLOGIA_STRADA

    12:10:54,070 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_R_TESTIMONI_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_R_TESTIMONI_INCIDENTI

    12:10:54,070 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_R_VEICINCID_RIMORCHI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_R_VEICINCID_RIMORCHI

    12:10:54,070 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_R_VEICIND_MERCI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_R_VEICIND_MERCI

    12:10:54,070 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_R_VEICOLI_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_R_VEICOLI_INCIDENTI

    12:10:54,085 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_SDO_PT_LOCINC validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_SDO_PT_LOCINC

    12:10:54,085 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_D_INDICATORI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_D_INDICATORI

    12:10:54,085 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_MTD_CATEGORIE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_MTD_CATEGORIE

    12:10:54,085 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_MTD_INDICATORI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_MTD_INDICATORI

    12:10:54,085 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_MTD_SCADENZIARIO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_MTD_SCADENZIARIO

    12:10:54,101 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_T_CONFIG validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_T_CONFIG

    12:10:54,101 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AMBITO_AUTOSTRADA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AMBITO_AUTOSTRADA

    12:10:54,101 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AMBITO_COM_URBANO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AMBITO_COM_URBANO

    12:10:54,101 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AMBITO_COMUNALE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AMBITO_COMUNALE

    12:10:54,117 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AMBITO_EXTRAURBANO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AMBITO_EXTRAURBANO

    12:10:54,117 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AMBITO_PROVINCIALE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AMBITO_PROVINCIALE

    12:10:54,117 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AMBITO_REG_STATALE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AMBITO_REG_STATALE

    12:10:54,117 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AMBITO_URBANO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AMBITO_URBANO

    12:10:54,117 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AUTOCARRI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AUTOCARRI

    12:10:54,117 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_AUTOVETTURE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_AUTOVETTURE

    12:10:54,117 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_CICLOMOTORI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_CICLOMOTORI

    12:10:54,117 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_CONDUCENTI_PSICO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_CONDUCENTI_PSICO

    12:10:54,132 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI

    12:10:54,132 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI_CICLISTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI_CICLISTI

    12:10:54,132 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI_MASCHI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI_MASCHI

    12:10:54,132 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI_MAX_65 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI_MAX_65

    12:10:54,132 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI_MIN_25 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI_MIN_25

    12:10:54,132 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI_MOTOCICLIST validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI_MOTOCICLIST

    12:10:54,132 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI_PEDONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI_PEDONI

    12:10:54,148 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI_TRA_26_45 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI_TRA_26_45

    12:10:54,148 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_FERITI_TRA_46_64 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_FERITI_TRA_46_64

    12:10:54,148 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_INCIDENTI_ISTAT validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_INCIDENTI_ISTAT

    12:10:54,148 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_INCIDENTI_MORTALI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_INCIDENTI_MORTALI

    12:10:54,148 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_INTERSEZIONE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_INTERSEZIONE

    12:10:54,148 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI

    12:10:54,148 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_CICLISTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_CICLISTI

    12:10:54,164 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_FERITI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_FERITI

    12:10:54,164 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_MASCHI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_MASCHI

    12:10:54,164 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_MAX_65 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_MAX_65

    12:10:54,164 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_MIN_25 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_MIN_25

    12:10:54,164 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_MOTOCICLISTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_MOTOCICLISTI

    12:10:54,179 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_PEDONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_PEDONI

    12:10:54,179 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_TRA_26_45 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_TRA_26_45

    12:10:54,179 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MORTI_TRA_46_64 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MORTI_TRA_46_64

    12:10:54,179 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MOTO_CICLOMOTORI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MOTO_CICLOMOTORI

    12:10:54,179 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_MOTOCICLI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_MOTOCICLI

    12:10:54,195 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_PEDONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_PEDONI

    12:10:54,195 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_SCHEDE_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_SCHEDE_INCIDENTI

    12:10:54,195 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_SOLO_FERITI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_SOLO_FERITI

    12:10:54,195 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_VEIC_MORTI_FERITI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_VEIC_MORTI_FERITI

    12:10:54,195 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_VEICOLI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_VEICOLI

    12:10:54,195 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_VEICOLI_AVARIE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_VEICOLI_AVARIE

    12:10:54,210 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_V_VELOCIPEDI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_V_VELOCIPEDI

    12:10:54,210 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_W_INDICATORI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_W_INDICATORI

    12:10:54,210 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_W_SCADENZIARIO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_W_SCADENZIARIO

    12:10:54,210 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_W_SCADENZIARIO_BCK validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_W_SCADENZIARIO_BCK

    12:10:54,210 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_W_STORIA_INDICATORI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_W_STORIA_INDICATORI

    12:10:54,210 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_STAT_W_STORIA_SCADENZIAR validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_STAT_W_STORIA_SCADENZIAR

    12:10:54,210 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_ALLEGATI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_ALLEGATI

    12:10:54,226 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_ALTRE_STRADE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_ALTRE_STRADE

    12:10:54,226 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_ALTRI_ELEM_STRADA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_ALTRI_ELEM_STRADA

    12:10:54,226 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_APPG_EMAIL validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_APPG_EMAIL

    12:10:54,226 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_APPG_STATO_SEZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_APPG_STATO_SEZIONI

    12:10:54,242 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_ASSENZA_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_ASSENZA_INCIDENTI

    12:10:54,242 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_ASSICURAZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_ASSICURAZIONI

    12:10:54,242 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_CALENDARIO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_CALENDARIO

    12:10:54,242 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_CARATT_LUOGO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_CARATT_LUOGO

    12:10:54,242 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_COMPETENZE_TERRITORIALI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_COMPETENZE_TERRITORIALI

    12:10:54,242 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_CONDUCENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_CONDUCENTI

    12:10:54,257 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_DANNI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_DANNI

    12:10:54,257 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_DELEGHE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_DELEGHE

    12:10:54,257 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_DESTINATARIO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_DESTINATARIO

    12:10:54,257 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_DOCUMENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_DOCUMENTI

    12:10:54,257 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_ENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_ENTI

    12:10:54,257 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_INC_ALTRI_DATI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_INC_ALTRI_DATI

    12:10:54,257 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_INC_DATI_PERSONE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_INC_DATI_PERSONE

    12:10:54,273 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_INCIDENTI

    12:10:54,273 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_LOCALIZZ_INCIDENTE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_LOCALIZZ_INCIDENTE

    12:10:54,273 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_MEZZI_SOCCORSO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_MEZZI_SOCCORSO

    12:10:54,273 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_NR_STRADE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_NR_STRADE

    12:10:54,273 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_OPERE_ARTE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_OPERE_ARTE

    12:10:54,273 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_OSSERVAZIONE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_OSSERVAZIONE

    12:10:54,273 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_OSTRUZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_OSTRUZIONI

    12:10:54,289 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_PARAMETRI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_PARAMETRI

    12:10:54,289 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_PASSEGGERI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_PASSEGGERI

    12:10:54,289 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_PERSONE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_PERSONE

    12:10:54,289 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_SCHEDE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_SCHEDE

    12:10:54,289 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_SEGNALAZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_SEGNALAZIONI

    12:10:54,289 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_TOTALI_UPLOADER validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_TOTALI_UPLOADER

    12:10:54,289 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_T_VEIC_ALTRI_DATI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_T_VEIC_ALTRI_DATI

    12:10:54,304 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_ELEM_STRADA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_ELEM_STRADA

    12:10:54,304 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_ENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_ENTI

    12:10:54,304 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_F_FERITI_A_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_F_FERITI_A_2

    12:10:54,304 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_F_FERITI_B_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_F_FERITI_B_2

    12:10:54,304 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_F_FERITI_C_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_F_FERITI_C_2

    12:10:54,304 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_F_MORTI_A_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_F_MORTI_A_2

    12:10:54,304 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_F_MORTI_B_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_F_MORTI_B_2

    12:10:54,320 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_F_MORTI_C_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_F_MORTI_C_2

    12:10:54,320 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_M_FERITI_A_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_M_FERITI_A_2

    12:10:54,320 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_M_FERITI_B_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_M_FERITI_B_2

    12:10:54,335 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_M_FERITI_C_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_M_FERITI_C_2

    12:10:54,335 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_M_MORTI_A_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_M_MORTI_A_2

    12:10:54,335 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_M_MORTI_B_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_M_MORTI_B_2

    12:10:54,335 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_M_MORTI_C_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_M_MORTI_C_2

    12:10:54,335 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_ALTRI_VEI_COINVOLTI_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_ALTRI_VEI_COINVOLTI_2

    12:10:54,335 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_CIRCOST_INCONV_CIRCOL validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_CIRCOST_INCONV_CIRCOL

    12:10:54,351 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_COINVOLGIMENTO_CICLISTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_COINVOLGIMENTO_CICLISTI

    12:10:54,351 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_COINVOLGIMENTO_MOTOCICL validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_COINVOLGIMENTO_MOTOCICL

    12:10:54,351 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_COINVOLGIMENTO_PEDONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_COINVOLGIMENTO_PEDONI

    12:10:54,351 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_CVB validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_CVB

    12:10:54,351 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_DANNI_ANIMALI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_DANNI_ANIMALI

    12:10:54,351 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_DANNI_COSE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_DANNI_COSE

    12:10:54,367 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_DOC1 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_DOC1

    12:10:54,367 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_DOC2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_DOC2

    12:10:54,367 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_DOC3 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_DOC3

    12:10:54,367 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_FERITI_F_ALTRI_VEI_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_FERITI_F_ALTRI_VEI_2

    12:10:54,367 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_FERITI_M_ALTRI_VEI_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_FERITI_M_ALTRI_VEI_2

    12:10:54,367 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_INCIDENTI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_INCIDENTI

    12:10:54,367 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_LOCINC validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_LOCINC

    12:10:54,382 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_MORTI_F_ALTRI_VEI_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_MORTI_F_ALTRI_VEI_2

    12:10:54,382 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_MORTI_M_ALTRI_VEI_2 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_MORTI_M_ALTRI_VEI_2

    12:10:54,382 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_NOME_FERITI_ALL validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_NOME_FERITI_ALL

    12:10:54,382 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_NOME_MORTI_ALL validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_NOME_MORTI_ALL

    12:10:54,382 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_OSPEDALI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_OSPEDALI

    12:10:54,382 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_OSPEDALI_ALL validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_OSPEDALI_ALL

    12:10:54,398 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_PASSAGGIO_PEDONALE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_PASSAGGIO_PEDONALE

    12:10:54,398 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_SCHEDE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_SCHEDE

    12:10:54,398 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_SOLO_DANNI_MAT validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_SOLO_DANNI_MAT

    12:10:54,398 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_SOLO_FERITI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_SOLO_FERITI

    12:10:54,398 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_COND_NOPIEM validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_COND_NOPIEM

    12:10:54,398 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_COND_PAT_ESTERA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_COND_PAT_ESTERA

    12:10:54,398 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_DESCRIZ_STRADA validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_DESCRIZ_STRADA

    12:10:54,414 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_FERITI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_FERITI

    12:10:54,414 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_MORTI_24 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_MORTI_24

    12:10:54,414 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_MORTI_30 validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_MORTI_30

    12:10:54,414 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_OPERE_ARTE validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_OPERE_ARTE

    12:10:54,414 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_OSTRUZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_OSTRUZIONI

    12:10:54,429 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_PRS_BORDO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_PRS_BORDO

    12:10:54,429 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_PRS_NOPIEM validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_PRS_NOPIEM

    12:10:54,429 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_V_TOT_PRS_STUDIO_LAVORO validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_V_TOT_PRS_STUDIO_LAVORO

    12:10:54,429 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_VSDO_PT_LOCINC validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_VSDO_PT_LOCINC

    12:10:54,429 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_XCHG_D_APPLICAZIONI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_XCHG_D_APPLICAZIONI

    12:10:54,429 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_XCHG_D_CAMPI validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_XCHG_D_CAMPI

    12:10:54,429 INFO  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31080 View siss_view.SISS.SISS_XCHG_W_RUOLI_MAP validation error: [QueryResolverException]Group does not exist: SISS.SISS.SISS_XCHG_W_RUOLI_MAP

    12:10:54,429 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40073 The metadata for the VDB geocode.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.

    12:10:54,445 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40006 VDB geocode.1 is set to "inactive"

     

     

    I would expect consistent errors not random ones (unless I've have some other bigger error around, but in this case I should have a proper error message).

    Luca

  • 12. Re: importing google geolocation service as relational table
    luca gioppo Novice

    After a second restart (no mods done)

    All start correctly and VDB is active.

    Query made and got the same error.

     

    Now there are 2 problems

     

    First

    TEIID behaves erratically ... two restart to make it forget/clear caches or what.

     

    Second

    How to force the XMLTABLE to return just one row?

    (SELECT A.lat AS lat FROM (EXEC elgoog.invokeHttp('GET', null, QUERYSTRING('http://maps.googleapis.com/maps/api/geocode/xml', concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(l.CIVICO, ','), l.TIPO_VIA), ' '), l.NOME_VIA), ','), i.COMUNE), ','), i.PROVINCIA), ','), 'Italy') AS address, 'true' AS sensor))) AS f, XMLTABLE('/GeocodeResponse' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS lat string PATH 'result/geometry/location/lat/text()', lng string PATH 'result/geometry/location/lng/text()') AS A LIMIT 1)

    The query above fire the error, I hoped that "LIMIT 1" could do the job, but probably not.

     

    Thanks

    Luca

  • 13. Re: importing google geolocation service as relational table
    Ramesh Reddy Master

    Luca,

     

    Is this with 8.1 Alpha1 or on 8.0 version? We fixed few issues with metadata in 8.1.x version. In 8.x the metadata loads are happening in parallel threads, however they get resolved once all the models are loaded. The errors show that the metadata validation is failing, does not show why. I will try it out locally and see if I can replicate any of these issues.

     

    Ramesh..

  • 14. Re: importing google geolocation service as relational table
    Ramesh Reddy Master

    Luca,

     

     

    I tried dozen times but failed to replicate the metadata load error with latest code. So, not sure what is going on there. Try building the latest from trunk and see if you can replicate the behavior. Otherwise we will have 8.1.Alpha2 out in next week.  On the LIMIT case, I see this from your error above

     

    "Message:TEIID30171 Unexpected multi-valued result was returned for XMLTable column "lat".  Path expressions for non-XML type columns should return at most a single result"

     

    so, the google service is returning the multiple "lat" in the XML, can you confirm by executing just the invokeHTTP part and inspect the XML? If you find that XML has two "lat" elements then you can change the PATH on lat to 'result/geometry/location/lat[0]/text()' to limit to the very first one.

     

    Let me know if both above solutions work for you.

     

    Thanks

     

    Ramesh..

1 2 Previous Next