Archive for the ‘Business Objects’ 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

0812: Working with Auditing Data in the Activity Universe

August 9th, 2010

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

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.

Disappointed in boe_reposcan

June 21st, 2010

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

OpenDoc vs. CallReport

May 5th, 2010

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

    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

    Java or .NET

    January 1st, 2010

    Recent Question: Do you have any recommendations on installing the .NET (IIS) vs Java (Tomcat) versions? I liked the ease with which we implemented the SSO hack in IIS on our XI R2 server but I’m not if we can do the same on the 3.1 version. Also I remember that on sometime the .Net versions sometimes did not have all the functionality as the Java version is that still true?

    Answer:I usually lean towards whatever web platform that IT has optimization expertise in. If they don’t have optimization expertise in either then for several reasons, I usually do the Java.

    However for SSO the IIS setup is less steps than the Java version. The IIS pass through can still be done but is not a great solution if you are doing things like scheduling out reports with email links back to the system and still wanting SSO.

    If you do go with Java,Normally I work with people to setup the Vintella Kerberos SSO so that there is only one web platform running on the server rather than the pass through.

    Split and Search

    October 22nd, 2009

    Presented at the GBN conference on a way to provide users the way to enter a comma delimited list of values into a prompt and then use a database function to split those values in order to return the list as a table that can be used in joins.

    WHERE rs_tb_cms_groups.group_ID IN ( SELECT rs_tb_cms_groups.group_ID FROM @Prompt(‘Group
    Name ‘,’A',{‘California’,'New York’},mono,constrained,not_persistent,))

    If anyone wants the full article including the Oracle and SQL server code please contact Kevin McManus at answers@mcmanusconsulting.com

    Business Objects Bursting SDK – Part 2

    June 19th, 2009

    Whether you choose single or multiple report bursting, eventually you will want to deliver the results to your users, and if you are delivering a custom application solution, that means understanding the object model around publications.

    A publication object appears in a BOE folder just like a report does, and like a report, it too has historical instances. But whereas a report instance represents a snapshot of the report with data, a publication instance is a container that further holds (you guessed it) the report instances themselves.

    The great thing about BOE publication architecture is that the report instances held in a publication instance are automatically filtered to the report instances the currently logged in user has been “bursted.” In other words, it makes no difference if a user has rights to the folder in which the publication resides; he/she must have been named (or at least the user group to which he/she belongs must have been named) as a burst recipient in the publication. » Read more: Business Objects Bursting SDK – Part 2

    How to use Crystal Report ActiveX viewer in your Tomcat J2EE application

    June 10th, 2009

    If you ask the SAP developer support, they will say it’s not supported. However, there are complex Crystal Reports that renders properly in ActiveX viewer.

    The only option right now is to use InfoView’s URL reporting. This is ok but there are a few places where this can get you into trouble. For example, let say your J2EE application is on the DMZ and your BOE server is inside of your corporate network. The firewall will only let certain ports (e.g. 6400) and no http requests. In case of URL reporting, you would have to call <BOE server>:<http port>/businessobjects/viewrpt.cwr from your J2EE applications. This will not work. In most cases, opening http port so that ActiveX viewer would work is not an option.

    Here’s how to setup URL reporting as a part of you own application.

    1)  copy crystalreportviewers folder from infoview /businessobjects/viewers folder and place it in the root of your J2EE application

    2)  copy WEB-INF/lib/reportsourcebridge.jar from InfoView application and place it in WEB-INF/lib folder of your J2EE applicaiton

    3)  Edit WEB-INF/web.xml to include

    <context-param>
    <param-name>crystal_image_uri</param-name>
    <param-value>/crystalreportviewers115</param-value>
    </context-param>

    <servlet>
    <servlet-name>viewrpt</servlet-name>
    <description>
    Reportsource bridge used to support Java applet viewer and ActiveX viewer.
    </description>
    <servlet-class>com.businessobjects.crystalreports.reportsourcebridge.ReportSourceBridge</servlet-class>
    <load-on-startup>1</load-on-startup>
    </servlet>

    <servlet-mapping>
    <servlet-name>viewrpt</servlet-name>
    <url-pattern>/viewrpt.cwr</url-pattern>
    </servlet-mapping>

    4)  Restart Tomcat

    5)  You should be able to access URL reporting from <your J2EE application>/viewrpt.cwr