View Issue Details

IDProjectCategoryView StatusLast Update
0003991SymmetricDSBugpublic2019-06-19 09:20
ReporterhanesAssigned Tojaredfrees 
Prioritynormal 
Status assignedResolutionopen 
Product Version3.10.2 
Target VersionFixed in Version 
Summary0003991: dbcompare null pointers with basic setup with two source tables to a target with no transforms
DescriptionSimple, corp to store setup. Two tables (item and item_price) sync from corp to store. The following command seems to be correct but null pointers. FYI, no transforms are configured for the scenario.

~/tmp/3.10.2-test/pro-corp-000> ./bin/dbcompare --use-sym-config=true --source /Users/myuser/tmp/3.10.2-test/pro-corp-000/engines/corp-000.properties --target /Users/myuser/tmp/3.10.2-test/pro-store-001/engines/store-001.properties


Log output will be written to /Users/mhanes/tmp/3.10.2-test/pro-corp-000/logs/symmetric.log
[] - AbstractCommandLauncher - Option: name=use-sym-config, value={true}
[] - AbstractCommandLauncher - Option: name=source, value={/Users/mhanes/tmp/3.10.2-test/pro-corp-000/engines/corp-000.properties}
[] - AbstractCommandLauncher - Option: name=target, value={/Users/mhanes/tmp/3.10.2-test/pro-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/mhanes/tmp/3.10.2-test/pro-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/mhanes/tmp/3.10.2-test/pro-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 @null
    targetTableNames=null @default
    excludedTableNames=null @default
    useSymmetricConfig=true @command-line
    numericScale=3 @default
    whereClauses={}@default
    tablesToExcludedColumns={} @default
    outputSql=null @null

-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
java.lang.NullPointerException
    at org.jumpmind.symmetric.io.DbCompare.getTransformFor(DbCompare.java:521)
    at org.jumpmind.symmetric.io.DbCompare.loadTargetTable(DbCompare.java:471)
    at org.jumpmind.symmetric.io.DbCompare.loadTables(DbCompare.java:402)
    at org.jumpmind.symmetric.io.DbCompare.loadTablesFromConfig(DbCompare.java:330)
    at org.jumpmind.symmetric.io.DbCompare.getTablesToCompare(DbCompare.java:309)
    at org.jumpmind.symmetric.io.DbCompare.compare(DbCompare.java:92)
    at org.jumpmind.symmetric.DbCompareCommand.executeWithOptions(DbCompareCommand.java:136)
    at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:189)
    at org.jumpmind.symmetric.DbCompareCommand.main(DbCompareCommand.java:162)
-------------------------------------------------------------------------------
Tagsdbcompare

Relationships

related to 0003990 assignedjaredfrees dbcompare use-sym-config ignore table name argument 

Activities

hanes

2019-06-10 12:16

developer   ~0001519

Last edited: 2019-06-10 12:21

View 3 revisions

same issue in 3.9.20:
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
java.lang.NullPointerException
    at org.jumpmind.symmetric.io.DbCompare.getTransformFor(DbCompare.java:500)
    at org.jumpmind.symmetric.io.DbCompare.loadTargetTable(DbCompare.java:450)
    at org.jumpmind.symmetric.io.DbCompare.loadTables(DbCompare.java:381)
    at org.jumpmind.symmetric.io.DbCompare.loadTablesFromConfig(DbCompare.java:323)
    at org.jumpmind.symmetric.io.DbCompare.getTablesToCompare(DbCompare.java:302)
    at org.jumpmind.symmetric.io.DbCompare.compare(DbCompare.java:91)
    at org.jumpmind.symmetric.DbCompareCommand.executeWithOptions(DbCompareCommand.java:136)
    at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:194)
    at org.jumpmind.symmetric.DbCompareCommand.main(DbCompareCommand.java:162)
-------------------------------------------------------------------------------

hanes

2019-06-10 12:28

developer   ~0001520

Last edited: 2019-06-10 12:30

View 2 revisions

Note that removing the --use-sym-config=true part and specifying the table seems to work. I.e.,

./dbcompare --source /Users/myuser/tmp/training-3.9/pro-corp-000/engines/corp-000.properties --target /Users/myuser/tmp/training-3.9/pro-store-001/engines/store-001.properties item

jaredfrees

2019-06-19 09:20

developer   ~0001536

I believe this is happening when the nodes are not setup yet. It happens for me only when sym_node is empty

Issue History

Date Modified Username Field Change
2019-06-10 11:19 hanes New Issue
2019-06-10 11:19 hanes Status new => confirmed
2019-06-10 12:00 hanes Summary dbcompare null pointers in basic => dbcompare null pointers with basic setup with two source tables to a target with no transforms
2019-06-10 12:03 hanes Relationship added related to 0003990
2019-06-10 12:16 hanes Note Added: 0001519
2019-06-10 12:17 hanes Note Edited: 0001519 View Revisions
2019-06-10 12:21 hanes Note Edited: 0001519 View Revisions
2019-06-10 12:26 hanes Assigned To => jaredfrees
2019-06-10 12:26 hanes Status confirmed => assigned
2019-06-10 12:28 hanes Note Added: 0001520
2019-06-10 12:30 hanes Note Edited: 0001520 View Revisions
2019-06-18 16:31 jaredfrees Tag Attached: dbcompare
2019-06-19 09:20 jaredfrees Note Added: 0001536