Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Invalid Object Name in Transaction Replication Error 208 Expand / Collapse
Author
Message
Posted Monday, April 22, 2013 4:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 3:51 PM
Points: 52, Visits: 813
Hi Experts

I have set up a Transaction Replication and its working fine on most of the database in one of the database its giving me error. This is the error 'vwTrip_Leg' is a view in database. Please help

Thank you

Command attempted:
/*
Select * From fnMemberBenefitsUsedCSPIID(2013,'CM2026526','01/01/2013','H0544015')

Description:
Return table of Legs with flags for each benefit indicating if the benefit covers
the leg otherwise it’s a one-way
*/
CREATE function [dbo].[fnMemberBenefitsUsedCSPIID]
(
@Year int
, @SBSB_ID varchar ( 9 )
, @MEPE_EFF_DT date
, @CSPI_ID varchar ( 8 )
)
Returns Table
as Return
(

Select
SBSB_ID = @SBSB_ID
, MEPE_EFF_DT = @MEPE_EFF_DT
, v.Trip_ID
, v.Leg_ID
, v.Trans
(Transaction sequence number: 0x0000008500082101000500000000, Command ID: 106)

Error messages:
Invalid object name 'vwTrip_Leg'. (Source: MSSQLServer, Error number: 208)
Get help: http://help/208
Invalid object name 'vwTrip_Leg'. (Source: MSSQLServer, Error number: 208)
Get help: http://help/208
Post #1445227
Posted Monday, April 22, 2013 8:20 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:34 PM
Points: 1,219, Visits: 1,690
Does the view "vwTrip_Leg" exist on the subscriber?
Post #1445243
Posted Monday, April 22, 2013 9:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 3:51 PM
Points: 52, Visits: 813
no it does not exist on subscriber.

also when I created replication it created a lot of jobs at Distribution database and in Replication Monitor I am seening old replication Publication how should I delete them ?

Thanks for your help
Post #1445261
Posted Monday, April 22, 2013 11:00 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:34 PM
Points: 1,219, Visits: 1,690
If the old publication does not have any subscribtions, you can drop it using:
EXEC sp_droppublication @publication = 'oldpublication'

But make sure there's no subscriptions first.

Add the missing view (or all views) to the publication by going into the articles and ticking Views. Then generate a new snapshot and it will be applied at the subscriber.

Post #1445270
Posted Tuesday, April 23, 2013 9:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 3:51 PM
Points: 52, Visits: 813
Thanks A lot for your help :)
Post #1445505
Posted Tuesday, April 23, 2013 10:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 3:51 PM
Points: 52, Visits: 813
I have another question when I am looking at distribution database I am seeing a lot of job.

Our Database get refreshed every month and it breaks the replication and I have to recreated the entire replication again. Should I drop the Distribution database also and recreate it everything from scratch???

Thanks
Post #1445584
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse