cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports for Enterprise connection error to BI 4.0 Platform

Derek_Fox
Contributor
0 Kudos

Hi All

We are trying to connect Crystal Reports for Enterprise to our BI 4.0 Platform, however we are getting the following error: "Failed to establish a connection. The cause was: Cannot connect to SAP BusinessObjects Enterprise at this time. Please try again later".

System Information:

- SAP BI Platform 4.0 SP02 patch 6

- Windows Server 2008 R2 64bit

- Tomcat 6.0.24

We have also installed the following client software:

- SAP BI Platform Client Tools 4.0 SP02

- SAP Crystal Reports for Enterprise 4.0 SP02

- SAP BI Platform Client Tools 4.0 SP02 Patch 6

- SAP Crystal Reports for Enterprise 4.0 SP02 Patch 6

Our deployment of the BI Platform is a distributed system where

- Server 1 hosts the BI Platform Services and

- Server 2 hosts the web application server

We have reviewed the following OSS Notes below from SAP first to determine if there is a technical issue :

- 1598906 - Crystal Reports for Enterprise gives Cannot Connect to SAP Business Objects Enterprise at this time. Please try again later.

We have adjusted the "dsws.properties" as mentioned in the OSS note 1598906 above to contain the correct CMS and CMS port number (for Server 1).

- 1602024 - Error - Failed to establish a connection. The cause was - Cannot Connect to SAP BusinessObjects Enterprise at this time.

We have entered the server context as "/dswsbobje" mentioned in the OSS note 1602024 above in the connection details for CR for Enterprise connections

- 1636862 - Login for Crystal Reports fail on BO Server Cannot Connect to SAP Business Objects Enterprise at this time.

We have checked the proxy settings of Internet Explorer and adjusted it to have the following exceptions defined:

- Server 1.<domain_name>

- Server 2.<domain.name>

In the CMC, we also checked in the applications section for the web service option's access URL andchanged it from http://localhost:8080/dswsbobje to http://server2:8080/dswsbobje

We restarted the tomcat service and tried to access the CR for Enterprise from the BI Launch Pad as well as starting it directly from Windows, howevere we still get the same error.

Regards

Derek

Edited by: Derek Fox on Oct 27, 2011 1:07 PM

Edited by: Derek Fox on Oct 27, 2011 1:10 PM

Edited by: Derek Fox on Oct 27, 2011 1:11 PM

Edited by: Derek Fox on Oct 27, 2011 1:20 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

My Crystal Server has been installed on Linux.  How do I find the dswsbobje.war file?  I have looked all over the folder where the server is installed.

Also I performed the installation with the Install Web Application with Container since Apache is already installed on the server with a different user name.  Confirming that this was the correct choice.  My first installation I chose to install the Tomcat Application Server but it appeared to not be working. 

Former Member
0 Kudos

Good day Derek,

Have you managed to correct this issue? We are experiencing the same issue, even after changing all the settings from the SAP Notes.

Former Member
0 Kudos

I managed to logon to Crystal Enterprise on the BOE server itself. Not ideal, but at least I can now use the tool. Now just having issues saving back to the CMS.

Derek_Fox
Contributor
0 Kudos

Hi Anna-Marie

I apologise for only responding now back.

I have managed to logon successfully from Crystal Reports for Enterprise 2011 to the BI 4.0 Platform now, where we can create a report and save the report back to the BI Platform.

As we have a distributed system, where the BI Platform is on one server (Server1) and the WebAs on another server (Server2). We had to adjust thefollowing settings on the WebAs system.

1. On the WebAs server (Server 2), in the directory <install drive>:\Program Files (x86)\SAP BusinessObjects\Tomcat6\webapps\dswsbobje\WEB-INF we changed the file: web.xml by entering the default CMS.

<context-param>

<param-name>cms.default</param-name>

<param-value>Server2:6400</param-value>

</context-param>

2.Then also in the directory <install drive>:\Program Files (x86)\SAP BusinessObjects\Tomcat6\webapps\dswsbobje\WEB-INF\classes we changed the file: dsws.properties where the section for domain=Server2 to domain=Server1 (example below from the file)

#default host for CMS and will be replaced during installationdomain=Server1:6400

3. In internet explorer's proxy exceptions, we set the following:

server1.<domain>*

server2.<domain>*

4. In the local Intranet setting, we also set the site as:

http://*.<domain>;

Now for my laptop the connection works with no issues, but another developer's does not work - so we are busy investigating what is different between my laptop and his laptop.

Update:

We found that a setting inside the Crystal Reports for Enterprise 2011 in the network settings had to also be adjusted.

5. Use the menu path: Edit > Preferences > Network settings

6. Switch from "use system proxy configuration (if available)" to "Manual proxy configuration"

Enter the HTTP proxy address: proxy_server

Enter the Port: 80 (example)

Enter the list of servers to bypass: Server1;Server2

Check the checkbox "Enable proxy authentication"

Enter a username

Enter a password

Click on the OK button.

7. Afterward change the setting from "Manual proxy configuration" to "use system proxy configuration (if available)"

Then Crystal Reports for Enterprise 2011 works correctly.

What we found was that Crystal Reports for Enterprise 2011 must authenticate against the proxy server first otherwise one has issues.

Regards

Derek

Edited by: Derek Fox on Oct 28, 2011 2:02 PM

Edited by: Derek Fox on Oct 28, 2011 3:38 PM

Former Member
0 Kudos

Derek,

thanks your solution work as you described.

Former Member
0 Kudos

Hi Anna,

Did you manage to solve your problem with saving to the server.

I managed to logon but having issues saving to the server.

Regards,

Tunwiir

Former Member
0 Kudos

Hello,

             For the proxy authentication, your post mentions a username and password.  What username and password go in this area?  Please advise.