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.
- 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)
- 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
- 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
Keywords
Design studio BIP 400 Bad request IIS Tomcat redirect isapi redirect , KBA , bad_request , iis , design_studio , isapi , tomcat , ds , BI-RA-AD-BIP , Business Intelligence Platform Integration , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , Problem
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.