[JBoss JIRA] (TEIIDDES-2241) The jndi name used to import is not the one assigned to the model in VDB editor
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2241?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2241.
------------------------------------
Assignee: Barry LaFond
Resolution: Duplicate Issue
Duplicate of TEIIDDES-2235 which is already fixed
> The jndi name used to import is not the one assigned to the model in VDB editor
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-2241
> URL: https://issues.jboss.org/browse/TEIIDDES-2241
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: VDB & Execution
> Affects Versions: 8.6
> Reporter: Van Halbert
> Assignee: Barry LaFond
>
> When importing using Teiid Connection, the JNDI name for the source selected is not the JNDI name assigned to the model in the VDB editor. It seems to be using the "DataSource" name the user gives it in the import wizard.
> Therefore, when trying to deploy the VDB, it thinks the data source doesn't exist.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2241) The jndi name used to import is not the one assigned to the model in VDB editor
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-2241:
-------------------------------------
Summary: The jndi name used to import is not the one assigned to the model in VDB editor
Key: TEIIDDES-2241
URL: https://issues.jboss.org/browse/TEIIDDES-2241
Project: Teiid Designer
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: VDB & Execution
Affects Versions: 8.6
Reporter: Van Halbert
When importing using Teiid Connection, the JNDI name for the source selected is not the JNDI name assigned to the model in the VDB editor. It seems to be using the "DataSource" name the user gives it in the import wizard.
Therefore, when trying to deploy the VDB, it thinks the data source doesn't exist.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-1846) Top Down modeling, when importing to create views, allow for default syntax to applied
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1846?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1846:
-----------------------------------
Fix Version/s: 8.7
(was: 8.6)
> Top Down modeling, when importing to create views, allow for default syntax to applied
> --------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1846
> URL: https://issues.jboss.org/browse/TEIIDDES-1846
> Project: Teiid Designer
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 8.7
>
>
> When a user is starting from a top-down approach (building the views) to design their data layers, and will be performing an import to create the view layer, it would speed up the iterative development of build / deploy / test (not preview) if when the view is built (on import), it can contain valid syntax so that the model will validate. Example of syntax could be, "Select '1'" or "Select 'view not defined'" or throw an exception. This would enable the modeler to implement the views at their pace and have it deployable, rather than having to go thru every view and add syntax before its valid. This is akin to JAVA and NOOP'ing the methods.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 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:
-----------------------------------
Component/s: Import/Export
> 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)
> Components: Import/Export
> Affects Versions: 8.5
> 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)
11 years, 3 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:
-----------------------------------
Affects Version/s: 8.5
> 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)
> Affects Versions: 8.5
> 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)
11 years, 3 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 resolved TEIIDDES-2216.
------------------------------------
Resolution: Done
Fixed header flag issue
> 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)
> Components: Import/Export
> Affects Versions: 8.5
> 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)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2240) Handling of fixed-length datatypes is not handled consistently
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2240?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2240.
------------------------------------
Resolution: Done
Commited to 8.5.x and master. DOne
> Handling of fixed-length datatypes is not handled consistently
> --------------------------------------------------------------
>
> Key: TEIIDDES-2240
> URL: https://issues.jboss.org/browse/TEIIDDES-2240
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Import/Export
> Affects Versions: 8.5, 8.3.3
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.6, 8.5.1
>
>
> Some data sources like Oracle & SQL Server allow *char* datatypes with length > 1.
> JDBC importer (via TEIIDDES-2061) converts d-type to *string* but changes the *char* to a *varchar* native type
> Teiid Connection importer will create a *char(10)* datatype if the column's datatype is *string(10)* and the native type is *char*
> In both instances, the datatype should end up being *string(10)* and the native type == *char*
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2240) Handling of fixed-length datatypes is not handled consistently
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2240?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2240:
-----------------------------------
Description:
Some data sources like Oracle & SQL Server allow *char* datatypes with length > 1.
JDBC importer (via TEIIDDES-2061) converts d-type to *string* but changes the *char* to a *varchar* native type
Teiid Connection importer will create a *char(10)* datatype if the column's datatype is *string(10)* and the native type is *char*
In both instances, the datatype should end up being *string(10)* and the native type == *char*
was:
Some data sources like Oracle & SQL Server allow *char* datatypes with length > 1.
JDBC importer (via TEIIDDES-2061) converts d-type to *string* but changes the *char* to a *varchar* native type
Teiid Connection importer will create a *string(10)* datatype to a *char(10)* if the native type is *char*
In both instances, the datatype should end up being *string(10)* and the native type == *char*
> Handling of fixed-length datatypes is not handled consistently
> --------------------------------------------------------------
>
> Key: TEIIDDES-2240
> URL: https://issues.jboss.org/browse/TEIIDDES-2240
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Import/Export
> Affects Versions: 8.5, 8.3.3
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.6, 8.5.1
>
>
> Some data sources like Oracle & SQL Server allow *char* datatypes with length > 1.
> JDBC importer (via TEIIDDES-2061) converts d-type to *string* but changes the *char* to a *varchar* native type
> Teiid Connection importer will create a *char(10)* datatype if the column's datatype is *string(10)* and the native type is *char*
> In both instances, the datatype should end up being *string(10)* and the native type == *char*
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months
[JBoss JIRA] (TEIIDDES-2240) Handling of fixed-length datatypes is not handled consistently
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2240:
--------------------------------------
Summary: Handling of fixed-length datatypes is not handled consistently
Key: TEIIDDES-2240
URL: https://issues.jboss.org/browse/TEIIDDES-2240
Project: Teiid Designer
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Import/Export
Affects Versions: 8.5, 8.3.3
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 8.6, 8.5.1
Some data sources like Oracle & SQL Server allow *char* datatypes with length > 1.
JDBC importer (via TEIIDDES-2061) converts d-type to *string* but changes the *char* to a *varchar* native type
Teiid Connection importer will create a *string(10)* datatype to a *char(10)* if the native type is *char*
In both instances, the datatype should end up being *string(10)* and the native type == *char*
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 3 months