Description:
Description:
=========
Deleting entities fails when using a backing store with SQL Server.

Environment:
==========
TIBCO BusinessEvents (BE) 5.1.0.

Symptoms:
========
BE engine throws the following exception.

Delete in batch be.gen.BusinessEvents.Events.AutomationNotificationEvent delete from D_AUTOMATIONNOTIFICATIONEVENT T where T.id$=? 3
2012 Aug 23 13:31:05:367 GMT -7 10.1.1.1.InfoneTest1 Warning [$default.be.mt$.Thread.7] - [jdbcstore] [agent1] SaveTransaction failed. Error=Incorrect syntax near 'T'. code=102
2012 Aug 23 13:31:05:373 GMT -7 10.1.1.1.InfoneTest1 Warning [$default.be.mt$.Thread.7] - [runtime.service] [agent1] Failed writing to DB. Will re-try: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'T'.
2012 Aug 23 13:31:10:379 GMT -7 10.1.1.1.InfoneTest1 Warning [$default.be.mt$.Thread.7] - [runtime.service] [agent1] Attempting to write to DB. Retry Count = 1


Resolution:
==========
This issue will be fixed in upcoming release of TIBCO BusinessEvents. In the meantime you can use the workaround mentioned below.

Workaround
=========
To delete the entities successfully, set the property be.backingstore.deleteInBatch to false at the cluster level, and restart the engines.
Symptoms:

Cause:

Deleting entities fails when using a backing store with SQL Server.