bad_operand error logged when NOTLIKE operator used in TIBCO Active Spaces (AS) Channel's filter field.

bad_operand error logged when NOTLIKE operator used in TIBCO Active Spaces (AS) Channel's filter field.

book

Article ID: KB0091563

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
=========
Following bad_operand error logged when NOTLIKE operator used in AS Channel's filter field.
+++++++++++++++++
Error occurred while activating agent [process:1]
com.tibco.as.space.ASException: SYS_ERROR (bad_operand - name NOTLIKE "updated")
    at Native.QueryParser::parse(QueryParser.cpp:194)
    at Native.SpaceFilter::initialize(SpaceFilter.cpp:23)
    at Native.SpaceBrowser::initialize(SpaceBrowser.cpp:50)
    at Native.SpaceEventBrowser::initialize(SpaceEventBrowser.cpp:29)
    at Native.SpaceListener::initialize(SpaceListener.cpp:23)
    at Native.Api_Listener_Initialize(ApiListener.cpp:44)
    at Native.Api_Listener_Initialize(ApiListener.cpp:17)
    at Native.Java_com_tibco_as_space_impl_NativeImpl_spaceListen(JListener.cpp:20)
    at com.tibco.as.space.impl.NativeImpl.spaceListen(Native Method)
    at com.tibco.as.space.impl.ASSpace.listen(ASSpace.java:519)
    at com.tibco.cep.driver.as.internal.consumptionmodes.ASConsumptionModeEventListener.postStart(ASConsumptionModeEventListener.java:42)
    at com.tibco.cep.driver.as.internal.consumptionmodes.AASConsumptionMode.start(AASConsumptionMode.java:36)
    at com.tibco.cep.driver.as.internal.ASDestination.bind(ASDestination.java:71)
    at com.tibco.cep.runtime.session.impl.RuleServiceProviderImpl.bind(RuleServiceProviderImpl.java:1025)
    at com.tibco.cep.runtime.service.cluster.agent.InferenceAgent.onActivate(InferenceAgent.java:986)
    at com.tibco.cep.bpmn.runtime.agent.ProcessAgentImpl.onActivate(ProcessAgentImpl.java:102)
    at com.tibco.cep.runtime.service.cluster.agent.AbstractCacheAgent.activate(AbstractCacheAgent.java:152)
    at com.tibco.cep.runtime.service.cluster.agent.AbstractCacheAgent.start(AbstractCacheAgent.java:165)
    at com.tibco.cep.runtime.service.cluster.agent.AgentRuntimePolicyManager.tryActivateAgent(AgentRuntimePolicyManager.java:173)
    at com.tibco.cep.runtime.service.cluster.agent.AgentRuntimePolicyManager.stabilizeCluster(AgentRuntimePolicyManager.java:249)
    at com.tibco.cep.runtime.service.cluster.agent.AgentRuntimePolicyManager.tryActivateLocalAgents(AgentRuntimePolicyManager.java:297)
    at com.tibco.cep.runtime.service.cluster.agent.DefaultAgentManager.start(DefaultAgentManager.java:99)
    at com.tibco.cep.runtime.service.cluster.MultiAgentCluster.start(MultiAgentCluster.java:253)
    at com.tibco.cep.runtime.session.impl.RuleServiceProviderImpl.startCluster(RuleServiceProviderImpl.java:746)
    at com.tibco.cep.runtime.session.impl.RuleServiceProviderImpl.configure(RuleServiceProviderImpl.java:253)
    at com.tibco.cep.container.standalone.BEMain.jumpStart(SourceFile:151)
    at com.tibco.cep.container.standalone.BEMain.main(SourceFile:69)
+++++++++++++++++

Environment:
==========
TIBCO Product name and version: TIBCO BusinessEvents (BE) 5.1.0
Operating System(s): All

Symptoms:
========
See above description.

Cause:
=====
Incorrect operator used.

Resolution:
========
Operator should be used as NOT LIKE instead of NOTLIKE. Note: There is a space between NOT and LIKE.

References:
=========
None

Issue/Introduction

bad_operand error logged when NOTLIKE operator used in TIBCO Active Spaces (AS) Channel's filter field.