cancel
Showing results for 
Search instead for 
Did you mean: 

Restore my dev environment

Former Member
0 Kudos

Hi All,

I have BO XIR3 in dev & prod environment.

After our oracle upgrade refresh, my dev cms database got overwritten from prod.

I have restore the dev cms database (db back-up before the refresh) & bring the server up;

but now my dev cmc is showing all the prod server (Login to cmc > Servers).

How can I restore my dev environment so it will pointing to correct dev server?

Thanks & Best Rgds,

-M-

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Yes, my question has been answered.

Former Member
0 Kudos

I did try to 'recreate the cms' Page 183 on the Guide.

Failed for a couple of times. Finally I found out there is a problem in previous database (take 1 minute to login). Therefore BO not happy with it.

I did change to other dev server and it reinitialize the DB. It work ok now.

Thx.

Former Member
0 Kudos

Hi Ashwini,

I tried to use the ccmsdbsetup "reinitialize" but no luck.

It seems does not find cluster name.

The linux screen:

Current CMS Data Source: OLDCAN04

err: ERROR Failed to get cluster name. (STU00165)

err: Error description: Internal error: An unknown exception has occurred.

err: ERROR Failed to get auditing data source name. (STU00164)

err: Error description: The data source name (DSN) could not be extracted from the connection string.

update (Update Data Source Settings)

reinitialize (Recreate the current Data Source)

copy (Copy data from another Data Source)

changecluster (Change current cluster name)

selectaudit (Select an Auditing Data Source)

(update(6)/reinitialize(5)/copy(4)/changecluster(3)/selectaudit(2)/back(1)/quit(0))

Logging cmsdbsetup20100825_141738.log :

Wed Aug 25 2010 14:17:51 GMT1000 (EST) /opt/busobj/bobje/setup/jscripts//ccmunix.js started at Wed Aug 25 2010 14:17:51 GMT1000 (EST)

Wed Aug 25 2010 14:17:51 GMT+1000 (EST) About to process commandline parameters...

Wed Aug 25 2010 14:17:51 GMT+1000 (EST) Finished processing commandline parameters.

Wed Aug 25 2010 14:17:51 GMT+1000 (EST) Warning: No password supplied, setting password to default.

Wed Aug 25 2010 14:17:51 GMT+1000 (EST) Warning: No username supplied, setting username and password to default.

Wed Aug 25 2010 14:17:51 GMT+1000 (EST) Warning: No authentication type supplied, setting authentication type to default.

Wed Aug 25 2010 14:17:51 GMT+1000 (EST) Warning: No CMS name supplied, setting CMS name to machine name.

Wed Aug 25 2010 14:17:51 GMT+1000 (EST) err: ERROR Failed to get cluster name. (STU00165)

Wed Aug 25 2010 14:17:51 GMT+1000 (EST) err: Error description: Internal error: An unknown exception has occurred.

...

...

Starting CMS...

argv[0] = /opt/busobj/bobje/enterprise120/linux_x86/boe_cmsd

argv[1] = -name

argv[2] = ausyd23as07.cms

argv[3] = -dbinfo

argv[4] = /opt/busobj/bobje/enterprise120/linux_x86/_boe_ausyd23as07.dbinfo

argv[5] = -port

argv[6] = 6400

argv[7] = -fg

argv[8] = -restart

Using working directory /opt/busobj/bobje.

Logging on to ausyd23as07:6400 as user Administrator with secEnterprise authentication...

The CMS has terminated unexpectedly with exit code 0.

UpdateClientActionsProp started...

The CMS is: ausyd23as07:6400

The username is: Administrator

The resource name is: null

The si_kind are: 'ClientAction', 'ClientActionUsage', 'ClientActionSet', 'AuditEventInfo', 'MetricDescriptions', 'Service', 'ServiceCategory', 'ServiceContainer', 'CustomRole', 'Federation'

The CMS DB are: ci_appobjects,ci_systemobjects,ci_infoobjects

The CMS bags are: *

The directory of *.jar files is: /opt/busobj//caf

The list of *.jar is: dfoproperties_Xcelsius_en.jar,dfoproperties_DeskI_en.jar,dfoproperties_Framework_en.jar,dfoproperties_CrystalReports_en.jar,dfoproperties_MDA_Client_en.jar,dfoproperties_Connectivity_en.jar,dfoproperties_MDA_Services_en.jar,dfoproperties_Client_en.jar,dfoproperties_WebI_en.jar,epm_CafUpdate.sh,dfoproperties_WebServices_en.jar,dfoproperties_EPM_en.jar

Authentication type is: secEnterprise

com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$NotFoundInDirectory: Server ausyd23as07:6400 not found or server may be down (FWM 01003)

cause:java.net.ConnectException: Connection refused

detail:Server ausyd23as07:6400 not found or server may be down (FWM 01003) Connection refused

AKHUMBI
Advisor
Advisor
0 Kudos

Hi

Could you please mention the exact steps that you followed, with some more details

Regards

Ashwini

AKHUMBI
Advisor
Advisor
0 Kudos

Hi

you can refer "Selecting a new or existing CMS database" section on page number 184, in "http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_bip_admin_en.pdf"

Regards

Ashwini