Error HTTP Status 500 While Accessing CMC/BI Launchpad in SAP BI 4.0

Environment:

• Windows
• Tomcat 6
• SAP BusinessObjects BI 4.0
• Possibly the installation of SAP BusinessObjects Explorer 4.0

Resolution:

1. Stop Tomcat
2. Go to the Tomcat Work directory (usually C:\Program Files\SAP BusinessObjects\Tomcat\work) and continue down to Catalina\localhost.
3. Delete the BOE directory - this gets recreated on startup.
4. Start Tomcat
5. Wait a few minutes while Tomcat recreates the directory and regenerates it's cache.
6. Attempt to log into the CMC.

If this fails, then try redeploying the WAR file once again, initially without using wdeploy as follows:

1. Stop Tomcat
2. Go to the Tomcat Web App directory (usually C:\Program Files\SAP BusinessObjects\Tomcat\webapps)
3. Delete the BOE directory - this gets re-deployed by tomcat due to the BOE.xml file in tomcat\conf\Catalina\localhost\.
4. Go to the Tomcat Work directory (usually C:\Program Files\SAP BusinessObjects\Tomcat\work) and continue down to Catalina\localhost.
5. Delete the BOE directory - this gets recreated on startup.
6. Start Tomcat
7. Wait a few minutes while Tomcat recreates the directory and regenerates it's cache.
8. Attempt to log into the CMC.

If this fails, then try redeploying the WAR file using wdeploy.

1. Go to the wdeploy directory in the BusinessObjects directory
2. Check that the config.tomcat6 file points to the right location
3. Run the following command: wdeploy.bat tomcat6 deployall
4. Attempt to log into the CMC.

Hope you find this useful.

Cheers,
Umang Patel
+919979084870
SAP BO BI Solution Architect/Consultant

SAP BI 4.0 + SSL

1. Execute the following from a command line to create a .keystore file:

Windows User :

%JAVA_HOME%\bin\keytool -genkey -alias tomcat -keyalg RSA
 

2. Upon executing the above command, you will be prompted for a keystore password, your full name, organizational unit, organization, city, state and country. At the end, you will be prompted for the keystore password again. This has to be the same password as the password you entered previously. Newer versions of the keytool will prompt you to hit ENTER to keep it the same.

3. Once finished, a self signed .keystore file will have been created in your user"s home directory:

For example: C:\Program Files\Documents and Settings\Administrator

4. Move this file from this directory to one in the Business Objects folder structure:

For example: C:\Program Files\Business Objects

5. Browse to Tomcat's server.xml file and create a backup file:

For example: C:\Program Files\Business Objects\Tomcat\conf\server.xml

6. Open and edit the server.xml file in wordpad.

7. Uncomment the section below and add the two commands after keystorePass & keystoreFile. This section needs to reference the new location of the .keyfile and the password you specified when creating it.

<!-- Define a SSL Coyote HTTP/1.1 Connector on port 8443 -->
 
<Connector port="8443"
          maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
          enableLookups="false" disableUploadTimeout="true"
          acceptCount="100" debug="0" scheme="https" secure="true"
          clientAuth="false" sslProtocol="TLS" keystorePass="password" keystoreFile="C:\Program Files\Business Objects\.keystore"/>

8. Restart Tomcat and it should now be accessible using:

https://servername:8443

Hope you find this useful.

Cheers,
Umang Patel
+919979084870
SAP BO BI Solution Architect/Consultant