BusinessObjects, Web Intelligence , Crystal Reports

Troubleshooting a BO Edge on Red Hat Linux Oracle driver Issue

August 29th, 2010 by Kevin McManus No comments »
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

Events

August 29th, 2010 by Kevin McManus No comments »

We are going to host a Fall BI Mixer in Austin in September so we make sure we take care of everyone who has not been able to attend the San Antonio events. Location is going to be USTEL one of the predominent STBOUG members. Date is going to be confirmed. Let me know who can attend

http://www.surveymonkey.com/s/V62YSW

0812: Working with Auditing Data in the Activity Universe

August 9th, 2010 by Kevin McManus No comments »

October 7th – Will be at ASUG speaking on how there is a wealth of information about your BusinessObjects system that is only available in the Auditing database.    Getting access to these questions (and answers) takes a good understanding of the auditing database and the confidence to extend the activity universe to meet your needs. With some real world examples we will show you how to get the answers to some tough questions.

http://asugew.asug.com/displaymod/detailevent.cfm?conference_id=95&event_id=18468

Multi-node BOE

July 31st, 2010 by Kevin McManus No comments »

Had the great opportunity to present a webinar on some of the more complex options when configuring SAP BusinessObjects Enterprise XI 3.1.  The link is here http://jive.asug.com/docs/DOC-25624 if you are an ASUG member.

Reminder: Who manages RI in a data mart?

July 19th, 2010 by Kevin McManus No comments »

Reviewed the data model and loading today with the DBA.  To explain the reason for not enforcing RI through foreign key constraints there are few concepts.(see page 536 of the toolkit book mentioned below for more explanation)

1) This is a read only data mart not an operational system so there are single threaded ETL jobs and read only queries.  The ETL process handles the RI by loading the Dimensions and Facts as part of a single correlated load stream.  This means there are not outside applications adding and removing rows so RI can be maintained by the ETL application logic.

2) We are not rejecting fact records based on their keys.  If keys don’t match an appropriate value in a dimension, then the value is added to the dimension (e.g. new title is added)

3) We are not rejecting dimension records based on their keys.  If keys don’t match the lookup attribute table then the Unknown key is used (i.e. -1)

Example: So if a series of  web sites that have an invalid country code we are still going to load web site attributes into the sites dimension tables,  but we will insert the key for an “unknown” country into the country foreign key.

4) We needed to first load a significant amount of data in order to validate that the data model was going to match the proposed model.  We can always add foreign key constraints but since items 2 and 3 handle valid and invalid keys programmatically they constraints would not come into play.

From Oracle: “Unlike many relational-database environments, data in a data warehouse is typically added and/or modified under very controlled circumstances during the ETT process. Multiple users typically do not update the data warehouse directly; this is considerably different from the usage of a typical operational system. Thus, the specific usage of constraints in a data warehouse may vary considerably from the usage of constraints in operational systems”

Recommended reading:

Data Modeling Essentials -Graeme Simsion – ISBN 1-850-32877-3

The Data Warehouse Lifecycle Toolkit – Ralph Kimball (and others) – ISBN 0-471-25547-5

Disappointed in boe_reposcan

June 21st, 2010 by Kevin McManus No comments »

After reading the document I thought that it was going to be a cool new tool for disaster recovery.  I thought that boe_reposcan would publish orphaned files left in the file repositories after a database outage.

I event spent the time to update the script syntax and find the proper location to execute the program

./boe_reposcan.sh -dbdriver oracledatabasesubsystem “-connect “UID=BO_data;PWD=b0_data;DSN=database-server;HOSTNAME=ip-address;PORT=1521” -repair -inputfrsdir “/usr/apps/bobj/bobje/data/frsinput” -outputfrsdir “/user/apps/boj/bobje/data/frsoutput” -scanfrs

But to no avail.  the program told me that my reports did not synch with the repository but I was on my own to republish them.  After all that work comparing I think a synch option would have been the perfrect match

I will add this as another item for Admin Launch for the future.

./boe_reposcan.sh -dbdriver oracledatabasesubsystem “-connect
UID=BO_NEXUS_data;PWD=b0_nex1s_data;DSN=bradpit;HOSTNAME=bradpit;PORT=1521” -inputfrsdir /usr/wbol/bobj/bobje/data/frsinput -outputfrsdir /user/sbol/boj/bobje/data/frsoutput -scanfrs

SAPPHIRE

May 28th, 2010 by Kevin McManus No comments »

My Highlights
– Met with new product managers of Webi Intelligence and BI On-Demand
– Everyone I met had a challenge with BOE that we could assist with
– Other BOE parters were ready to talk about collaboration
– Got to see my sister who lives nearby
– Great feedback at my presentation on Data Quality

OpenDoc vs. CallReport

May 5th, 2010 by Kevin McManus No comments »

We get a lot of question on how Open Document compares to Report Launch. In a conversation with our sales team I tried to summarize the vast differences. Opendoc is a single URL that can only call a single report at a time ….and for Webi can only return to the viewer or PDF

Report Launch’s “call report” is an application that will provide a consistent ways of calling both Crystal and Web Intelligence reports using single sign on.

  • On- demand refresh
  • On demand scheduling
  • Report List
  • Last Scheduled Instance
  • Last Bursted Instance
  • List of Historical Scheduled Instances
  • List of Historical Bursted Instances
  • It can also support the following formats

  • PDF
  • XLS
  • PPT
  • CSV
  • TXT
  • HTML
  • XML
  • These are the basics. There are also more complex features for complex solutions.

  • Cached Results
  • Report Parts by Name
  • On the fly Dimensional Slicing
  • – Challenge us with something you need and I can tell you if CallReport already handles that.

    Kevin McManus

    April 16th ASUG Meeting

    April 14th, 2010 by Kevin McManus No comments »

    Busy Spring on tour. I will be speaking a the Dallas / OK ASUG meeting in Plano BusinessObjects Installation Concepts.

    Address is
    SMU – Plano Campus
    5236 Tennyson Parkway
    Plano, Texas 75024
    9:00 a.m. – 4:00 p.m.

    Just spoke at the Central Texas conference in March in San Antonio on Xceslius Project Management and will be speaking in May at SAPPHIRE in Orlando on Web Intelligence Data Tracking techniques.

    SalesForce integration to BusinessObjects

    March 26th, 2010 by Kevin McManus No comments »

    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