CAD 8.0.1 recording and statistic replication error

[Chintan Gajjar]

hi,

i have installed CAD 8.0(1a) and i am trying to configuere recording and statistc Replication.

wehen i try to set it up through postinstall,it gives me below error:

Recrding and statistics replication failed,

Error: encountered en error when addidng the publisher.

i went through logs and found below:

egin sp_splk_drop_publisher

end sp_splk_drop_publisher

Msg 50000, Level 16, State 1, Server HPLAB6\CADSQL, Procedure craLogMessage, Line 210

(58) ERR craDropPublication :The publication(cra_agent_pub) is not a

valid CRA publication

Msg 50000, Level 16, State 1, Server HPLAB6\CADSQL, Procedure craLogMessage, Line 210

(58) ERR craDropSubscription :The publication(cra_agent_pub) is not a

valid CRA publication

Msg 21147, Level 16, State 1, Server HPLAB6\CADSQL, Procedure sp_MSCheckmergereplication, Line 12

The 'FCRasSvr' database is not published for merge replication.

Msg 50000, Level 16, State 1, Server HPLAB6\CADSQL, Procedure craLogMessage, Line 210

(58) ERR craDropPublication :Call to sp_dropmergepublication failed

(0 rows affected)

End sp_splk_drop_publishe

futher more when i checked SQL server logs i found below.

Error: 450000, Severity: 16, State: 1.

2012-12-21 15:43:46.37 spid58      (58) ERR craDropPublication :The publication(cra_agent_pub) is not a valid CRA publication

2012-12-21 15:43:46.37 spid58      Error: 50000, Severity: 16, State: 1.

2012-12-21 15:43:46.37 spid58      (58) ERR craDropPublication :The publication(cra_agent_pub) is not a valid CRA publication

2012-12-21 15:43:46.55 spid58      Error: 450000, Severity: 16, State: 1.

2012-12-21 15:43:46.55 spid58      (58) ERR craDropSubscription :The publication(cra_agent_pub) is not a valid CRA publication

2012-12-21 15:43:46.55 spid58      Error: 50000, Severity: 16, State: 1.

2012-12-21 15:43:46.55 spid58      (58) ERR craDropSubscription :The publication(cra_agent_pub) is not a valid CRA publication

2012-12-21 15:43:46.60 spid58      Error: 450000, Severity: 16, State: 1.

2012-12-21 15:43:46.60 spid58      (58) ERR craDropPublication :Call to sp_dropmergepublication failed

2012-12-21 15:43:46.60 spid58      Error: 50000, Severity: 16, State: 1.

2012-12-21 15:43:46.60 spid58      (58) ERR craDropPublication :Call to sp_dropmergepublication failed

2012-12-21 15:43:47.82 spid58      Error: 450000, Severity: 16, State: 1.

2012-12-21 15:43:47.82 spid58      (58) ERR craAddPublication :The publication(cra_agent_pub) is not a valid CRA publication

2012-12-21 15:43:47.82 spid58      Error: 50000, Severity: 16, State: 1.

2012-12-21 15:43:47.82 spid58      (58) ERR craAddPublication :The publication(cra_agent_pub) is not a valid CRA publication

i am stuck at this perticular point and i need some help to get Rid of this errors

help will be highly appreciable

regards,

Chintan

[Dmitry Sidorov]

Hi i faced with this problem too. Have you resolve this issue?

[anchoudh]

Hi Chintan,

Please see if the below post helps you here.

https://supportforums.cisco.com/thread/272613

Thanks,

Anand

[Dmitry Sidorov]

Hi Anchoudh,

Thanks for answer,.i saw that post earlier and try to remake replication it doesn't help.

when i try to enable db replication the following error pop-up:

Cisco Agent Desktop Configuration Setup

Recording and Statistics replication failed.

Error: encountered an error when adding the local distributer

(51) ERR craAddLocalDistributor :Failed to find the distribution DB using craGetDistributionDB

(51) ERR craAddLocalDistributor :Failed to find the distribution DB using craGetDistributionDB

(51) ERR craDropPublication :Call to sp_dropmergepublication failed

(51) ERR craDropPublication :Call to sp_dropmergepublication failed

(51) ERR craDropSubscription :The publication(cra_agent_pub) is not a valid CRA publication

(51) ERR craDropSubscription :The publication(cra_agent_pub) is not a valid CRA publication

(51) ERR craDropPublication :The publication(cra_agent_pub) is not a valid CRA publication

(51) ERR craDropPublication :The publication(cra_agent_pub) is not a valid CRA publication

FCRasSvr database exists and does not need upgrading.

[Chintan Gajjar]

i tried withh almost all the stuff,i manually tried to setup one servers as publisher and other as subrscriber but it also didnt help.

then i left setting up CAD server, as i dont have DEmo licences also.

if any body found any sollution please share.

[Chintan Gajjar]

HI all,

This is FYI,

this issue is resolved by moving to CAD 8.5.4

we might be hitting some bug here(dont know exactly which one)

and the same bug is resolved in 8.5 release and the same worked for me aslo.

regards

Chintan Gajjar