Configuring the batch processor to avoid errors due to multiple thread processing

When the batch processor is configured to use multiple threads, transactions can potentially fail due to problems with managing more than one thread, such as deadlocks and duplicate keys.

• Configure the batch processor to use a single thread.
  1. Open Batch.properties.
  2. Change the value of the Submitter.number property to 1.

     Submitter.number=1

  3. Save your changes.
• Configure the batch processor to employ deadlock retries so that it will resubmit any transactions that fail at runtime.
  1. Open Batch.properties.
  2. Change the properties related deadlock retries, as follows, to enable deadlock retries.

     deadlockRetryErrorCodeList=
     deadlockRetryErrorStringList=SQLCODE=-911,SQLCODE=-913,ORA-00370,ORA-02049,ORA-00060,CDKCS0001E
     deadlockMaxRetries=1

  3. Save your changes.
  Tip: Alternatively, you can change the deadlock retry settings using one of the configuration override options.