Dashboard Designer Fail to connect to BI Platform - SAP Note 1168437

[Former Member]

Hi,

I only see unanswered threats on this.

When trying to connect Dashboard Designer to Universe, log in detail is reviewed and correct but you receive error "Failed to connect to BI platform.If this error keeps occurring then refer to SAP note 1668437 for troubleshooting"

SAP Note 1168437 is not a solution to this, as log in access passes before getting the error.

Dashboard Designer 4.0 SP06

All servers are running and have been restarted etc.

Tomcat can be accessed

Above error received as administrator log in so not a user security issue.

Any other thoughts or suggestions?

Thanks

Marius

[former_member192430]

Hi Everyone,

I faced this same issue today and was able to resolve following two basic steps:

1) Checked CMC for FQDN, followed by check on the hosts file found in path "C:\Windows\System32\drivers\etc". I had removed the ID and used the correct name there. Also please ensure concurrence between the entries in host file and CMC -> Applications -> Web Service Name.

2) I checked the privacy and content policies on the Internet Options of Internet Explorer [Main Browser used for portal activities], I had reset them to a lower security level than current with pop-ups allowed from this portal and other content and trust level activities. After adjusting them I was able to successfully re-login and goto my dashboards.

Regards,

Abhishek Sharma

[Former Member]

Hi Marius,

We had the same issue when creating a dashboard on BEx Query through Query Browser.

But the below setting solved the issue,Apply in your Default Browser (IE),

Internet options -> Connections -> LAN Settings -> Check only "Automatically detect Settings" and Uncheck the other options.

Thanks

Jethendra

[Former Member]

Hi,

We are on 4.0 SP7 Patch2 and we do see the same issue.

Note 1168437 does not resolve the issue.

Please update if anyone has a workaround/solution for it.

Thanks,

Sagar

[Former Member]

Hi Marius,

When you add a query in dashboard designer, can you please enable fiddler trace at the same time.

This will help you to locate the problem.

http://fiddler2.com/get-fiddler

Thanks,

Vivek

[Former Member]

Hi Vivek,

Attached picture & Fiddler script on error received when trying to log into dashboard designer - let me know if you require any other info.

Thanks

Marius

Fiddler Script.txt.zip

[Former Member]

Note that I'm also getting an error when trying to log into Apache services (dswsbobje/services/listservices)

Not sure if this is part of the issue.

Thanks

Marius

[Former Member]

Hi Marius,

   1. Logon to Central Management Console (CMC)

   2. Go to Applications

   3. Now double click on Web Service and go to Properties

   4. Confirm the URL which is updated here

As another test, can you check if below URL:-

http://<hostname>:8080/dswsbobje/ works fine or not.

Ideally you should set URL with hostname under this properties and update hostname/IP address in hosts file under "System32\drivers\etc".

Thanks,

Vivek

[Former Member]

already did all of that

[former_member194862]

Hi Marius,

save the fiddler log by going file->save->all sessions ,zip it and attach the log.

Regards,

Amit

[Former Member]

.Zip not allowed for upload?

[former_member195290]

Hi Marius,

As you are trying to connect to universe from your system, the IP address and hostname entry for BO Server is needed on the client system

Please update the host file in your system and try again.

Regards,

Javed

[Former Member]

I'm trying to use Dashboard designer from a different masjien. (BOBJ is on a linux server)

So I got a valid key and now I'm getting SAP note 1668437 which refers to adding my hostname as also mentioned above.

In regards to the SAP note, I'm stuck at point 3 below;

SAP Note 1668437 - Resolution

Steps for resolution:

1. Dashboard Designer connects to the universes through web services under the hood. Check the path registered in the CMS with the following through the query builder: (http://localhost:8080/AdminTools/querybuilder/query.jsp )

2. Select SI_ACCESS_URL from CI_APPOBJECTS This gave the correct path. e.g.  http://Win2003EEx64:8080/dswsbobje

3. Copy and paste this path into Internet Explorer and see if it resolves. If localhost is resolving but machine name isn't open the apache server.xml file and drop in an alias with your machine name under the hosts section.

The server.xml file is located at [path_to_]\Tomcat\conf\server.xml e.g. <Host name="localhost" appBase="C:\Program Files (x86)\SAP BusinessObjects\Tomcat6\webapps" unpackWARs="true" autoDeploy="true" xmlV alidation="false" xmlNamespaceAwar

I get to the file - Where do I add my computer name and how?

"drop in an alias with your machine name under the hosts section" - I don't see a host section

Nothing in that file really makes sense to me. (attached)

Thanks in advance

Regards

Marius

[former_member194862]

Hi Marius,

Just specify the correct url in the CMC->applications-->web service.

the correct url would be http://tomcatservername:port/dswsbobje

Click on save and try.

Also copy the same url in browser and test whether you are able to see the services

Regards,

Amit

[former_member195290]

Hi Marius,

Enter your BOBJ Server details in hosts file , you can access the same by typing "drivers" in run command, it will open up a new window from there go to folder name "etc" , inside etc you will find "hosts" file.Open it with notepad and add your server entry.

Eg:

192.168.1.1     hostname

Hope this helps.

Regards,

Javed

[Former Member]

Hi Javed,

Add the hostname to the server host file or my PC host file?

Thanks

[former_member195290]

Hi Marius,

Add it to your machine from where you are running the dashboard / trying to connect to universe.

Not on the server side.

Also test from your client system in command prompt:

ping <bobj server ip address>

If its working fine or not.

Kindly let me know if you face any issues.

Regards,

Javed

[Former Member]

Hi Javed,

I've added the server IP to my host file and can ping the bobj server without any issues, but still getting the same issue.

Regards

[Former Member]

Same issue with Crystal reports on my local machine. (can't connect)

Do I have to have the Business Objects Client installed on my local machine or can I run Dashboard Designer and Crystal Reports stand alone?

[former_member195290]

Hi Marius,

Have you added the full hostname entry for your bobj server

eg>

192.168.1.1     abc    abc.domain.com

Also please check whether you are able to connect to universe using Universe Designer or IDT from your client system.

Please let me know.

Regards,

Javed

[former_member195290]

Hi Marius,

If after doing the above your issue still persists than try the below method:

    1. Logon to Central Management Console (CMC)

    2. Go to Applications

    3. Now double click on Web Service and go to Properties

    4. Update the Access URL as mentioned below and click on Save & Close:

       http://<Web Application Server Name>:8080/dswsbobje

    5. Now launch Dashboard Design, and check

Also check the url on your system if its opening the services page.

Regards,

Javed

[Former Member]

Hi,

I have done that previously and http://192.168.0.114:8080/dswsbobje/ does open the Apache page but still no luck with dashboard designer.

[former_member195290]

Not needed, the user should have proper permissions to access reports/universe.

Answer to your BO Client tools question

http://scn.sap.com/thread/3434169

Regards,

Javed

[former_member195290]

Hi,

Change the ip address to hostname in the URL. http://192.168.0.114:8080/dswsbobje/

sometimes it works.Just check.

Regards,

Javed

[Former Member]

Hi,

Hostname resolves in internet explorer but getting the same error when trying to add a query in dashboard designer.

Regards

Marius

[Former Member]

Hi Marius,

Amit is right. check the access URL in cmc -> Applications -> Web serivce.

Validate this in bowser. Also make the hosts file entry.

Try with servername, IP address or on server go to CCM and copy the computer name and pate it for servername below:

http://servername:portno/dswsbobje

[former_member194862]

check in cmc-applications-web service   whether the url mentioned is reachable i.e http://server:port/dswsbobje

[Former Member]

Can you check if you are using a enterprise licence for the dashboard and not ? This feature is only available with enterprise licence.

[Former Member]

I'm using a temporary key currently as provided by SAP consultants to review functionality before buying the full version.

SAP Crystal Dashboard Design, Departmental Edition 2011 (also known as Xcelsius Enterprise 2011 & Dashboards 4.0)