SAP Knowledge Base Article - Preview

2312762 - Design Studio login to clustered BI platform fails with 400 Bad Request errors

Symptom

Using Design Studio 1.5/1/6 and login to the BI platform 4.1 SP7 cluster on a secure (SSL) loadbalanced deployment which comprises a loadbalancer and an IIS web server, the design studio login fails with below errors.

  • The deployment comprises of clustered and distributed BI 4.1 SP7 environment with Tomcat web tier and fronted by IIS web server and a standard loadbalancer with SSL implemented.
  • The server side backend processes are all running (Analysis Application designer) and CMC shows the design studio runtime.
  • With Design Studio, login with https loadbalancer URL (https://loadbalancer_FQDN/dswsbobje/services/Session): Failed with below error -
  • com.sap.ip.bi.zen.connectivity.ConnectivityException: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1] Message: Content is not allowed in prolog. 
    LOGON_FAILED_1.png

  • If you skip on error window and login the second time or if you login without SSL in loadbalancer (http://loadbalancer_FQDN/dswsbobje/services/Session), following error is thrown-
    com.sap.ip.bi.zen.connectivity.ConnectivityException: SOAP message MUST NOT contain a Document Type Declaration(DTD)
    lOGON_FAILED_2.png

     
  • The same errors as above are thrown by design studio if we Login using direct Tomcat server HTTP / HTTPS URLS which failed with same error as before. 
  • After applying SAP Kbase 1985014 - Test Connection returns "Error: SOAP message MUST NOT contain a document Type Declaration(DTD)" in CR for Enterprise via HTTPS, error changed to below with https

    lOGON_FAILED_3.png


  • Using the same Design studio, we can login to another standalone environment which also uses a loadbalancer and IIS redirection.
  • DS Support logs show following error details:
    com.sap.ip.bi.zen.connectivity.ConnectivityException: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1] Message: Content is not allowed in prolog.
    at com.sap.ip.bi.zen.backends.bip.BiPlatformSystem.createConnectivityException(BiPlatformSystem.java:879)
    at com.sap.ip.bi.zen.backends.bip.BiPlatformSystem.logon(BiPlatformSystem.java:564)
  • HTTP traces using Fiddler or wireshar show following error :


    REQUEST from Design Studio

    POST /dswsbobje/services/BIPlatform HTTP/1.1
    Content-Type: text/xml; charset=UTF-8
    Cookie: JSESSIONID=xxxxxxxxxxxxxxxyyyyyyyyyyy; Path=/dswsbobje/; HttpOnly=null
    SOAPAction: "http://biplatform.dsws.businessobjects.com/2007/06/01/Get"
    User-Agent: Axis2
    Host: FQDN.of.host.com
    Transfer-Encoding: chunked

    60c
    <?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv=" http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><Get xmlns="http://biplatform.dsws.businessobjects.com/2007/06/01"><SessionID xmlns="http://biplatform.dsws.businessobjects.com/2007/06/01">xxxxxxxxxxxxxxxxxyyyyyyyyyyyyyyyyyyyyyyyzzzzzzzzzzzzzzzzzzzzzzzzzzzz2CSI_TENANT_ID%3D0|en|America/Los_Angeles|ANALYSIS AAD 1.0 </SessionID><Path xmlns="http://biplatform.dsws.businessobjects.com/2007/06/01">query://{SELECT SI_NAME FROM CI_INFOOBJECTS WHERE SI_ID='23'}</Path><Options xmlns="http://biplatform.dsws.businessobjects.com/2007/06/01"><ExportDependencies xmlns="http://biplatform.dsws.businessobjects.com/2007/06/01">false</ExportDependencies></Options></Get></soapenv:Body></soapenv:Envelope>
    0


    Response from Server

    HTTP/1.1 400 Bad Request
    Content-Type: text/html
    Server: Microsoft-IIS/7.5
    X-Powered-By: ASP.NET
    Date: Tue, 26 Apr 2016 16:08:37 GMT
    Content-Length: 11

    Bad Request

 

 


Read more...

Environment

SAP BusinessObjects BI Platform 4.1 SP7
SAP Design Studio 1.6
Loadbalanced deployment with Apache Tomcat 7 Web tier.
IIS 7 - Tomcat 7 Redirector / AJP 1.3

 

 

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Design Studio 1.5 ; SAP BusinessObjects Design Studio 1.6

Keywords

Design studio BIP 400 Bad request IIS Tomcat redirect isapi redirect , KBA , ds , tomcat , iis , design_studio , isapi , bad_request , BI-RA-AD-BIP , Business Intelligence Platform Integration , BI-BIP-DEP , SBOP Web Application Deployment, Wdeploy , Problem

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.