Error "DeleteMultiple has not yet been implemented"

[Feb00]

Only for some tenants, delete queries fail, example:

Version 9.0.1
Am I doing something wrong?

[MarkMpn]

What sort of entity is it that you’re using, eg regular, virtual, elastic?

[Feb00]

Regular entity

[MarkMpn]

This message should only be used on elastic tables, but it sounds like it has been added somehow in the affected tenants for this entity. You can check this by running:

SELECT *
FROM   sdkmessagefilter
       INNER JOIN
       sdkmessage
       ON sdkmessagefilter.sdkmessageid = sdkmessage.sdkmessageid
WHERE  sdkmessagefilter.primaryobjecttypecode = 'xxx_jobqueue'
       AND sdkmessage.name = 'DeleteMultiple';

You should receive 0 records, but in the affected environments I think you will receive 1 result. I'd be interested to understand why this message exists for this entity, but I can work around this in a future update. For now you should be able to avoid the problem by changing the batch size setting to 1, either globally in the SQL 4 CDS settings or by adding the OPTION(USE HINT('BATCH_SIZE_1')) hint for this individual query.

[Feb00]

I confirm that I get 1 line by running the query in the environments where the problem is present.
Setting the batch sizes to 1 the problem does not occur, thank you.