Error in query parsing using Teiid Translator in a EDS VDB

Solution Verified - Updated -

Issue

  • I tried using Teiid Translator to fetch data from another VDB inside my VDB and am getting a parsing error when I query it.
2014-09-04 09:27:21,669 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Processing exception 'Error Code:0 Message:FOUNDRY_API_Source: Error Code:0 Message:'Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "SELECT g_0.Result Namespace [*]AS[*] c_0," at line 1, column 90.
Was expecting: <EOF> | "except" | "fetch" | "from" | "intersect" | "into" | "limit" | "offset" | "option" | "order" ...' error executing statement(s): [Prepared Values: [] SQL: SELECT /*teiid sessionid:YxqnQWg9DKSB, requestid:YxqnQWg9DKSB.0.1*/ g_0.Result Namespace AS c_0, g_0.Date AS c_1, g_0.Currency AS c_2, g_0.Ledger-Book#Key AS c_3, g_0.Source System AS c_4, g_0.Source Book#Book Id AS c_5, g_0.Measure#Calculation Method AS c_6, g_0.PnL Type Id AS c_7, g_0.Category AS c_8, g_0.Top Level Explain AS c_9, g_0.Second Level Explain AS c_10, SUM(g_0.Value) AS c_11 FROM risk AS g_0 WHERE g_0.Result Namespace = 'EOD_PNL_ADJ' AND g_0.Date = '2014-05-30' AND g_0.Measure = 'ADJUSTMENT PNL' AND g_0.Organisational Unit = 'Other' AND g_0.Ledger-Book#Key IN ('SDM:GDSL1001', 'SDM:CALLAB-CASH') AND g_0.Measure#Kind = 'PNL' AND g_0.Category <> 'Supplemental' AND g_0.Is Error = 'false' GROUP BY g_0.Result Namespace, g_0.Date, g_0.Currency, g_0.Ledger-Book#Key, g_0.Source System, g_0.Source Book#Book Id, g_0.Measure#Calculation Method, g_0.PnL Type Id, g_0.Category, g_0.Top Level Explain, g_0.Second Level Explain LIMIT 100]' for request YxqnQWg9DKSB.0.  Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214). Enable more detailed logging to see the entire stacktrace.

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In