View Revisions: Issue #4037
| Summary | 0004037: DBCompare not finding target tables in a basic configuration | ||
|---|---|---|---|
| Revision | 2019-07-08 18:42 by hanes | ||
| Description | Simple 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 |
||
| Revision | 2019-07-08 18:41 by hanes | ||
| Description | Simple corp/store case with two tables (ITEM, ITEM_PRICE) defined on both corp and store. No transforms involved. 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 |
||