SAP Knowledge Base Article - Preview

1843924 - Parallel Locking causes NOWAIT or BUSY errors

Symptom

  • Running a process chain containing parallel running of APDs produces locking issues
  • An APD, with a transactional ODS, fails with a short dump in function module CL_RSAN_RT_GENERIC_RUNTIME
  • APD returns with ERROR_DELETING_ODS
  • APD returns with ORA-00054: resource busy and acquire with NOWAIT
  • Parallel Locking causes errors (ERROR_DELETING_ODS or ORA-00054: resource busy and acquire with NOWAIT)


Read more...

Environment

  • SAP BW release 7.x

Keywords

Analysis Process Designer, CL_RSAN_RT_GENERIC_RUNTIME, Overwrite Part of the Datastore Object, Datastore Object, DSO, LOCK TABLE, EXCLUSIVE MODE NOWAIT, EXCLUSIVE NO WAIT, concurrent deletions, CL_RSDRD_SELDEL_PACK, RSDU_DB_COMMIT, RSDRD_SEL_DELETION , KBA , BW-BEX-OT-DBIF , Interface to Database , BW-EI-APD , Analysis Process Designer , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.