05-28-2012 02:00 AM - edited 03-14-2019 09:56 AM
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.
05-28-2012 02:07 AM
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
05-28-2012 02:12 AM
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,
Hop ie helps.
Anand
Pls rate helpful posts by clicking on the stars below the right answers !!
05-28-2012 03:34 AM
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...
05-28-2012 03:36 AM
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.
05-29-2012 05:09 AM
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 !!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide