View Issue Details

IDProjectCategoryView StatusLast Update
0005781SymmetricDSBugpublic2023-05-12 13:00
Reporteralainmangelsdorf Assigned Tocquamme  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.6 
Target Version3.14.7Fixed in Version3.14.7 
Summary0005781: DBCompare --use-sym-config true
DescriptionWhen doing a DBCompare --use-sym-config true the following erro occurs

[site-002] - DbCompare - Starting DBCompare with config:
        sourceTableNames=null @default
        targetTableNames=null @default
        excludedTableNames=null @default
        useSymmetricConfig=true @command-line
        numericScale=3 @default
        whereClauses={}@default
        tablesToExcludedColumns={} @default
        outputSql=.\site-002.diff.sql @command-line
        continueAfterError=true @command-line

-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
java.lang.NullPointerException
        at org.jumpmind.symmetric.io.DbCompare.loadTablesFromConfig(DbCompare.java:311)
        at org.jumpmind.symmetric.io.DbCompare.getTablesToCompare(DbCompare.java:303)
        at org.jumpmind.symmetric.io.DbCompare.compare(DbCompare.java:85)
        at org.jumpmind.symmetric.DbCompareCommand.executeWithOptions(DbCompareCommand.java:122)
        at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:153)
        at org.jumpmind.symmetric.DbCompareCommand.main(DbCompareCommand.java:155)
-------------------------------------------------------------------------------
[] - AbstractSymmetricEngine - Stopping SymmetricDS externalId=000 version=3.14.6 database=Microsoft SQL Server
[] - AbstractSymmetricEngine - Stopping SymmetricDS externalId=002 version=3.14.6 database=Microsoft SQL Server
Steps To Reproduce
dbcompare --continue-after-error true --date-time-format "yyyy-MM-dd HH:mm:ss" -s ..\engines\corp-000.properties -t ..\engines\site-002.properties --output-sql .\site-002.diff.sql --use-sym-config true
Additional Informationsym_node is configured and updating table is working

when using --use-sym-config false and specifying tables dbcompare is working

when doing a global with --use-sym-config true we get the error, it was working when using 3.11.7, we just upgraded to 3.14.6
TagsNo tags attached.

Activities

alainmangelsdorf

2023-04-09 11:37

reporter  

corp-000.properties (1,631 bytes)   
engine.name=corp-000

db.driver=net.sourceforge.jtds.jdbc.Driver

db.url=jdbc:jtds:sqlserver://192.168.193.1:1433/[MWT-NutLogger-Marquis-Live];useCursors=true;bufferMaxMemory=10240;lobBuffer=5242880

# The database user that SymmetricDS should use.
db.user=sa

# The database password
db.password=@SA2sa

db.validation.query=select 1

# This node will contact the root node's sync.url to register itself.
# Leave blank to indicate this is the root node.
registration.url=

# Sync URL where other nodes can contact this node to push/pull data or register.
sync.url=http://192.168.193.1:31415/sync/corp-000

# Node group this node belongs to, which defines what it will sync with who.
# Must match the sym_node_group configuration in database.
group.id=corp

# External ID for this node, which is any unique identifier you want to use.
external.id=000

# How often to run purge job,
job.purge.period.time.ms=7200000

# How to run routing (in millis), which puts changes into batches.
job.routing.period.time.ms=5000

# How often to run push (in millis), which sends changes to other nodes.
job.push.period.time.ms=10000

# How often to run pull (in millis), which receives changes from other nodes.
job.pull.period.time.ms=10000

# Automatically register new nodes when they request it.
# If this is false, accept the registration requests using "symadmin open-registration" command.
auto.registration=true

auto.reload=false
auto.reload.reverse=false

# When this node sends an initial load of data to another node, first send table create scripts.
initial.load.create.first=false
corp-000.properties (1,631 bytes)   
db-compare.properties (137 bytes)   
doc_curing_bins.exclude_columns=fdcbc_trigger
doc_receiving.exclude_columns=fdss_trigger
doc_despatch_img.exclude_columns=img_image

db-compare.properties (137 bytes)   
site-002.properties (1,166 bytes)   
engine.name=site-002

db.driver=net.sourceforge.jtds.jdbc.Driver

db.url=jdbc:jtds:sqlserver://192.168.193.2:1433/[MWT-NutLogger-Marquis-LowsCreek-Live];useCursors=true;bufferMaxMemory=10240;lobBuffer=5242880

# The database user that SymmetricDS should use.
db.user=sa

# The database password
db.password=@SA2sa

db.validation.query=select 1

# This node will contact the root node's sync.url to register itself.
# 
registration.url=http://192.168.193.1:31415/sync/corp-000

# Sync URL where other nodes can contact this node to push/pull data or register.
#sync.url=

# Node group this node belongs to, which defines what it will sync with who.
# Must match the sym_node_group configuration in database.
group.id=site

# External ID for this node, which is any unique identifier you want to use.
external.id=002

# How to run routing (in millis), which puts changes into batches.
job.routing.period.time.ms=5000

# How often to run push (in millis), which sends changes to other nodes.
job.push.period.time.ms=10000

# How often to run pull (in millis), which receives changes from other nodes.
job.pull.period.time.ms=10000
site-002.properties (1,166 bytes)   

Related Changesets

SymmetricDS: 3.14 d34540ec

2023-05-12 12:19:55

cquamme

Details Diff
0005781: DBCompare --use-sym-config true Affected Issues
0005781
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompare.java Diff File

Issue History

Date Modified Username Field Change
2023-04-09 11:37 alainmangelsdorf New Issue
2023-04-09 11:37 alainmangelsdorf File Added: corp-000.properties
2023-04-09 11:37 alainmangelsdorf File Added: db-compare.properties
2023-04-09 11:37 alainmangelsdorf File Added: site-002.properties
2023-04-12 17:58 jvanmeter Assigned To => cquamme
2023-04-12 17:58 jvanmeter Status new => assigned
2023-04-12 18:12 cquamme Relationship added related to 0005785
2023-04-25 14:10 cquamme Status assigned => resolved
2023-04-25 14:10 cquamme Fixed in Version => 3.14.7
2023-05-08 13:17 cquamme Status resolved => assigned
2023-05-08 13:17 cquamme Resolution fixed => open
2023-05-08 13:17 cquamme Fixed in Version 3.14.7 =>
2023-05-09 17:33 cquamme Status assigned => resolved
2023-05-09 17:33 cquamme Resolution open => fixed
2023-05-09 17:33 cquamme Fixed in Version => 3.14.7
2023-05-09 17:33 cquamme Target Version => 3.14.7
2023-05-10 19:36 cquamme Status resolved => assigned
2023-05-10 19:36 cquamme Resolution fixed => open
2023-05-10 19:36 cquamme Fixed in Version 3.14.7 =>
2023-05-12 12:20 cquamme Status assigned => resolved
2023-05-12 12:20 cquamme Resolution open => fixed
2023-05-12 12:20 cquamme Fixed in Version => 3.14.7
2023-05-12 12:20 cquamme Target Version => 3.14.7
2023-05-12 12:20 cquamme Relationship deleted related to 0005785
2023-05-12 13:00 cquamme Changeset attached => SymmetricDS 3.14 d34540ec
2023-05-12 19:49 admin Status resolved => closed