View Issue Details

IDProjectCategoryView StatusLast Update
0004037SymmetricDSBugpublic2022-08-02 19:38
Reporterhanes Assigned To 
Prioritylow 
Status confirmedResolutionopen 
Product Version3.10.3 
Summary0004037: DBCompare not finding target tables in a basic configuration
DescriptionSimple corp/store case with two tables (ITEM, ITEM_PRICE) defined on both corp and store. No transforms involved. (Used H2 in this case)

DBCompare command produces error message that it can't find the tables on the target, but they do exist and can be synced to.

 ./bin/dbcompare --use-sym-config=true --source /Users/myuser/tmp/3.10.4-3726/corp-000/engines/corp-000.properties --target /Users/myuser/tmp/3.10.4-3726/store-001/engines/store-001.properties


Log output will be written to /Users/myuser/tmp/3.10.4-3726/corp-000/logs/symmetric.log
[] - AbstractCommandLauncher - Option: name=use-sym-config, value={true}
[] - AbstractCommandLauncher - Option: name=source, value={/Users/myuser/tmp/3.10.4-3726/corp-000/engines/corp-000.properties}
[] - AbstractCommandLauncher - Option: name=target, value={/Users/myuser/tmp/3.10.4-3726/store-001/engines/store-001.properties}
[] - SymmetricUtils -
   _____ __ _ ____ _____
  / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
  \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
 ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
      /____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2019 JumpMind, Inc. |
| |
| Licensed under one or more agreements from JumpMind, Inc. |
| See doc/license.html |
+-----------------------------------------------------------------+
[corp-000] - AbstractSymmetricEngine - Initializing connection to database
[corp-000] - JdbcDatabasePlatformFactory - Detected database 'H2', version '1', protocol 'h2'
[corp-000] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.h2.H2DatabasePlatform
[corp-000] - H2SymmetricDialect - The DbDialect being used is org.jumpmind.symmetric.db.h2.H2SymmetricDialect
[corp-000] - ExtensionService - Found 0 extension points from the database that will be registered
[corp-000] - StagingManager - The staging directory was initialized at the following location: /Users/myuser/tmp/3.10.4-3726/corp-000/tmp/corp-000
[corp-000] - EnhancedStagingManager - Compressed staging is enabled
[corp-000] - ExtensionService - Found 0 extension points from the database that will be registered
[corp-000] - ClientExtensionService - Found 14 extension points from spring that will be registered
[store-001] - AbstractSymmetricEngine - Initializing connection to database
[store-001] - JdbcDatabasePlatformFactory - Detected database 'H2', version '1', protocol 'h2'
[store-001] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.h2.H2DatabasePlatform
[store-001] - H2SymmetricDialect - The DbDialect being used is org.jumpmind.symmetric.db.h2.H2SymmetricDialect
[store-001] - StagingManager - The staging directory was initialized at the following location: /Users/myuser/tmp/3.10.4-3726/corp-000/tmp/store-001
[store-001] - EnhancedStagingManager - Compressed staging is enabled
[store-001] - ClientExtensionService - Found 14 extension points from spring that will be registered
[store-001] - 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=null @default

[store-001] - DbCompare - No target table found for name ITEM
[store-001] - DbCompare - No target table found for name ITEM_PRICE
+---------------------------------------+---------------------------------------+------------+------------+------------+------------+------------+------------+
+Source Target Source Rows Target Rows Matched Different Missing Extra
+---------------------------------------+---------------------------------------+------------+------------+------------+------------+------------+------------+
+---------------------------------------+---------------------------------------+------------+------------+------------+------------+------------+------------+
[store-001] - DbCompare - dbcompare complete. Total Time: 0 seconds
Tagsdbcompare

Activities

hanes

2019-07-08 18:43

developer   ~0001553

Could this be related to https://www.symmetricds.org/issues/view.php?id=3991

Issue History

Date Modified Username Field Change
2019-07-08 18:41 hanes New Issue
2019-07-08 18:42 hanes Description Updated View Revisions
2019-07-08 18:43 hanes Note Added: 0001553
2019-07-08 18:52 hanes Status new => confirmed
2022-08-02 19:38 elong Tag Attached: dbcompare