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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content