Index failure on Oracle because of default alfresco.transactionDocsBatchSize=2000

Description

The default setting of alfresco.transactionDocsBatchSize=2000 is too high for Oracle databases.

The default settings causes tracking to fail and the following error to be logged once there are a sufficient number of nodes and transactions in the database (55k nodes in the alf_node table and 70k transactions as a customer reported figure)

Reproduction Steps

  1. Setup ACS + SS 2.0 with an Oracle DB

  2. Start typical operations (Ingesting nodes and modifying nodes)

  3. Once there is sufficient data in the repo, tracking fails

Observed Behaviour
Once there is sufficient data in the repository, the query sent to the database will contain too many bind variables. Oracle is capped at 1000 bind variables and hence once we hit this limit the query fails.

Expected Behaviour
The default value of alfresco.transactionDocsBatchSize should work with Oracle OOTB and hence be lower then 1000.

Environment

Oracle DB

Testcase ID

None

Activity

Show:
Sandeep Reehall
3 days ago

The current work around is to lower alfresco.transactionDocsBatchSize < 1000. This will allow tracking to continue.

Assignee

Unassigned

Reporter

Sandeep Reehall

Labels

None

Escalated By

None

Security Issue

None

ACT Numbers

00376763

Premier Customer

None

Code Branch

None

Build Location

None

Regression Since

None

Work Funnel End

None

Patch Attached

None

Dependent Version/s

None

Cloud or Enterprise

None

Prioritization Score

None

Delivery Team

None

Bug Priority

Category 2

Components

Fix versions