replication reintialisztion fail

Question

Hi all,

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

regards

sushil 

Answer 1

is it SQL publisher or Oracle publisher?

---

Vivek Patle

Answer 2

this is a  SQL server publisher and Subscriber too

Answer 3

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??

---

Vivek Patle

Answer 4

sorry my mistake the referenced object is not a table its view... what is Demand subscription 

please explain me.

Answer 5

You can got o replication folder and under local subscription you can see "view Synchronization Status" and there you go.

---

Vivek Patle

Answer 6

hi

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. 

Answer 7

I think you should always try for On-Demand subscription in future is there any reason why you did not opt for this.

---

Vivek Patle

Answer 8

Actually 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.