[JBoss JIRA] (TEIIDDES-2207) Web Service Operation SQL valid in 8.3.2 but invalid in 8.5
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2207?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2207:
----------------------------------------
Appears the SQL error will show up in 8.5 for any Table that's used to generate a WS operation does NOT have a PK. Adding the primary key to the table and regenerating changes the resulting SQL to:
{code}
BEGIN
DECLARE string VARIABLES.IN_INSTR_ID;
VARIABLES.IN_INSTR_ID = xPathValue(Products_WS.Products_AllProducts.getAllProducts.AllProducts_InputMsg, '/*:AllProducts_Input/*:INSTR_ID');
SELECT * FROM Products_Output_View.AllProducts_OutputView WHERE Products_Output_View.AllProducts_OutputView.AllProducts_Output.AllProducts_Output_Instance.INSTR_ID = VARIABLES.IN_INSTR_ID;
END
{code}
So it still may be an expected error
> Web Service Operation SQL valid in 8.3.2 but invalid in 8.5
> -----------------------------------------------------------
>
> Key: TEIIDDES-2207
> URL: https://issues.jboss.org/browse/TEIIDDES-2207
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Validation, Web Services Support
> Affects Versions: 8.5
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Priority: Critical
> Fix For: 8.5
>
> Attachments: testWebService.zip
>
>
> Compared creating WS from source and view models in 8.3.2 vs 8.5.
> See attached project set
> 1) Created WS from ProductsOracle source and WS operations validated fine in 8.3.2 and 8.5 Designer
> 2) Created WS from PRoductsViews view model and WS operations contained an error.
> Differences in the SQL for 8.5 vs 8.3.2 relate to the removing the CREATE VIRTUAL PROCEDURE in the SQL.
> 8.3.2 SQL
> {code}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE string VARIABLES.IN_exampleVar;
> VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
> SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
> END
> {code}
> Same operation validated in 8.5 but results in validation error:
> {code}
> BEGIN
> DECLARE string VARIABLES.IN_exampleVar;
> VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
> SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
> END
> {code}
> ERROR
> {code}
> ERROR: TEIID30070 The function 'xPathValue(null, '//*[local-name()="exampleName"]')' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2207) Web Service Operation SQL valid in 8.3.2 but invalid in 8.5
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2207?page=com.atlassian.jira.plu... ]
Barry LaFond reopened TEIIDDES-2207:
------------------------------------
> Web Service Operation SQL valid in 8.3.2 but invalid in 8.5
> -----------------------------------------------------------
>
> Key: TEIIDDES-2207
> URL: https://issues.jboss.org/browse/TEIIDDES-2207
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Validation, Web Services Support
> Affects Versions: 8.5
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Priority: Critical
> Fix For: 8.5
>
> Attachments: testWebService.zip
>
>
> Compared creating WS from source and view models in 8.3.2 vs 8.5.
> See attached project set
> 1) Created WS from ProductsOracle source and WS operations validated fine in 8.3.2 and 8.5 Designer
> 2) Created WS from PRoductsViews view model and WS operations contained an error.
> Differences in the SQL for 8.5 vs 8.3.2 relate to the removing the CREATE VIRTUAL PROCEDURE in the SQL.
> 8.3.2 SQL
> {code}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE string VARIABLES.IN_exampleVar;
> VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
> SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
> END
> {code}
> Same operation validated in 8.5 but results in validation error:
> {code}
> BEGIN
> DECLARE string VARIABLES.IN_exampleVar;
> VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
> SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
> END
> {code}
> ERROR
> {code}
> ERROR: TEIID30070 The function 'xPathValue(null, '//*[local-name()="exampleName"]')' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-1882) Add Support for JSON Based Web Service Importing
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1882?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1882:
----------------------------------------
+100 for the feature.
Actually I was helping somebody today with the very use case, once the https://issues.jboss.org/browse/TEIIDDES-1829 correctly resolved, then the using the JSONTOXML is pretty straight forward, all it would require couple extra things
* When JSON data is read, automatically convert it to XML, so that XML wizards can be used as is
* In result transformation, use the JSONTOXML function as shown in example below.
ex:
{code}
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT now.id AS id FROM (EXEC csdyn.invokeHttp('GET', null, 'http://api.tvbuzz.nl/api/2.0/nl_NL/column/now/trending', 'TRUE')) AS f, XMLTABLE('/foo/data/now' PASSING JSONTOXML('foo', f.result) COLUMNS id integer PATH 'id') AS now;
END
{code}
> Add Support for JSON Based Web Service Importing
> ------------------------------------------------
>
> Key: TEIIDDES-1882
> URL: https://issues.jboss.org/browse/TEIIDDES-1882
> Project: Teiid Designer
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Web Services Support
> Affects Versions: 8.2
> Reporter: Ted Jones
> Assignee: Ted Jones
> Fix For: 8.5.1
>
>
> The current web service importer only supports XML responses. Need to add support for JSON responses.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-1882) Add Support for JSON Based Web Service Importing
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1882?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-1882:
---------------------------------------
With all the interest in this feature, it might be a good opportunity for everyone to work together. Ted, if you could comment on this jira and let everyone know when you make it initially available in the nightly builds, then those interested could test it and provide feedback.
> Add Support for JSON Based Web Service Importing
> ------------------------------------------------
>
> Key: TEIIDDES-1882
> URL: https://issues.jboss.org/browse/TEIIDDES-1882
> Project: Teiid Designer
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Web Services Support
> Affects Versions: 8.2
> Reporter: Ted Jones
> Assignee: Ted Jones
> Fix For: 8.5.1
>
>
> The current web service importer only supports XML responses. Need to add support for JSON responses.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2160) Merge various fixes from master into 8.3.3
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2160?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2160:
---------------------------------------------------
jolee(a)redhat.com changed the Status of [bug 1064360|https://bugzilla.redhat.com/show_bug.cgi?id=1064360] from NEW to MODIFIED
> Merge various fixes from master into 8.3.3
> ------------------------------------------
>
> Key: TEIIDDES-2160
> URL: https://issues.jboss.org/browse/TEIIDDES-2160
> Project: Teiid Designer
> Issue Type: Task
> Security Level: Public(Everyone can see)
> Components: Build, Release Work
> Affects Versions: 8.3.3
> Reporter: Barry LaFond
> Assignee: Johnathon Lee
> Priority: Blocker
> Fix For: 8.3.3
>
>
> A handful of fixes for 8.5 release have been requested to be back-ported and applied to next 8.3 release, namely, 8.3
> *Candidates*
> * TEIIDDES-#### None
> *Completed Upstream*
> * TEIIDDES-#### None
> *Merged*
> * TEIIDDES-1901 Teiid Connection Importer is using the pool-name instead of jndi name
> * TEIIDDES-1945 fixed via TEIIDDES-2104
> * TEIIDDES-1961 Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text
> * TEIIDDES-2061 char[n+] field is truncated by importer
> * TEIIDDES-2101 Query resolution fails on procedure that references XmlDocument
> * TEIIDDES-2104 NPE launching Undeploy VDB Action in server view
> * TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
> * TEIIDDES-2136 File Source (XML) importer reverses Root patch when typed (Windows)
> * TEIIDDES-2155 Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
> * TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
> * TEIIDDES-2168 Importing older (7.x) model projects into 8.x Designer results in .project not including the VdbBuilder buildCommand (required for TEIIDDES-2120)
> * Misc... *6db82635538d6f3aab029e207678de3dac4e47fd* and *e9255d4187f437ad491cb2ad9fe8eba83e7ea29a*
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2216) TEIID30181 HEADER entry missing for column name id in Unknown
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2216?page=com.atlassian.jira.plu... ]
Steven Hawkins updated TEIIDDES-2216:
-------------------------------------
Assignee: (was: Steven Hawkins)
> TEIID30181 HEADER entry missing for column name id in Unknown
> -------------------------------------------------------------
>
> Key: TEIIDDES-2216
> URL: https://issues.jboss.org/browse/TEIIDDES-2216
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Environment: TEIID 8.8, JBoss EAP 6.1alpha
> Reporter: luca gioppo
>
> I'm accessing a CSV file through the web service connector (follows the resource-adapter):
> <resource-adapter id="webservice">
> <module slot="main" id="org.jboss.teiid.resource-adapter.webservice"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.ws.WSManagedConnectionFactory" jndi-name="java:/amm" enabled="true" use-java-context="true" pool-name="amm">
> <config-property name="EndPoint">http://spcdata.digitpa.gov.it/data/amm.csv</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> I create a table from, this CSV but not have the first row as header column name, so I gave names to the table and have this transformation:
> SELECT
> A.id, A.denominazione, A.sede_legale, A.nome_resp, A.cognome_resp, A.cap, A.provincia, A.regione, A.sito_istituzionale, A.indirizzo, A.titolo_resp, A.tipo_istat, A.acronimo, A.cf_validato, A.cf, A.mail, A.tipo_mail, A.mail2, A.tipo_mail2, A.mail3, A.tipo_mail3, A.facebook, A.twitter, A.googleplus, A.youtube, A.liv_access
> FROM
> (EXEC amm.invokeHttp('GET', null, 'http://spcdata.digitpa.gov.it/data/amm.csv', 'TRUE')) AS f, TEXTTABLE(TO_CHARS(f.result, 'UTF-8') COLUMNS id string, denominazione string, sede_legale string, nome_resp string, cognome_resp string, cap string, provincia string, regione string, sito_istituzionale string, indirizzo string, titolo_resp string, tipo_istat string, acronimo string, cf_validato string, cf string, mail string, tipo_mail string, mail2 string, tipo_mail2 string, mail3 string, tipo_mail3 string, facebook string, twitter string, googleplus string, youtube string, liv_access string DELIMITER ' ' HEADER) AS A
> When I try to access the VDB I get this error:
> 14:52:42,410 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue56) Ho/sIQ8ukETA TEIID30015 Failed to load materialized view table #MAT_AMMV.AMMINISTRAZIONI.: org.teiid.core.TeiidProcessingException: TEIID30181 HEADER entry missing for column name id in Unknown.
> at org.teiid.query.processor.relational.TextTableNode.processHeader(TextTableNode.java:477) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.TextTableNode.initReader(TextTableNode.java:453) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.TextTableNode.nextBatchDirect(TextTableNode.java:198) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:255) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTable.insert(TempTable.java:682) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:659) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:558) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:487) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_25]
> at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_25]
> 14:52:42,413 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue56) Ho/sIQ8ukETA TEIID30020 Processing exception for request Ho/sIQ8ukETA.5 'TEIID30181 HEADER entry missing for column name id in Unknown.'. Originally TeiidProcessingException TextTableNode.java:477. Enable more detailed logging to see the entire stacktrace.
> Where I do something wrong?
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months
[JBoss JIRA] (TEIIDDES-2216) TEIID30181 HEADER entry missing for column name id in Unknown
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2216?page=com.atlassian.jira.plu... ]
Steven Hawkins moved TEIID-3002 to TEIIDDES-2216:
-------------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-2216 (was: TEIID-3002)
> TEIID30181 HEADER entry missing for column name id in Unknown
> -------------------------------------------------------------
>
> Key: TEIIDDES-2216
> URL: https://issues.jboss.org/browse/TEIIDDES-2216
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Environment: TEIID 8.8, JBoss EAP 6.1alpha
> Reporter: luca gioppo
> Assignee: Steven Hawkins
>
> I'm accessing a CSV file through the web service connector (follows the resource-adapter):
> <resource-adapter id="webservice">
> <module slot="main" id="org.jboss.teiid.resource-adapter.webservice"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.ws.WSManagedConnectionFactory" jndi-name="java:/amm" enabled="true" use-java-context="true" pool-name="amm">
> <config-property name="EndPoint">http://spcdata.digitpa.gov.it/data/amm.csv</config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> I create a table from, this CSV but not have the first row as header column name, so I gave names to the table and have this transformation:
> SELECT
> A.id, A.denominazione, A.sede_legale, A.nome_resp, A.cognome_resp, A.cap, A.provincia, A.regione, A.sito_istituzionale, A.indirizzo, A.titolo_resp, A.tipo_istat, A.acronimo, A.cf_validato, A.cf, A.mail, A.tipo_mail, A.mail2, A.tipo_mail2, A.mail3, A.tipo_mail3, A.facebook, A.twitter, A.googleplus, A.youtube, A.liv_access
> FROM
> (EXEC amm.invokeHttp('GET', null, 'http://spcdata.digitpa.gov.it/data/amm.csv', 'TRUE')) AS f, TEXTTABLE(TO_CHARS(f.result, 'UTF-8') COLUMNS id string, denominazione string, sede_legale string, nome_resp string, cognome_resp string, cap string, provincia string, regione string, sito_istituzionale string, indirizzo string, titolo_resp string, tipo_istat string, acronimo string, cf_validato string, cf string, mail string, tipo_mail string, mail2 string, tipo_mail2 string, mail3 string, tipo_mail3 string, facebook string, twitter string, googleplus string, youtube string, liv_access string DELIMITER ' ' HEADER) AS A
> When I try to access the VDB I get this error:
> 14:52:42,410 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker2_QueryProcessorQueue56) Ho/sIQ8ukETA TEIID30015 Failed to load materialized view table #MAT_AMMV.AMMINISTRAZIONI.: org.teiid.core.TeiidProcessingException: TEIID30181 HEADER entry missing for column name id in Unknown.
> at org.teiid.query.processor.relational.TextTableNode.processHeader(TextTableNode.java:477) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.TextTableNode.initReader(TextTableNode.java:453) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.TextTableNode.nextBatchDirect(TextTableNode.java:198) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:255) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTable.insert(TempTable.java:682) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:659) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:558) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:487) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:108) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.8.0.Alpha1.jar:8.8.0.Alpha1]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_25]
> at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_25]
> 14:52:42,413 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue56) Ho/sIQ8ukETA TEIID30020 Processing exception for request Ho/sIQ8ukETA.5 'TEIID30181 HEADER entry missing for column name id in Unknown.'. Originally TeiidProcessingException TextTableNode.java:477. Enable more detailed logging to see the entire stacktrace.
> Where I do something wrong?
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 10 months