Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Jun 23 19:57

    evan-miller-jumpmind on 4943-vaadin-14

    0004943: Added add-ons for Twin… (compare)

  • Jun 23 12:31

    erilong on 3.12

    0005000: Turn on Jetty access l… (compare)

  • Jun 22 20:46

    erilong on 3.12

    0004717: Client ack rejected wi… (compare)

  • Jun 22 19:09

    erilong on 3.12

    0005034: Initial load shows up … (compare)

  • Jun 22 15:18

    joshahicks on 3.11

    0005035: Big Query support for … Merge branch '3.11' of https://… (compare)

  • Jun 21 19:56

    erilong on bugfix_purge_initial_load_createtable

    (compare)

  • Jun 21 19:56

    erilong on 3.12

    fix inserting create table even… (compare)

  • Jun 21 19:56
    erilong closed #161
  • Jun 21 18:20

    erilong on 3.12

    0005036: Outgoing batch panel r… (compare)

  • Jun 17 19:04

    evan-miller-jumpmind on 4943-vaadin-14

    0004943: Continued Vaadin 14 up… (compare)

  • Jun 16 17:27

    erilong on 3.12

    add logging of jdbc type (compare)

  • Jun 16 15:11

    rudiejd on fix_purge_initialload_create_table

    (compare)

  • Jun 16 15:11
    rudiejd opened #161
  • Jun 16 15:10

    rudiejd on bugfix_purge_initial_load_createtable

    fix inserting create table even… (compare)

  • Jun 16 15:03

    rudiejd on fix_purge_initialload_create_table

    5018: add permission check for … 5018: add permission check for … fix inserting create table even… (compare)

  • Jun 16 15:02
    rudiejd closed #160
  • Jun 16 14:59
    rudiejd opened #160
  • Jun 14 20:21

    philipmarzullo64 on 3.12

    0005030: Load Filter documentat… (compare)

  • Jun 14 20:02

    joshahicks on 3.12

    0005029: Push acknowledgements … (compare)

  • Jun 14 19:04

    philipmarzullo64 on 3.13

    0003897: Cleanly exit all job t… (compare)

joshahicks
@joshahicks
@Thwipp it depends on the platform if triggers are fired as part of your snapshot process. I do not believe they are so you should be good
Thwipp
@Thwipp
Thanks @joshahicks!
tjp1955
@tjp1955
Does symmetric support Oracle 12 CLOB's that contain a large amount of data? e.g. 12 MB string?
joshahicks
@joshahicks
yes
hariharan.thyagarajan
@hariharanthyagu_twitter
Hi morning all, I am configuring Symmetric DS between Oracle DB 11.2 source and Oracle DB 11.2 target.
PushService - Could not communicate with dest:001:001 at http://11.11.11.2:31415/sync/dest-001 because: org.jumpmind.exception.IoException: java.net.NoRouteToHostException: No route to host (Host unreachable) org.jumpmind.exception.IoException: java.net.NoRouteToHostException: No route to host (Host unreachable)
i am getting this above error while configuring the replication between source & Target.
source & Target Oracle VM's @ CLoud.
we are able to ping source & target VM's
hariharan.thyagarajan
@hariharanthyagu_twitter
[source-000] - PushService - Could not communicate with dest:001:001 at http://11.11.11.2:31415/sync/dest-001 because it returned HTTP code 400
-bash: [source-000]: command not found
joshahicks
@joshahicks
@hariharanthyagu_twitter this is a networking issue. You need to make sure your firewalls and ports are all setup correctly.
Kathy Marshall-Procope
@kprocope_gitlab
good day everyone...I want to backup my sql databases for Autosol Communication Manager and i am using SymmetricDS to sync the tables
does it have steps to show me how to stop symmetricDS from syncing the tables before i backup?
joshahicks
@joshahicks
You can disable sym_trigger_router and run the sync triggers and the capture triggers will be removed. Then you can flip the flag back when your ready to capture again
Akash K Roy
@akashkroy
Hi everyone

RegistrationService - Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is centralNode and the target group id is clientNode

I am getting this error while running bin/sym . I searched everywhere but couldn't find any reference to what source group id and target group id is ?

I have added group.id=centralNode and group.id=clientNode in the respective properties file
but not entirely sure why I am getting this error
joshahicks
@joshahicks
@akashkroy you need to create an engine (node) for each of these groups which is sounds like you have done. But now you need to add a group link to the database of the centralNode in sym_node_group_link table. See below docs.
The group link defines how information will pass between these nodes and which node initiates communication via a push or pull
Akash K Roy
@akashkroy
@joshahicks ahhh okay but doesnt it automatically takes care of that ?
also in that example in the link that you posted, why is the source_node_group_id set to store instead of corp ( Assuming store is a client node)
Akash K Roy
@akashkroy
ahh there's data_event_action got it
Also does symmetricds supports mssql ?
hariharan.thyagarajan
@hariharanthyagu_twitter
Hi Experts,
i'm using SYMETTRIC DS to replicate data from Oracle to Oracle DB, How to replicate multiple multiple schemas from one DB to another DB via symmetric DB
for an example SCOTT & SCOTT1 has to be replicated from source to target DB so my understanding it to run multiple instances on the same machine
? please getback.

@hariharanthyagu_twitter this is a networking issue. You need to make sure your firewalls and ports are all setup correctly.

Thanks we are able to resolve and move forward.

joshahicks
@joshahicks
You can replicate multiple schemas through a single node/engine if the user can access those schemas. In the triggers you can specify the source schema and you can specify target schemas in the routers (or transforms)
hariharan.thyagarajan
@hariharanthyagu_twitter
ok thanks for the answers, if my SCOTT schema doesn't have access to SCOTT1 schema objects in such case we can't replicate the table data of SCOTT1 from source to target right ?
In a single node /engine we cant replicate multiple users/schemas objects from source to target right ! is my understanding right..
joshahicks
@joshahicks
You can replicate multiple source and target schemas if the jdbc connection and your database vendor supports it. It is not a SymmetricDS limitation it would be based on each database and how you setup your permissions. If you can connect into SCOTT with user abc and can still access SCOTT1 then your set if your database does not allow that then you can not. SymmetricDS does not limit it is only based on what is allowed by your database
Akash K Roy
@akashkroy
Hi :-D
  1. How can I setup a trigger that will detect a change in schema in the CentralNode and update the clientNode before syncing the data ?
    Another question related to this : Can it just detect change in schema for a table or db when there is no change in the actual data ? ( I hope this makes sense )
joshahicks
@joshahicks
@akashkroy only on MSSQL can you capture and sync schema changes
you can use the bin/symadmin send-schema to send schema defintions of tables from source to target and they will be altered on target to match source
Akash K Roy
@akashkroy
but I have to run bin/symadmin send-schema everytime, before running bin/sym ?
joshahicks
@joshahicks
Just when your table definitions change
bin/sym just starts SymmetricDS the bin/send-schema is independent and can be run anytime
Akash K Roy
@akashkroy
if I run it as a service as bin/sym_service , then if there if a change in schema and new data is added to CentralNode, it will detect the change in new data for sure, but it will automatically detect the change in schema as well before syncing the new data ? ( in MSSQL that is) I tested it with mysql it doesnt ( in my tests)
joshahicks
@joshahicks
That is correct for MSSQL it will not capture new date until you run sync triggers in other platforms to rebuild the trigger
hariharan.thyagarajan
@hariharanthyagu_twitter

You can replicate multiple source and target schemas if the jdbc connection and your database vendor supports it. It is not a SymmetricDS limitation it would be based on each database and how you setup your permissions. If you can connect into SCOTT with user abc and can still access SCOTT1 then your set if your database does not allow that then you can not. SymmetricDS does not limit it is only based on what is allowed by your database

Thanks Josh So kind of you for helping us with our clarifications.

Akash K Roy
@akashkroy
Thanks @joshahicks , Much Appreciated !
Akash K Roy
@akashkroy

Hi, me again :-)

I noticed that in mssql it created the sym_* tables in master db of Central Node by default , if there a way to change that ?
because bin/sym errors out after I do a bin/symadmin send-schema
error : references invalid table 'master.dbo.sym_node_group_link'

in clientNode sym_* tables are in a different db
joshahicks
@joshahicks
It will create sym_* tables in the default location based on your db.url and connection. So you just need to setup a database for SDS and connect to that and give that user proper permissions to see your application database.
Akash K Roy
@akashkroy
Yeah Thats what I observed in mysql but in Mssql it defaults to the master db for some reason. Here's my server.properties file: https://pastebin.com/brt0fkC0
Akash K Roy
@akashkroy
Edit: updated the pastebin link there was a typo.