Skip to Content
avatar image
Former Member

Client import issues

Dear gurus,

i am getting bellow error when i am importing on quality system

-------------------------------------------------------------------------------------------------------------------

2EETW125 SQL error "1204" during "" access: "[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."

1 ETP154 MAIN IMPORT

-------------------------------------------------------------------------------------------------------------------

00:0003:00000:00102:2015/11/01 18:19:13.82 server  login: Process with spid 102 could not connect to the ASE which has temporarily run out of locks.

--------------------------------------------------------------------------------------------------------------------

* it is possible client export , import on same client number. my  production client-500 and quality client-500

I increase locks from 2000000 to 3350000 agai imported but i am getting same above  error

so please advice me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 02, 2015 at 01:26 PM

    Hello Sidhu,

    The recommendation when doing the bulk load that implies the import is to configure the "number of locks" to at least 5 millons. Do not hesitate to increase it for the import, you may decrease it after the import.
    Also important is to have a latest DBSL version.

    Regards,
    Victoria.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sindhu,
      As mentioned Dilip you'll need to increase the "max memory" configuration parameter which as per the message returned has a low value.
      You can use also the "sp_configure" to increase it.
      Let's say that the minimum configuration on your target system would be the current configuration on source system. Starting from that and for import purposes you may resize some parameters like number of locks, procedure cache size, etc... You can take as reference the sample on page 22 "Optimizing the ASE Configuration for Data Import" of the "Best Practices" guide attached to SAP Note 1680803 - SYB: SAP Adaptive Server Enterprise - Best Practice for SAP Business Suite and SAP BW

      Regards,

      Victoria.

  • avatar image
    Former Member
    Nov 03, 2015 at 09:06 AM

    Thanks

    Add comment
    10|10000 characters needed characters exceeded