Unable to Enable/Startup RAS

| Posted by watashii | Filed under BusinessObjects

On a BusinessObjects XIR2 (SP3) Solaris installation, the following effects may be occurring:

  1. The RAS server refuses to startup using ./ccm.sh -start ras or ./startservers commands.
  2. Performing a ./ccm.sh -enable ras will complain that the RAS object does not exist, even though it is listed within ccm.config file.
  3. When the RAS server instance is deleted from the CMC, restarting all the servers and performing ./ccm.sh -enable all or ./ccm.sh -display, the RAS entry does not show up at all.
  4. When the RAS server instance is deleted and added using the ./serverconfig.sh tool, the RAS entry does not show up at all in CMC, ./ccm.sh -enable all or ./ccm.sh -display.
  5. When the ./ccm.sh -start ras does performs successfully, related serverpid’s are created, RAS processes are running, but RAS entry does not show up in ./ccm.sh -display or CMC, and the RAS server’s tcp ports are not opened at all.

Read the rest of this entry »

Tags: , , ,

BIAR File Command Line Import – Bypassing Import Wizard

| Posted by watashii | Filed under BusinessObjects, Software, Unix

The command line to import the BusinessObjects Enterprise (XIR2 Unix) exported biar file can be done using the following command:

java -jar <BOBJE_HOME>/bobje/java/lib/InstallEntSdkWrapper.jar 'cms_name' 'admininistrator' 'admin_password' 'secEnterprise' <PATH_TO>/MyBiarFile.biar

[InstallEntSdkWrapper.main] Connecting to CMS Development as administrator
[InstallEntSdkWrapper.main] BIAR Imported Successfully

Tags: , ,

BusinessObjects InfoView LDAP Authentication Error

| Posted by watashii | Filed under BusinessObjects, Software

Suddenly one day I got the following error when logging into InfoView via LDAP (with SSL):

Account Information  Not Recognized: The secLdap plugin failed to connect to the specified hosts.

However when logging into CMC via LDAP there were no problems.

The solution is to do with the cacerts file (and .keystore, if using mutual authentication).  Usually this is caused by an expired certificate.   Server authentication (or mutual authentication) does not verify the certificates when LDAP authentication is via CMC.

To fix the problem, obtain the valid certificates then recreate the necessary cacerts and .db files.  Go through the CMC LDAP configuration wizard to validate it, then restart the CMS for settings to take effect.

Tags: , , ,

BusinessObjects Enterprise – Changing Tomcat Session Timeout

| Posted by watashii | Filed under BusinessObjects, Software, Web

To change the timeout limit of a BusinessObjects Enterprise XIR2 (Solaris) logged-in session (with Tomcat), the following files needs to be modified:

$BOBJE_HOME/tomcat/webapps/businessobjects/WEB-INF/web.xml
$BOBJE_HOME/tomcat/webapps/businessobjects/enterprise115/desktoplaunch/WEB-INF/web.xml
$BOBJE_HOME/tomcat/webapps/businessobjects/enterprise115/adminlaunch/WEB-INF/web.xml
$BOBJE_HOME/tomcat/webapps/businessobjects/enterprise115/adhoc/WEB-INF/web.xml

Find the following setting within the web.xml file to change the timeout value in minutes.

<!-- Define the default session timeout for your application,
      in minutes.  From a servlet or JSP page, you can modify
      the timeout for a particular session dynamically by using
      HttpSession.getMaxInactiveInterval(). -->
<session-config>
      <session-timeout>20</session-timeout> <!-- 20 minutes for session objects -->
</session-config>

Then just restart the Apache Tomcat webserver to take effect.

Tags: , , ,

BusinessObjects Universe Designer – Sysdate Value Object

| Posted by watashii | Filed under BusinessObjects, Database, Software

universe_sysdate

Creating SYSDATE value objects in a Universe (via Oracle connection) can simply be done as shown above.   I have simply created a single-value dimension object, which can be used anywhere within a query (result/condition/sort).  Having sysdate values allows the flexibility to create dynamic time-based reports.  For example you can schedule a weekly report to extract data from the past 7 days starting from the current time the report was run.

Note, when parsing the object against the database (Oracle), an error will appear. ORA-00903: Invalid table name.

You can just ignore this error and press ok.

Tags: , , ,

BusinessObjects – Delete Universes in CMC

| Posted by watashii | Filed under BusinessObjects, Software

When deleting Universes in the Administrator Central Management Console (CMC), under a BOXIR2 Unix installation, i got the following error:

Error. Unable to reconnect to the CMS XXX:6400. The session has been logged off or has expired.

The solution is to make sure the timezone environment variable is set under the user’s Unix profile (the user which installed BO).

vi /opt/bo/.profile

Add the following example timezone and source the profile.

TZ=Australia/NSW export TZ
source /opt/bo/.profile

Then restart the BO servers.

Tags: , ,

BusinessObjects – Insert Webi Report Images

| Posted by watashii | Filed under BusinessObjects, Software

To insert external images on BO Webi reports, create a blank cell from the Templates tab, go to Properties tab, and under ‘Background image’ put the following custom image URL:
boimg://<filename>.jpg
Then on the BO server (Windows), place the image file under

C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Images

Or if you’re working under Unix system, its located at

/opt/bo/bobje/enterprise115/Images

Tags: ,

BusinessObjects – Internal Error when connecting Windows clients

| Posted by watashii | Filed under BusinessObjects, Software

When connecting with a Windows client using Designer or Import Wizard to a remote BOE XIR2 server, I got the following error:

Internal Error [repo_proxy 13] SessionFacade::openSessionLogon with user info has failed(Transport error: Communication failure.)

This error message (generally repo_proxy) is a very generic error message and doesnt tell you much what is going on. Your problem may be different to mine. However this post shows the steps I used to troubleshoot the problem and make my windows client to connect properly.

Read the rest of this entry »

Tags: , , ,