[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 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)
10 years
[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:
--------------------------------------
So what can we tell users in terms of 'known issues' when they are trying to use google ss as a source? I'm not sure how to stay on the happy path.
> 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
[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 edited comment on TEIID-2998 at 6/13/14 2:20 PM:
----------------------------------------------------------------
For example the raw json we are getting back from a similar example I have is:
{code}
google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"1124987261","table":{"cols":[{"id":"A","label":"aa aa1 c","type":"string"},{"id":"B","label":"bb bb1 d","type":"string"},{"id":"C","label":"cc cc1 e","type":"string"}],"rows":[]}});
{code}
If I don't use all string data - for example having just the first row as strings, then things seem to work appropriately. So I don't think this is something that we should yet attempt to address on our side.
was (Author: shawkins):
For example the raw json we are getting back from a similar example I have is:
google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"1124987261","table":{"cols":[{"id":"A","label":"aa aa1 c","type":"string"},{"id":"B","label":"bb bb1 d","type":"string"},{"id":"C","label":"cc cc1 e","type":"string"}],"rows":[]}});
If I don't use all string data - for example having just the first row as strings, then things seem to work appropriately. So I don't think this is something that we should yet attempt to address on our side.
> 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
[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:
---------------------------------------
For example the raw json we are getting back from a similar example I have is:
google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"1124987261","table":{"cols":[{"id":"A","label":"aa aa1 c","type":"string"},{"id":"B","label":"bb bb1 d","type":"string"},{"id":"C","label":"cc cc1 e","type":"string"}],"rows":[]}});
If I don't use all string data - for example having just the first row as strings, then things seem to work appropriately. So I don't think this is something that we should yet attempt to address on our side.
> 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
[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:
---------------------------------------
What you are seeing is completely unrelated to the DDL. Since google is inferring the label as being all of the initial column values, the google api more than likely doesn't think there is any row values.
> 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
[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:
---------------------------------------
> Could it be a too long string that got cut from the webservice translator?
We won't proactively truncate content, but that can happen sometimes with proxies or other middle men.
You'll need to see what the raw text that Teiid is seeing looks like on line 16,161 - for example by just selecting and inspecting the clob that you form getting.
The exception occurs when we see something like:
x y"...
Where we encounter the character y in between the delimiter ' ' and the " qualifier.
> 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
[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:
--------------------------------------
Another issue... For the sheet that originally returned the concatenated label, I manually edited the resulting model. Changed the columns to A,B,C and removed the NIS. But when I execute a query against that source, I get no data rows. am i doing something wrong?
> 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
[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 Steven, you are right.
Forum could have been better, but I do not see any reason for being broken.
Could it be a too long string that got cut from the webservice translator?
This could explain why the parser got the error
> 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
[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:
--------------------------------------
Ok understand. We'd definitely just need the to use the column id in that case. So if you can add an import property, that should work for us. Thx
> 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