View Issue Details

IDProjectCategoryView StatusLast Update
0004330SymmetricDSBugpublic2020-03-27 14:55
Reporterelong Assigned Toelong  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.9.0 
Summary0004330: NPE in MS-SQL dialect for DDL change from datetime to datetime2
DescriptionWhen detecting DDL changes between a source and target table, the SQL Server dialect gets a null pointer exception when detecting a data type changing from datetime to datetime2. The following exception is from using the audit router, which compares DDL between a source table a target audit table:

        at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:1094)
        at org.jumpmind.symmetric.service.impl.RouterService.selectDataAndRoute(RouterService.java:969)
        at org.jumpmind.symmetric.service.impl.RouterService.routeDataForChannel(RouterService.java:733)
        at org.jumpmind.symmetric.service.impl.RouterService.routeDataForEachChannel(RouterService.java:515)
        at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:229)
        at org.jumpmind.symmetric.job.RouterJob.doJob(RouterJob.java:49)
        at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:227)
        at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:298)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
        at org.jumpmind.db.platform.mssql.MsSql2000DdlBuilder.processColumnChange(MsSql2000DdlBuilder.java:628)
        at org.jumpmind.db.platform.mssql.MsSql2000DdlBuilder.processTableStructureChanges(MsSql2000DdlBuilder.java:505)
        at org.jumpmind.db.platform.AbstractDdlBuilder.processTableStructureChanges(AbstractDdlBuilder.java:796)
        at org.jumpmind.db.platform.AbstractDdlBuilder.processTableStructureChanges(AbstractDdlBuilder.java:659)
        at org.jumpmind.db.platform.AbstractDdlBuilder.processChanges(AbstractDdlBuilder.java:488)
        at org.jumpmind.db.platform.mssql.MsSql2000DdlBuilder.processChanges(MsSql2000DdlBuilder.java:433)
        at org.jumpmind.db.platform.AbstractDdlBuilder.alterDatabase(AbstractDdlBuilder.java:389)
        at org.jumpmind.db.platform.AbstractDdlBuilder.alterDatabase(AbstractDdlBuilder.java:327)
        at org.jumpmind.db.platform.AbstractDatabasePlatform.alterTables(AbstractDatabasePlatform.java:234)
        at org.jumpmind.symmetric.route.AuditTableDataRouter.routeToNodes(AuditTableDataRouter.java:82)
        at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:1073)
Tagsddl/schema, dialect: sql-server

Activities

elong

2020-03-27 14:55

developer   ~0001692

Might be size of datetime that needs to change in addition to type.

Issue History

Date Modified Username Field Change
2020-03-27 14:42 elong New Issue
2020-03-27 14:42 elong Status new => assigned
2020-03-27 14:42 elong Assigned To => elong
2020-03-27 14:42 elong Tag Attached: ddl/schema
2020-03-27 14:42 elong Tag Attached: dialect: sql-server
2020-03-27 14:55 elong Note Added: 0001692