-
1. Re: importing google geolocation service as relational table
tejones Jun 15, 2012 10:43 AM (in response to gioppoluca)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 Jun 15, 2012 11:01 AM (in response to tejones)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 Jun 15, 2012 11:07 AM (in response to gioppoluca)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 Jun 15, 2012 11:28 AM (in response to tejones)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 Jun 18, 2012 5:32 AM (in response to 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 Jun 18, 2012 5:44 AM (in response to 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 Jun 18, 2012 8:49 AM (in response to gioppoluca)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 Jun 18, 2012 11:00 AM (in response to rareddy)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'
,
'1
600+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
'1
600+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 Jun 18, 2012 11:46 AM (in response to gioppoluca)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 Jun 19, 2012 6:09 AM (in response to rareddy)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 :-))
-
geocode.vdb.zip 545.4 KB
-
-
11. Re: importing google geolocation service as relational table
gioppoluca Jun 19, 2012 6:14 AM (in response to 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 Jun 19, 2012 6:25 AM (in response to 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 Jun 19, 2012 9:15 AM (in response to gioppoluca)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 Jun 19, 2012 11:59 AM (in response to 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..