Problexi

I was using Business Objects XI 3.1 on Red Hat Enterprise Linux 5 and when run cmsdbsetup.sh to check the CMS repository I faced the following error:

err: ERROR Failed to get cluster name. (STU00165)
err: Error description: Database access error. Reason Loading shared objects failed. First tried to load library clntsh and failed because of error: [clntsh: cannot open shared object file: No such file or directory]. Second tried to load library libclntsh.so and failed because of error: [libclntsh.so: cannot open shared object file: No such file or directory].

After some search I find this solution:
Find libclntsh.so in your system by running the following command
 find / -name libclntsh.*
 gives the result: /libclntsh.so
then add the path of libclntsh.so into the LD_LIBRARY_PATH system variable by executing
 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/libclntsh.so

Also make sure that the Oracle client is running and try to tnsping the repository database

When using Query as a Webservice, and you try to import the WSDL link into Xcelsius an error may pop up and say "Unable to load URL". Or when you paste the link into your internet browser an error occurs as following:

QaaWS HTTP Servlet
QaaWS error
Sorry, something seems to have gone wrong... here are the details:

Exception - com.crystaldecisions.sdk.exception.SDKServerException: An error occurred at the server :
Enterprise authentication could not log you on. Please make sure your logon information is correct.

cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:An error occurred at the server :
Enterprise authentication could not log you on. Please make sure your logon information is correct.

The server supplied the following details: OCA_Abuse exception 10498 at [.\secpluginent.cpp : 610] 42040 {}
...Invalid password

I solved this problem by going to \Tomcat55\webapps\dswsbobje\WEB-INF\classes and open the dsws.properties with notepad. Then at the qaaws.principal.username and qaaws.principal.password insert the user name of Business Objects and the password.
Then restart the services.
For my case I created a separate username and password for the QaaWS.

[repo_proxy 13] SessionFacade::openSessionLogon with user info has failed(Transport error: Communication failure. (FWM 00001) (hr=#0x80042a01)

If are facing this error then you need to add your computer name to the hosts file.

You can find the hosts file at this directory C:\WINDOWS\system32\drivers\etc
open the file with Notepad and add the ip and the server name for example:
192.1.1.200   BOServer1

If the server is part of domain you have to write the full address of machine, for example:
192.1.1.200   BOServer1.DomainName.com

This problem happens when you are connecting with Business Objects clients like, Universe Designer, Desktop Intelligence, and Web Intelligence Rich Client and so on...

If you are using Xcelsius and have encounter error #2170 when you viewing a published dashboard then you have to check the link, if you are using IP try to change it to the hostname, for example: use http://boserver:8080/.../.. instead of http://192.168.1.3:8080/../..

The problem could be also the crossdomain file which is elaborated at this website http://neverknewthat.wordpress.com/2008/03/19/when-using-xcelsius-2008/