[JBoss JIRA] (TEIID-3089) TEIID10078 Invalid double format in String: Age
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3089?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3089:
------------------------------------
This using the following dynamic VDB definition for this excel:
<model name="OtherHoldings">
<property name="importer.headerRowNumber" value="1"/>
<property name="importer.ExcelFileName" value="otherholdings.xls"/>
<source name="excelconnector" translator-name="excel" connection-jndi-name="java:/excel-file"/>
</model>
> TEIID10078 Invalid double format in String: Age
> -----------------------------------------------
>
> Key: TEIID-3089
> URL: https://issues.jboss.org/browse/TEIID-3089
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Attachments: otherholdings.xls
>
>
> Seeing the following error when querying attached excel file:
> TEIID10078 Invalid double format in String: Age
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3090) Unexpected exception for correct SQL query
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-3090:
-----------------------------------
Summary: Unexpected exception for correct SQL query
Key: TEIID-3090
URL: https://issues.jboss.org/browse/TEIID-3090
Project: Teiid
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Misc. Connectors
Affects Versions: 8.7
Environment: OS: Fedora 20
hardware: x86_64
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Attachments: exception-stack-trace, full-server.log, server.log
Description of problem:
Query ends with exception. Same query for MariaDB database returns correct result but Teiid throws an exception.
Actual results:
Query ends with exception - TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: Unexpected exception while translating results: Error
Expected results:
No exception
Additional info:
excption stack trace and server log in attachment
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3085) Exception with unclear message
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3085?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3085:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1130985|https://bugzilla.redhat.com/show_bug.cgi?id=1130985] from NEW to CLOSED
> Exception with unclear message
> ------------------------------
>
> Key: TEIID-3085
> URL: https://issues.jboss.org/browse/TEIID-3085
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: exception-stack-trace, full-server.log, server.log
>
>
> Description of problem:
> Unexpected exception. Returned exception indicates that query failed but there is no reason in message.
> Actual results:
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."timevalue", cast(g_0."bytenum" AS smallint), (SELECT g_1."floatnum" FROM "smalla" AS g_1 WHERE g_1."intkey" = g_0."intkey" AND g_1."intkey" = (SELECT g_2."intkey" FROM "smalla" AS g_2 WHERE g_2."stringnum" > '10' AND g_2."intkey" = g_1."intkey")) FROM "smalla" AS g_0]
> Expected results:
> Remote org.postgresql.util.PSQLException: ERROR: Interconnect Error: Unexpected Motion Node Id: 2. This means a motion node that wasn't setup is requesting interconnect resources.
> Additional info:
> Log and exception stack trace in attachment.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3086) Exception with unclear message
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3086?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3086:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1131007|https://bugzilla.redhat.com/show_bug.cgi?id=1131007] from NEW to CLOSED
> Exception with unclear message
> ------------------------------
>
> Key: TEIID-3086
> URL: https://issues.jboss.org/browse/TEIID-3086
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: OS: Fedora 20
> architecture: x86_64
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: exception-stack-trace, full-server.log, server.log
>
>
> Description of problem:
> Unexpected exception. Returned exception indicates that query failed but there is no reason in message.
> Actual results:
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 4200 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(g_0.bytenum AS tinyint) AS c_0, abs(cast(g_0.bytenum AS tinyint)) AS c_1 FROM smallb AS g_0 ORDER BY c_0]
> Expected results:
> Remote java.sql.SQLException: Specified cursor is not known to the server.
> Additional info:
> server log and exception stack trace in attachment
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3087) Exception with unclear message
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3087?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3087:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1131012|https://bugzilla.redhat.com/show_bug.cgi?id=1131012] from NEW to CLOSED
> Exception with unclear message
> ------------------------------
>
> Key: TEIID-3087
> URL: https://issues.jboss.org/browse/TEIID-3087
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: OS: Fedora 20
> architecture: x86_64
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: exception-stack-trace, full-server.log, server.log
>
>
> Description of problem:
> Unexpected exception. Returned exception indicates that query failed but there is no reason in message.
> Actual results:
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 4200 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(g_0.shortvalue AS smallint) AS c_0, abs(cast(g_0.shortvalue AS smallint)) AS c_1 FROM smallb AS g_0 ORDER BY c_0]
> Expected results:
> Remote java.sql.SQLException: Specified cursor is not known to the server.
> Additional info:
> server log and exception stack trace in attachment
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3088) Exception with unclear message
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3088?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3088:
---------------------------------------
Since the exception chain is clear, this is our expected behavior. Attempting to re-report the lower exception message can lead to a lot of bloat in the message which may not be helpful either in a lot of circumstances - and is not always clear unless the scenario is a simple full pushdown.
> Exception with unclear message
> ------------------------------
>
> Key: TEIID-3088
> URL: https://issues.jboss.org/browse/TEIID-3088
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: OS: Fedora 20
> hardware: x86_64
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: exception-stack-trace, full-server.log, server.log
>
>
> Description of problem:
> Unexpected exception. Returned exception indicates that query failed but there is no reason in message.
> Actual results:
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 4502 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.stringkey = (SELECT g_1.stringkey FROM smalla AS g_1 WHERE g_1.intnum = g_0.intnum) ORDER BY c_0]
> Additional info:
> server log and exception stack trace in attachment
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3088) Exception with unclear message
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-3088?page=com.atlassian.jira.plugin... ]
Juraj Duráni commented on TEIID-3088:
-------------------------------------
Yes, root exception has good message. But exception returned by teiid has unclear message. If you think it is not a bug then ignore it.
I ran testing SQL queries and expected exception and returned exception was different. I showed it to my team leader and he said that I should report it.
> Exception with unclear message
> ------------------------------
>
> Key: TEIID-3088
> URL: https://issues.jboss.org/browse/TEIID-3088
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: OS: Fedora 20
> hardware: x86_64
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: exception-stack-trace, full-server.log, server.log
>
>
> Description of problem:
> Unexpected exception. Returned exception indicates that query failed but there is no reason in message.
> Actual results:
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 4502 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.stringkey = (SELECT g_1.stringkey FROM smalla AS g_1 WHERE g_1.intnum = g_0.intnum) ORDER BY c_0]
> Additional info:
> server log and exception stack trace in attachment
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3089) TEIID10078 Invalid double format in String: Age
by Van Halbert (JIRA)
Van Halbert created TEIID-3089:
----------------------------------
Summary: TEIID10078 Invalid double format in String: Age
Key: TEIID-3089
URL: https://issues.jboss.org/browse/TEIID-3089
Project: Teiid
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Misc. Connectors
Affects Versions: 8.7.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Seeing the following error when querying attached excel file:
TEIID10078 Invalid double format in String: Age
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months