[JBoss JIRA] (TEIIDDES-2206) Oracle DDL Importer should handle comment statements
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2206?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2206:
----------------------------------------
Oracle DDL Parsing is covered by Modeshape's DDL Parsing/Sequencing framework.
Considering we're moving more and more toward importing *jdbc* sources through Teiid's connection, we won't have a direct need to handle comments since ALL DDL will be of type Teiid dialect.
Which brings up a good point... that in the past there were customers that embraced/utilized the source metadata for more than just accessing data. The Metadata (including comments) were used for other purposes. Not sure that Teiid is set-up for, nor envisions processing this additional metadata that isn't critical to actual data access/manipulation. (~shawkins ~rareddy)
> Oracle DDL Importer should handle comment statements
> ----------------------------------------------------
>
> Key: TEIIDDES-2206
> URL: https://issues.jboss.org/browse/TEIIDDES-2206
> Project: Teiid Designer
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Import/Export
> Affects Versions: 8.5
> Reporter: Mark Drilling
> Fix For: 8.6
>
> Attachments: order_test_ddl.txt
>
>
> Request that Oracle DDL comment statements be processed. Use the comment for the object description. Currently the DDL parser does not handle this statement type.
> See attached DDL for an example.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 10 months
[JBoss JIRA] (TEIIDDES-2216) TEIID30181 HEADER entry missing for column name id in Unknown
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2216?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2216:
-----------------------------------
Fix Version/s: (was: 8.3.4)
> 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: Barry LaFond
> Fix For: 8.6, 8.5.1
>
>
> 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)
9 years, 10 months
[JBoss JIRA] (TEIIDDES-2216) TEIID30181 HEADER entry missing for column name id in Unknown
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2216?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2216:
--------------------------------------
Assignee: Barry LaFond
> 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: Barry LaFond
> Fix For: 8.3.4, 8.6, 8.5.1
>
>
> 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)
9 years, 10 months
[JBoss JIRA] (TEIIDDES-2216) TEIID30181 HEADER entry missing for column name id in Unknown
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2216?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2216:
-----------------------------------
Fix Version/s: 8.3.4
8.6
8.5.1
> 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: Barry LaFond
> Fix For: 8.3.4, 8.6, 8.5.1
>
>
> 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)
9 years, 10 months
[JBoss JIRA] (TEIIDDES-2227) After deleting connection profile, action Guides -> Generate relational models from WSDL throws an exception
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2227?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2227.
------------------------------------
Resolution: Done
added null check for connection profile. Fixed in master (8.6) and 8.5.x
> After deleting connection profile, action Guides -> Generate relational models from WSDL throws an exception
> ------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2227
> URL: https://issues.jboss.org/browse/TEIIDDES-2227
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.3.3
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 8.6
>
> Attachments: log.log, screen1.png, screen2.png
>
>
> How to reproduce:
> 1. Create connection profile to SOAP Web Service
> 2. Open Guides -> Generate relational models from WSDL
> 3. Close it without changes (click Cancel)
> 4. Delete created connection profile in Database development perspective
> 5. Open Guides -> Generate relational models from WSDL
> Exception is thrown (see screenshots)
> Connection profile needs to be recreated to make it work without throwing exception.
> I actually came accros this bug when I had 2 SOAP connections and deleted the one that has been created last. I figured out that it is easier to reproduce this bug using 1 connection profile.
> Method: File -> Import -> WSDL File or URL >> Source and View Model (SOAP); works.
> JBDS 7.1.1. GA + Teiid Designer 8.3.3.Final-v20140613-1202-B88
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 10 months
[JBoss JIRA] (TEIIDDES-2227) After deleting connection profile, action Guides -> Generate relational models from WSDL throws an exception
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2227?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2227:
-----------------------------------
Fix Version/s: 8.5.1
> After deleting connection profile, action Guides -> Generate relational models from WSDL throws an exception
> ------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2227
> URL: https://issues.jboss.org/browse/TEIIDDES-2227
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.3.3
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 8.6, 8.5.1
>
> Attachments: log.log, screen1.png, screen2.png
>
>
> How to reproduce:
> 1. Create connection profile to SOAP Web Service
> 2. Open Guides -> Generate relational models from WSDL
> 3. Close it without changes (click Cancel)
> 4. Delete created connection profile in Database development perspective
> 5. Open Guides -> Generate relational models from WSDL
> Exception is thrown (see screenshots)
> Connection profile needs to be recreated to make it work without throwing exception.
> I actually came accros this bug when I had 2 SOAP connections and deleted the one that has been created last. I figured out that it is easier to reproduce this bug using 1 connection profile.
> Method: File -> Import -> WSDL File or URL >> Source and View Model (SOAP); works.
> JBDS 7.1.1. GA + Teiid Designer 8.3.3.Final-v20140613-1202-B88
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 10 months
[JBoss JIRA] (TEIIDDES-2227) After deleting connection profile, action Guides -> Generate relational models from WSDL throws an exception
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2227?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2227:
--------------------------------------
Assignee: Barry LaFond
> After deleting connection profile, action Guides -> Generate relational models from WSDL throws an exception
> ------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2227
> URL: https://issues.jboss.org/browse/TEIIDDES-2227
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.3.3
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 8.6
>
> Attachments: log.log, screen1.png, screen2.png
>
>
> How to reproduce:
> 1. Create connection profile to SOAP Web Service
> 2. Open Guides -> Generate relational models from WSDL
> 3. Close it without changes (click Cancel)
> 4. Delete created connection profile in Database development perspective
> 5. Open Guides -> Generate relational models from WSDL
> Exception is thrown (see screenshots)
> Connection profile needs to be recreated to make it work without throwing exception.
> I actually came accros this bug when I had 2 SOAP connections and deleted the one that has been created last. I figured out that it is easier to reproduce this bug using 1 connection profile.
> Method: File -> Import -> WSDL File or URL >> Source and View Model (SOAP); works.
> JBDS 7.1.1. GA + Teiid Designer 8.3.3.Final-v20140613-1202-B88
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 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 MODIFIED to ON_QA
> 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)
9 years, 10 months