Monday, March 05, 2012 8:54 AM
We are facing 1 problem . we have found that on distribution server replication job is failed. for that we ran it manually it ran successfully. but the no. of records on production server not matching with the replication database for that we thought to reintialize the subscription, we stopped the log reader agent and generated the snapshot of the publication and again started the log reader agent for that we are getting the error
" Cannot DROP TABLE 'dbo.S_XXXXX' because it is being referenced by object 'v_XXX_XXXXt'."
the referenecd table is not there in publication .
the problem very critical please help regarding this
thanks a ton in advance
Monday, March 05, 2012 9:01 AMis it SQL publisher or Oracle publisher?
Monday, March 05, 2012 9:05 AMthis is a SQL server publisher and Subscriber too
Monday, March 05, 2012 9:14 AM
You need to look for the reference table on Subscriber.
My idea is why dont you try on Demand subscription; why you need to recreate the snapshot and then run logreader??
Monday, March 05, 2012 9:20 AM
sorry my mistake the referenced object is not a table its view... what is Demand subscription
please explain me.
Monday, March 05, 2012 9:23 AM
You can got o replication folder and under local subscription you can see "view Synchronization Status" and there you go.
Monday, March 05, 2012 1:04 PM
i have resolved the problem.
Actually the view was blocking agent. we have deleted the view and reintialised it after that again recreated the view.
- Marked As Answer by sushil naik Monday, March 05, 2012 1:04 PM
Tuesday, March 06, 2012 5:44 AM
I think you should always try for On-Demand subscription in future is there any reason why you did not opt for this.
Tuesday, March 06, 2012 7:59 AMActually i tried your method but the referenced view is not allowing for synchronisation with the publication . i dont know weather it is good or bad, with no choice i opted for drop and create the view.