"Joe Bertolini" <Joe.Bertolini@bgc-contracting.com.au> wrote in message
news:OgaSCC7aDHA.1832@TK2MSFTNGP10.phx.gbl...
> I'm trying to create a publication using the sp_addpublication stored
> procedure without much success. I've used it previously to create other
> publications but for some reason on this particular database it keeps
> failing. The syntax I have used is :-
>
> use master
> GO
>
> exec sp_replicationdboption @dbname = N'JDE_CRP', @optname = N'publish',
> @value = N'true'
> GO
>
> use [JDE_CRP]
> GO
>
> exec sp_addpublication @publication = N'JDE_CRP_REFERENCE',
> @restricted = N'false',
> @sync_method = N'native',
> @repl_freq = N'continuous',
> @description = N'Transactional publication of JDE_CRP database from
> Publisher DATASTORE.',
> @status = N'active',
> @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'false',
> @retention = 336,
> @allow_queued_tran = N'false',
> @snapshot_in_defaultfolder = N'true',
> @compress_snapshot = N'false',
> @ftp_port = 21,
> @ftp_login = N'anonymous',
> @allow_dts = N'false',
> @allow_subscription_copy = N'false', @add_to_active_directory = N'false',
> @logreader_job_name = N'DATASTORE-JDE_CRP-1'
>
> After this are the statements to add the articles, etc. The problem that I

> am getting is the following error:-
>
> Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers,
> Line 24
> Supply either @job_id or @job_name to identify the job.
>
> AS can bee seen, I have supplied all the necessary parameters to the
> procedure but still keep getting this error. If I try to create the
> publication using Enterprise Manager I get essentially the same error. I
> can't find any literature anywhere regarding this error. Any help anyone
can
> provide will be greatly appreciated.
>
>
>
> Regards,
>
>
> Joe Bertolini
>
>

"Joe Bertolini" <Joe.Bertolini@bgc-contracting.com.au> wrote in message
news:e9NN%23XHbDHA.388@TK2MSFTNGP10.phx.gbl...
> I've traced the entire procedure through with the debugger, it's passing
in
> NULL values for the parameters. At line 854 it calls the
> sp_MSAdd_Publication stored procedure that lives in the distribution
> database. The runs through OK and creates all the necessary jobs except
when
> it creates the job for the cleanup tasks. This is where the problem seems
to
> be. BTW we're running SQL 2K Enterprise with SP3.
>
> And yes we are replicating the CRP environment. We raised the issue with
JDE
> about some tables not having PK's and other indexes and they supplied a
> script that created them for us.
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:OhXx1T8aDHA.2632@TK2MSFTNGP12.phx.gbl...
> > One idea.
> >
> > Run profiler at the same time and see what parameters are passed to the
SP
> > (sp_verify_job_identifiers). You can then troubleshoot it from there in
> QA.
> >
> > Can i take it that you are going to do a transaction publication of JD
> > Edwards CRP environment?
> >
> > How are you getting around the PK requirements of transactional
> replication
> > ?
> >
> >
> >
> > --
> >
> > ----------------------------
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
> >
> > "Joe Bertolini" <Joe.Bertolini@bgc-contracting.com.au> wrote in message
> > news:OgaSCC7aDHA.1832@TK2MSFTNGP10.phx.gbl...
> > > I'm trying to create a publication using the sp_addpublication stored
> > > procedure without much success. I've used it previously to create
other
> > > publications but for some reason on this particular database it keeps
> > > failing. The syntax I have used is :-
> > >
> > > use master
> > > GO
> > >
> > > exec sp_replicationdboption @dbname = N'JDE_CRP', @optname =
N'publish',
> > > @value = N'true'
> > > GO
> > >
> > > use [JDE_CRP]
> > > GO
> > >
> > > exec sp_addpublication @publication = N'JDE_CRP_REFERENCE',
> > > @restricted = N'false',
> > > @sync_method = N'native',
> > > @repl_freq = N'continuous',
> > > @description = N'Transactional publication of JDE_CRP database from
> > > Publisher DATASTORE.',
> > > @status = N'active',
> > > @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'false',
> > > @retention = 336,
> > > @allow_queued_tran = N'false',
> > > @snapshot_in_defaultfolder = N'true',
> > > @compress_snapshot = N'false',
> > > @ftp_port = 21,
> > > @ftp_login = N'anonymous',
> > > @allow_dts = N'false',
> > > @allow_subscription_copy = N'false', @add_to_active_directory =
> N'false',
> > > @logreader_job_name = N'DATASTORE-JDE_CRP-1'
> > >
> > > After this are the statements to add the articles, etc. The problem
that
> I
> >
> > > am getting is the following error:-
> > >
> > > Server: Msg 14294, Level 16, State 1, Procedure
> sp_verify_job_identifiers,
> > > Line 24
> > > Supply either @job_id or @job_name to identify the job.
> > >
> > > AS can bee seen, I have supplied all the necessary parameters to the
> > > procedure but still keep getting this error. If I try to create the
> > > publication using Enterprise Manager I get essentially the same error.
I
> > > can't find any literature anywhere regarding this error. Any help
anyone
> > can
> > > provide will be greatly appreciated.
> > >
> > >
> > >
> > > Regards,
> > >
> > >
> > > Joe Bertolini
> > >
> > >
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OhXx1T8aDHA.2632@TK2MSFTNGP12.phx.gbl...
> One idea.
>
> Run profiler at the same time and see what parameters are passed to the SP
> (sp_verify_job_identifiers). You can then troubleshoot it from there in
QA.
>
> Can i take it that you are going to do a transaction publication of JD
> Edwards CRP environment?
>
> How are you getting around the PK requirements of transactional
replication
> ?
>
>
>
> --
>
> ----------------------------
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
>
> "Joe Bertolini" <Joe.Bertolini@bgc-contracting.com.au> wrote in message
> news:OgaSCC7aDHA.1832@TK2MSFTNGP10.phx.gbl...
> > I'm trying to create a publication using the sp_addpublication stored
> > procedure without much success. I've used it previously to create other
> > publications but for some reason on this particular database it keeps
> > failing. The syntax I have used is :-
> >
> > use master
> > GO
> >
> > exec sp_replicationdboption @dbname = N'JDE_CRP', @optname = N'publish',
> > @value = N'true'
> > GO
> >
> > use [JDE_CRP]
> > GO
> >
> > exec sp_addpublication @publication = N'JDE_CRP_REFERENCE',
> > @restricted = N'false',
> > @sync_method = N'native',
> > @repl_freq = N'continuous',
> > @description = N'Transactional publication of JDE_CRP database from
> > Publisher DATASTORE.',
> > @status = N'active',
> > @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'false',
> > @retention = 336,
> > @allow_queued_tran = N'false',
> > @snapshot_in_defaultfolder = N'true',
> > @compress_snapshot = N'false',
> > @ftp_port = 21,
> > @ftp_login = N'anonymous',
> > @allow_dts = N'false',
> > @allow_subscription_copy = N'false', @add_to_active_directory =
N'false',
> > @logreader_job_name = N'DATASTORE-JDE_CRP-1'
> >
> > After this are the statements to add the articles, etc. The problem that
I
>
> > am getting is the following error:-
> >
> > Server: Msg 14294, Level 16, State 1, Procedure
sp_verify_job_identifiers,
> > Line 24
> > Supply either @job_id or @job_name to identify the job.
> >
> > AS can bee seen, I have supplied all the necessary parameters to the
> > procedure but still keep getting this error. If I try to create the
> > publication using Enterprise Manager I get essentially the same error. I
> > can't find any literature anywhere regarding this error. Any help anyone
> can
> > provide will be greatly appreciated.
> >
> >
> >
> > Regards,
> >
> >
> > Joe Bertolini
> >
> >
>
>