Index failure on Oracle because of default alfresco.transactionDocsBatchSize=2000
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)
Setup ACS + SS 2.0 with an Oracle DB
Start typical operations (Ingesting nodes and modifying nodes)
Once there is sufficient data in the repo, tracking fails
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.
The default value of alfresco.transactionDocsBatchSize should work with Oracle OOTB and hence be lower then 1000.
The current work around is to lower alfresco.transactionDocsBatchSize < 1000. This will allow tracking to continue.