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

SAP Knowledge Base Article - Preview

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

Symptom

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

connleftopen-bics.png

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" https://service.sap.com/sap/support/notes/887909
  • "max no of cpic clients exceeded (<max_sys>) exceeded"  https://service.sap.com/sap/support/notes/894100

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


Read more...

Environment

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

 

Product

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

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.