Post reply

Replication Oracle->SQL2014 Error 14124

  • September 20, 2016 at 4:34 pm

    #313808

    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

  • September 20, 2016 at 5:04 pm

    #1902054

    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

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • September 20, 2016 at 5:32 pm

    #1902056

    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 🙂

  • September 21, 2016 at 8:37 am

    #1902195

    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