1 2 Previous Next 22 Replies Latest reply on Jun 21, 2012 9:49 AM by shawkins

    importing google geolocation service as relational table

    gioppoluca

      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
          tejones

          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
            gioppoluca

            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
              tejones

              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
                gioppoluca

                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
                  gioppoluca

                  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
                    gioppoluca

                    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
                      rareddy

                      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
                        gioppoluca

                        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
                          rareddy

                          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
                            gioppoluca

                            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
                              gioppoluca

                              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
                                gioppoluca

                                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
                                  rareddy

                                  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
                                    rareddy

                                    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