Distribution Agents Failed

Question

Distribution Agents Failed

CooLDBA

Hall of Fame

Points: 3301
More actions
October 9, 2007 at 3:09 pm

#95525

In SQL 2000,
ORA-00955: name is already used by an existing object
create table MSrepl7 (pubsrv varchar2 (128), pubdb varchar2 (128), publcn varchar2 (128), indagent number (1, 0),subtype number (10, 0), dstagent varchar2 (100),timecol date,descr varchar2 (255), xactts raw (16), updmode number (3, 0), agentid raw (16), subguid raw (16), subid raw (16), immsync number (1, 0))
I have two publication,
it seems that anytime distribution agents run it create the MSrepl7 table.
any solutions for this? I can't find any answers in Google search. =(

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Erik Bitemo SSCrazy Points: 2062 More actions · Answer 1

Hi,

Can you write a bit more about the architecture? It seems that you're replicationg into Oracle. Which version and what kind of replication?

-- Erik

-- Erik http://blog.rollback.hu

CooLDBA Hall of Fame Points: 3301 More actions · Answer 2

CooLDBA

Hall of Fame

Points: 3301

October 12, 2007 at 9:28 am

#741640

Don't worry!

I figured it out!

Thanks anyways!

duxingdaxia Grasshopper Points: 21 More actions · Answer 3

I have the same problem,

can you tell me how you figured it out?

Thank you!!!

christopher83 Valued Member Points: 67 More actions · Answer 4

I'm also having this issue, could you shed some more light on your solution please?

Kathleen.Ford SSC Enthusiast Points: 104 More actions · Answer 5

I fixed the problem by granting sysadm to my datasource ID...It needs it to create the rep table and the package MSC001. Once the replication is up and running , you can change the ID to have cntl access only..also ensure the ID's password does not expire...

Kathleen.Ford SSC Enthusiast Points: 104 More actions · Answer 6

I just wanted to add that I deleted the MSREPL7

table initially ( we already had a table), so it could create the table. It created the table in the system tables..DSNDB04

Pancho flores Valued Member Points: 53 More actions · Answer 7

Hello All,

Im running into the same problem but I can't seem to fix the "Drop Table MSREPL7" if anybody can give me a hint on how to configure the permissions on the SQL Server so that it drops the Table and Recreates it automatically, that would be awesome.

thank u in advance

CooLDBA Hall of Fame Points: 3301 More actions · Answer 8

Sorry for the delay. What I did last time was I modified the automatic created script under the path you specified (e.g. \MSSQL\ReplData) under Publication Properties --> Snapshot --> Location of snapshot files.

It works for me. I hope this help.