I have having a registration issue to the child. Can you please give me some suggestions?
[source] - RegistrationUriHandler - child:001:? was not allowed to register. [child] - RegistrationService - Waiting for registration to be accepted by the server. Registration is not open. [child] - RegistrationService - Could not register. Sleeping for 20000ms before attempting again.
Terminate batch job (Y/N)? Y
I have having a registration issue to the child. Can you please give me some suggestions?
[source] - RegistrationUriHandler - child:001:? was not allowed to register.
[child] - RegistrationService - Waiting for registration to be accepted by the server. Registration is not open.
[child] - RegistrationService - Could not register. Sleeping for 20000ms before attempting again.
Terminate batch job (Y/N)? Y
Below are my properties files
----child.properties
engine.name=child
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://localhost:63382;database=SQLEXPRESS_2;useCursors=true;bufferMaxMemory=10240;lobBuffer=5242880;integratedSecurity=true
db.user=
db.password=
registration.url=http://localhost:31415/sync/source
group.id=child
external.id=001
job.purge.period.time.ms=7200000
job.routing.period.time.ms=5000
job.push.period.time.ms=10000
job.pull.period.time.ms=10000
initial.load.create.first=true
----source.properties
engine.name=source
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://localhost:63381;database=SQLEXPRESS;useCursors=true;bufferMaxMemory=10240;lobBuffer=5242880;integratedSecurity=true
db.user=
db.password=
registration.url=
sync.url=http://localhost:31415/sync/source
group.id=source
external.id=000
job.purge.period.time.ms=7200000
job.routing.period.time.ms=5000
job.push.period.time.ms=10000
job.pull.period.time.ms=10000
initial.load.create.first=true
Also I have ran the following SQL statements on the source database:
insert into sym_node_group
(node_group_id) values ('child')
insert into SYM_NODE_GROUP_LINK
(source_node_group_id, target_node_group_id, data_event_action)
values ('child', 'source', 'P');
insert into SYM_NODE_GROUP_LINK
(source_node_group_id, target_node_group_id, data_event_action)
values ('source', 'child', 'W');
insert into SYM_ROUTER (router_id,
source_node_group_id, target_node_group_id, create_time,
last_update_time) values ('source-2-child','source', 'child',
current_timestamp, current_timestamp);
--trigger
insert into SYM_TRIGGER (trigger_id, source_table_name,
channel_id, last_update_time, create_time)
values ('fxratestrig', 'fx_rates', 'default',
current_timestamp, current_timestamp);
--trigger router
insert into SYM_TRIGGER_ROUTER
(trigger_id, router_id, initial_load_order, create_time,
last_update_time) values ('fxratestrig', 'source-2-child', 1,
current_timestamp,
current_timestamp);