Products | Versions |
---|---|
TIBCO BusinessEvents Enterprise Edition | - |
Not Applicable | - |
Resolution:
Description:
===========
BusinessEvents Views - Datasource with the "where" clause does not work.
ex.:
SELECT * FROM /Dashboards/MT_testTiming WHERE TMS >= $tInput ORDER BY TMS;
Environment:
===========
o BusinessEvents 5.0
o All Operating Systems
Symptoms:
=========
Error in log:
Error [Thread-70] [subscriber] NoViableAltException(79@[364:15: (lc= TOK_IN (u= unaryExpr -> ^( TOK_OR $inExpr $u) | TOK_LPAREN field ( TOK_COMMA field )* TOK_RPAREN -> ^( TOK_OR ( ^( TOK_EQ $e field ) )+ ) ) | TOK_NOT lc= TOK_IN (u= unaryExpr -> ^( TOK_NOR $inExpr $u) | TOK_LPAREN field ( TOK_COMMA field )* TOK_RPAREN -> ^( TOK_NOR ( ^( TOK_EQ $e field ) )+ ) ) )?])
Cause:
======
required to use Keyword "where" in lower case
CR BE-12676 exist (should be fixed in BusinessEvents Version 5.1)
Resolution:
========
Keyword "where" is case sensitive in BE 5.0 (lower case required)
i.e.:
SELECT * FROM /Dashboards/MT_testTiming where TMS >= $tInput ORDER BY TMS;