Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Jul 01 16:19

    vanmetjk on 3.14

    Updated and Added Documentation… (compare)

  • Jul 01 15:43

    evan-miller-jumpmind on 3.14

    0005302: Updated user guide to … (compare)

  • Jun 30 20:41

    erilong on 3.12

    upgrade spring and gson (compare)

  • Jun 30 20:38

    erilong on 3.13

    upgrade gson library (compare)

  • Jun 30 15:21

    evan-miller-jumpmind on 3.14

    0005295: Finalized table group … (compare)

  • Jun 28 19:49

    erilong on 3.14

    0005188: back out utc create_ti… (compare)

  • Jun 27 20:05

    philipmarzullo64 on 3.14

    0005157: Sybase and SQL Server … (compare)

  • Jun 27 20:03

    philipmarzullo64 on 3.14

    0005157: Sybase and SQL Server … (compare)

  • Jun 27 19:56

    philipmarzullo64 on 3.14

    0005157: Sybase and SQL Server … (compare)

  • Jun 24 12:47

    erilong on 3.14

    0005197: fix upgrade with is_mi… (compare)

  • Jun 23 20:33

    evan-miller-jumpmind on 3.9

    0005343: Fixed mathematical tra… (compare)

  • Jun 23 19:58

    erilong on 3.14

    fix unit test (compare)

  • Jun 23 18:20

    catherinequamme on 3.14

    0005344: Documentation for Bulk… Merge branch '3.14' of https://… (compare)

  • Jun 23 15:24

    evan-miller-jumpmind on 3.13

    0005343: Fixed mathematical tra… (compare)

  • Jun 22 19:35

    evan-miller-jumpmind on 3.13

    0005340: Fixed incorrect charac… (compare)

  • Jun 22 18:34

    evan-miller-jumpmind on 3.14

    0005295: Fixed bugs with table … (compare)

  • Jun 22 14:40

    evan-miller-jumpmind on 3.14

    0005295: Fixed table group bugs… (compare)

  • Jun 21 18:34

    catherinequamme on 3.14

    0005338: Flag for If Batch Was … Merge branch '3.14' of https://… 0005338: Flag for If Batch Was … and 2 more (compare)

  • Jun 21 14:57

    erilong on 3.14

    0005341: Add system property to… (compare)

  • Jun 21 14:56

    erilong on 3.13

    0005341: Add system property to… (compare)

joshahicks
@joshahicks
@zalmanlew we have had groups replicate from Sybase to MSSQL it should not be different than any other vendors
@dikum do you see triggers physically in place on the source tables? Do you see entries in sym_data for capture
dikum
@dikum
@joshahicks There are records in sym_data table on the source DB. Regarding the Triggers, do you mean the records in SYM_TRIGGER table?
joshahicks
@joshahicks
@dikum in sym_data though are there entries for your tables
are changes for your tables being captured
dikum
@dikum
@joshahicks I see there are new records in the table but I don't know how to verify if changes are being captured. Please can you tell me the what to check so I revert? Thanks for your help.
joshahicks
@joshahicks
sym_data has a table_name column and a create_time
you should see new changes coming in here if capture is working
If you see records in here that are new you may want to take the data_id of one of them and query sym_data_event where data_id = ?
Then take the batch_id in sym_data_event that is returned and use that to query sym_outgoing_batch where batch_id = ?
This will tell you if batches are being constructed (as part of the routing process job) and being sent to the target. The status column on the sym_outgoing_batch will tell you if this batch is pending or has been committed on target
dikum
@dikum
@joshahicks I've executed the queries and the status says 'OK' on the sym_outgoing_batch table
joshahicks
@joshahicks
then it should of replicated and committed that change to the target
dikum
@dikum
@joshahicks The issue I'm currently facing is it isn't replicating. The number of rows in my tables are different.
dikum
@dikum
@joshahicks The channel id column is reload, summary has the name of the table. I don't know if this information would be of help.
joshahicks
@joshahicks
thats for initial load but doesnt line up with your queries in sym_data
do you see changes in sym_data for “deafault” channel
dikum
@dikum
@joshahicks If you mean having "default" as a value in the channel_id column, then No, I don't have records for that in the sym_data table.
joshahicks
@joshahicks
default is the main change capture channel unless you setup your own
This would mean you are not capturing changes on the source
if changes are occurring
dikum
@dikum
@joshahicks How can I capture the changes. I'm sorry, these weren't created by me. I just took over the system. So it's a bit confusing at the moment.
joshahicks
@joshahicks

You need to make sure you have valid configuration in sym_trigger, sym_router, and sym_trigger_router.

There is also a professional version that provides a web console for maintenance like this and full support. If that is something you might be interested in we can start a direct chat to discuss those options

dikum
@dikum
@joshahicks Thanks for your time. I'll look into what you've mentioned and get back.
Zalman Lew
@zalmanlew
What is the db.driver for MS SQL Server? Would it be com.microsoft.sqlserver?
Zalman Lew
@zalmanlew

I'm trying out the demo, trying to run

../bin/symadmin --engine corp-000 create-sym-tables

I'm getting an error

Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.OracleDriver

(corp-000 is using sybase drivers )

joshahicks
@joshahicks
@zalmanlew you need to install the Oracle module
symadmin module install oracle
Zalman Lew
@zalmanlew
@joshahicks thanks, I tried that but got an error
ERROR: Invalid module specified
joshahicks
@joshahicks
@zalmanlew the demo uses H2 by default you may need to remove your engines files and start clean. What database types are you trying to replicate
There is a pro free trial for 30 days that might help you walk through the connection setup if you are having issues creating the engine files on your own
joshahicks
@joshahicks
@zalmanlew also are you running Java 8 or higher
Zalman Lew
@zalmanlew
I managed to download the oracle drivers and got it working. Now I'm just having trouble connecting to my Sybase source.
I'm trying to connect Sybase >> MS SQL
Zalman Lew
@zalmanlew
I'm getting a Connection refused error; I'm able to connect to Sybase via the CLI and run commands
isql -Usa -P{pass} -S{server}
joshahicks
@joshahicks
have you tried a pure JDBC client like Squirrel or DBeaver
Zalman Lew
@zalmanlew
@joshahicks yep, same issue. I think I'm doing something wrong in my Sybase configuration - but no idea what.
Zalman Lew
@zalmanlew

@joshahicks I managed to get connected using DBeaver on my Mac (through an SSH tunnel). However I'm still getting the connection refused error when running the following command

../bin/symadmin --engine corp-000 create-sym-tables

this is the configuration of corp-000 (yes, the actual database name is databasename)

db.url=jdbc:sybase:Tds:localhost:5000/databasename
I was able to successfully connect using jConnect as well as jTDS from DBeaver
Zalman Lew
@zalmanlew
Worth noting that SymmetricDS is installed and being run locally (on the machine with the Sybase install)
Zalman Lew
@zalmanlew
@joshahicks after hours of messing around, I managed to get it working by changing the DB to listen on 127.0.1.1 instead of localhost (note the 1 instead of the common 0).

I'm facing an issue now when trying to create-sym-tables - it's giving an error

java.sql.SQLException: JZ0SB: Parameter index out of range: 1.

Any ideas?

Zalman Lew
@zalmanlew
Also, what is the official db.driver for SQL Server? Would it be com.microsoft.sqlserver?
joshahicks
@joshahicks
@zalmanlew we use to ship the JTDS driver but have swithched to the MSSQL one with the latest releases finding it faster and more stable
3 replies
Are you using SQL Anywhere for the other issues above by the way
1 reply
joshahicks
@joshahicks
Could you send us a log
1 reply
susana prado
@susanap23640384_twitter
Hola alguien sabe por que no puedo escoger master o node
joshahicks
@joshahicks
@susanap23640384_twitter ¿Te refieres a la consola web? Cambiamos la redacción. "Configurar nuevo .." = "Maestro" y "Unirse a existente..." = "Nodo".
susana prado
@susanap23640384_twitter
Al darle clic en Open Web Console la siguiente pantalla no me deja escoger master , o nodo , dice que existe un error inesperado
joshahicks
@joshahicks
Mire logs/wrapper.log y vea qué error está teniendo al iniciarse. El siguiente lugar para verificar es logs/symmetric.log.