Replication Oracle->SQL2014 Error 14124

  • I have created a publication from Oracle to SQL2014.

    replmon says the snapshot has completed.

    The snapshot files are in the directory.

    SQL agent has access to the snap directory, oracle files.

    When I create a subscription I get the error "A publication must have at least one article before a subscription to it can be created. The subscription could not be found." Error 14124

    The publication has a single table (for testing purposes) and I have tried both transactional and snapshot publications.

    The single table is tiny and has a primary key.

    Any ideas?

    Thanks

    sl

  • This feature is deprecated (see here).

    So I suggest you consider an SSIS/CDC solution, as recommended by MS, instead.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Thanks, I realise it is deprecated and have recommended not using it but the client has a love of the idea and I am just trying to get it working.

    Once I have exhausted all avenues of it working I am hoping they will use a different product - I know nothing about Oracle and am quite happy that way 🙂

  • Temporarily increase the -outputverboselevel of the distribution job, and inspect results.

Viewing 4 posts - 1 through 3 (of 3 total)

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