[JBoss JIRA] (TEIIDDES-2217) 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 Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2217?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2217:
-----------------------------------
Fix Version/s: 9.2
9.0.3
> 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: TEIIDDES-2217
> URL: https://issues.jboss.org/browse/TEIIDDES-2217
> Project: Teiid Designer
> Issue Type: Quality Risk
> Reporter: luca gioppo
> Priority: Minor
> Fix For: 9.2, 9.0.3
>
>
> 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.3.15#6346)
9 years
[JBoss JIRA] (TEIIDDES-2550) parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2550:
-----------------------------------
Fix Version/s: 9.2
9.0.3
> parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
> ---------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2550
> URL: https://issues.jboss.org/browse/TEIIDDES-2550
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling, Transformations
> Affects Versions: 9.1
> Environment: Teiid 8.7.1.redhat-8 and Teiid Designer 9.1.0.Beta1
> Reporter: Daan Creemers
> Fix For: 9.2, 9.0.3
>
>
> When using the parseTimestamp function in the transformation editor while creating a relational view model, a StringIndexOutOfBoundsException is thrown. The query SELECT parseTimestamp('18:10:20', 'HH:mm:ss') is used in the transformation editor which gives 'String index out of range: 1'. I want to use the function with a column of my table but produces the same error.
> When deploying a virtual database and executing exactly the same query on the database, the query finishes successfully and gives the result.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years
[JBoss JIRA] (TEIIDDES-2550) parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2550:
--------------------------------------
Assignee: Paul Richardson
> parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
> ---------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2550
> URL: https://issues.jboss.org/browse/TEIIDDES-2550
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling, Transformations
> Affects Versions: 9.1
> Environment: Teiid 8.7.1.redhat-8 and Teiid Designer 9.1.0.Beta1
> Reporter: Daan Creemers
> Assignee: Paul Richardson
> Fix For: 9.2, 9.0.3
>
>
> When using the parseTimestamp function in the transformation editor while creating a relational view model, a StringIndexOutOfBoundsException is thrown. The query SELECT parseTimestamp('18:10:20', 'HH:mm:ss') is used in the transformation editor which gives 'String index out of range: 1'. I want to use the function with a column of my table but produces the same error.
> When deploying a virtual database and executing exactly the same query on the database, the query finishes successfully and gives the result.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years
[JBoss JIRA] (TEIIDDES-2550) parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
by Daan Creemers (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu... ]
Daan Creemers updated TEIIDDES-2550:
------------------------------------
Component/s: Modeling
> parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
> ---------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2550
> URL: https://issues.jboss.org/browse/TEIIDDES-2550
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling, Transformations
> Affects Versions: 9.1
> Environment: Teiid 8.7.1.redhat-8 and Teiid Designer 9.1.0.Beta1
> Reporter: Daan Creemers
>
> When using the parseTimestamp function in the transformation editor while creating a relational view model, a StringIndexOutOfBoundsException is thrown. The query SELECT parseTimestamp('18:10:20', 'HH:mm:ss') is used in the transformation editor which gives 'String index out of range: 1'. I want to use the function with a column of my table but produces the same error.
> When deploying a virtual database and executing exactly the same query on the database, the query finishes successfully and gives the result.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years
[JBoss JIRA] (TEIIDDES-2550) parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
by Daan Creemers (JIRA)
Daan Creemers created TEIIDDES-2550:
---------------------------------------
Summary: parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception
Key: TEIIDDES-2550
URL: https://issues.jboss.org/browse/TEIIDDES-2550
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 9.1
Environment: Teiid 8.7.1.redhat-8 and Teiid Designer 9.1.0.Beta1
Reporter: Daan Creemers
When using the parseTimestamp function in the transformation editor while creating a relational view model, a StringIndexOutOfBoundsException is thrown. The query SELECT parseTimestamp('18:10:20', 'HH:mm:ss') is used in the transformation editor which gives 'String index out of range: 1'. I want to use the function with a column of my table but produces the same error.
When deploying a virtual database and executing exactly the same query on the database, the query finishes successfully and gives the result.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years