[JBoss JIRA] (TEIID-3004) TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16, 161 in Unknown. SQLState: TEIID30183
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3004?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3004:
---------------------------------------
This should probably have been a forum topic first. More than likely you have an issue with your data file. The line that you give above is not problematic.
> TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown. SQLState: TEIID30183
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3004
> URL: https://issues.jboss.org/browse/TEIID-3004
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Reporter: luca gioppo
> Assignee: Steven Hawkins
> Priority: Minor
>
> On the same use case of TEIID30181 I now got the error in object:
> TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown.
> SQLState: TEIID30183
> the row should be:
> istsc_pgee021002 Direzione Didattica Statale "Franco Rasetti" Castiglione del Lago ANTONIETTA MANNUCCI 06061 PG Umbria www.dirclago.it Via Carducci, 25 Dirigente Scolastico Istituti di Istruzione Statale di Ogni Ordine e Grado Pubbliche Amministrazioni S 80005650546 pgee021002(a)pec.istruzione.it pec pgee021002(a)istruzione.it altro null null null null null null 0
> the only difference I find between the previous rows that passed without problems is that a field has double quote in its content.
> The delimiter is tabulation so there should not be any problem.
> Could it be this the problem and how to solve it?
> Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-3004) TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16, 161 in Unknown. SQLState: TEIID30183
by luca gioppo (JIRA)
[ https://issues.jboss.org/browse/TEIID-3004?page=com.atlassian.jira.plugin... ]
luca gioppo commented on TEIID-3004:
------------------------------------
Sorry wrong referencd to issue:
https://issues.jboss.org/browse/TEIIDDES-2216
> TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown. SQLState: TEIID30183
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3004
> URL: https://issues.jboss.org/browse/TEIID-3004
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.8
> Reporter: luca gioppo
> Assignee: Steven Hawkins
> Priority: Minor
>
> On the same use case of TEIID30181 I now got the error in object:
> TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown.
> SQLState: TEIID30183
> the row should be:
> istsc_pgee021002 Direzione Didattica Statale "Franco Rasetti" Castiglione del Lago ANTONIETTA MANNUCCI 06061 PG Umbria www.dirclago.it Via Carducci, 25 Dirigente Scolastico Istituti di Istruzione Statale di Ogni Ordine e Grado Pubbliche Amministrazioni S 80005650546 pgee021002(a)pec.istruzione.it pec pgee021002(a)istruzione.it altro null null null null null null 0
> the only difference I find between the previous rows that passed without problems is that a field has double quote in its content.
> The delimiter is tabulation so there should not be any problem.
> Could it be this the problem and how to solve it?
> Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-3004) TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16, 161 in Unknown. SQLState: TEIID30183
by luca gioppo (JIRA)
luca gioppo created TEIID-3004:
----------------------------------
Summary: TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown. SQLState: TEIID30183
Key: TEIID-3004
URL: https://issues.jboss.org/browse/TEIID-3004
Project: Teiid
Issue Type: Bug
Security Level: Public (Everyone can see)
Affects Versions: 8.8
Reporter: luca gioppo
Assignee: Steven Hawkins
Priority: Minor
On the same use case of TEIID30181 I now got the error in object:
TEIID30183 Message:TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line 16,161 in Unknown.
SQLState: TEIID30183
the row should be:
istsc_pgee021002 Direzione Didattica Statale "Franco Rasetti" Castiglione del Lago ANTONIETTA MANNUCCI 06061 PG Umbria www.dirclago.it Via Carducci, 25 Dirigente Scolastico Istituti di Istruzione Statale di Ogni Ordine e Grado Pubbliche Amministrazioni S 80005650546 pgee021002(a)pec.istruzione.it pec pgee021002(a)istruzione.it altro null null null null null null 0
the only difference I find between the previous rows that passed without problems is that a field has double quote in its content.
The delimiter is tabulation so there should not be any problem.
Could it be this the problem and how to solve it?
Thanks
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2998?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2998:
---------------------------------------
> Its odd that what they return seems to flip back and forth. Sometimes is does use the column label. Whenever it is returned as concat data values, there is a corresponding NAMEINSOURCE option that has the correct column label.
To clarify there are two names we are dealing with. A column label and a column id. The column ids are always A, B ... While the labels are inferred by google docs (I haven't tested, but they also may be used for a named range containing the column). If the metadata provides us with a label we use that as the column name and set the name in source to the id. Otherwise we just use the id as the column name - we could also set the name in source here, but we know that the column ids are simple identifiers so there is no special handling involved.
> Is there any way to detect that and force it to use the column label?
No, I'm saying that you may want an option to not use the column label and instead just go with the id (A, B, ...)
> problems with DDL returned for dynamic vdb with google spreadsheet source
> -------------------------------------------------------------------------
>
> Key: TEIID-2998
> URL: https://issues.jboss.org/browse/TEIID-2998
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: AdminApi
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Attachments: ChromeSheet.png, FirefoxSheet.png, GoogleSpreadsheetJIRA.txt
>
>
> I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters)
> See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet.
> Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-3002) TEIID30181 HEADER entry missing for column name id in Unknown
by luca gioppo (JIRA)
[ https://issues.jboss.org/browse/TEIID-3002?page=com.atlassian.jira.plugin... ]
luca gioppo reopened TEIID-3002:
--------------------------------
There should be a problem in the Designer for the code has been generated by it and the selection was not to use headers
> TEIID30181 HEADER entry missing for column name id in Unknown
> -------------------------------------------------------------
>
> Key: TEIID-3002
> URL: https://issues.jboss.org/browse/TEIID-3002
> Project: Teiid
> 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)
10 years, 7 months
[JBoss JIRA] (TEIID-3002) TEIID30181 HEADER entry missing for column name id in Unknown
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3002?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3002:
---------------------------------------
If you did not check using a header, it should not be assumed.
> TEIID30181 HEADER entry missing for column name id in Unknown
> -------------------------------------------------------------
>
> Key: TEIID-3002
> URL: https://issues.jboss.org/browse/TEIID-3002
> Project: Teiid
> 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)
10 years, 7 months
[JBoss JIRA] (TEIID-3002) TEIID30181 HEADER entry missing for column name id in Unknown
by luca gioppo (JIRA)
[ https://issues.jboss.org/browse/TEIID-3002?page=com.atlassian.jira.plugin... ]
luca gioppo commented on TEIID-3002:
------------------------------------
So it is a bug on the designer since the stuff has been created by the designer and I checked not to use header.
> TEIID30181 HEADER entry missing for column name id in Unknown
> -------------------------------------------------------------
>
> Key: TEIID-3002
> URL: https://issues.jboss.org/browse/TEIID-3002
> Project: Teiid
> 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)
10 years, 7 months
[JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIID-2998?page=com.atlassian.jira.plugin... ]
Mark Drilling commented on TEIID-2998:
--------------------------------------
Its odd that what they return seems to flip back and forth. Sometimes is does use the column label. Whenever it is returned as concat data values, there is a corresponding NAMEINSOURCE option that has the correct column label. Is there any way to detect that and force it to use the column label?
> problems with DDL returned for dynamic vdb with google spreadsheet source
> -------------------------------------------------------------------------
>
> Key: TEIID-2998
> URL: https://issues.jboss.org/browse/TEIID-2998
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: AdminApi
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Attachments: ChromeSheet.png, FirefoxSheet.png, GoogleSpreadsheetJIRA.txt
>
>
> I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters)
> See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet.
> Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months
[JBoss JIRA] (TEIID-2996) Ability to disable keepAlive
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2996?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2996:
---------------------------------------
Added changes for the above:
1. Added the system property org.teiid.checkPing, which can be set to false to disable the server side ping check - for back porting this is the only change that is needed.
2. Allowed for the disabling of the ping on the client side via the org.teiid.sockets.disablePing property - this will not yet be documented as we may eventually allow the server to dictate this behavior and it is not necessary from the client perspective to disable ping - at best it would just helps prevent some unnecessary traffic.
3. Added the TeiidDataSource property loadBalance, which can be set to false to disable the default load balancing behavior when an XA connection handle is closed.
> Ability to disable keepAlive
> ----------------------------
>
> Key: TEIID-2996
> URL: https://issues.jboss.org/browse/TEIID-2996
> Project: Teiid
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Server
> Affects Versions: 7.7.10
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
>
> offer an option to disable the ping/keep alive as the connections will always be associated with a given socket.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 7 months