Resolution:
Abstract
===========
DELETE Query not supported against cache in TIBCO BusinessEvents 5.1.1 version with Shared Nothing persistence.

Description:
===========
Following exception is thrown when DELETE queries are run against Business Events cache when Shared Nothing persistence is enabled.

com.tibco.cep.query.api.QueryException: java.lang.NullPointerException
java.lang.RuntimeException: com.tibco.cep.query.api.QueryException: java.lang.NullPointerException
                at com.tibco.cep.query.functions.StatementFunctions.execute(StatementFunctions.java:266)

Environment:
===========
TIBCO Business Events 5.1.x

Symptoms:
=========
DELETE queries fail with NullPointerException

Cause:
=======
Expected behavior as of Business Events 5.1.1 HotFix 2

Resolution:
===========
This Null Pointer exception is normal to be seen in this case, there is no workaround at this point. Also, the behavior of this delete query needs to be tested and documented in the following scenarios.

- Delete from both cache & persistence for Shared-Nothing
- Delete from both cache & persistence with Shared-All with write-behind
- Delete from cache only with Shared-All backing store and cache-aside