[teiid-issues] [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

[luca gioppo (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12976184#comment-12976184 ] 

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 at pec.istruzione.it	pec	pgee021002 at 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)