[
https://issues.jboss.org/browse/TEIID-3004?page=com.atlassian.jira.plugin...
]
luca gioppo commented on TEIID-3004:
------------------------------------
Sorry Steve how can I inspect the content read from the webservice translator before that
is parsed? To know if it got truncated.
The content are rows whose fields are delimited by TAB and not quote, but the row 16161 is
the only one that has double quote as content (I believe that even if I declared the TAB
as delimiter TEIID find the double quote and complain).
If you want to inspect the data it is an open data set of info published at this address.
http://spcdata.digitpa.gov.it/data/amm.csv
you can see that there is only the 16161 row with some double quote in the field, but is
not a delimiter (not understand what you mean by qualifier)
Luca
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)