SAP Knowledge Base Article - Preview

1899144 - ASE Error SQL1204 during transfer of data between Infocubes


  • During the transfer of data between Infocubes via INSERTs, the ASE data server reports the following error:

    [ASE Error SQL1204]ASE has run out of LOCKS. Re-run your command when there are fewer active users,
    or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS.

  • Increasing the ASE data server  parameter 'number of locks' does not cure the problem



  • SAP Sybase Adaptive Server Enterprise (ASE) 16.0
  • Business Warehouse (BW)
  • Platform-independent


SAP NetWeaver Business Warehouse 7.2


KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.