BQL Query (delete from ;url; where true) gives NullPointerException after enabling Shared Nothing Persistence.

BQL Query (delete from ;url; where true) gives NullPointerException after enabling Shared Nothing Persistence.

book

Article ID: KB0089125

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Description:
Query “delete  from <url> where true” failed when persistence (Shared Nothing) is enabled.  It works as expected when Shared Nothing is not enabled.
Symptoms:
Exception thrown on BQL execution:

<timestamp> <agent> Error [$default.be.mt$.Thread.1] - [kernel.core] [inference-class] inference-class got exception [java.lang.RuntimeException: com.tibco.cep.query.api.QueryException: java.lang.NullPointerException] while executing preprocessor [void RuleFunctions.QueryConcept(be.gen.Events.Execute1 execute)] for event [be.gen.Events.Execute1@id=361462@extId=teststartup]
java.lang.RuntimeException: com.tibco.cep.query.api.QueryException: java.lang.NullPointerException
                at com.tibco.cep.query.functions.StatementFunctions.execute(StatementFunctions.java:269)
                at com.tibco.cep.query.functions.SsQueryExecutionHelper.execute(SsQueryExecutionHelper.java:66)
                at com.tibco.cep.query.functions.QueryUtilFunctions.executeInQuerySession(QueryUtilFunctions.java:173)
Cause:
Product issue CR BE-20050  has been raised.

Resolution

As a workaround, query the concepts and delete them using Instance.deleteInstance() in a Rule.

Issue/Introduction

BQL Query (delete from ;url; where true) gives NullPointerException after enabling Shared Nothing Persistence.