Archive for the ‘BusinessObjects’ category

Troubleshooting a BO Edge on Red Hat Linux Oracle driver Issue

August 29th, 2010
So BOE 3.1 SP2 Edge CMS would not start after a database driver upgrade to solve an LDAP imcompatibility on a Red hat installation
1) checked the tnsnames.ora
Status: OK
2) Checked my Connectivity through sqlplus
Status: OK
3) Checked the CMS Setup
[bobj@server bobje]$ ./cmsdbsetup.sh
err: ERROR Failed to get cluster name. (STU00165)
err: Error description: Database access error. Reason Loading shared object 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: wrong ELF class: ELFCLASS64].
4) Checked the LD_LIBRARY_PATH in the profile of the bobj account
drwxr-x— 58 oracle oinstall 4096 Aug 27 13:51 OraHome10gr2_32bit
$ cd
$ vi .bash_profile
Status: OK
export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib:
5) Tried changing to 32 bit libary path
export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib32:
Status: libclntsh.so file was not there
6) Reset the rights for Read and Execute
chmod -R 755 lib32
Status: OK
7) Checked the file that BOE is looking for and it shows as a 64 bit file
libclntsh.so.10.1: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), not stripped
This should be showing as the following as BOE requires 32 bit database drivers
libclntsh.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), not stripped
Status: Issue
8) The current issue prohibits the BusinessObjects system from running on the server. Database driver to be setup correctly

So BusinessObjects 3.1 SP2 Edge CMS would not start after an Oracle database driver upgrade to solve an LDAP imcompatibility on a Red hat installation

1) checked the tnsnames.ora

Status: OK

2) Checked my Connectivity through sqlplus

Status: OK

3) Checked the CMS Setup

[bobj@server bobje]$ ./cmsdbsetup.sh

err: ERROR Failed to get cluster name. (STU00165)

err: Error description: Database access error. Reason Loading shared object 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: wrong ELF class: ELFCLASS64].

4) Checked the LD_LIBRARY_PATH in the profile of the bobj account

drwxr-x— 58 oracle oinstall 4096 Aug 27 13:51 OraHome10gr2_32bit

$ cd

$ vi .bash_profile

Status: OK

export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib:

5) Tried changing to 32 bit libary path

export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib32:

Status: libclntsh.so file was not there

6) Reset the rights for Read and Execute

chmod -R 755 lib32

Status: OK

7) Checked the file that BOE is looking for and it shows as a 64 bit file

libclntsh.so.10.1: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), not stripped

This should be showing as the following as BOE requires 32 bit database drivers

libclntsh.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), not stripped

Status: Issue

8) The current issue prohibits the BusinessObjects system from running on the server. Database driver to be setup correctly

SalesForce integration to BusinessObjects

March 26th, 2010

An article on cloud to premise integration reminded me of one of my favorite features. See ZDnet article here

Its good to see SFDC and SAP playing nice. Last year we released a connection that links SalesForce to SAP BusinessObjects. This reportlaunch is
useful for those SAP BO customers that need enterprise reporting embedded into SalesForce. Hopefully this will be a good trend of cloud to premise connections

Kevin McManus
www.mcmanussoft.com

What I Do

March 22nd, 2010

What we do: Some asked recently for what was going on related to our tools. Here is a summary
At a 50K foot level we have 5 tools

1) Report Launch allows you to embed Crystal and Webi reports from any application without needing the SDK.

2) Dashboard Launch (You will have to see this). Caches webi content and many other things for really fast dashboards. SAP certified too

3) Admin Launch – bleeding edge web based BOE administration tool that you can train to do what you need it to do for you (beta just started).

4) Audit Launch : Export extends BOE auditing for advanced analysis by syncing CMC attributes into an extended audit database. Audit Launch Import syncs security from 3rd party apps into BOE

5) Activity Launch – allows you to create business activity monitoring events into report schedules and trach when a batch of schedules completes so you can continue the notification or event process

All of our software is 100& web based on Java SDK so it runs on Windows, Unix, and Linux

Question of the day

August 7th, 2009

Here are the product names going back before all the mergers and today.

Company 1: Business Objects – Business Objects 6.X
Company 2: Crystal Decisions – Crystal Enterprise 10
Company 3: Infomersion – Xcelsius

Company: Mergers with BusinessObjects = BusinessObjects
BusinessObjects Enterprise XI (aka BOE XI Release 1)
Content : Crystal + Deski

BusinessObjects Enterprise R2 (aka BOE XI Release 2)
Main Content: Crystal+ Webi + Deski + Xcelsius + Live Office

Company: Acquisition of Business Objects by SAP = SAP BusinessObjects
SAP Business Objects XI 3.X (Currently 3.1 Service Pack 2)
This version is unofficially called ?BusinessObjects XI R3?

Kevin McManus
www.mcmanussoft.com