SAP Knowledge Base Article - Preview

1903067 - BICS Connections to SAP BW are not released after some Scheduling workflows for Web Intelligence


  • Connections that use BICS connectivity to an SAP BW system remain open on the Adaptive Processing Server (DSL Bridge) during some schedule workflows.
  • This issue can cause a variety of symptoms.  The most obvious symptom is that multiple connections to the SAP BW server will be held open by the Adaptive Processing Servers (APS) that host the DSL Bridge Service.
  • In the below screenshot, using Process Explorer, we show what the connections may look like when monitoring the APS TCP/IP Connections


  • As these connections add up, they can cause secondary symptoms.  Below are some of the known issues this can cause.
    • "An error has occurred.  The Maximum connection limit has been reached. (Error:  RWI 00000)" In the Schedule/Prompts dialog. 
      • This could also occur in other areas of the product as well but the root cause may be these connections that are left open during the schedule workflow

        BICs-Conn-Not-Released-Max Conn Reached -2.png

  • "An error has occurred.  java.lang.NullPointerException" in the Schedule/Prompts dialog
    • This happened during testing internally and may be another symptom of this issue

      BICs-Conn-Not-Released-Null Pointer Error.png
  • "max no of connections (<max_conn>) exceeded" - SAP Note 887909
  • "max no of cpic clients exceeded (<max_sys>) exceeded"  - SAP Note 894100

 Note: The BW connection remains open until the default session timeout is reached on the Web Intelligence Processing Server



  • SAP BusinessObjects Business Intelligence Platform 4.0
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Web Intelligence
  • SAP Business Warehouse (BW) through BICS connectivity


SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1


BICS Business Intelligence Consumer Service BW Business Warehouse connections gateway schedule prompts parameters values left open , KBA , BI-RA-BICS-BW , BICS BW Provider , BI-RA-WBI , Web Intelligence , Bug Filed

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.