1943660 - AL_CDC_CHECKPOINT deadlocking

• AL_CDC_CHECKPOINT deadlock
• Error similar to:
  (14.1) 10-07-13 18:16:56 (E) (11436:11288) REP-100109: |Data flow
  DF_SOMEDF_CDC Cannot save <CDC Checkpoint Object> into the repository. Additional database information: <SQL submitted to ODBC data source <SOMEDATASOURCE> resulted in
  error <[Microsoft][SQL Server Native Client 10.0][SQL Server]
  Transaction (Process ID 131) was deadlocked  on lock resources with
  another process and has been chosen as the deadlock victim. Rerun the
  transaction.                                           >. The SQL
  submitted is <UPDATE AL_CDC_CHECKPOINT SET LAST_POSITION
  = '20131008T011247.000010000000' WHERE DATASTORE = 'SOMEDATASTORE' AND
  CONFIG_NAME = 'Configuration1' AND OWNER = 'SOMEOWNER:PUBLIC' AND
  CDC_TABLE = 'TEST' AND DI_SUB_NAME = 'TEST'>.>.
  
  

SAP Data Services 4.1

BODS, DS, CDC, Change data capture, framework, continuous, dead-lock, locking, blocking , KBA , EIM-DS-EXE , Job Execution , Problem