Data load consuming all dialog processes

[chris_robertson]

We recently did a client copy of our source system and upgrade it. Now when we do a data pull from R/3 into BI it consumes all the dialog processes in the BI system. This did not work this way before we upgraded the source system.

I right clicked on the source system, and chose customizing extractors. Then I navigated to general settings --> Maintain Control Parameters for Data Transfer. Here I noticed that the source systems defined were the ones copies, so I added my source system here with Max KB = 20000, Frequency = 10 & Max Process = 3. After this I tried the load again. It still consumes all the processes. Any idea what I'm missing? I searched SDN for anwsers to this, but most information points me to the steps I took above.

Thanks,

Chris

[Former Member · Accepted solution]

You could place the DB into noarchivelog mode. Also, do you have a basis person handy? They could place your system into a mode where there are more batch processes versus dialog mode.

[chris_robertson]

I forwarded to BASIS to address. thanks.

[Former Member]

Actually after refresh this will take some delay due to refresh activities on ODS, Cube, Infoobjects.....

Please raise this concerned performance issue to your Basis team. This is actually the task of Basis to monitor utilization of Dialogue processes.

If refused by basis then this come to your EAI(Enterprise Application Interpreter). They have the access to application server and they will check this.

Regards,

Mahesh

[Former Member]

Please contact your SAP hosting team and ask them to kill all the Dialogue processes for once. This is happening due to some of the endless loop processes. This might be due to refresh activities.

Do this activity at earliest as this will cause the lock on system and no one is able to log in to system due to non availability of the Dialogue process.

[chris_robertson]

The processes timed out and we can get back in. That is not our issue. If I clean it all up and submit the refresh again, it will consume all of the dialog processes again. Is there a setting that we have to address that will only allow so many processes to be using in parallel for a single data load?