Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2216

TEIID30181 HEADER entry missing for column name id in Unknown

    Details

      Description

      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?

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                gioppoluca luca gioppo
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: