Skip to Content

Issue in Client Import

Dec 21, 2017 at 05:14 AM


avatar image

We are performing client import from our Production system to Development system, but stuck while import TR due to Lock Overflow in Development system, we have already increased the number of locks till memory support but still issue not solved.

is there any way to solve this issue ?

Number of Locks Configured - 48946666(2K)

Our System

OS - Windows Server Standard 2008 R2 (Physical Memory Support 32 GB)

Database - ASE Sybase 15.7

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Andy Ashwood
Dec 21, 2017 at 09:11 AM

Hi Ritesh,

From your use of terminology it sounds like this is a SAP Buisness Suite system in which case I will let one of my colleagues advise you on this but if you are running a standalone ASE then please reply with as much information as you can and I will try and advise you.


10 |10000 characters needed characters left characters exceeded
Mehrab Bucktowar
Dec 21, 2017 at 09:55 AM

Hello Ritesh,

Andy is right. This is a SAP on ASE question and the correct tag you should use is "SAP ASE ERP Enablement". Choosing the right tag is important as it exposes the question to the right people from the start.

Coming back to the question, you should analyse the ASE log along with a sp_monitorconfig 'all' output run in isql. If they indicate a shortage of locks in ASE, you can check the following KBA if it helps:

If there is no errors in ASE, then you should investigate the issue from the Client import angle.

Hope this helps



Show 1 Share
10 |10000 characters needed characters left characters exceeded

I checked in ASE Log File, shows error ASE has run out of LOCKS, increased locks but not work

follow SAP Note - 1884542 - [ASE Error SQL1204] ASE has run out of LOCKS

Maria Victoria NORMAND
Dec 22, 2017 at 09:21 AM

Hello Ritesh,

Almost 50 millons for number of locks is a very high value indeed. Which is the sizing of your source SID database ? (you should be able to see that from DBACockpit). The ASE 15.7 SP level should be ideally >= SP137.
Along with KBA provided here, you may have a look on this SAP Note which has a link to the Best Practices Guide (page 33 - "3.5.4 Troubleshooting Data Import"). Also have a look on explanation from page 30.

Best regards,

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Yes, i allocated all the locks till can allocate. Our DB size is small - only 240 GB

Sybase ASE 15.7 - SP132

I dont no why it stuck

is there any other way, please tell


Greetings Ritesh,

I realize I didn't specify the SAP Note for the Best Practices Guide, here is it: SAP Note 1680803, the complete import recommendations start at page 25 (chapter "3.5 Import"). Please read it carefully.

Also for analysis purpose it would be interesting to check whether the out of locks message (Msg 1204) is returned always on the same table import / import phase.

Best regards,