Merge Replication nested view problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Merge Replication nested view problem

Author

Topic

mindreader13
Starting Member

6 Posts

Posted - 2007-09-20 : 23:32:13

Using SQL 2005 as pub and SQL EXPRESS as sub using Merge replication. Got the following error message

The schema script 'CD_InTransit_v_153.sch' could not be propagated to the subscriber.
Error Detail:
The schema script 'CD_InTransit_v_153.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL20164)
Get help: http://help/MSSQL_REPL20164
Invalid object name 'dbo.Debit_v'. (Source: MSSQLServer, Error number: 208)
Get help: http://help/208

According to error message, it seems that debit_v is missing. However, I cannot control the sequence of view to replicate. How can I solve this problem

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-21 : 00:02:47

Do they have same schema?

mindreader13
Starting Member

6 Posts

Posted - 2007-09-21 : 02:33:53

They have exactly the same schema.. Problem is coming from the nested view (a view that references a view). I tried transactional with update which doesn't gives error. However, error happen in merge replication... Please help..

m_z_iqbal
Starting Member

28 Posts

Posted - 2008-12-24 : 05:21:25

facing same problem ???

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-24 : 07:34:26

Are all tables involved in Views,Functions,or SP replicated to Subscriber? Otherwise it won't work. Use sp_depends to find dependency.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2008-12-26 : 02:50:50

yes, all objects are involved, but its not working.