all groups > sql server replication > october 2003 >
You're in the

sql server replication

group:

Publication Wizard Failure - Error 14294


Publication Wizard Failure - Error 14294 BobW
10/28/2003 2:49:00 PM
sql server replication:
Have any of you folks encountered error 14294 - "Supply
either @job_id or @job_name to identify job" while trying
to create a publication using the wizard?

I've tried deleting and recreating the subscription
database on the subscriber - no luck. When I run
sp_addpublication in query analyzer it fails on the same
error. The online books list "@logreader_job_name"
and "@qreader_job_name" as part of the stored procedure,
but I don't see either in the trace! Both are listed
as "For internal use only". Is it possible that I've
missed a step in creating the publication? There doesn't
seem to be a whole lot of references to this error on the
WWW.....

Thanks,
Bob

The profiler gives the following trace:

exec sp_addpublication
@publication = N'RCS_Whse_Repl',
@restricted = N'false',
@sync_method = N'native',
@repl_freq = N'continuous',
@description = N'Transactional publication of RCS_Whse
database from Publisher DOLPHIN.',
@status = N'inactive',
@allow_push = N'true',
@allow_pull = N'true',
@allow_anonymous = N'false',
@enabled_for_internet = N'false',
@independent_agent = N'false',
@immediate_sync = N'false',
@allow_sync_tran = N'false',
@autogen_sync_procs = N'true',
@retention = 336,
@allow_queued_tran = N'false',
@snapshot_in_defaultfolder = N'true',
@compress_snapshot = N'false',
@ftp_port = 21,
@allow_dts = N'false',
@allow_subscription_copy = N'false',
@add_to_active_directory = N'false'


exec sp_addpublication_snapshot
@publication = N'RCS_Whse_Repl',
@frequency_type = 4,
@frequency_interval = 1,
@frequency_relative_interval = 0,
@frequency_recurrence_factor = 1,
@frequency_subday = 1,
@frequency_subday_interval = 0,
@active_start_date = 0,
@active_end_date = 20031028,
@active_start_time_of_day = 221900,
Publication Wizard Failure - Error 14294 Hilary Cotter
10/30/2003 8:18:42 AM
I think you need to change your status to active.

The @logreader_job_name and @qreader_job_name are the
names that SQL Server will give to your logreader agent
and queue reader agent.

Values you put in here will be ignored and overwritten

It is also possible that you already have a publication
with a snapshot_agent/logreader_agent, Queue_reader_agent
with the same name and when you run your script you ager
getting an error.

[quoted text, click to view]
Publication Wizard Failure - Error 14294 BobW
10/30/2003 12:30:30 PM
Thanks Hilary -

I found an old publication/subscription a former developer
had done a half-baked job of cleaning up and dropped it.
Once that mess was cleaned up, the wizard decided to play
nicely. Appreciate your response!

Bob
Re: Publication Wizard Failure - Error 14294 RamonC
11/26/2003 4:13:17 AM
BobW,

Sorry but my English is not very good.

I have the same problem. Can you send me what I need to do,
Thanks

Ramon

*** Sent via Developersdex http://www.developersdex.com ***
AddThis Social Bookmark Button