Prepare NPL to SAP BW development
From few versions back, SAP Netveawer is shipped in standard with SAP BW module. The free non-production system delivered by SAP to developers is not an exception, but if you want to develop without any issues, you have to make some small reconfiguration first.
By default SAP NPL instance is configured with a small number of processes. This, of course, is not an issue if you want to develop ABAP, but if you want to run extractor on developer system you probably get an issue like:
- SMQS scheduler status shows RES_LACK in SQMS transaction
- You have to manually execute LUW in SM58
- You can see “status not OK” in monitor
Increase jobs in SAP
All these issues is caused by a lack of resources, let’s start with an increasing number of process in SAP.
First, please edit the profile configuration file:
and a set a number of processes, 16 in my case:
rdisp/wp_no_dia = 16
Now, please restart your application server ( ie. stopsap ALL, startsap ALL).
Unfortunately, this is not the end of our journey. Now if you try to execute info package, or generally do some other work on application server you probably got a dump like:
Database error text: "SQL message: [ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died while reading from socket. ERRNO returned 2. Check the server to determine the status of any open transactions."
If you check your database log, you will probably get:
There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure ASE with more user connections.
To correct this, we have to log in to the database user and change user connections. I have increased the number of connections by 100% from 50 to 100.
su -l sybnpl isql -Usapsa -X -SNPL sp_configure "number of user connections" go sp_configure "number of user connections", 100 go
Now you probably see a message with max memory settings. I recommend changing this value to 764134 and ignore the proposition from the message .
sp_configure 'max memory','764134' go sp_configure "number of user connections", 100 go
Voila, now extraction should work fine. Let’s restart the application server once again.
My database not starting after changes
If something goes wrong, your database could not start now. I had this issue when the first time I change the value to proposition from message. If for some reason your application server won’t run. Please execute:
As you see, in my case I have to adjust max memory, to achieve this I have to change config file:
2564704 – SAP ASE – There are not enough ‘user connections’ available to start a new process
This looks interesting, thanks. I'll try to add it to the dev edition (NPL) FAQs.
If you write any blog post about the dev edition, please just let me know. Then I can share it with other dev edition users - the demand is high!
Hi Julie - no problem 🙂 I will inform you!