[teiid-issues] [JBoss JIRA] Closed: (TEIID-933) AdminShell taking exception to a query that's executing in the Designer

[Steve Hawkins (JIRA)]

     [ https://jira.jboss.org/browse/TEIID-933?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins closed TEIID-933.
-------------------------------



> AdminShell taking exception to a query that's executing in the Designer
> -----------------------------------------------------------------------
>
>                 Key: TEIID-933
>                 URL: https://jira.jboss.org/browse/TEIID-933
>             Project: Teiid
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 7.0
>         Environment: Fedora 12, OpenJDK Server VM (build 14.0-b16, mixed mode), Teiid build 1/19/2010
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>         Attachments: E2eTpcrTextMetadataTestScript.odt, TpcrTest.vdb, TpcrTextMetadataFiles.zip
>
>
> I'm executing the TPCR quesier and #7 is failing in AdminShell. It does successfully execute in SQL Explorer.
> The query being executed is: select * from vTpcr.Q07 ORDER BY supp_nation, cust_nation, l_year
> The transformation behind the query is:
> SELECT 
> 		supp_nation, cust_nation, l_year, SUM(volume) AS revenue 
> FROM 
> 		(SELECT n1.N_NAME AS supp_nation, n2.N_NAME AS cust_nation, YEAR(L_SHIPDATE) AS l_year, (L_EXTENDEDPRICE * (1 - L_DISCOUNT)) AS volume FROM TPCR.SUPPLIER, TPCR.LINEITEM, TPCR.ORDERS, TPCR.CUSTOMER, TPCR.NATION AS n1, TPCR.NATION AS n2 WHERE (S_SUPPKEY = L_SUPPKEY) AND (O_ORDERKEY = L_ORDERKEY) AND (C_CUSTKEY = O_CUSTKEY) AND (S_NATIONKEY = n1.N_NATIONKEY) AND (C_NATIONKEY = n2.N_NATIONKEY) AND (((n1.N_NAME = 'FRANCE') AND (n2.N_NAME = 'GERMANY')) OR ((n1.N_NAME = 'GERMANY') AND (n2.N_NAME = 'FRANCE'))) AND (L_SHIPDATE BETWEEN {ts'1995-01-01 00:00:00.0'} AND {ts'1996-12-31 00:00:00.0'})) AS shipping 
> GROUP BY supp_nation, cust_nation, l_year
> Executing the transformation query in AdminShell also fails.
> AdminShell provides this error information:
> select * from vTpcr.Q07;
> // Error: // Uncaught Exception: TargetError : at Line: 241 : in file: URL: jar:file:/home/pnittel/Teiid0119/teiid-adminshell-7.0.0-SNAPSHOT/lib/teiid-adminshell-7.0.0-SNAPSHOT.jar!/scripts/jdbc.bsh : throw e ; 
> Called from method: execute : at Line: 4 : in file: <unknown file> : execute ( "select * from vTpcr.Q07" ) 
> Target exception: com.metamatrix.jdbc.MMSQLException: com.metamatrix.api.exception.MetaMatrixComponentException
> Many files will be attached.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira