From the forums;
This is related to .
It looks like the SQL used in the batch to select from OFPUBSUBITEM has a ‘LIMIT’ which is not supported by both Oracle DB and DB2. This makes the purging of OFPUBSUBITEM constantly fail.
Found in 3.9.3, but as far as I can see, it is present in newer versions as well.
Note; issue with Oracle was fixed in OF-1657, this issue covers off DB2.
I have faced with about the same issue, log is attached below.
Technical details: Windows Server 2008 R2 Standard SP1, Open Fire 4.3.2 x64, DB2 NT64 10.5.5 Express-C
If you're able to provide working SQL for DB2 (it's not something I have ready access to) it may help us get this bug fixed quicker,
For reference, the SQL that is currently failing is:
DB2 doesn't have LIMIT, that's why the SQL is failing.