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