Invalid Object Name in Transaction Replication Error 208

Question

Post reply

Invalid Object Name in Transaction Replication Error 208

dba.sql29

SSCommitted

Points: 1837
More actions
April 22, 2013 at 4:17 pm

#276805

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Andrew G SSChampion Points: 12809 More actions · Answer 1

Does the view "vwTrip_Leg" exist on the subscriber?

dba.sql29 SSCommitted Points: 1837 More actions · Answer 2

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

Andrew G SSChampion Points: 12809 More actions · Answer 3

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.

dba.sql29 SSCommitted Points: 1837 More actions · Answer 4

dba.sql29

SSCommitted

Points: 1837

April 23, 2013 at 9:08 am

#1609123

Thanks A lot for your help 🙂

dba.sql29 SSCommitted Points: 1837 More actions · Answer 5

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