September 20, 2016 at 4:34 pm
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
This feature is deprecated (see here).
So I suggest you consider an SSIS/CDC solution, as recommended by MS, instead.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 20, 2016 at 5:32 pm
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
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