View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005781 | SymmetricDS | Bug | public | 2023-04-09 11:37 | 2023-05-12 13:00 |
Reporter | alainmangelsdorf | Assigned To | cquamme | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.14.6 | ||||
Target Version | 3.14.7 | Fixed in Version | 3.14.7 | ||
Summary | 0005781: DBCompare --use-sym-config true | ||||
Description | When 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 Information | sym_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 | ||||
Tags | No tags attached. | ||||
|
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 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 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 |
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 |