Create database client on BO

[Former Member]

Hi all,

I want to install BO Edge series 3.0 on existing Oracle database server. I read "Business Objects Edge Series Installation Guide for Linux", I do not understand the step create "database client". where is script setupint.sh? Can you show me mode of installation clearly? how to create database client?

Thanks

Duypm

[Former Member · Accepted solution]

Hi,

I can not find "BOBJ ENTERPRISE XI 3.0". I can find some production below in my SAP Support:

"SAP BusinessObjects packages and products

• Ad-hoc Querying package

+ BOBJ INTGR. FOR SAP XI 3.0

• Enterprise Query, Reporting, and Analysis package

+ BOBJ INTGR. FOR SAP XI 3.0

+ BOBJ XCELSIUS ENTERPRISE 2008

+ CRYSTAL REPORTS 2008 V0

• Visualization and Reporting package

+ BOBJ INTGR. FOR SAP XI 3.0

+ BOBJ XCELSIUS ENTERPRISE 2008

+ CRYSTAL REPORTS 2008 V0

• BOBJ EDGE BI

• BOBJ EDGE INTEG. FOR SAP SOL.

• BOBJ INTGR.FOR SAP

• BOBJ Knowledge Accelerator

+ SAP PRODUCTIVITY PAK BY RWD

• BOBJ XCELSIUS ENTERPRISE

• CRYSTAL REPORTS

• Address Directories

"

Can you instruct me, how to download client Tool??

Please, help me!!!!

Thanks

Duypm

[former_member142702 · Accepted solution]

Hi,

please download the windows version of BO Edge XI 3.0 (1 x EXE file + 2 x RAR files) and start the exe file. Select the directory where you want to extract the installation files into. After the extraction is finished, the installation will start automatically. Just abort the installation in the intro screen and go into the directory you extracted your installation files into. From there navigate to 51034355->Collaterals->Client Installer and start the setup.exe found there. This way you can install the client tools on a windows machine.

You can also download and install CRYSTAL REPORTS 2008 V0 and BOBJ XCELSIUS ENTERPRISE 2008 found under the Enterprise Query, Reporting, and Analysis package.

Please keep in mind that if you want to integrate with SAP R/3 or SAP BW systems you need to download and install _ (should be installed AFTER all other packages) _ the BOBJ INTGR. FOR SAP XI 3.0 on both your linux server and your windows client.

Regards,

Stratos

PS:

[Former Member]

Hi,

The issue is solved.

Thank you very much!!!

Duypm

[Former Member]

Hi,

I re-created user database and re-install. It is ok!! The issue is solved. But I do not know client software for connect it. Can you give me link for download Client Tool??

Thanks

Duypm

[former_member142702]

Hi,

go to [http://service.sap.com/installations] , navigate through Entry By Application Group->SAP BusinessObjects packages and products->Enterprise Query, Reporting, and Analysis package->BOBJ ENTERPRISE XI 3.0->Installation->Windows Server and choose to download the BOBJ ENTERPRISE XI 3.0 (CLIENT TOOLS) WINDOWS package. Additionally you can download Crystal Reports 2008 Designer V0 and XCelsius 2008 (To be found also under Entry By Application Group->SAP BusinessObjects packages and products->Enterprise Query, Reporting, and Analysis package )

Regards,

Stratos

[Former Member]

Hi,

I run the cmsdbsetup.sh utility and try to recreate the CMS database. But It show below:

-

---

Business Objects

Please specify the name of the Server Intelligence Agent.

This Server Intelligence Agent must have at least one local CMS.

[quit(0)]

-

---

[]cms

The selected Server Intelligence Agent does not have a local CMS.

Specify the name of another Server Intelligence Agent.

Please press Enter to continue...

"

Perhaps I created unsuccessful SIA.

Please, help me in this case!!!!

Thanks

Duypm

[former_member142702]

Hi Dymp,

can you consider reinstalling the software again? I am assuming that you are trying to do a new installaiton here so there is no risk of loosing content if you remove the previous installation and start agaian. During the new installation you should document your inputs in every single step. This way, if this also fails we can find out more easily where something went wrong.

In order to uninstall the product please follow these steps:

1) Stop the tomcat server (tomcatshutdown.sh)

2) Run the AddOrRemoveProducts.sh script and choose to uninstall the entire product

3) After that just remove the bobje directory.

4) Remove all tables the oracle user "BO" owns.

Before you start with the new installation please make sure that your oracle instance uses a Unicode character set, such as UTF-8. If you are not sure about this then just issue the following command in your database und post the output here:

SELECT * FROM nls_database_parameters;

During the new installation please do not forget to do the following:

1) Choose to install und use Tomcat as Web Server ( If your installing BO Edge Tomcat is the only option anyway)

2) In the setup screen for your BOBJ repository, choose to use an existing oracle instance.

3) Please define an administrator password für your BOJB repository during the installation. Note down the password.

[Former Member]

Hi,

I post my ccm.config file below,

"#!/bin/sh

SERVICENAME_AUDIT="pts"

NAMESERVER="sap-vpmn"

DBTYPE="Oracle"

INSTALLTYPE="new"

REINIT="no"

BOBJEVERSION="12.0"

SHUTDOWNPORT="8006"

REGFILE="/home/bo1/businessobjects/bobje/data/.bobj"

DBTYPE_AUDIT="Oracle"

CLUSTER_NAMESERVER=""

CONNECTORPORT="8081"

SIAPORTNUMBER="6420"

BOBJELANG="en"

BOBJELICENSEKEY="CV51R-JY3MV20-000505Y-F1B3"

cmsLAUNCH='"/home/bo1/businessobjects/bobje/enterprise120/generic//bobjrestart.sh" -protect "/home/bo1/businessobjects/bobje/enterprise120/linux_x86//boe_cmsd" -name bosia.cms -port 6402 -loggingPath "/home/bo1/businessobjects/bobje/logging/" -pidFile "/home/bo1/businessobjects/bobje/serverpids/bo1_cms.pid" -dbinfo "/home/bo1/businessobjects/bobje/enterprise120/linux_x86/_boe_bosia.dbinfo" -restart -fg'

PRODUCTID_NAME="BusinessObjects"

PRODUCTID_VER="12.0"

LOCALNAMESERVER="sap-vpmn"

PIDDIR="/home/bo1/businessobjects/bobje/serverpids"

CMSCLUSTER="no"

REDIRECTPORT="8444"

SIANODENAME="bosia"

INSTALL_DIR="/home/bo1/businessobjects/bobje/"

DEFAULT_NAMESERVER="sap-vpmn"

BOBJEUSERNAME="bo1"

CMSNAMESERVER="sap-vpmn"

DATABASEUID="bo"

BOBJEDIR="/home/bo1/businessobjects/bobje/"

BOBJEINSTALLLOCAL="user"

SERVICENAME="pts"

CMSPORTNUMBER="6402"

CLUSTERPORTNUMBER="6400"

"

Some tables created by BO. You can see below. I granted dba privilege for BO user.

OWNER TABLE_NAME TABLESPACE_NAME CLUSTER_NAME IOT_NAME STATUS PCT_FREE

1 BO CMS_INFOOBJECTS6 BO VALID 10

2 BO CMS_ALIASES6 BO VALID 10

3 BO CMS_IDNUMBERS6 BO VALID 10

4 BO CMS_VERSIONINFO BO VALID 10

5 BO AUDIT_EVENT BO VALID 10

6 BO AUDIT_DETAIL BO VALID 10

7 BO SERVER_PROCESS BO VALID 10

8 BO EVENT_TYPE BO VALID 10

9 BO DETAIL_TYPE BO VALID 10

10 BO APPLICATION_TYPE BO VALID 10

11 BO CMS_RELATIONS6 BO VALID 10

12 BO CMS_LOCKS6 BO VALID 10

13 BO CMS_CCFRONTIER6 VALID 10

14 BO CMS_FRONTIER6 VALID 10

15 BO CMS_ROOTFRONTIER6 VALID 10

Please, help me!!!!

Thanks

Duypm

[former_member142702]

Hi,

please run the cmsdbsetup.sh utility and try to recreate the CMS database. Tell me if this succeeded.

Regards,

Stratos

[Former Member]

Hi,

I do not find any error message like "TNS: could not resolve the connect identifier specified" is contained in the log files!!

Please, help me!!!!

Thanks

Duypm

[former_member142702]

Hi,

can you please post your ccm.config file here?

Regards,

Stratos

[former_member142702]

Hi,

can you also please check if there are any tables created in the Oracle DB under the DB user you used to setup the repository. The SQL statement that extracts this information looks something like this: select * from usertables where owner='BO'_. What kind of permissions does the user 'BO' has in the oracle database?

Regards,

Stratos

[Former Member]

Hi,

I can not recreate SIA. After I recreate SIA, I do not see new SIA in list

"

-

---

Business Objects

cms (boe_cmsd)

[back(1)/quit(0)]

-

---

[back]

"

I check log file, it show as below:

"Starting CMS...

argv[0] = /home/bo1/businessobjects/bobje/enterprise120/linux_x86/boe_cmsd

argv[1] = -name

argv[2] = newsia.cms

argv[3] = -dbinfo

argv[4] = /home/bo1/businessobjects/bobje/enterprise120/linux_x86/_boe_newsia.dbinfo

argv[5] = -port

argv[6] = 6402

argv[7] = -dbdriver

argv[8] = oracledatabasesubsystem

argv[9] = -connect

argv[10] = DSN=pts;UID=bo;PWD=bo001

argv[11] = -auditdbdriver

argv[12] = oracleauditdbss

argv[13] = -auditdbconnect

argv[14] = DSN=pts;UID=bo;PWD=bo001

argv[15] = -fg

argv[16] = -restart

Using working directory /home/bo1/businessobjects/bobje.

Logging on to sap-vpmn:6402 as user Administrator with secEnterprise authentication...

Could not log into CMS "sap-vpmn:6402" with the given credentials

Stopping CMS...

"

Please, help me!!!

Thanks

Duypm

[former_member142702]

Hi Duypm,

can you please check if an error message like "TNS: could not resolve the connect identifier specified" is contained in the log files?

Regards,

Stratos

[Former Member]

Hi,

1. I listed SIA by run serverconfig.sh. It show

"----

---

Business Objects

cms (boe_cmsd)

[back(1)/quit(0)]

-

---

[back]

"

2. I could not run tnsping without any arguments. When I run without arguments, it show

"[bo1@sap-vpmn ~]$ tnsping

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 29-APR-2009 09:04:12

Copyright (c) 1997, 2005, Oracle. All rights reserved.

TNS-03502: Insufficient arguments. Usage: tnsping <address> [<count>]

"

3. In my ORALCE_HOME do not see lib32 directory.I just have lib directory

Please, help me in this case!!!

Thanks

Duypm

[denis_konovalov]

Is cms the name you gave for your sia during installation ?

Let's try this :

run serverconfig.sh and create a new SIA. Name it something like "newsia", with no quotes.

use options to install sia with all default servers and to re-create local sia if already exist in cms.

then run cmsdbsetup.sh select this new sia and re-create connection to your CMS DB.

tell us what happens.

Have you looked in bobje/logging directory, are there any usefull logs for us there ?

[Former Member]

Hi,

1.My LD_LIBRARY_PATH is /home/bo1/oracle/product/10.2.0/client_1/lib

2.tnsping is

'[bo1@sap-vpmn bobje]$ tnsping pts

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 28-APR-2009 22:48:18

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/home/bo1/oracle/product/10.2.0/client_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sap-vpmn)(PORT = 1527))) (CONNECT_DATA = (SERVICE_NAME = pts)))

OK (0 msec)

"

3. [bo1@sap-vpmn bobje]$ ls -ltr

total 308

-rwxr-xr-x 1 bo1 dba 1723 Jun 24 2008 boe_reposcan.sh

-rwxr-xr-x 1 bo1 dba 34798 Jun 24 2008 cmsdbsetup.sh

-rwxr-xr-x 1 bo1 dba 2169 Jun 24 2008 ccm.sh

-rwxr-xr-x 1 bo1 dba 407 Jun 24 2008 tomcatstartup.sh

-rwxr-xr-x 1 bo1 dba 304 Jun 24 2008 tomcatshutdown.sh

-rwxr-xr-x 1 bo1 dba 1187 Jun 24 2008 stopservers

-rwxr-xr-x 1 bo1 dba 1191 Jun 24 2008 startservers

-rwxr-xr-x 1 bo1 dba 19912 Jun 24 2008 sockssetup.sh

-rwxr-xr-x 1 bo1 dba 153914 Jun 24 2008 serverconfig.sh

drwxr-xr-x 7 bo1 dba 4096 Apr 28 17:35 jdk

drwxr-xr-x 3 bo1 dba 4096 Apr 28 17:36 crystalreportviewers12

drwxr-xr-x 4 bo1 dba 4096 Apr 28 17:38 samples

drwxr-xr-x 9 bo1 dba 4096 Apr 28 17:40 tomcat

drwxr-xr-x 2 bo1 dba 4096 Apr 28 17:41 ShData

drwxr-xr-x 2 bo1 dba 4096 Apr 28 17:41 LocData

drwxr-xr-x 15 bo1 dba 4096 Apr 28 17:41 enterprise120

-rwxr-xr-x 1 bo1 dba 294 Apr 28 17:41 LanguagePacks.xml

drwxr-xr-x 6 bo1 dba 4096 Apr 28 17:41 java

-rwxr-xr-x 1 bo1 dba 918 Apr 28 17:41 odbc.ini

-rwxr-xr-x 1 bo1 dba 107 Apr 28 17:41 eventupdater.sh

drwxr-xr-x 6 bo1 dba 4096 Apr 28 17:44 setup

drwxr-xr-x 3 bo1 dba 4096 Apr 28 17:44 wcs

drwxr-xr-x 8 bo1 dba 4096 Apr 28 17:44 data

-rw-rr 1 bo1 dba 1098 Apr 28 17:45 ccm.config

drwxr-xr-x 3 bo1 dba 4096 Apr 28 17:45 tmp

drwxr-xr-x 2 bo1 dba 4096 Apr 28 17:45 serverpids

drwxr-xr-x 2 bo1 dba 4096 Apr 28 17:45 logging

4.When I preform cmsdbsetup.sh and fill information. It show

"

-

---

Business Objects

Please specify the name of the Server Intelligence Agent.

This Server Intelligence Agent must have at least one local CMS.

[quit(0)]

-

---

[]cms

The selected Server Intelligence Agent does not have a local CMS.

Specify the name of another Server Intelligence Agent.

Please press Enter to continue...

"

have you seen this case yet?? Do you have solution in this case?

Thanks

Duypm

[denis_konovalov]

Could you please run serverconfig.sh and tell it to list all sia, what do you see ?

Could you lease run tnsping without any arguments ?

your LD_LIBRARY_PATH points to \lib directory, can you go to ORACLE_HOME dir and see if \lib32 exist ?

If it does - you need to point LD_LIBRARY_PATH to it instead.

then create new sia and re create CMS DB connection using cmsdbsetup.sh

[Former Member]

Hi Stratos,

I install to CMS but it show error in log file below:

"[info] Return code from cmslogon.jar: 512

[error] [PostInstallScripts::WaitForCMS] CMS is not started, giving up."

Please, Can you help me???

Thanks

Duypm

[denis_konovalov]

could you please post following info to help us help you :

1. what is your LD_LIBRARY_PATH ?

2. run tnsping , show us output ?

3. do ls -ltr in bobje directory , show us output ?

4. What error you get in cmsdbsetup.sh when you setup CMS DB connection ?

[Former Member]

Hi Stratos,

I setup to step "Enter the information for your new CMS". I fill information (TNS_NAME, USERNAME, PASSWORD) the system required. But it error. I checked by sqlplus with tns_name, username, password on command line. It is ok.Can you help me!!!

Thanks

Duypm

[former_member142702]

Hi,

is the path to the libraries of your Oracle driver included in the LD_LIBRARY_PATH environment variable for your BOBJ installation user?

Do you use 32bit or 64bit Linux?

Look for a directory with the name "logging" within your BOBJ installation directory and look for error messages in the log files created there during the installation.

Regards,

Stratos

[Former Member]

Hi Stratos,

My database is Oracle.I need information for my new CMS. how to create it? Can you instruct me step by step?

Thanks

Duypm

[former_member142702]

Hi Duypm,

these are the step you have to follow. I assume you already have an oracle server installed somewhere.

1) Create an new Oracle DB instance on your Oracle server (optionally you can use an existing one. Keep in mind that the performance of your BOBJ system may get influenced by users using the same instance for other purposes ).

2) Create a user in your newly (or existing) database instance. The user must have full access in its own schema ( mandatory)

3) Download and install the linux oracle client (32bit) in your machine. (mandatory)

4) Define the connection to your Oracle server by modyfying the tnsnames.ora file (mandatory)

For more info on the above steps please refer to the oracle documentation.

You can use the name and password of your newly created user in order to setup a new repository for your BOBJ installation.

Regards,

Stratos

[Former Member]

The CMS DB is created and initialized during installation time. In BO Enterprise you can change the connection parameters or recreated the CMS DB using the cmsdbsetup.sh. Check if you have the cmsdbsetup.sh in your installation under the bobje directory. Once you run it, to recreate the CMS DB is pretty straight forward. Yo can find more information in the BO Enterprise Administrator's Guide under UNIX Tools.

Hope this help, Leo

Edited by: Leonidas Zuloaga on Apr 27, 2009 1:25 PM

[denis_konovalov]

3 things :

1. Why would you install Edge 3.0 when we already have Edge 3.1 ?

2. Installing Edge on a server where Oracle DB is running is a bad idea because of performance issues you're going to have. Edge and Oracle will be fighting for resources.

3. If you are installing on same server as Oracle DB, you do not need to install Oracle drivers, they are already there.

If you are installing on a server which has no Oracle DB, then you have to install Oracle DB drivers, which you will have to get from Oracle.

BO software cannot generate DB drivers.

[Former Member]

HI all,

Please help me!!! How do I create database client for BO??? Please...!!

Thanks

duypm

[former_member142702]

Hi,

can you please clarify if you want to use your oracle server ALSO for the BOBJ repository or if you just want only to build BO reports on data residing on your oracle server and use the MySQL DB (coming with your BOBJ installation) for your repository database instead?

At any case you have to install first the oracle client on the Linux machine you plan to install your BOBJ server on. You can download such a client from the oracle site. Make sure you download and install the 32bit version of the oracle client even if you are using a 64bit Linux version.

Regards,

Stratos