SQL 2008 Replication Monitor Error
Running SQL 2008 R2
Setup A transactional publication of 'database1' and a subscription from 'database2'
Setup seemed to go okay.
When I open Replication Monitor The left navigation pane cycles from all items (Replicatio nMOnitor, My Publishers, DB1, Publication_Database) having a red X to seemingly working fine.
When the red X disappears the right pane under All Subscriptions shows ERROR with 0 Latency.
Tracer Tokens shows Distrubtor to Subscriber as Pending and Total latency as Pending.
Agents Tab shows Completed Snapshot Agent, and Last Action as [100%]A snapshot of 800 article(s) was generated. It also shows Running Log Reader Agent with Last Action as No replicated transactions are available.
The new DB (subscriber) shows no tables yet)
The Subscription Dialog box in the Distributor To Subscriber History show th efollowing as the most recent error: Unable to replicate a view or function because the referenced objects are not present on the subscriber.
Setup A transactional publication of 'database1' and a subscription from 'database2'
Setup seemed to go okay.
When I open Replication Monitor The left navigation pane cycles from all items (Replicatio nMOnitor, My Publishers, DB1, Publication_Database) having a red X to seemingly working fine.
When the red X disappears the right pane under All Subscriptions shows ERROR with 0 Latency.
Tracer Tokens shows Distrubtor to Subscriber as Pending and Total latency as Pending.
Agents Tab shows Completed Snapshot Agent, and Last Action as [100%]A snapshot of 800 article(s) was generated. It also shows Running Log Reader Agent with Last Action as No replicated transactions are available.
The new DB (subscriber) shows no tables yet)
The Subscription Dialog box in the Distributor To Subscriber History show th efollowing as the most recent error: Unable to replicate a view or function because the referenced objects are not present on the subscriber.
Command attempted:
CREATE VIEW [dbo].[vwBDDSinfo]
AS
SELECT Person_FName, Person_LName, ssn_number, case_name, open_date, close_date, case_type_name, contract_name, Person_ID
FROM dbo.vwConsumer_Case_Info
(Transaction sequence number: 0x000CFF0B000000F4026300000000, Command ID: 2081)
Error messages:
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.vwConsumer_Case_Info'. (Source: MSSQLServer, Error number: 208)
Get help: http://help/208
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_REPL2759)
Get help: http://help/MSSQL_REPL2759
ASKER
Out of frustration I deleted the Subscription and Publication and recreated them receiving and received the same error:
Command attempted:
CREATE VIEW [dbo].[vwBDDSinfo]
AS
SELECT Person_FName, Person_LName, ssn_number, case_name, open_date, close_date, case_type_name, contract_name, Person_ID
FROM dbo.vwConsumer_Case_Info
(Transaction sequence number: 0x000CFF7B000002A0003D0000
Error messages:
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.vwConsumer_Case_Info'
Get help: http://help/208
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_REPL)
FYI. Both DBs are in Compatibility Mode 80 (SQL 2000)
Command attempted:
CREATE VIEW [dbo].[vwBDDSinfo]
AS
SELECT Person_FName, Person_LName, ssn_number, case_name, open_date, close_date, case_type_name, contract_name, Person_ID
FROM dbo.vwConsumer_Case_Info
(Transaction sequence number: 0x000CFF7B000002A0003D0000
Error messages:
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.vwConsumer_Case_Info'
Get help: http://help/208
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_REPL)
FYI. Both DBs are in Compatibility Mode 80 (SQL 2000)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The basics of this are.
I have setup one way replication between two databases. Replication Monitor shows errors as listed above.
Also, when checking 'View Synchronization Status' i receive the following "Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber"