View Issue Details

IDProjectCategoryView StatusLast Update
0003794SymmetricDSBugpublic2018-11-28 17:31
Reporterachintya.de@uk.daiwacm.com Assigned To 
Priorityhigh 
Status closedResolutionno change required 
Product Version3.9.14 
Summary0003794: Can anybody please please help, im kind of tantalisingly close but cant drink the water
DescriptionDear developers,

i think ive done all the steps but 3 nodes (corp, store1, store2) have started but im getting this repeated msg in the errorlog, which seems there is an issue in the registration URL,

http://www.symmetricds.org/doc/3.9/html/tutorials.html#_configure

It just needs a nudge in my opinion but i dont know how to do it

2018-11-14 10:21:48,190 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Full gap analysis is running
2018-11-14 10:21:48,221 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Querying data in gaps from database took 31 ms
2018-11-14 10:21:48,221 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Full gap analysis is done after 31 ms
2018-11-14 10:21:48,346 WARN [?] [SymmetricServlet] [qtp330084561-13] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:48,549 WARN [?] [SymmetricServlet] [qtp330084561-11] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:48,736 WARN [?] [SymmetricServlet] [qtp330084561-17] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:48,892 INFO [store-002] [RegistrationService] [store-002-job-3] This node is unregistered. It will attempt to register using the registration.url
2018-11-14 10:21:48,908 INFO [store-002] [DataLoaderService] [store-002-job-3] Using registration URL of http://localhost:31415/sync/CBDEV_LN/registration?nodeGroupId=store&externalId=002&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-002&schemaVersion=%3F&databaseType=Microsoft+SQL+Server&databaseVersion=14.0&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:48,923 WARN [?] [SymmetricServlet] [qtp330084561-14] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=002&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-002&schemaVersion=%3F&databaseType=Microsoft+SQL+Server&databaseVersion=14.0&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:48,923 WARN [store-002] [RegistrationService] [store-002-job-3] Unable to register with server because the service is not available. It may be starting up.
2018-11-14 10:21:48,923 INFO [store-002] [RegistrationService] [store-002-job-3] Could not register. Sleeping for 4000ms before attempting again.
2018-11-14 10:21:48,955 WARN [?] [SymmetricServlet] [qtp330084561-15] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:49,142 WARN [?] [SymmetricServlet] [qtp330084561-13] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:49,361 WARN [?] [SymmetricServlet] [qtp330084561-11] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:49,798 WARN [?] [SymmetricServlet] [qtp330084561-17] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:50,016 WARN [?] [SymmetricServlet] [qtp330084561-14] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:50,236 WARN [?] [SymmetricServlet] [qtp330084561-15] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:50,441 WARN [?] [SymmetricServlet] [qtp330084561-13] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:50,628 WARN [?] [SymmetricServlet] [qtp330084561-11] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:50,832 WARN [?] [SymmetricServlet] [qtp330084561-17] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:52,926 INFO [store-002] [RegistrationService] [store-002-job-3] This node is unregistered. It will attempt to register using the registration.url
2018-11-14 10:21:52,942 INFO [store-002] [DataLoaderService] [store-002-job-3] Using registration URL of http://localhost:31415/sync/CBDEV_LN/registration?nodeGroupId=store&externalId=002&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-002&schemaVersion=%3F&databaseType=Microsoft+SQL+Server&databaseVersion=14.0&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:52,957 WARN [?] [SymmetricServlet] [qtp330084561-14] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=002&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-002&schemaVersion=%3F&databaseType=Microsoft+SQL+Server&databaseVersion=14.0&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:21:52,957 WARN [store-002] [RegistrationService] [store-002-job-3] Unable to register with server because the service is not available. It may be starting up.
2018-11-14 10:21:52,957 INFO [store-002] [RegistrationService] [store-002-job-3] Could not register. Sleeping for 27000ms before attempting again.
2018-11-14 10:21:53,363 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Full gap analysis is running
2018-11-14 10:21:53,394 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Querying data in gaps from database took 31 ms
2018-11-14 10:21:53,394 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Full gap analysis is done after 31 ms
2018-11-14 10:21:58,519 INFO [corp-000] [DataGapFastDetector] [corp-000-job-11] Full gap analysis is running
2018-11-14 10:21:58,554 INFO [corp-000] [DataGapFastDetector] [corp-000-job-11] Querying data in gaps from database took 35 ms
2018-11-14 10:21:58,554 INFO [corp-000] [DataGapFastDetector] [corp-000-job-11] Full gap analysis is done after 35 ms
2018-11-14 10:22:00,073 INFO [store-001] [RegistrationService] [store-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2018-11-14 10:22:00,117 INFO [store-001] [DataLoaderService] [store-001-job-3] Using registration URL of http://localhost:31415/sync/CBDEV_LN/registration?nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:22:00,167 WARN [?] [SymmetricServlet] [qtp330084561-15] The client node request is being rejected because the server node does not exist. Please check that the engine.name exists in the url. It should be of the pattern http://host:port/sync/{engine.name}/{action}. If it does not, then check the sync.url of this node or the registration.url of the client making the request. The request was /CBDEV_LN/registration from the host 127.0.0.1 with an ip address of 127.0.0.1. The query string was: nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2FGBWS1393%3A31415%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=Adaptive+Server+Enterprise&databaseVersion=15.7&symmetricVersion=3.9.14&deploymentType=server&hostName=GBWS1393&ipAddress=172.30.40.86
2018-11-14 10:22:00,169 WARN [store-001] [RegistrationService] [store-001-job-3] Unable to register with server because the service is not available. It may be starting up.
2018-11-14 10:22:00,191 INFO [store-001] [RegistrationService] [store-001-job-3] Could not register. Sleeping for 26000ms before attempting again.

i get this error when i try to access the registration URL: HTTP ERROR 660

i know that 660 can be caused by various reasons but not sure whats the trouble in my case

the URL is :

registration.url=http://localhost:31415/sync/CBDEV_LN

where CBDEV_LN is the engine name in the corp-000.properties file

please have a look and i know somebody of you can help me to fix it

ive never used this product and trying to setup a demo to show the business that it works, if i cant make this working, it wont be used here at my organisation

thanks

achintya


TagsNo tags attached.

Activities

hanes

2018-11-16 12:57

developer   ~0001334

Are both of your nodes on the same machine? It looks like your store node is attempting to register with a registration URL of a node that is on 'localhost' port 31415.

achintya.de@uk.daiwacm.com

2018-11-16 13:06

reporter   ~0001336

thanks Hanes for picking up the case.

Im using my desktop to setup this product as a proof of concept to show that it replicates data from corp-000 node (which is a Sybase Node) to store-001 ( another Sybase ASE node ) and also to store-002 ( which is a sql server node )

These Sybase and SQL Server databases are running on different unix and windows hosts

I have followed the steps until 1.2.1 of this tutorial note: http://www.symmetricds.org/doc/3.9/html/tutorials.html#_configure

but 1.2.2 doesnt work as the item, item_selling_price, sale_return_line_item, sale_transaction tables are not created on store-001 and store-002 nodes but those are created on corp-000 node

I was expecting those tables will be created on the store nodes otherwise how the data will be replicated to there

I hope i explained what i did and what im expecting and what im getting

there must be a missing jigsaw to solve this puzzle

you may call me at 00447984714251 if you wish to get a better idea and we can talk thru to get this done

please dont give up and i havent given up yet

many thanks

Achintya

hanes

2018-11-19 18:19

developer   ~0001338

Last edited: 2018-11-19 18:22

View 2 revisions

The tutorial relies on the setting of "initial.load.create.first" being "true". This setting causes SymmetricDS to attempt to create the tables on the target when an initial load occurs. If you haven't run an initial load on the node before inserting data into the tables, there won't be target tables to put the data into.

More commonly, though, you would manually create the tables on the target from your schema. More often than not that's the approach

A final note: Your issues appear to be more of understanding how SymmetricDS works and how to configure SymmetricDS, and aren't specifically bugs. Thus, please go ahead and post your questions on the open source forums to get the help you need. It's the best place to get answers to your questions.

The forums can be found here:

https://sourceforge.net/p/symmetricds/discussion/

Thanks. :)

achintya.de@uk.daiwacm.com

2018-11-20 10:38

reporter   ~0001356

i fully agree with you hanes, i'm not a java developer, do most the DBA/Unix/Infra related works in my org. Im trying to setup this tool out of the box with very little config changes

According to the tutorial,it should work out of the box

the only thing ive changed is the node database types ie using Sybase/SAP ASE and MS-SQL Servers, somebody from the support team helped me to modify the jdbc entries to use the ASE and MS-SQLServer DBMS in the corp, store1, store2 nodes

now im expecting, it should work as described

i'll post msgs to that discussion forum also, nobody told me before to use that instead, they just ignored my cases

thanks for pointing me to the right direction, ive to crack this nut

hanes

2018-11-28 17:31

developer   ~0001357

Moved to forum.

Issue History

Date Modified Username Field Change
2018-11-14 10:31 achintya.de@uk.daiwacm.com New Issue
2018-11-16 12:57 hanes Assigned To => hanes
2018-11-16 12:57 hanes Status new => feedback
2018-11-16 12:57 hanes Note Added: 0001334
2018-11-16 13:06 achintya.de@uk.daiwacm.com Note Added: 0001336
2018-11-16 13:06 achintya.de@uk.daiwacm.com Status feedback => assigned
2018-11-19 18:19 hanes Note Added: 0001338
2018-11-19 18:22 hanes Note Edited: 0001338 View Revisions
2018-11-20 10:38 achintya.de@uk.daiwacm.com Note Added: 0001356
2018-11-28 17:31 hanes Assigned To hanes =>
2018-11-28 17:31 hanes Status assigned => closed
2018-11-28 17:31 hanes Resolution open => no change required
2018-11-28 17:31 hanes Note Added: 0001357