Hello,
I have problem while creating subscription (at the same PC as publication).
I have succesfully created publication in Oracle and then I tried to create subscription in SQLServer. In SQLServer there are created seven tables with prefix "rep_". The operation finishes with this message: Can not find the xml file at specified path.
Thank you for your help
beginnerJ
This is written in log on publisher site
IX 25 11:38:27 INFO [AWT-EventQueue-0] replication.ReplicationServer - URL rmi://0.0.0.0:3001/PC001_3001 PORT 3001
IX 25 11:39:59 INFO [RMI TCP Connection(4)-192.168.2.100] replication.Utility - Oracle
IX 25 11:40:01 INFO [RMI TCP Connection(4)-192.168.2.100] replication.Utility - Oracle
IX 25 11:40:01 INFO [RMI TCP Connection(4)-192.168.2.100] replication.Publication - conflictResolver publisher_wins
IX 25 11:40:01 INFO [RMI TCP Connection(4)-192.168.2.100] replication.ReplicationServer - Publisher name pub conflictResolver publisher_wins TableNames [REPTABLE NAME [O.T1] PRIMCOLS [[Ljava.lang.String;@15dc37d] ConflictResolver [publisher_wins] Filter [null] ]
IX 25 11:40:01 INFO [RMI TCP Connection(4)-192.168.2.100] replication.Publication - Returning conflictResolver publisher_wins
IX 25 11:40:01 INFO [RMI TCP Connection(4)-192.168.2.100] replication.Utility – Oracle
This is written on subscriber site:
IX 25 11:39:34 INFO [AWT-EventQueue-0] replication.ReplicationServer - URL rmi://0.0.0.0:3002/PC001_3002 PORT 3002
IX 25 11:39:58 INFO [AWT-EventQueue-0] replication.Utility - Microsoft SQL Server
IX 25 11:39:58 INFO [AWT-EventQueue-0] replication.Utility - Microsoft SQL Server
IX 25 11:39:59 INFO [AWT-EventQueue-0] replication.ReplicationServer - created subscription sub with publication pub
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed Create Table Rep_Subscriptions ( Rep_Sub_Name varchar(255) , Rep_pub_Name varchar(255) , Rep_conflict_resolver varchar(255) , Rep_server_Name varchar (255) , Primary Key (Rep_Sub_Name) )
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed Create Table Rep_BookMarkTable ( Rep_LocalName varchar(255) , Rep_RemoteName varchar(255) , Rep_Table_Name varchar(255) , Rep_Last_Sync_ID bigint , Rep_ConsideredId bigint ,Rep_IsDeletedTable char(1) default 'N' , Primary Key (Rep_LocalName, Rep_RemoteName, Rep_Table_Name) )
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed Create Table Rep_LogTable ( Rep_cid bigint identity , Rep_table_name varchar(255) )
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed CREATE INDEX Rep_LogIndex ON Rep_LogTable(Rep_cid)
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed Create Table Rep_RepTable ( Rep_PubSub_Name varchar(255) , Rep_Table_Id int identity, Rep_Table_Name varchar(255) , Rep_filter_clause varchar(255) , Rep_createshadowtable char(1) Default 'Y', Rep_cyclicdependency char(1) Default 'N', Rep_conflict_resolver varchar(255), Primary Key (Rep_PubSub_Name , Rep_Table_Name ) )
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed Create Table Rep_ScheduleTable ( Rep_schedule_name varchar(255) , Rep_Sub_Name varchar(255) unique , Rep_scheduleType varchar(255) , Rep_server_Name varchar (255) ,Rep_publicationPortNo varchar(255) , Rep_recurrenceType varchar(255) , Rep_replicationType varchar(255) , Rep_scheduleTime bigint , Rep_scheduleCounter bigint , Primary Key (Rep_schedule_name , Rep_Sub_Name) )
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed Create Table Rep_IgnoredColumnsTable ( Rep_Table_Id int , Rep_ignoredcolumnName varchar(255) , Primary Key (Rep_Table_Id , Rep_ignoredcolumnName ) )
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed CREATE TABLE Rep_TrackRepTabUpdation ( TrackUpdation bit PRIMARY KEY)
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed Insert into Rep_TrackRepTabUpdation values(1)
IX 25 11:39:59 INFO [AWT-EventQueue-0] DBHandler.AbstractDataBaseHandler - Query executed CREATE TRIGGER TRI_Rep_TrackRepTabUpdation ON Rep_TrackRepTabUpdation AFTER INSERT AS DELETE FROM Rep_TrackRepTabUpdation WHERE TrackUpdation NOT IN(SELECT * FROM inserted)


Try putting the appropriate
Try putting the appropriate hostnames in dbreplicator.conf on both publisher and subscriber. This should resolve it for you.
Sorry, If you're running on
Sorry,
If you're running on windows, dbreplicator.conf is ignored. Get the latest files from sourceforge (They're new as of today). They have the definitions in the batch files that you'll need to make this work. Ignore any *.conf file, as these are only used on *nix systems.
B