Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASE Replicator / ASE 12.5

5 posts in replicator Last posting was on 2005-04-14 08:21:52.0Z
ViBart Posted on 2005-04-11 07:53:14.0Z
From: "ViBart" <bartekz@uhc.com.pl>
Newsgroups: sybase.public.ase.replicator
Subject: ASE Replicator / ASE 12.5
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Antivirus: avast! (VPS 0514-3, 2005-04-10), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: gate.uhc.lublin.pl
X-Original-NNTP-Posting-Host: gate.uhc.lublin.pl
Message-ID: <425a2cea$1@forums-1-dub>
Date: 11 Apr 2005 00:53:14 -0700
X-Trace: forums-1-dub 1113205994 212.182.110.2 (11 Apr 2005 00:53:14 -0700)
X-Original-Trace: 11 Apr 2005 00:53:14 -0700, gate.uhc.lublin.pl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:63
Article PK: 103314

Welcome,

Adaptive Server Enterprise/12.5.0.3/EBF 10696 IR/P/Linux Intel/Linux
2.4.7-10smpi686/rel12503/1915/32-bit/OPT/

I had started ASE Replicator with primary connection xxx (with
subs,articles,etc.), then I changed primary connection into yyy (and the
rest). Everything was fine. But when I try to back to xxx primary connection
Sybase returns me this error:

1> sp_addprimaryconn "xxx"
2> go
Msg 32000, Level 20, State 0:
Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
Command <sp_addprimaryconn> failed - Could not add Primary Connection
<xxx> because: The object 'sp_repmarker' is not a procedure so
you cannot create another procedure under that group name.

Any ideas?

TIA

Best Regards
ViBart


Sybase Employee Posted on 2005-04-12 23:37:36.0Z
Message-ID: <425C5BC0.18A38B3E@sybase.com>
From: Sybase Employee <username@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.replicator
Subject: Re: ASE Replicator / ASE 12.5
References: <425a2cea$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vhandros2k.sybase.com
X-Original-NNTP-Posting-Host: vhandros2k.sybase.com
Date: 12 Apr 2005 16:37:36 -0700
X-Trace: forums-1-dub 1113349056 10.22.85.220 (12 Apr 2005 16:37:36 -0700)
X-Original-Trace: 12 Apr 2005 16:37:36 -0700, vhandros2k.sybase.com
Lines: 36
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:64
Article PK: 103311

Hi ViBart,
are there any SQL error messages in Replicator log files? I would check for
possible errors that may have happened
prior to issuing 'sp_addprimaryconn xxx', for example, on 'sp_dropprimaryconn
xxx'.

Thanks,
Victoria.

ViBart wrote:

> Welcome,
>
> Adaptive Server Enterprise/12.5.0.3/EBF 10696 IR/P/Linux Intel/Linux
> 2.4.7-10smpi686/rel12503/1915/32-bit/OPT/
>
> I had started ASE Replicator with primary connection xxx (with
> subs,articles,etc.), then I changed primary connection into yyy (and the
> rest). Everything was fine. But when I try to back to xxx primary connection
> Sybase returns me this error:
>
> 1> sp_addprimaryconn "xxx"
> 2> go
> Msg 32000, Level 20, State 0:
> Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
> Command <sp_addprimaryconn> failed - Could not add Primary Connection
> <xxx> because: The object 'sp_repmarker' is not a procedure so
> you cannot create another procedure under that group name.
>
> Any ideas?
>
> TIA
>
> Best Regards
> ViBart


ViBart Posted on 2005-04-13 08:05:27.0Z
From: "ViBart" <bartekz@uhc.com.pl>
Newsgroups: sybase.public.ase.replicator
References: <425a2cea$1@forums-1-dub> <425C5BC0.18A38B3E@sybase.com>
Subject: Re: ASE Replicator / ASE 12.5
Lines: 464
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Antivirus: avast! (VPS 0515-1, 2005-04-12), Outbound message
X-Antivirus-Status: Clean
X-Original-NNTP-Posting-Host: gate.uhc.lublin.pl
Message-ID: <425cd2c4@forums-2-dub>
X-Original-Trace: 13 Apr 2005 01:05:24 -0800, gate.uhc.lublin.pl
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Apr 2005 01:05:25 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Apr 2005 01:05:27 -0700
X-Trace: forums-1-dub 1113379527 10.22.108.75 (13 Apr 2005 01:05:27 -0700)
X-Original-Trace: 13 Apr 2005 01:05:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:65
Article PK: 103312

Welcome,

I droped all subs,pubs,articles and primary rep connection with no errors.

1> sp_helprep
2> go
type name status status_desc
---- -------------- ------ -----------
DDB ASEReplicator 0 DOWN

1> sp_addprimaryconn "server_name.DB_Name_PRD"
2> go
Msg 32000, Level 20, State 0:
Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
Command <sp_addprimaryconn> failed - Could not add Primary Connection
<server_name.DB_Name_PRD> because: The object 'sp_repmarker' is not a
procedure so
you cannot create another procedure under that group name.

##################
system.log:
##################

E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
execution failed.
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL ERROR --
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Message:
The object 'sp_repmarker' is not a procedure so you cannot create another
procedure under that group name.
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
SQLState: ZZZZZ
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Remote
Code: 2008
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL ERROR --
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Message:
The object 'sp_repmarker' is not a procedure so you cannot create another
procedure under that group name.
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
SQLState: ZZZZZ
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Remote
Code: 2008
W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess Offending SQL
statement:
W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess --
W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess -- PLACES A MARKER
IN THE LOG
W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess --
W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess CREATE PROCEDURE
sp_repmarker
W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess @key
varchar(30),
W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess @value
varchar(255)
W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess AS
E. 2005/04/13 09:41:00.32. com.sybase.ra.la.DBAccess Work is being rolled
back because of problems executing script: The object 'sp_repmarker' is not
a procedure so you cannot create another procedure under that group name.
E. 2005/04/13 09:41:00.32. com.sybase.ra.la.DBAccess
E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin Could not
add Primary Connection <server_name.DB_Name_PRD> because: The object
'sp_repmarker' is not a procedure so you cannot create another procedure
under that group name.
E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin

##################
trace.log:
##################

BMGRTRACE server_name 2005/04/13 09:40:59.50 root
com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
Code) Thread-1 Got RPC event from TDS: sp_addprimaryconn
BMGRTRACE server_name 2005/04/13 09:40:59.50 root
com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
Thread-1 receive() - cmd: sp_addprimaryconn
<server_name.DB_Name_PRD>, < >
BMGRTRACE server_name 2005/04/13 09:40:59.51 root
com.sybase.ra.beanmgr.CommandRouter.invokeCommand(CommandRouter.java,
Compiled Code) Thread-1 Invoking method:
com.sybase.replite.da.DDBAdmin.createPriConnection()
RACONTRC server_name 2005/04/13 09:40:59.52 root
com.sybase.ra.conn.RAConnectionMgr.nextConnection(RAConnectionMgr.java,
Compiled Code) Thread-1 Obtained connection
<com.sybase.ra.conn.RAConnection@39393788> from pool.
RACONTRCSQL server_name 2005/04/13 09:40:59.58 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:40:59.58 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 select * from connections where conn_type = 1 and ds =
'server_name' and db = 'server_name_PRD' order by ds, db
RACONTRCSQL server_name 2005/04/13 09:40:59.60 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:40:59.60 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 select * from master..sysservers where srvname =
'server_name'
RACONTRCSQL server_name 2005/04/13 09:40:59.62 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:40:59.62 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 select rl_user = suser_name()
LATRC server_name 2005/04/13 09:40:59.64 root
com.sybase.ra.la.ScriptBuffer.<init>(ScriptBuffer.java, Compiled Code)
Thread-1 ScriptBuffer() received a NULL file name.
RACONTRCSQL server_name 2005/04/13 09:40:59.65 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:40:59.65 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 sp_databases
RACONTRCSQL server_name 2005/04/13 09:40:59.67 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:40:59.67 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 select count(*) from server_name_PRD..sysusers where name =
'rpl'
LATRC server_name 2005/04/13 09:40:59.75 root
com.sybase.ra.la.ScriptBuffer.<init>(ScriptBuffer.java, Compiled Code)
Thread-1 ScriptBuffer() received a NULL file name.
LATRC server_name 2005/04/13 09:40:59.77 root
com.sybase.ra.la.ScriptBuffer.getFileName(ScriptBuffer.java, Compiled Code)
Thread-1 getFileName() returning NULL
LATRC server_name 2005/04/13 09:40:59.78 root
com.sybase.replite.da.Catalog.writeAndExec(Catalog.java, Compiled Code)
Thread-1 writeAndExec(): Writing SQL script to null
LATRC server_name 2005/04/13 09:40:59.79 root
com.sybase.ra.la.ScriptBuffer.writeToFile(ScriptBuffer.java, Compiled Code)
Thread-1 writeToFile() has NULL file
LATRC server_name 2005/04/13 09:40:59.80 root
com.sybase.replite.da.Catalog.writeAndExec(Catalog.java, Compiled Code)
Thread-1 writeAndExec() Executing SQL commands.
LATRC server_name 2005/04/13 09:40:59.83 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 executeDdlList: force = false undo = false
LATRC server_name 2005/04/13 09:40:59.84 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 executing SQL:
LATRC server_name 2005/04/13 09:40:59.84 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 use server_name_PRD
RACONTRCSQL server_name 2005/04/13 09:40:59.85 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:40:59.85 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 use server_name_PRD
LATRC server_name 2005/04/13 09:40:59.97 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 skipping SQL:
LATRC server_name 2005/04/13 09:40:59.97 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 go
LATRC server_name 2005/04/13 09:40:59.98 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 executing SQL:
LATRC server_name 2005/04/13 09:40:59.98 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 dbcc settrunc('ltm', 'end')
RACONTRCSQL server_name 2005/04/13 09:41:00.05 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:41:00.05 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 dbcc settrunc('ltm', 'end')
LATRC server_name 2005/04/13 09:41:00.12 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 skipping SQL:
LATRC server_name 2005/04/13 09:41:00.12 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 go
LATRC server_name 2005/04/13 09:41:00.13 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 executing SQL:
LATRC server_name 2005/04/13 09:41:00.13 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 --
LATRC server_name 2005/04/13 09:41:00.13 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 -- PLACES A MARKER IN THE LOG
LATRC server_name 2005/04/13 09:41:00.13 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 --
LATRC server_name 2005/04/13 09:41:00.13 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 CREATE PROCEDURE sp_repmarker
LATRC server_name 2005/04/13 09:41:00.13 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 @key varchar(30),
LATRC server_name 2005/04/13 09:41:00.13 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 @value varchar(255)
LATRC server_name 2005/04/13 09:41:00.13 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 AS
RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 --
RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 -- PLACES A MARKER IN THE LOG
RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 --
RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 CREATE PROCEDURE sp_repmarker
RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 @key varchar(30),
RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 @value varchar(255)
RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 AS
RACONTRC server_name 2005/04/13 09:41:00.18 root
com.sybase.ra.conn.query.QueryException Thread-1 SQL execution
failed.
RACONTRC server_name 2005/04/13 09:41:00.20 root
com.sybase.ra.conn.query.QueryException Thread-1 Offending SQL
statement:
RACONTRC server_name 2005/04/13 09:41:00.20 root
com.sybase.ra.conn.query.QueryException Thread-1 --
RACONTRC server_name 2005/04/13 09:41:00.20 root
com.sybase.ra.conn.query.QueryException Thread-1 -- PLACES A
MARKER IN THE LOG
RACONTRC server_name 2005/04/13 09:41:00.20 root
com.sybase.ra.conn.query.QueryException Thread-1 --
RACONTRC server_name 2005/04/13 09:41:00.20 root
com.sybase.ra.conn.query.QueryException Thread-1 CREATE
PROCEDURE sp_repmarker
RACONTRC server_name 2005/04/13 09:41:00.20 root
com.sybase.ra.conn.query.QueryException Thread-1 @key
varchar(30),
RACONTRC server_name 2005/04/13 09:41:00.20 root
com.sybase.ra.conn.query.QueryException Thread-1 @value
varchar(255)
RACONTRC server_name 2005/04/13 09:41:00.20 root
com.sybase.ra.conn.query.QueryException Thread-1 AS
RACONTRC server_name 2005/04/13 09:41:00.21 root
com.sybase.ra.conn.query.QueryException Thread-1
RACONTRC server_name 2005/04/13 09:41:00.21 root
com.sybase.ra.conn.query.QueryException Thread-1 SQL ERROR --
RACONTRC server_name 2005/04/13 09:41:00.21 root
com.sybase.ra.conn.query.QueryException Thread-1 Message:
The object 'sp_repmarker' is not a procedure so you cannot create another
procedure under that group name.
RACONTRC server_name 2005/04/13 09:41:00.21 root
com.sybase.ra.conn.query.QueryException Thread-1
RACONTRC server_name 2005/04/13 09:41:00.21 root
com.sybase.ra.conn.query.QueryException Thread-1 SQLState:
ZZZZZ
RACONTRC server_name 2005/04/13 09:41:00.21 root
com.sybase.ra.conn.query.QueryException Thread-1 Remote
Code: 2008
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
execution failed.
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL ERROR --
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Message:
The object 'sp_repmarker' is not a procedure so you cannot create another
procedure under that group name.
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
SQLState: ZZZZZ
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Remote
Code: 2008
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL ERROR --
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Message:
The object 'sp_repmarker' is not a procedure so you cannot create another
procedure under that group name.
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
SQLState: ZZZZZ
E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Remote
Code: 2008
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 SQL execution failed.
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 SQL ERROR --
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Message: The object 'sp_repmarker' is not a
procedure so you cannot create another procedure under that group name.
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 SQLState: ZZZZZ
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Remote Code: 2008
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 SQL ERROR --
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Message: The object 'sp_repmarker' is not a
procedure so you cannot create another procedure under that group name.
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 SQLState: ZZZZZ
RACONTRC server_name 2005/04/13 09:41:00.24 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Remote Code: 2008
LATRC server_name 2005/04/13 09:41:00.26 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 Caught QueryException: The object 'sp_repmarker' is not a
procedure so you cannot create another procedure under that group name.
LATRC server_name 2005/04/13 09:41:00.26 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1
W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess Offending SQL
statement:
W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess --
W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess -- PLACES A MARKER
IN THE LOG
W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess --
W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess CREATE PROCEDURE
sp_repmarker
W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess @key
varchar(30),
W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess @value
varchar(255)
W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess AS
E. 2005/04/13 09:41:00.30. com.sybase.ra.la.DBAccess Work is being rolled
back because of problems executing script: The object 'sp_repmarker' is not
a procedure so you cannot create another procedure under that group name.
E. 2005/04/13 09:41:00.30. com.sybase.ra.la.DBAccess
LATRC server_name 2005/04/13 09:41:00.33 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 executeDdlList: force = false undo = true
LATRC server_name 2005/04/13 09:41:00.35 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 executing undo SQL:
LATRC server_name 2005/04/13 09:41:00.35 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 dbcc settrunc('ltm', 'ignore')
RACONTRCSQL server_name 2005/04/13 09:41:00.36 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:41:00.36 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 dbcc settrunc('ltm', 'ignore')
LATRC server_name 2005/04/13 09:41:00.40 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 executing undo SQL:
LATRC server_name 2005/04/13 09:41:00.40 root
com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
Thread-1 use DDB
RACONTRCSQL server_name 2005/04/13 09:41:00.43 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 Executing SQL:
RACONTRCSQL server_name 2005/04/13 09:41:00.43 root
com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
Thread-1 use DDB
RACONTRC server_name 2005/04/13 09:41:00.44 root
com.sybase.ra.conn.RAConnectionMgr.releaseConnection(RAConnectionMgr.java,
Compiled Code) Thread-1 Returned connection
<com.sybase.ra.conn.RAConnection@39393788> to pool.
E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin Could not
add Primary Connection <server_name.DB_Name_PRD> because: The object
'sp_repmarker' is not a procedure so you cannot create another procedure
under that group name.
E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
Thread-1 Command <sp_addprimaryconn> failed, received:
com.sybase.replite.da.DAException - Could not add Primary Connection
<server_name.DB_Name_PRD> because: The object 'sp_repmarker' is not a
procedure so you cannot create another procedure under that group name.
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
Thread-1
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
Code) Thread-1 Received execution status for sp_addprimaryconn
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
Code) Thread-1 Command failed
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
Code) Thread-1 Exception message: Command <sp_addprimaryconn>
failed - Could not add Primary Connection <server_name.DB_Name_PRD> because:
The object 'sp_repmarker' is not a procedure so you cannot create another
procedure under that group name.
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
Code) Thread-1
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
Code) Thread-1 Error number: 0
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
Code) Thread-1 Error level: 0
BMGRTRACE server_name 2005/04/13 09:41:00.46 root
com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
Code) Thread-1 Result data is null


##########################################################################################

I am able to create a replication for any database on that server except
"server_name.DB_Name_PRD"

TIA

Best Regards
ViBart

> Hi ViBart,
> are there any SQL error messages in Replicator log files? I would check
> for
> possible errors that may have happened
> prior to issuing 'sp_addprimaryconn xxx', for example, on
> 'sp_dropprimaryconn
> xxx'.
>
> Thanks,
> Victoria.
>
> ViBart wrote:
>
>> Welcome,
>>
>> Adaptive Server Enterprise/12.5.0.3/EBF 10696 IR/P/Linux Intel/Linux
>> 2.4.7-10smpi686/rel12503/1915/32-bit/OPT/
>>
>> I had started ASE Replicator with primary connection xxx (with
>> subs,articles,etc.), then I changed primary connection into yyy (and the
>> rest). Everything was fine. But when I try to back to xxx primary
>> connection
>> Sybase returns me this error:
>>
>> 1> sp_addprimaryconn "xxx"
>> 2> go
>> Msg 32000, Level 20, State 0:
>> Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
>> Command <sp_addprimaryconn> failed - Could not add Primary Connection
>> <xxx> because: The object 'sp_repmarker' is not a procedure so
>> you cannot create another procedure under that group name.
>>
>> Any ideas?
>>
>> TIA
>>
>> Best Regards
>> ViBart
>


Victoria Handros Posted on 2005-04-13 18:29:51.0Z
Message-ID: <425D651A.F21753A5@sybase.com>
From: Victoria Handros <vhandros@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.replicator
Subject: Re: ASE Replicator / ASE 12.5
References: <425a2cea$1@forums-1-dub> <425C5BC0.18A38B3E@sybase.com> <425cd2c4@forums-2-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: vhandros2k.sybase.com
X-Original-Trace: 13 Apr 2005 11:29:47 -0800, vhandros2k.sybase.com
Lines: 473
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Apr 2005 11:29:48 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Apr 2005 11:29:51 -0700
X-Trace: forums-1-dub 1113416991 10.22.108.75 (13 Apr 2005 11:29:51 -0700)
X-Original-Trace: 13 Apr 2005 11:29:51 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:66
Article PK: 103315

Hi ViBart,
you could try to delete sp_repmarker procedure manually from DB_Name_PRD database before
you add the primary connection. It is possible the procedure hasn't been fully deleted when
you dropped
the first primary connection to this database.

Thanks,
Victoria.

ViBart wrote:

> Welcome,
>
> I droped all subs,pubs,articles and primary rep connection with no errors.
>
> 1> sp_helprep
> 2> go
> type name status status_desc
> ---- -------------- ------ -----------
> DDB ASEReplicator 0 DOWN
>
> 1> sp_addprimaryconn "server_name.DB_Name_PRD"
> 2> go
> Msg 32000, Level 20, State 0:
> Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
> Command <sp_addprimaryconn> failed - Could not add Primary Connection
> <server_name.DB_Name_PRD> because: The object 'sp_repmarker' is not a
> procedure so
> you cannot create another procedure under that group name.
>
> ##################
> system.log:
> ##################
>
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
> execution failed.
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL ERROR --
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Message:
> The object 'sp_repmarker' is not a procedure so you cannot create another
> procedure under that group name.
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
> SQLState: ZZZZZ
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Remote
> Code: 2008
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL ERROR --
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Message:
> The object 'sp_repmarker' is not a procedure so you cannot create another
> procedure under that group name.
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
> SQLState: ZZZZZ
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Remote
> Code: 2008
> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess Offending SQL
> statement:
> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess --
> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess -- PLACES A MARKER
> IN THE LOG
> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess --
> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess CREATE PROCEDURE
> sp_repmarker
> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess @key
> varchar(30),
> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess @value
> varchar(255)
> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess AS
> E. 2005/04/13 09:41:00.32. com.sybase.ra.la.DBAccess Work is being rolled
> back because of problems executing script: The object 'sp_repmarker' is not
> a procedure so you cannot create another procedure under that group name.
> E. 2005/04/13 09:41:00.32. com.sybase.ra.la.DBAccess
> E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin Could not
> add Primary Connection <server_name.DB_Name_PRD> because: The object
> 'sp_repmarker' is not a procedure so you cannot create another procedure
> under that group name.
> E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin
>
> ##################
> trace.log:
> ##################
>
> BMGRTRACE server_name 2005/04/13 09:40:59.50 root
> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
> Code) Thread-1 Got RPC event from TDS: sp_addprimaryconn
> BMGRTRACE server_name 2005/04/13 09:40:59.50 root
> com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
> Thread-1 receive() - cmd: sp_addprimaryconn
> <server_name.DB_Name_PRD>, < >
> BMGRTRACE server_name 2005/04/13 09:40:59.51 root
> com.sybase.ra.beanmgr.CommandRouter.invokeCommand(CommandRouter.java,
> Compiled Code) Thread-1 Invoking method:
> com.sybase.replite.da.DDBAdmin.createPriConnection()
> RACONTRC server_name 2005/04/13 09:40:59.52 root
> com.sybase.ra.conn.RAConnectionMgr.nextConnection(RAConnectionMgr.java,
> Compiled Code) Thread-1 Obtained connection
> <com.sybase.ra.conn.RAConnection@39393788> from pool.
> RACONTRCSQL server_name 2005/04/13 09:40:59.58 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:40:59.58 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 select * from connections where conn_type = 1 and ds =
> 'server_name' and db = 'server_name_PRD' order by ds, db
> RACONTRCSQL server_name 2005/04/13 09:40:59.60 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:40:59.60 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 select * from master..sysservers where srvname =
> 'server_name'
> RACONTRCSQL server_name 2005/04/13 09:40:59.62 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:40:59.62 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 select rl_user = suser_name()
> LATRC server_name 2005/04/13 09:40:59.64 root
> com.sybase.ra.la.ScriptBuffer.<init>(ScriptBuffer.java, Compiled Code)
> Thread-1 ScriptBuffer() received a NULL file name.
> RACONTRCSQL server_name 2005/04/13 09:40:59.65 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:40:59.65 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 sp_databases
> RACONTRCSQL server_name 2005/04/13 09:40:59.67 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:40:59.67 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 select count(*) from server_name_PRD..sysusers where name =
> 'rpl'
> LATRC server_name 2005/04/13 09:40:59.75 root
> com.sybase.ra.la.ScriptBuffer.<init>(ScriptBuffer.java, Compiled Code)
> Thread-1 ScriptBuffer() received a NULL file name.
> LATRC server_name 2005/04/13 09:40:59.77 root
> com.sybase.ra.la.ScriptBuffer.getFileName(ScriptBuffer.java, Compiled Code)
> Thread-1 getFileName() returning NULL
> LATRC server_name 2005/04/13 09:40:59.78 root
> com.sybase.replite.da.Catalog.writeAndExec(Catalog.java, Compiled Code)
> Thread-1 writeAndExec(): Writing SQL script to null
> LATRC server_name 2005/04/13 09:40:59.79 root
> com.sybase.ra.la.ScriptBuffer.writeToFile(ScriptBuffer.java, Compiled Code)
> Thread-1 writeToFile() has NULL file
> LATRC server_name 2005/04/13 09:40:59.80 root
> com.sybase.replite.da.Catalog.writeAndExec(Catalog.java, Compiled Code)
> Thread-1 writeAndExec() Executing SQL commands.
> LATRC server_name 2005/04/13 09:40:59.83 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 executeDdlList: force = false undo = false
> LATRC server_name 2005/04/13 09:40:59.84 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 executing SQL:
> LATRC server_name 2005/04/13 09:40:59.84 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 use server_name_PRD
> RACONTRCSQL server_name 2005/04/13 09:40:59.85 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:40:59.85 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 use server_name_PRD
> LATRC server_name 2005/04/13 09:40:59.97 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 skipping SQL:
> LATRC server_name 2005/04/13 09:40:59.97 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 go
> LATRC server_name 2005/04/13 09:40:59.98 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 executing SQL:
> LATRC server_name 2005/04/13 09:40:59.98 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 dbcc settrunc('ltm', 'end')
> RACONTRCSQL server_name 2005/04/13 09:41:00.05 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:41:00.05 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 dbcc settrunc('ltm', 'end')
> LATRC server_name 2005/04/13 09:41:00.12 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 skipping SQL:
> LATRC server_name 2005/04/13 09:41:00.12 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 go
> LATRC server_name 2005/04/13 09:41:00.13 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 executing SQL:
> LATRC server_name 2005/04/13 09:41:00.13 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 --
> LATRC server_name 2005/04/13 09:41:00.13 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 -- PLACES A MARKER IN THE LOG
> LATRC server_name 2005/04/13 09:41:00.13 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 --
> LATRC server_name 2005/04/13 09:41:00.13 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 CREATE PROCEDURE sp_repmarker
> LATRC server_name 2005/04/13 09:41:00.13 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 @key varchar(30),
> LATRC server_name 2005/04/13 09:41:00.13 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 @value varchar(255)
> LATRC server_name 2005/04/13 09:41:00.13 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 AS
> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 --
> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 -- PLACES A MARKER IN THE LOG
> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 --
> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 CREATE PROCEDURE sp_repmarker
> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 @key varchar(30),
> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 @value varchar(255)
> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 AS
> RACONTRC server_name 2005/04/13 09:41:00.18 root
> com.sybase.ra.conn.query.QueryException Thread-1 SQL execution
> failed.
> RACONTRC server_name 2005/04/13 09:41:00.20 root
> com.sybase.ra.conn.query.QueryException Thread-1 Offending SQL
> statement:
> RACONTRC server_name 2005/04/13 09:41:00.20 root
> com.sybase.ra.conn.query.QueryException Thread-1 --
> RACONTRC server_name 2005/04/13 09:41:00.20 root
> com.sybase.ra.conn.query.QueryException Thread-1 -- PLACES A
> MARKER IN THE LOG
> RACONTRC server_name 2005/04/13 09:41:00.20 root
> com.sybase.ra.conn.query.QueryException Thread-1 --
> RACONTRC server_name 2005/04/13 09:41:00.20 root
> com.sybase.ra.conn.query.QueryException Thread-1 CREATE
> PROCEDURE sp_repmarker
> RACONTRC server_name 2005/04/13 09:41:00.20 root
> com.sybase.ra.conn.query.QueryException Thread-1 @key
> varchar(30),
> RACONTRC server_name 2005/04/13 09:41:00.20 root
> com.sybase.ra.conn.query.QueryException Thread-1 @value
> varchar(255)
> RACONTRC server_name 2005/04/13 09:41:00.20 root
> com.sybase.ra.conn.query.QueryException Thread-1 AS
> RACONTRC server_name 2005/04/13 09:41:00.21 root
> com.sybase.ra.conn.query.QueryException Thread-1
> RACONTRC server_name 2005/04/13 09:41:00.21 root
> com.sybase.ra.conn.query.QueryException Thread-1 SQL ERROR --
> RACONTRC server_name 2005/04/13 09:41:00.21 root
> com.sybase.ra.conn.query.QueryException Thread-1 Message:
> The object 'sp_repmarker' is not a procedure so you cannot create another
> procedure under that group name.
> RACONTRC server_name 2005/04/13 09:41:00.21 root
> com.sybase.ra.conn.query.QueryException Thread-1
> RACONTRC server_name 2005/04/13 09:41:00.21 root
> com.sybase.ra.conn.query.QueryException Thread-1 SQLState:
> ZZZZZ
> RACONTRC server_name 2005/04/13 09:41:00.21 root
> com.sybase.ra.conn.query.QueryException Thread-1 Remote
> Code: 2008
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
> execution failed.
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL ERROR --
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Message:
> The object 'sp_repmarker' is not a procedure so you cannot create another
> procedure under that group name.
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
> SQLState: ZZZZZ
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Remote
> Code: 2008
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL ERROR --
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Message:
> The object 'sp_repmarker' is not a procedure so you cannot create another
> procedure under that group name.
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
> SQLState: ZZZZZ
> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection Remote
> Code: 2008
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 SQL execution failed.
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 SQL ERROR --
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Message: The object 'sp_repmarker' is not a
> procedure so you cannot create another procedure under that group name.
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 SQLState: ZZZZZ
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Remote Code: 2008
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 SQL ERROR --
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Message: The object 'sp_repmarker' is not a
> procedure so you cannot create another procedure under that group name.
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 SQLState: ZZZZZ
> RACONTRC server_name 2005/04/13 09:41:00.24 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Remote Code: 2008
> LATRC server_name 2005/04/13 09:41:00.26 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 Caught QueryException: The object 'sp_repmarker' is not a
> procedure so you cannot create another procedure under that group name.
> LATRC server_name 2005/04/13 09:41:00.26 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1
> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess Offending SQL
> statement:
> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess --
> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess -- PLACES A MARKER
> IN THE LOG
> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess --
> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess CREATE PROCEDURE
> sp_repmarker
> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess @key
> varchar(30),
> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess @value
> varchar(255)
> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess AS
> E. 2005/04/13 09:41:00.30. com.sybase.ra.la.DBAccess Work is being rolled
> back because of problems executing script: The object 'sp_repmarker' is not
> a procedure so you cannot create another procedure under that group name.
> E. 2005/04/13 09:41:00.30. com.sybase.ra.la.DBAccess
> LATRC server_name 2005/04/13 09:41:00.33 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 executeDdlList: force = false undo = true
> LATRC server_name 2005/04/13 09:41:00.35 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 executing undo SQL:
> LATRC server_name 2005/04/13 09:41:00.35 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 dbcc settrunc('ltm', 'ignore')
> RACONTRCSQL server_name 2005/04/13 09:41:00.36 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:41:00.36 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 dbcc settrunc('ltm', 'ignore')
> LATRC server_name 2005/04/13 09:41:00.40 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 executing undo SQL:
> LATRC server_name 2005/04/13 09:41:00.40 root
> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
> Thread-1 use DDB
> RACONTRCSQL server_name 2005/04/13 09:41:00.43 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 Executing SQL:
> RACONTRCSQL server_name 2005/04/13 09:41:00.43 root
> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
> Thread-1 use DDB
> RACONTRC server_name 2005/04/13 09:41:00.44 root
> com.sybase.ra.conn.RAConnectionMgr.releaseConnection(RAConnectionMgr.java,
> Compiled Code) Thread-1 Returned connection
> <com.sybase.ra.conn.RAConnection@39393788> to pool.
> E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin Could not
> add Primary Connection <server_name.DB_Name_PRD> because: The object
> 'sp_repmarker' is not a procedure so you cannot create another procedure
> under that group name.
> E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
> Thread-1 Command <sp_addprimaryconn> failed, received:
> com.sybase.replite.da.DAException - Could not add Primary Connection
> <server_name.DB_Name_PRD> because: The object 'sp_repmarker' is not a
> procedure so you cannot create another procedure under that group name.
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
> Thread-1
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
> Code) Thread-1 Received execution status for sp_addprimaryconn
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
> Code) Thread-1 Command failed
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
> Code) Thread-1 Exception message: Command <sp_addprimaryconn>
> failed - Could not add Primary Connection <server_name.DB_Name_PRD> because:
> The object 'sp_repmarker' is not a procedure so you cannot create another
> procedure under that group name.
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
> Code) Thread-1
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
> Code) Thread-1 Error number: 0
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
> Code) Thread-1 Error level: 0
> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java, Compiled
> Code) Thread-1 Result data is null
>
> ##########################################################################################
>
> I am able to create a replication for any database on that server except
> "server_name.DB_Name_PRD"
>
> TIA
>
> Best Regards
> ViBart
>
> > Hi ViBart,
> > are there any SQL error messages in Replicator log files? I would check
> > for
> > possible errors that may have happened
> > prior to issuing 'sp_addprimaryconn xxx', for example, on
> > 'sp_dropprimaryconn
> > xxx'.
> >
> > Thanks,
> > Victoria.
> >
> > ViBart wrote:
> >
> >> Welcome,
> >>
> >> Adaptive Server Enterprise/12.5.0.3/EBF 10696 IR/P/Linux Intel/Linux
> >> 2.4.7-10smpi686/rel12503/1915/32-bit/OPT/
> >>
> >> I had started ASE Replicator with primary connection xxx (with
> >> subs,articles,etc.), then I changed primary connection into yyy (and the
> >> rest). Everything was fine. But when I try to back to xxx primary
> >> connection
> >> Sybase returns me this error:
> >>
> >> 1> sp_addprimaryconn "xxx"
> >> 2> go
> >> Msg 32000, Level 20, State 0:
> >> Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
> >> Command <sp_addprimaryconn> failed - Could not add Primary Connection
> >> <xxx> because: The object 'sp_repmarker' is not a procedure so
> >> you cannot create another procedure under that group name.
> >>
> >> Any ideas?
> >>
> >> TIA
> >>
> >> Best Regards
> >> ViBart
> >


ViBart Posted on 2005-04-14 08:21:52.0Z
From: "ViBart" <bartekz@uhc.com.pl>
Newsgroups: sybase.public.ase.replicator
References: <425a2cea$1@forums-1-dub> <425C5BC0.18A38B3E@sybase.com> <425cd2c4@forums-2-dub> <425D651A.F21753A5@sybase.com>
Subject: Re: ASE Replicator / ASE 12.5
Lines: 539
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Antivirus: avast! (VPS 0515-1, 2005-04-12), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: gate.uhc.lublin.pl
X-Original-NNTP-Posting-Host: gate.uhc.lublin.pl
Message-ID: <425e2820@forums-1-dub>
Date: 14 Apr 2005 01:21:52 -0700
X-Trace: forums-1-dub 1113466912 212.182.110.2 (14 Apr 2005 01:21:52 -0700)
X-Original-Trace: 14 Apr 2005 01:21:52 -0700, gate.uhc.lublin.pl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:67
Article PK: 103313

Welcome,

Big Thanks!!

The body of the sp_repmarker procedure was:

-- PLACES A MARKER IN THE LOG
--
CREATE PROCEDURE sp_repmarker
@key varc
har(30),
@value varchar(255)
AS

(1 row affected)
(return status = 0)

So it hadn't been created correctly.

Dropping procedure solved this problem!

Once again thanks!!!

Pozdrawiam / Best Regards
ViBart

> Hi ViBart,
> you could try to delete sp_repmarker procedure manually from DB_Name_PRD
> database before
> you add the primary connection. It is possible the procedure hasn't been
> fully deleted when
> you dropped
> the first primary connection to this database.
>
> Thanks,
> Victoria.
>
> ViBart wrote:
>
>> Welcome,
>>
>> I droped all subs,pubs,articles and primary rep connection with no
>> errors.
>>
>> 1> sp_helprep
>> 2> go
>> type name status status_desc
>> ---- -------------- ------ -----------
>> DDB ASEReplicator 0 DOWN
>>
>> 1> sp_addprimaryconn "server_name.DB_Name_PRD"
>> 2> go
>> Msg 32000, Level 20, State 0:
>> Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
>> Command <sp_addprimaryconn> failed - Could not add Primary Connection
>> <server_name.DB_Name_PRD> because: The object 'sp_repmarker' is not a
>> procedure so
>> you cannot create another procedure under that group name.
>>
>> ##################
>> system.log:
>> ##################
>>
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
>> execution failed.
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
>> ERROR --
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> Message:
>> The object 'sp_repmarker' is not a procedure so you cannot create another
>> procedure under that group name.
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> SQLState: ZZZZZ
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> Remote
>> Code: 2008
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
>> ERROR --
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> Message:
>> The object 'sp_repmarker' is not a procedure so you cannot create another
>> procedure under that group name.
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> SQLState: ZZZZZ
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> Remote
>> Code: 2008
>> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess Offending SQL
>> statement:
>> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess --
>> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess -- PLACES A
>> MARKER
>> IN THE LOG
>> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess --
>> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess CREATE PROCEDURE
>> sp_repmarker
>> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess @key
>> varchar(30),
>> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess @value
>> varchar(255)
>> W. 2005/04/13 09:41:00.29. com.sybase.ra.la.DBAccess AS
>> E. 2005/04/13 09:41:00.32. com.sybase.ra.la.DBAccess Work is being
>> rolled
>> back because of problems executing script: The object 'sp_repmarker' is
>> not
>> a procedure so you cannot create another procedure under that group name.
>> E. 2005/04/13 09:41:00.32. com.sybase.ra.la.DBAccess
>> E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin Could not
>> add Primary Connection <server_name.DB_Name_PRD> because: The object
>> 'sp_repmarker' is not a procedure so you cannot create another procedure
>> under that group name.
>> E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin
>>
>> ##################
>> trace.log:
>> ##################
>>
>> BMGRTRACE server_name 2005/04/13 09:40:59.50 root
>> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java,
>> Compiled
>> Code) Thread-1 Got RPC event from TDS: sp_addprimaryconn
>> BMGRTRACE server_name 2005/04/13 09:40:59.50 root
>> com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
>> Thread-1 receive() - cmd: sp_addprimaryconn
>> <server_name.DB_Name_PRD>, < >
>> BMGRTRACE server_name 2005/04/13 09:40:59.51 root
>> com.sybase.ra.beanmgr.CommandRouter.invokeCommand(CommandRouter.java,
>> Compiled Code) Thread-1 Invoking method:
>> com.sybase.replite.da.DDBAdmin.createPriConnection()
>> RACONTRC server_name 2005/04/13 09:40:59.52 root
>> com.sybase.ra.conn.RAConnectionMgr.nextConnection(RAConnectionMgr.java,
>> Compiled Code) Thread-1 Obtained connection
>> <com.sybase.ra.conn.RAConnection@39393788> from pool.
>> RACONTRCSQL server_name 2005/04/13 09:40:59.58 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:40:59.58 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 select * from connections where conn_type = 1 and ds =
>> 'server_name' and db = 'server_name_PRD' order by ds, db
>> RACONTRCSQL server_name 2005/04/13 09:40:59.60 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:40:59.60 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 select * from master..sysservers where srvname =
>> 'server_name'
>> RACONTRCSQL server_name 2005/04/13 09:40:59.62 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:40:59.62 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 select rl_user = suser_name()
>> LATRC server_name 2005/04/13 09:40:59.64 root
>> com.sybase.ra.la.ScriptBuffer.<init>(ScriptBuffer.java, Compiled Code)
>> Thread-1 ScriptBuffer() received a NULL file name.
>> RACONTRCSQL server_name 2005/04/13 09:40:59.65 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:40:59.65 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 sp_databases
>> RACONTRCSQL server_name 2005/04/13 09:40:59.67 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:40:59.67 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 select count(*) from server_name_PRD..sysusers where name
>> =
>> 'rpl'
>> LATRC server_name 2005/04/13 09:40:59.75 root
>> com.sybase.ra.la.ScriptBuffer.<init>(ScriptBuffer.java, Compiled Code)
>> Thread-1 ScriptBuffer() received a NULL file name.
>> LATRC server_name 2005/04/13 09:40:59.77 root
>> com.sybase.ra.la.ScriptBuffer.getFileName(ScriptBuffer.java, Compiled
>> Code)
>> Thread-1 getFileName() returning NULL
>> LATRC server_name 2005/04/13 09:40:59.78 root
>> com.sybase.replite.da.Catalog.writeAndExec(Catalog.java, Compiled Code)
>> Thread-1 writeAndExec(): Writing SQL script to null
>> LATRC server_name 2005/04/13 09:40:59.79 root
>> com.sybase.ra.la.ScriptBuffer.writeToFile(ScriptBuffer.java, Compiled
>> Code)
>> Thread-1 writeToFile() has NULL file
>> LATRC server_name 2005/04/13 09:40:59.80 root
>> com.sybase.replite.da.Catalog.writeAndExec(Catalog.java, Compiled Code)
>> Thread-1 writeAndExec() Executing SQL commands.
>> LATRC server_name 2005/04/13 09:40:59.83 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 executeDdlList: force = false undo = false
>> LATRC server_name 2005/04/13 09:40:59.84 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 executing SQL:
>> LATRC server_name 2005/04/13 09:40:59.84 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 use server_name_PRD
>> RACONTRCSQL server_name 2005/04/13 09:40:59.85 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:40:59.85 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 use server_name_PRD
>> LATRC server_name 2005/04/13 09:40:59.97 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 skipping SQL:
>> LATRC server_name 2005/04/13 09:40:59.97 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 go
>> LATRC server_name 2005/04/13 09:40:59.98 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 executing SQL:
>> LATRC server_name 2005/04/13 09:40:59.98 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 dbcc settrunc('ltm', 'end')
>> RACONTRCSQL server_name 2005/04/13 09:41:00.05 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:41:00.05 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 dbcc settrunc('ltm', 'end')
>> LATRC server_name 2005/04/13 09:41:00.12 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 skipping SQL:
>> LATRC server_name 2005/04/13 09:41:00.12 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 go
>> LATRC server_name 2005/04/13 09:41:00.13 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 executing SQL:
>> LATRC server_name 2005/04/13 09:41:00.13 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 --
>> LATRC server_name 2005/04/13 09:41:00.13 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 -- PLACES A MARKER IN THE LOG
>> LATRC server_name 2005/04/13 09:41:00.13 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 --
>> LATRC server_name 2005/04/13 09:41:00.13 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 CREATE PROCEDURE sp_repmarker
>> LATRC server_name 2005/04/13 09:41:00.13 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 @key varchar(30),
>> LATRC server_name 2005/04/13 09:41:00.13 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 @value varchar(255)
>> LATRC server_name 2005/04/13 09:41:00.13 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 AS
>> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 --
>> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 -- PLACES A MARKER IN THE LOG
>> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 --
>> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 CREATE PROCEDURE sp_repmarker
>> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 @key varchar(30),
>> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 @value varchar(255)
>> RACONTRCSQL server_name 2005/04/13 09:41:00.14 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 AS
>> RACONTRC server_name 2005/04/13 09:41:00.18 root
>> com.sybase.ra.conn.query.QueryException Thread-1 SQL
>> execution
>> failed.
>> RACONTRC server_name 2005/04/13 09:41:00.20 root
>> com.sybase.ra.conn.query.QueryException Thread-1 Offending
>> SQL
>> statement:
>> RACONTRC server_name 2005/04/13 09:41:00.20 root
>> com.sybase.ra.conn.query.QueryException Thread-1 --
>> RACONTRC server_name 2005/04/13 09:41:00.20 root
>> com.sybase.ra.conn.query.QueryException Thread-1 -- PLACES A
>> MARKER IN THE LOG
>> RACONTRC server_name 2005/04/13 09:41:00.20 root
>> com.sybase.ra.conn.query.QueryException Thread-1 --
>> RACONTRC server_name 2005/04/13 09:41:00.20 root
>> com.sybase.ra.conn.query.QueryException Thread-1 CREATE
>> PROCEDURE sp_repmarker
>> RACONTRC server_name 2005/04/13 09:41:00.20 root
>> com.sybase.ra.conn.query.QueryException Thread-1 @key
>> varchar(30),
>> RACONTRC server_name 2005/04/13 09:41:00.20 root
>> com.sybase.ra.conn.query.QueryException Thread-1 @value
>> varchar(255)
>> RACONTRC server_name 2005/04/13 09:41:00.20 root
>> com.sybase.ra.conn.query.QueryException Thread-1 AS
>> RACONTRC server_name 2005/04/13 09:41:00.21 root
>> com.sybase.ra.conn.query.QueryException Thread-1
>> RACONTRC server_name 2005/04/13 09:41:00.21 root
>> com.sybase.ra.conn.query.QueryException Thread-1 SQL ERROR --
>> RACONTRC server_name 2005/04/13 09:41:00.21 root
>> com.sybase.ra.conn.query.QueryException Thread-1 Message:
>> The object 'sp_repmarker' is not a procedure so you cannot create another
>> procedure under that group name.
>> RACONTRC server_name 2005/04/13 09:41:00.21 root
>> com.sybase.ra.conn.query.QueryException Thread-1
>> RACONTRC server_name 2005/04/13 09:41:00.21 root
>> com.sybase.ra.conn.query.QueryException Thread-1
>> SQLState:
>> ZZZZZ
>> RACONTRC server_name 2005/04/13 09:41:00.21 root
>> com.sybase.ra.conn.query.QueryException Thread-1 Remote
>> Code: 2008
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
>> execution failed.
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
>> ERROR --
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> Message:
>> The object 'sp_repmarker' is not a procedure so you cannot create another
>> procedure under that group name.
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> SQLState: ZZZZZ
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> Remote
>> Code: 2008
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection SQL
>> ERROR --
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> Message:
>> The object 'sp_repmarker' is not a procedure so you cannot create another
>> procedure under that group name.
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> SQLState: ZZZZZ
>> E. 2005/04/13 09:41:00.22. com.sybase.ra.conn.RAConnection
>> Remote
>> Code: 2008
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 SQL execution failed.
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 SQL ERROR --
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Message: The object 'sp_repmarker' is not a
>> procedure so you cannot create another procedure under that group name.
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 SQLState: ZZZZZ
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Remote Code: 2008
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 SQL ERROR --
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Message: The object 'sp_repmarker' is not a
>> procedure so you cannot create another procedure under that group name.
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 SQLState: ZZZZZ
>> RACONTRC server_name 2005/04/13 09:41:00.24 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Remote Code: 2008
>> LATRC server_name 2005/04/13 09:41:00.26 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 Caught QueryException: The object 'sp_repmarker' is not a
>> procedure so you cannot create another procedure under that group name.
>> LATRC server_name 2005/04/13 09:41:00.26 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1
>> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess Offending SQL
>> statement:
>> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess --
>> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess -- PLACES A
>> MARKER
>> IN THE LOG
>> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess --
>> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess CREATE PROCEDURE
>> sp_repmarker
>> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess @key
>> varchar(30),
>> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess @value
>> varchar(255)
>> W. 2005/04/13 09:41:00.28. com.sybase.ra.la.DBAccess AS
>> E. 2005/04/13 09:41:00.30. com.sybase.ra.la.DBAccess Work is being
>> rolled
>> back because of problems executing script: The object 'sp_repmarker' is
>> not
>> a procedure so you cannot create another procedure under that group name.
>> E. 2005/04/13 09:41:00.30. com.sybase.ra.la.DBAccess
>> LATRC server_name 2005/04/13 09:41:00.33 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 executeDdlList: force = false undo = true
>> LATRC server_name 2005/04/13 09:41:00.35 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 executing undo SQL:
>> LATRC server_name 2005/04/13 09:41:00.35 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 dbcc settrunc('ltm', 'ignore')
>> RACONTRCSQL server_name 2005/04/13 09:41:00.36 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:41:00.36 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 dbcc settrunc('ltm', 'ignore')
>> LATRC server_name 2005/04/13 09:41:00.40 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 executing undo SQL:
>> LATRC server_name 2005/04/13 09:41:00.40 root
>> com.sybase.ra.la.DBAccess.executeDdlList(DBAccess.java, Compiled Code)
>> Thread-1 use DDB
>> RACONTRCSQL server_name 2005/04/13 09:41:00.43 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 Executing SQL:
>> RACONTRCSQL server_name 2005/04/13 09:41:00.43 root
>> com.sybase.ra.conn.RAConnection.execute(RAConnection.java, Compiled Code)
>> Thread-1 use DDB
>> RACONTRC server_name 2005/04/13 09:41:00.44 root
>> com.sybase.ra.conn.RAConnectionMgr.releaseConnection(RAConnectionMgr.java,
>> Compiled Code) Thread-1 Returned connection
>> <com.sybase.ra.conn.RAConnection@39393788> to pool.
>> E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin Could not
>> add Primary Connection <server_name.DB_Name_PRD> because: The object
>> 'sp_repmarker' is not a procedure so you cannot create another procedure
>> under that group name.
>> E. 2005/04/13 09:41:00.45. com.sybase.replite.da.DDBAdmin
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
>> Thread-1 Command <sp_addprimaryconn> failed, received:
>> com.sybase.replite.da.DAException - Could not add Primary Connection
>> <server_name.DB_Name_PRD> because: The object 'sp_repmarker' is not a
>> procedure so you cannot create another procedure under that group name.
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.MaintPort.receive(MaintPort.java, Compiled Code)
>> Thread-1
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java,
>> Compiled
>> Code) Thread-1 Received execution status for sp_addprimaryconn
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java,
>> Compiled
>> Code) Thread-1 Command failed
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java,
>> Compiled
>> Code) Thread-1 Exception message: Command
>> <sp_addprimaryconn>
>> failed - Could not add Primary Connection <server_name.DB_Name_PRD>
>> because:
>> The object 'sp_repmarker' is not a procedure so you cannot create another
>> procedure under that group name.
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java,
>> Compiled
>> Code) Thread-1
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java,
>> Compiled
>> Code) Thread-1 Error number: 0
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java,
>> Compiled
>> Code) Thread-1 Error level: 0
>> BMGRTRACE server_name 2005/04/13 09:41:00.46 root
>> com.sybase.ra.beanmgr.TDSPortHandler.handleRPC(TDSPortHandler.java,
>> Compiled
>> Code) Thread-1 Result data is null
>>
>> ##########################################################################################
>>
>> I am able to create a replication for any database on that server except
>> "server_name.DB_Name_PRD"
>>
>> TIA
>>
>> Best Regards
>> ViBart
>>
>> > Hi ViBart,
>> > are there any SQL error messages in Replicator log files? I would check
>> > for
>> > possible errors that may have happened
>> > prior to issuing 'sp_addprimaryconn xxx', for example, on
>> > 'sp_dropprimaryconn
>> > xxx'.
>> >
>> > Thanks,
>> > Victoria.
>> >
>> > ViBart wrote:
>> >
>> >> Welcome,
>> >>
>> >> Adaptive Server Enterprise/12.5.0.3/EBF 10696 IR/P/Linux Intel/Linux
>> >> 2.4.7-10smpi686/rel12503/1915/32-bit/OPT/
>> >>
>> >> I had started ASE Replicator with primary connection xxx (with
>> >> subs,articles,etc.), then I changed primary connection into yyy (and
>> >> the
>> >> rest). Everything was fine. But when I try to back to xxx primary
>> >> connection
>> >> Sybase returns me this error:
>> >>
>> >> 1> sp_addprimaryconn "xxx"
>> >> 2> go
>> >> Msg 32000, Level 20, State 0:
>> >> Server 'ASE_Rep', Procedure 'sp_addprimaryconn', Line 1:
>> >> Command <sp_addprimaryconn> failed - Could not add Primary Connection
>> >> <xxx> because: The object 'sp_repmarker' is not a procedure so
>> >> you cannot create another procedure under that group name.
>> >>
>> >> Any ideas?
>> >>
>> >> TIA
>> >>
>> >> Best Regards
>> >> ViBart
>> >
>