Unable to login into my fresh install of BO 4.0 edge edition???

[Former Member]

I am unable to login into my fresh install of BO 4.0 edge edition?

I have installed the trial version of my Business objects 4.0 BI edge edition. I have been trying to get this working for last 2 weeks. I am still unsuccesfull. I have setup ODBC connection to my Microsoft SQL express server.

I keep getting error message.

"Account information not recognized: Could not reach CMS . The CMS on machine was stopped due to a critical error. (FWM 20031) "

Any help is greatly appreciated.

[Former Member]

   Anyone, know what steps I can take to create my own Reports. and start creating my own Universe???? SQL statements.  Like the boxes and connect with Inner Join queries?????

any help is appreciated.

[andreasja_schneider]

You need to use the software called "Information Design Tool" (IDT), which is part  of the "SAP BI Business Objects client tools", this is NOT a web based tool. The SAP Busobjects Client Tools are a separate download and are not included in your server install!

I kindly suggest reading up the free SAP BI Tutorials here: http://scn.sap.com/docs/DOC-7725

and attending some official SAP training courses to get you started:  https://training.SAP.com

[Former Member]

Thanks for the post and the links. extremely helpful.  Do you know where can I download Information Design Tool?  Is there a trial version? or licensed only?

[Former Member]

Hi John ,

You need to check couple of things here .

1. Can you connect to CMS database using DNS created for CMS database .

2. If you can login  , then please check whether BO repository tables are created or not. If installation is proper then you should be able to see around 7 tables.

Seeing the event log that you have posted  , it seems BO is not able t connect to CMS database .

Make sure CMS database is  64 bit database server and you have created DNS for 64 bit ODBC only.

Kindly note SIA is runnning does not mean all BO services are up and runnning.

Please let me know your observations.

Regards

Jeevan

[Former Member]

1. Can you connect to CMS database using DNS created for CMS database?

     I don't know.  I created a ODBC connection to my SQL server using Windows authentication.  When I run my business objects setup file.  It shows me the database I created with the BO4_CMS name.

2. If you can login  , then please check whether BO repository tables are created or not. If installation is proper then you should be able to see around 7 tables.

Yes, under the BO4_CMS database in my SQL server. It shows around 7 tables in the end it shows number 7.

I don't know what to do after that. I am lost.  I keep getting authetication error. saying my login is not good.

I will try to re-install the BO again. see what happens.

[Former Member]

   during setup it asks me about cluster key?  Is cluster key something  I make it up? or Do I find that information somewhere in my sql server?

[Former Member]

Cluster key is something, that is required during installation of BO/BI 4.0/4.1

You would have it may be in a a text or word file, where you maintained passwords etc.

Cluster key is the key component to go ahead!

Regards,
Atul B

[Former Member]

  when the login page  http://localhost:8080/BOE/CMC  opens up.

what do I put in for username, during setup it never asked for username?

what is the username?

password I setup already during setup. I tried username Administrator and the password I created during setup. It is not working.  Take a look at the screenshot

[Former Member]

If you forgot the password, follow below KB to reset the password

           
              1679970  - How to reset the Administrator password in Business Intelligence Platform 4...

[Former Member]

Based on the error message, Looks like the CMS is down, make sure SIA is up and running.

[Former Member]

    what is a cluster mean? does it mean one database?

for example, two clusters cannot be on the same network? meaning 2 databases???

[Former Member]

Hello,

This link may also help you:

There are few possible causes for this error.

Thanks & Regards,

Insaf

[Former Member]

Hi,

Cluster means, more than one system.

When two BO servers are connected to a single datasource ( CMS DB ), they are termed as in cluster.

To cluster them, you require a key, which is the cluster key.

Cluster key is required when you want to connect to your system db.

check what errors you see in event viewer.

check if CMS.exe is running in task manager.

If not, try to stop SIA. Go to SIA properties. go to startup and configuration tabs and check if you get any pop up errors during the same.

If not, go to configuration tab>click on specify> select the first option ( update data source ) connect to your db and check if you are able to connect succesfully.

Regards,

Atul B

[Former Member]

   I have some success. I am able to log into administrator CMC and BI launch pad. things are moving slow but successfull.

  here is a error message I got after login into CMC as administrator.

check attachment for error message.

[Former Member]

  thanks for posting.  I have some success to login into BO. 

  Now, under CMC login,  how do I start creating my own universe. and start creating reports.

do you know what are the steps?

[Former Member]

HI John,

check, CMC>license keys? all good?

check servers>list servers> all running?

Regards,

Atul B

[Former Member]

John,

If you go to the CCM, you can log into the SIA and see all the servers inside running and enable?

[Former Member]

these are the services I see.

[Former Member]

Hello John,

Server Intelligence Agent (SIA) is just a container for other BO Services. In order to login to BusinessObjects application, cms.exe should be running in Task Manager.

At this moment, first restart the server Intelligence Agent and see if it spawns cms.exe.

else need to enable trace to debug the issue.

-Mahesh

[Former Member]

this is the error found in my event viewer. I have no idea what to do next.

[Node Name: WIN_QRBR7Z3GIFR]

[User Name: WIN-QRBR7Z3GIFR$]

Server Intelligence Agent: CMS WIN_QRBR7Z3GIFR.CentralManagementServer has failed and the Server Intelligence Agent has not been able to connect to the cluster. Please verify your CMS port and database settings are correct.

[Former Member]

here is another error found.

The root server reported an error Initialization Failure. (Reason: SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database "BO_CMS". Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "BO4_CMS" requested by the login. The login failed.SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database "BO_CMS". Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "BO4_CMS" requested by the login. The login failed. CDatabase::Open failure.

).

[onkarvelhals]

Hi Josh,

Host file does look good for now.

According to the error message, it seems like CMS has the connection with CMS database. (unable to connect...).

Requirements:

Administrator Password, Cluster Key, CMS database, connection details

steps:

1. Run CCM

2. Right click Stop Server intelligence agent (SIA).

3. Right click again select properties> configuration tab.

4. take a screenshot of error message.

5. click specify, select database type and enter details.

Hope this helps.

Regards,

Onkar

[Former Member]

It looks like CMS is not able to establish connectivity with CMS Database.

Please check connectivity of DSN.

In ODBC Manager, go to the DSN that CMS uses to connect with CMS DB.

Test Data Source.

[Former Member]

  I can't even access the CMC administrator.  Does anyone know what would be the cluster key?

[Former Member]

thanks, your steps have solved many issues.  please, refer to my new error post.

do you know how I can start creating my own universe????

[onkarvelhals]

Hi John,

Also, make sure that your host file entries look good.

You should have your loopback address and your domain name with IP address (separated with tab).

e.g

127.0.0.1     localhost

10.x.x.x     mydomainnamefqdn.com     hostname

Regards,

Onkar

[Former Member]

"Also, make sure that your host file entries look good.

You should have your loopback address and your domain name with IP address (separated with tab).

e.g

127.0.0.1     localhost

10.x.x.x     mydomainnamefqdn.com     hostname

Regards,

Onkar "

==

  How do I verify that host file entries look good? I don't know how to verify this? what steps do I do?

How do I check for loopback address?  Is this directory in the C: drive or somewhere else?

thank you for posting.

[onkarvelhals]

Windows

Start> Click Run> Drivers> etc> hosts

open hosts file in notepad.

[Former Member]

thanks  

FYI => I am runnig windows 2008 standard server with SP2.

[Former Member]

here is my drivers/etc/hosts  file,

# Copyright (c) 1993-2006 Microsoft Corp.

#

# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.

#

# This file contains the mappings of IP addresses to host names. Each

# entry should be kept on an individual line. The IP address should

# be placed in the first column followed by the corresponding host name.

# The IP address and the host name should be separated by at least one

# space.

#

# Additionally, comments (such as these) may be inserted on individual

# lines or following the machine name denoted by a '#' symbol.

#

# For example:

#

#      102.54.94.97     rhino.acme.com          # source server

#       38.25.63.10     x.acme.com              # x client host

127.0.0.1       localhost

::1             localhost

[Former Member]

Hi John,

Couple of things...

1. Make sure you supply port number along with System name while logging into CMC.

2. Do you see cms.exe running in the Windows Task Manager on the server?

3. Check Windows Event Viewer if there is any port communication issues.

Regards,

Mahesh

[Former Member]

1. Make sure you supply port number along with System name while logging into CMC.

  The system name and port number is for SAP authentication. Should I not log in as Windows AD authetication or  Enterprise.  This is the free trial version I am using.

2. Do you see cms.exe running in the Windows Task Manager on the server?

I will check on this and report back to you.

3. Check Windows Event Viewer if there is any port communication issues.

How do I perform this step. I don't know where to look for the Windows Event Viewer. I am copletely new to this Business Objects deal.

thanks for replying.

[Former Member]

I checked the task manager.  cms.exe is not running in task manager.

Also, I did see the sia service running.

what step can I take next?

thanks for the help.