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
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.