View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005366 | SymmetricDS | Bug | public | 2022-07-19 13:55 | 2022-08-05 16:53 |
| Reporter | BenoitR | Assigned To | |||
| Priority | normal | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.13.4 | ||||
| Summary | 0005366: Problem with Alter table after migration from 3.3 to 3.13.4 | ||||
| Description | I'm migrating from an old SymmetricDS version. I've reinstalled all my environments, and have a probel with my SQL servers (2016) sync. All the firsts jobs are fine, but i met a problem with a table alter : 2022-07-19 15:39:10,745 INFO [SymmetricDS] [DefaultDatabaseWriter] [symmetricds-dataloader-6] About to create table using the following definition: <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database"> <database name="dataextractor"> <table name="RFI_TYPORGANE"> <column name="TYP_ID" primaryKey="true" primaryKeySeq="1" required="true" type="NUMERIC" size="18" autoIncrement="true"> <platform-column name="mssql2016" type="numeric() identity" size="18"/> </column> <column name="TYP_TYPEPERID" type="NUMERIC" size="18"> <platform-column name="mssql2016" type="numeric" size="18"/> </column> <column name="TYP_LIB" type="VARCHAR" size="30"> <platform-column name="mssql2016" type="varchar" size="30"/> </column> <column name="TYP_COD" type="VARCHAR" size="10"> <platform-column name="mssql2016" type="varchar" size="10"/> </column> <column name="TYP_ACTIF" type="BIT" size="1"> <platform-column name="mssql2016" type="bit" size="1"/> </column> <foreign-key name="FK_RFI_TYPO_STYP_RFI_TYPO" foreignTable="RFI_TYPORGANE" foreignTableCatalog="" foreignTableSchema=""> <reference local="TYP_TYPEPERID" foreign="TYP_ID"/> </foreign-key> <index name="STYP_FK"> <index-column name="TYP_TYPEPERID"/> </index> </table> </database> 2022-07-19 15:39:10,767 ERROR [SymmetricDS] [DefaultDatabaseWriter] [symmetricds-dataloader-6] Failed to alter table using the following xml: <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database"> <database name="dataextractor"> <table name="RFI_TYPORGANE"> <column name="TYP_ID" primaryKey="true" primaryKeySeq="1" required="true" type="NUMERIC" size="18" autoIncrement="true"> <platform-column name="mssql2016" type="numeric() identity" size="18"/> </column> <column name="TYP_TYPEPERID" type="NUMERIC" size="18"> <platform-column name="mssql2016" type="numeric" size="18"/> </column> <column name="TYP_LIB" type="VARCHAR" size="30"> <platform-column name="mssql2016" type="varchar" size="30"/> </column> <column name="TYP_COD" type="VARCHAR" size="10"> <platform-column name="mssql2016" type="varchar" size="10"/> </column> <column name="TYP_ACTIF" type="BIT" size="1"> <platform-column name="mssql2016" type="bit" size="1"/> </column> <foreign-key name="FK_RFI_TYPO_STYP_RFI_TYPO" foreignTable="RFI_TYPORGANE" foreignTableCatalog="" foreignTableSchema=""> <reference local="TYP_TYPEPERID" foreign="TYP_ID"/> </foreign-key> <index name="STYP_FK"> <index-column name="TYP_TYPEPERID"/> </index> </table> </database> StackTraceKey.init [NullPointerException:2757838042] java.lang.NullPointerException at org.jumpmind.db.alter.AddIndexChange.apply(AddIndexChange.java:86) at org.jumpmind.db.platform.AbstractDdlBuilder.processChange(AbstractDdlBuilder.java:565) at org.jumpmind.db.platform.AbstractDdlBuilder.processChanges(AbstractDdlBuilder.java:435) at org.jumpmind.db.platform.AbstractDdlBuilder.processChanges(AbstractDdlBuilder.java:422) at org.jumpmind.db.platform.mssql.MsSql2000DdlBuilder.processChanges(MsSql2000DdlBuilder.java:408) at org.jumpmind.db.platform.AbstractDdlBuilder.alterDatabase(AbstractDdlBuilder.java:363) at org.jumpmind.db.platform.AbstractDdlBuilder.alterDatabase(AbstractDdlBuilder.java:313) at org.jumpmind.db.platform.AbstractDatabasePlatform.alterTables(AbstractDatabasePlatform.java:247) at org.jumpmind.db.platform.AbstractDatabasePlatform.alterDatabase(AbstractDatabasePlatform.java:220) at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.create(DefaultDatabaseWriter.java:613) at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:180) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:62) at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:62) at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:190) at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:194) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:160) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:108) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1023) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1001) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) I've tested a lot of things, but nothing to do... | ||||
| Tags | ddl/schema, dialect: sql-server | ||||