Irfan's World

April 26, 2011

Apache Tomcat 5.5 Service installed with BusinessObjects 3.1 does not start on Windows 2003 Server ?

I was trying to install Business Objects 3.1 (32 bit) on Windows 2003 Standard Edition (32 bit).  This system does not have any web servers nor any service packs.   While installing Business Objects 3.1, I selected the option, Install on Apache Tomcat 5.5 and deploy war files.   After the completion of Business Objects installation, I thought everything is running fine but found that the Apache Tomcat 5.5 (Web/app server) is not starting correctly.  Due to this issue, I was unable to login to CMC Launchpad or Infoview.

Symptoms:

     When tried to start Tomcat in CCM,  it starts and stops immediately.

     When tried to start from Control Panel, Services, it started few times by displaying “Starting” and after few seconds service status disappears.

At first, I thought this might be a Windows Service Pack issue.  

1) When checked in Event Viewer it displayed the following error. 

image

2) Downloaded SP2 for Windows 2003 and installed.
    To find out whether your system has already SP2 installed, you can either go to Add Remove Programs or Use the following spCheck Tool from Microsoft.
   
http://support.microsoft.com/kb/279631 

    I tried starting the Apache Tomcat again but still in vain, no success yet. Thinking

3) At this time, I started looking the other way around, that is on the application server Apache Tomcat side.   Looked into Tomcat log files found at the following path on my machine D:\BusinessObjects31\Business Objects\Tomcat55\logs.  (Check the correct location for your machine, default location would be [drive]:\Program Files\Business Objects\Tomcat55\logs),   I found the following error shown below from jakarta_service_date.log. 

image

This gave a little clue that the Apache Tomcat 5.5 service is not able to initialize itself and shuts down immediately,  and that is nothing but it cannot find the JRE on my machine, hence cannot initialize itself.  To resolve the issue, I did the following two things:

a) Setting up the JAVA_HOME
    
       My JAVA_HOME directory location was at D:\BusinessObjects31\Business Objects\javasdk\jre\bin\server.  Following screenshot shows the JAVA_HOME setting.

image

      I also made sure that javaw.exe is also available at the same location “D:\BusinessObjects31\Business Objects\javasdk\jre\bin\server”  when Tomcat 
          
initializes JVM.

SNAGHTML1069b99
b) Setting up Apache Tomcat to look for jvm.dll or javaw.exe at the correct location.

    To do this, I need Apache Tomcat Service name.  I found it from here Start –> Settings –> Control Panel –> Administration Tools –> Services, Clicking on 
    Apache 
Tomcat Service to open its properties window,  On the General Tab, I was able to find the Service Name registered on my server, that is BOE120Tomcat.

image

        Opened a command prompt window and travelled to Tomcat55 bin directory, and then executed the following command tomcat52.exe //ES//BOE120Tomcat.
          Please see the screenshot below.

       After the command execution successful, It displayed a window of Apache Tomcat 5.5.20 Properties shown below, I was able to change the Java Virtual Machine 
          path including the initial and max. memory that  it can use 128MB and 512 MB respectively and then I clicked ‘OK’ to close the window.

 

image

         Rebooted the Server and directly went to Services in Administration Tools to Start the Apache Tomcat 5.5 service.  What I see you can’t imagine… the service starts 
          without any issue. 

         Enabled all the BOE Services, Logged onto CMC Lauchpad, Scheduled few documents in Infoview … everything is working perfectly.Wave

Thanks for stopping by and feel free to discuss any alternative solutions through comments.

April 23, 2011

Crystal Reports 2008: Failed to open the connection. test_oracle Details: [Database Vendor Code: 12154 ] – Resolved

Filed under: SAP Crystal Reports — Irfan @ 12:13 am

After spending lot of time on Google to fix the connectivity issue on Windows 7 64bit between Oracle 10g and Crystal Reports 2008 SP3, I thought I should write this post that may assist some of my readers including me for future reference down the road.  There is not much information available on the web and not any documentation about this issue.  The above error appears sometimes in Business Objects 3.1 SP3 Infoview or when you connect Crystal Reports 2008 Designer Tool to Oracle 10g database.

Remember the following steps:
a) Crystal Reports 2008 SP3 is a 32 bit application.
b) Business Objects 3.1 SP3 is a 32 bit application.
c) So, install  Oracle 10g 32 bit or 64 bit, But install Oracle 10g client connectivity software of 32 bit only to interact with Crystal Reports 2008.
d) If you want to use ODBC, you can connect using Microsoft ODBC drivers that are installed by default or you can also download Data Direct 5.3 drivers. or try this link https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/bobj_download/main.htm

Following is my environment on which connection is successful:
Operating System:   Windows 7 Ultimate (64 bit)
Database:                Oracle 10g 10.2.0.3 (32 bit)
Reporting Tool:       Crystal Reports 2008 SP3 (32 bit)
Enterprise:               Business Objects 3.1 SP3 (32 bit)

Using ODBC
1) create a 32 bit system DSN on the client machine (or the server).
    On a 64bit operating system, you will find 32 bit ODBC setup file in the following path [drive:/]Windows/sysWOW64/odbcad32.exe

2) Open Crystal reports designer tool, and try connecting to the System DSN created in step 1.  Check the following screenshot, Crystal Reports 2008 SP3, Connection tested with ODBC and it is successful on my machine.  Oh what a relief !!

SNAGHTML7fcf80

Using TNSNAMES.ORA
2) Check the following screenshot, Crystal Reports 2008 SP3, Connection tested with TNSNAMES.ORA (i.e. Oracle Server)
 

SNAGHTML772f8a

Make sure that you install all the correct 32 bit versions of Crystal Reports 2008, Business Objects 3.1 and Oracle 10g to be compatible with each other. The report should work fine in Infoview and local PC.

Share your thoughts or any alternative solutions to resolve this error. Have a Good day.!!  Smile

Create a free website or blog at WordPress.com.