SAP Knowledge Base Article - Preview

2502603 - Client Copy - import phase abort on large table with error 1204 - SAP ASE

Symptom

You are doing a Client Copy and the IMPORT phase abort on a large table (ACCTCR in this example) with error 1204

====

4 ETW000  [     dev trc,00000]  ERROR: -1 in function ExeNormalModify (execute) [line 26155]
4 ETW000  [     dev trc,00000]  (1204) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE has run out of LOCKS. Re-r
4 ETW000  [     dev trc,00000]  un your command when there are fewer active users, or contact a user with System
4 ETW000  [     dev trc,00000]   Administrator (SA) role to reconfigure ASE with more LOCKS.
4 ETW000  [     dev trc,00000]  sql statement is ==> DELETE FROM "ACCTCR" WHERE "MANDT" = ?
4 ETW000                        /* R3::0 T:ACCTCR */
4 ETW000  [    dbtran  ,00000]  ***LOG BY4=>sql error 1204   performing DEL on table ACCTCR

====

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0
  • SAP NetWeaver (NW) - All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0 ; SAP NetWeaver all versions

Keywords

#1204, SQL1204, error 1204, import, client copy , KBA , BC-DB-SYB , Business Suite 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.