UCMDB and UD Practitioners Forum (Previously CMS)
cancel
Showing results for 
Search instead for 
Did you mean: 

move ucmdb host

SOLVED
Go to solution
Highlighted
lana qasem
Member

move ucmdb host

hello all,
i am using the same database but am using a different host for ucmdb.
i did the following steps :
1 HAC Tables
a Empty the HAC tables:
➤ ALTER TABLE HA_SERVICES_DEP DROP CONSTRAINT
HA_SERVICES_DEP_FK1;
➤ ALTER TABLE HA_SERVICES_DEP DROP CONSTRAINT
HA_SERVICES_DEP_FK2;
➤ ALTER TABLE HA_SRV_ALLWD_GRPS DROP CONSTRAINT
HA_SRV_ALLWD_GRPS_FK2;
➤ ALTER TABLE HA_SERVICES DROP CONSTRAINT HA_SERVICES_FK1;
➤ TRUNCATE TABLE HA_BACKUP_PROCESSES
➤ TRUNCATE TABLE HA_PROC_ALWD_SERVICES
➤ TRUNCATE TABLE HA_SRV_ALLWD_GRPS
➤ TRUNCATE TABLE HA_SERVICES_DEP
➤ TRUNCATE TABLE HA_SERVICES
➤ TRUNCATE TABLE HA_SERVICE_GRPS
➤ TRUNCATE TABLE HA_TASK_ASSIGN
➤ ALTER TABLE HA_SERVICES_DEP ADD CONSTRAINT
HA_SERVICES_DEP_FK1 FOREIGN KEY (SERVICE_ID) REFERENCES
HA_SERVICES (ID);
➤ ALTER TABLE HA_SERVICES_DEP ADD CONSTRAINT
HA_SERVICES_DEP_FK2 FOREIGN KEY (DEPENDS_ON) REFERENCES
HA_SERVICES (ID);
➤ ALTER TABLE HA_SRV_ALLWD_GRPS ADD CONSTRAINT
HA_SRV_ALLWD_GRPS_FK2 FOREIGN KEY (GROUP_ID) REFERENCES
HA_SERVICE_GRPS (ID);
➤ ALTER TABLE HA_SERVICES ADD CONSTRAINT HA_SERVICES_FK1
FOREIGN KEY (GROUP_ID) REFERENCES HA_SERVICE_GRPS (ID);


b Erase references to controller upgrade from properties:
2 Bus Tables
Remove the reference to bus locations (including the Domain Manager) in
the properties table:
3 Setting Manager Values

Update the URLS in the SETTING_PARAMETERS table.
For each key in the table, modify and run the following query:

update SETTING_PARAMETERS set SP_VALUE='localhost'
where SP_CONTEXT='cmdb' and SP_NAME='dal.classmodel.host.name'

update SETTING_PARAMETERS set SP_VALUE='localhost'
where SP_CONTEXT='cmdb' and SP_NAME='dal.classmodel.server'


then i started the ucmdb configuration but i keep getting :
java.lang.NullPointerException

anyone can help with this ?

 

 

P.S. This thread has been moevd from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum. - Hp forum Moderator

2 REPLIES
haytham_hosny
Occasional Visitor
Solution

Re: move ucmdb host

Hi ,

please take a look for the following KB articles , it's very useful for your case:

- KM197244
- KM832528

http://support.openview.hp.com/selfsolve/document/KM832528?searchIdentifier=1a3154a8%3a12be559d8db%3a-18d7&resultType=document&documentURL=KM832528&resultsURL=%2fselfsolve%2fdocuments&allowReturn=true

Hope this helps you

Thanks
Haytham Hosny
Haytham Hosny
lana qasem
Member

Re: move ucmdb host

it worked perfectly
thanx alot
//Add this to "OnDomLoad" event