We're updating the issue view to help you get more done. 

PubSubPersistenceManager.purgeItems incompatibility with Oracle DB

Description

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.

Environment

None

Acceptance Test - Entry

None

Activity

Show:
Greg Thomas
March 27, 2019, 10:19 AM

Note: PR as submitted only support Oracle, closing this ticket, will create another for DB2 

Assignee

Greg Thomas

Reporter

Greg Thomas

Labels

None

Expected Effort

None

Components

Fix versions

Affects versions

Priority

Major
Configure