cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
17738
Views
0
Helpful
5
Replies

UCCX Engine Partial service

raunig123
Level 1
Level 1

Guys,

one of the two ipcc servers is partially in service and the other one is in service ,please assist.

the secondary server is having this issue and the primary server is ok

when i checked the services i saw the database subsystem service is in partial state screen shots are attached.

Please shed some light on it.

5 Replies 5

raunig123
Level 1
Level 1

This is what is see in MIVR logs

357: May 27 08:41:03.940 GMT+200 %MIVR-CFG_MGR-1-MGR_PARTIAL_SERVICE:Config Manager in partial service: Reason=com.cisco.config.impl.bsaccessor.BootstrapAccessor-Not IN_SERVICE

Hi Raun,

Database Subsystem goes into partial service

Symptom The Database subsystem is in partial service when the Cisco Unified CCX system is configured to use a Sybase database.

Error Message None.

Possible Cause If the Sybase datasource name that you enter in the Cisco Unified CCX Administration Enterprise Database Subsystem Configuration web page does not match exactly the datasource name in the Windows ODBC DSN configuration window, the database connection will fail and the database will go into partial service.

Recommended Action Be sure the Sybase datasource name on the Administration Enterprise Database Subsystem Configuration web page matches the Windows ODBC datasource name.

Also please use the below troubleshooting guide for more information,

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_7_0/troubleshooting/guide/uccx70srvtrbl.pdf

Hop ie helps.

Anand

Pls rate helpful posts by clicking on the stars below the right answers !!

More logs for your concern..

%MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

915: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> INITIALIZING

916: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-5-ModuleStart:Module has successfully started: Module Name=Database Manager-4164

917: May 27 08:41:08.003 GMT+200 %MIVR-GENERIC-5-ModuleStart:Module has successfully started: Module Name=Database Manager-4164

918: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-MGR_INITIALIZING:Database Manager initializing:

919: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

920: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

921: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Historical Datastore) -> INITIALIZING

922: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:database Manager postStart init CRS Config Datastore

923: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:datasource init - CRS Config Datastore

924: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: INITIALIZING -> PARTIAL_SERVICE

925: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-1-MGR_PARTIAL_SERVICE:Database Manager in partial service:

926: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

927: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

928: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> OUT_OF_SERVICE

929: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-2-MGR_OUT_OF_SERVICE:Database Manager in out of service:

930: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

931: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

932: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Config Datastore) -> INITIALIZING

933: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:the node of the service getting registered is2

934: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:the cluster context name registered/put is :Database Manager2

935: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: OUT_OF_SERVICE -> PARTIAL_SERVICE

936: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-1-MGR_PARTIAL_SERVICE:Database Manager in partial service:

937: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:registerListener() CRS Config DatastoreCRS SQL Server - Config

938: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:getDbMaster CRS Config Datastore

939: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:dsMaster converged for CRS Config Datastore

940: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:got dsService for CRS Config Datastore

941: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:CRS Config Datastore ds master HostName :CCX7-MAIN

942: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-3-Using CDS Master as bCDSpecial=true & bCDSLocalEnabled=true:Undefined mnemonic 'Using CDS Master as bCDSpecial=true & bCDSLocalEnabled=true'

943: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:CDS component is enabled on this node+creating poolCCX7-DR

944: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

945: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

946: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> OUT_OF_SERVICE

947: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-2-MGR_OUT_OF_SERVICE:Database Manager in out of service:

948: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

949: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

950: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Repository Datastore) INITIALIZING -> OUT_OF_SERVICE

951: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:registerListener() CRS Repository DatastoreCRS SQL Server - Repository

952: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:getDbMaster CRS Repository Datastore

953: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:dsMaster converged for CRS Repository Datastore

954: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:got dsService for CRS Repository Datastore

955: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:CRS Repository Datastore ds master HostName :CCX7-MAIN

956: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: OUT_OF_SERVICE -> PARTIAL_SERVICE

957: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-1-MGR_PARTIAL_SERVICE:Database Manager in partial service:

958: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

959: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

960: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> OUT_OF_SERVICE

961: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-2-MGR_OUT_OF_SERVICE:Database Manager in out of service:

962: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

963: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

964: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Historical Datastore) INITIALIZING -> OUT_OF_SERVICE

965: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Config Datastore) INITIALIZING -> OUT_OF_SERVICE

966: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:registerListener() CRS Historical DatastoreCRS SQL Server - Historical

967: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-3-Using CDS Master as bCDSpecial=true & bCDSLocalEnabled=true:Undefined mnemonic 'Using CDS Master as bCDSpecial=true & bCDSLocalEnabled=true'

968: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:getDbMaster CRS Historical Datastore

969: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:CDS component is enabled on this node+creating poolCCX7-DR

970: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:dsMaster converged for CRS Historical Datastore

971: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:got dsService for CRS Historical Datastore

972: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:CRS Historical Datastore ds master HostName :CCX7-MAIN

973: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:IntraDBManagerCommunication:NodeID = 002

974: May 27 08:41:08.096 GMT+200 %MIVR-CLUSTER_MGR-7-UNK:send: ClusterContextPutEntryCmdImpl, nodeId=2, serviceUniqueId=120, sourceName=CRS Engine, notifyAll=true, key=DBManager2 CVDContextContainer: value=DatabaseManagerImpl$IntraDBManagerCommunication[UnicastServerRef [liveRef: [endpoint:[10.80.184.68:49270](local),objID:[-5f557d30:1378d06d923:-7ffa, 4630680600240399643]]]], buffer length 3441

975: May 27 08:41:08.112 GMT+200 %MIVR-MGR_MGR-7-UNK:*** ManagerManager stopping timer for com.cisco.database.impl.DatabaseManagerImpl in init()

976: May 27 08:41:08.112 GMT+200 %MIVR-MGR_MGR-7-UNK:Configuration default parameter 'com.cisco.database.impl.DatabaseManagerImpl.mgrmgrstate' missing error:

977: May 27 08:41:08.112 GMT+200 %MIVR-MGR_MGR-7-UNK:*** manager = Database Manager, state change = null

978: May 27 08:41:08.159 GMT+200 %MIVR-MGR_MGR-7-UNK:Configuration default parameter 'com.cisco.user.impl.CCMUserManagerImpl.timeout' missing error:

979: May 27 08:41:08.159 GMT+200 %MIVR-MGR_MGR-7-UNK:*** ManagerManager starting timer for com.cisco.user.impl.CCMUserManagerImpl in init(). Time out value = 30000, time out buffer = 3000

980: May 27 08:41:08.159 GMT+200 %MIVR-LOG_MGR-7-UNK:Loading Catalog 'MIVR_USER_MGR' using Class 'com.cisco.user.impl.AbstractUserManager' ClassLoader 'com/cisco/net/URLClassLoader'

981: May 27 08:41:08.221 GMT+200 %MIVR-CLUSTER_MGR-7-UNK:send: Cmd[ServiceStateChangedCmdImpl[19]={0:ServiceStateUpdate=[topLevel=CRS Engine,svc=File Manager/Manager,state=INITIALIZING], 1:ServiceStateUpdate=[topLevel=CRS Engine,svc=RTP Port Manager/Manager,state=INITIALIZING], 2:ServiceStateUpdate=[topLevel=CRS Engine,svc=RTP Port Manager/Manager,state=IN_SERVICE], 3:ServiceStateUpdate=[topLevel=CRS Engine,svc=Channel Manager/Manager,state=INITIALIZING], 4:ServiceStateUpdate=[topLevel=CRS Engine,svc=Contact Manager/Manager,state=INITIALIZING], 5:ServiceStateUpdate=[topLevel=CRS Engine,svc=Session Manager/Manager,state=INITIALIZING], 6:ServiceStateUpdate=[topLevel=CRS Engine,svc=Session Manager/Manager,state=OUT_OF_SERVICE], 7:ServiceStateUpdate=[topLevel=CRS Engine,svc=Expression Manager/Manager,state=INITIALIZING], 8:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=INITIALIZING], 9:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 10:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=INITIALIZING], 11:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 12:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=INITIALIZING], 13:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 14:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=OUT_OF_SERVICE], 15:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 16:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=OUT_OF_SERVICE], 17:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 18:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=OUT_OF_SERVICE]},nodeId=2,seq#=4]

982: May 27 08:41:08.253 GMT+200 %MIVR-DB_MGR-7-UNK:readSqlProperties() Component Name=CRS Config Datastore

983: May 27 08:41:08.253 GMT+200 %MIVR-DB_MGR-7-UNK:readSqlProperties() InstanceName=CRSSQL & port=4433

984: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-7-UNK:readSqlProperties() Component Name=CRS Config Datastore

985: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-7-UNK:readSqlProperties() InstanceName=CRSSQL & port=4433

986: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: OUT_OF_SERVICE -> PARTIAL_SERVICE

987: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-1-MGR_PARTIAL_SERVICE:Database Manager in partial service:

988: May 27 08:41:08.268 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

989: May 27 08:41:08.268 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

990: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> OUT_OF_SERVICE

991: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-2-MGR_OUT_OF_SERVICE:Database Manager in out of service:

992: May 27 08:41:08.268 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

%MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

915: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> INITIALIZING

916: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-5-ModuleStart:Module has successfully started: Module Name=Database Manager-4164

917: May 27 08:41:08.003 GMT+200 %MIVR-GENERIC-5-ModuleStart:Module has successfully started: Module Name=Database Manager-4164

918: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-MGR_INITIALIZING:Database Manager initializing:

919: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

920: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

921: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Historical Datastore) -> INITIALIZING

922: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:database Manager postStart init CRS Config Datastore

923: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:datasource init - CRS Config Datastore

924: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: INITIALIZING -> PARTIAL_SERVICE

925: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-1-MGR_PARTIAL_SERVICE:Database Manager in partial service:

926: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

927: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

928: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> OUT_OF_SERVICE

929: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-2-MGR_OUT_OF_SERVICE:Database Manager in out of service:

930: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

931: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

932: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Config Datastore) -> INITIALIZING

933: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:the node of the service getting registered is2

934: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:the cluster context name registered/put is :Database Manager2

935: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: OUT_OF_SERVICE -> PARTIAL_SERVICE

936: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-1-MGR_PARTIAL_SERVICE:Database Manager in partial service:

937: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:registerListener() CRS Config DatastoreCRS SQL Server - Config

938: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:getDbMaster CRS Config Datastore

939: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:dsMaster converged for CRS Config Datastore

940: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:got dsService for CRS Config Datastore

941: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:CRS Config Datastore ds master HostName :CCX7-MAIN

942: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-3-Using CDS Master as bCDSpecial=true & bCDSLocalEnabled=true:Undefined mnemonic 'Using CDS Master as bCDSpecial=true & bCDSLocalEnabled=true'

943: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:CDS component is enabled on this node+creating poolCCX7-DR

944: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

945: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

946: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> OUT_OF_SERVICE

947: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-2-MGR_OUT_OF_SERVICE:Database Manager in out of service:

948: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

949: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

950: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Repository Datastore) INITIALIZING -> OUT_OF_SERVICE

951: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:registerListener() CRS Repository DatastoreCRS SQL Server - Repository

952: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:getDbMaster CRS Repository Datastore

953: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:dsMaster converged for CRS Repository Datastore

954: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:got dsService for CRS Repository Datastore

955: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:CRS Repository Datastore ds master HostName :CCX7-MAIN

956: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: OUT_OF_SERVICE -> PARTIAL_SERVICE

957: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-1-MGR_PARTIAL_SERVICE:Database Manager in partial service:

958: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

959: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

960: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> OUT_OF_SERVICE

961: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-2-MGR_OUT_OF_SERVICE:Database Manager in out of service:

962: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

963: May 27 08:41:08.003 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

964: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Historical Datastore) INITIALIZING -> OUT_OF_SERVICE

965: May 27 08:41:08.003 GMT+200 %MIVR-DB_MGR-6-DATASOURCE_STATE:state change: change=state changed(CRS Config Datastore) INITIALIZING -> OUT_OF_SERVICE

966: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:registerListener() CRS Historical DatastoreCRS SQL Server - Historical

967: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-3-Using CDS Master as bCDSpecial=true & bCDSLocalEnabled=true:Undefined mnemonic 'Using CDS Master as bCDSpecial=true & bCDSLocalEnabled=true'

968: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:getDbMaster CRS Historical Datastore

969: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:CDS component is enabled on this node+creating poolCCX7-DR

970: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:dsMaster converged for CRS Historical Datastore

971: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:got dsService for CRS Historical Datastore

972: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:CRS Historical Datastore ds master HostName :CCX7-MAIN

973: May 27 08:41:08.018 GMT+200 %MIVR-DB_MGR-7-UNK:IntraDBManagerCommunication:NodeID = 002

974: May 27 08:41:08.096 GMT+200 %MIVR-CLUSTER_MGR-7-UNK:send: ClusterContextPutEntryCmdImpl, nodeId=2, serviceUniqueId=120, sourceName=CRS Engine, notifyAll=true, key=DBManager2 CVDContextContainer: value=DatabaseManagerImpl$IntraDBManagerCommunication[UnicastServerRef [liveRef: [endpoint:[10.80.184.68:49270](local),objID:[-5f557d30:1378d06d923:-7ffa, 4630680600240399643]]]], buffer length 3441

975: May 27 08:41:08.112 GMT+200 %MIVR-MGR_MGR-7-UNK:*** ManagerManager stopping timer for com.cisco.database.impl.DatabaseManagerImpl in init()

976: May 27 08:41:08.112 GMT+200 %MIVR-MGR_MGR-7-UNK:Configuration default parameter 'com.cisco.database.impl.DatabaseManagerImpl.mgrmgrstate' missing error:

977: May 27 08:41:08.112 GMT+200 %MIVR-MGR_MGR-7-UNK:*** manager = Database Manager, state change = null

978: May 27 08:41:08.159 GMT+200 %MIVR-MGR_MGR-7-UNK:Configuration default parameter 'com.cisco.user.impl.CCMUserManagerImpl.timeout' missing error:

979: May 27 08:41:08.159 GMT+200 %MIVR-MGR_MGR-7-UNK:*** ManagerManager starting timer for com.cisco.user.impl.CCMUserManagerImpl in init(). Time out value = 30000, time out buffer = 3000

980: May 27 08:41:08.159 GMT+200 %MIVR-LOG_MGR-7-UNK:Loading Catalog 'MIVR_USER_MGR' using Class 'com.cisco.user.impl.AbstractUserManager' ClassLoader 'com/cisco/net/URLClassLoader'

981: May 27 08:41:08.221 GMT+200 %MIVR-CLUSTER_MGR-7-UNK:send: Cmd[ServiceStateChangedCmdImpl[19]={0:ServiceStateUpdate=[topLevel=CRS Engine,svc=File Manager/Manager,state=INITIALIZING], 1:ServiceStateUpdate=[topLevel=CRS Engine,svc=RTP Port Manager/Manager,state=INITIALIZING], 2:ServiceStateUpdate=[topLevel=CRS Engine,svc=RTP Port Manager/Manager,state=IN_SERVICE], 3:ServiceStateUpdate=[topLevel=CRS Engine,svc=Channel Manager/Manager,state=INITIALIZING], 4:ServiceStateUpdate=[topLevel=CRS Engine,svc=Contact Manager/Manager,state=INITIALIZING], 5:ServiceStateUpdate=[topLevel=CRS Engine,svc=Session Manager/Manager,state=INITIALIZING], 6:ServiceStateUpdate=[topLevel=CRS Engine,svc=Session Manager/Manager,state=OUT_OF_SERVICE], 7:ServiceStateUpdate=[topLevel=CRS Engine,svc=Expression Manager/Manager,state=INITIALIZING], 8:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=INITIALIZING], 9:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 10:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=INITIALIZING], 11:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 12:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=INITIALIZING], 13:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 14:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=OUT_OF_SERVICE], 15:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 16:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=OUT_OF_SERVICE], 17:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=PARTIAL_SERVICE], 18:ServiceStateUpdate=[topLevel=CRS Engine,svc=Database Manager/Manager,state=OUT_OF_SERVICE]},nodeId=2,seq#=4]

982: May 27 08:41:08.253 GMT+200 %MIVR-DB_MGR-7-UNK:readSqlProperties() Component Name=CRS Config Datastore

983: May 27 08:41:08.253 GMT+200 %MIVR-DB_MGR-7-UNK:readSqlProperties() InstanceName=CRSSQL & port=4433

984: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-7-UNK:readSqlProperties() Component Name=CRS Config Datastore

985: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-7-UNK:readSqlProperties() InstanceName=CRSSQL & port=4433

986: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: OUT_OF_SERVICE -> PARTIAL_SERVICE

987: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-1-MGR_PARTIAL_SERVICE:Database Manager in partial service:

988: May 27 08:41:08.268 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

989: May 27 08:41:08.268 GMT+200 %MIVR-MGR_MGR-7-UNK:State is the same => INITIALIZING, no change

990: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-7-UNK:Database Manager: PARTIAL_SERVICE -> OUT_OF_SERVICE

991: May 27 08:41:08.268 GMT+200 %MIVR-DB_MGR-2-MGR_OUT_OF_SERVICE:Database Manager in out of service:

992: May 27 08:41:08.268 GMT+200 %MIVR-MGR_MGR-7-UNK:Still constructing. Set state to initializing...

Hi Anchoud,

this is not the case because when the same datasource connects to the primary server it works well, can you please take a look at the logs above and update me.

Thanks in advance.

Hi Raun,

In this scenario make sure that the ODBC connection is created on both the servers and then refresh the database.

Hope it helps.

Anand

Pls rate helpful posts !!