Invalid Object Name in Transaction Replication Error 208
-
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]
(
@Yearint
, @SBSB_IDvarchar( 9 )
, @MEPE_EFF_DTdate
, @CSPI_IDvarchar( 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
-
Does the view "vwTrip_Leg" exist on the subscriber?
-
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
-
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.
-
Thanks A lot for your help
-
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply