View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002531 | SymmetricDS | Bug | public | 2016-03-22 15:51 | 2023-09-13 17:25 |
Reporter | prem.kumar@nabors.com | Assigned To | |||
Priority | normal | ||||
Status | closed | Resolution | open | ||
Product Version | 3.7.30 | ||||
Summary | 0002531: Error while starting Example Store Node | ||||
Description | I tried to implement your quick guide test example for a POC. But I get the below error. Could you please help [store-001] - DefaultDatabaseWriter - 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="ITEM"> <column name="ITEM_ID" primaryKey="true" required="true" type="DECIMAL" size="22"> <platform-column name="oracle" type="NUMBER" size="22"/> </column> <column name="NAME" type="VARCHAR" size="100"> <platform-column name="oracle" type="VARCHAR2" size="100"/> </column> </table> </database> [store-001] - DefaultDatabaseWriter - 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="ITEM"> <column name="ITEM_ID" primaryKey="true" required="true" type="DECIMAL" size="22"> <platform-column name="oracle" type="NUMBER" size="22"/> </column> <column name="NAME" type="VARCHAR" size="100"> <platform-column name="oracle" type="VARCHAR2" size="100"/> </column> </table> </database> [store-001] - DataLoaderService - Failed while parsing batch java.lang.NullPointerException at org.jumpmind.db.platform.AbstractDdlBuilder.getColumnName(AbstractDdlBuilder.java:1778) at org.jumpmind.db.platform.AbstractDdlBuilder.writeColumnTypeDefaultRequired(AbstractDdlBuilder.jav a:1783) at org.jumpmind.db.platform.AbstractDdlBuilder.writeColumn(AbstractDdlBuilder.java:1811) at org.jumpmind.db.platform.mysql.MySqlDdlBuilder.processColumnChange(MySqlDdlBuilder.java:310) at org.jumpmind.db.platform.mysql.MySqlDdlBuilder.processTableStructureChanges(MySqlDdlBuilder.java: 241) at org.jumpmind.db.platform.AbstractDdlBuilder.processTableStructureChanges(AbstractDdlBuilder.java: 792) at org.jumpmind.db.platform.AbstractDdlBuilder.processTableStructureChanges(AbstractDdlBuilder.java: 665) at org.jumpmind.db.platform.AbstractDdlBuilder.processChanges(AbstractDdlBuilder.java:490) at org.jumpmind.db.platform.AbstractDdlBuilder.alterDatabase(AbstractDdlBuilder.java:395) at org.jumpmind.db.platform.AbstractDdlBuilder.alterDatabase(AbstractDdlBuilder.java:327) at org.jumpmind.db.platform.AbstractDatabasePlatform.alterTables(AbstractDatabasePlatform.java:201) at org.jumpmind.db.platform.AbstractDatabasePlatform.alterDatabase(AbstractDatabasePlatform.java:179 ) at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.create(DefaultDatabaseWriter.java:511 ) at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:16 7) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64) at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:65) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64) at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:204) at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:200) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:170) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:116) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener.end(DataL oaderService.java:855) at org.jumpmind.symmetric.io.data.writer.StagingDataWriter.notifyEndBatch(StagingDataWriter.java:75) at org.jumpmind.symmetric.io.data.writer.AbstractProtocolDataWriter.end(AbstractProtocolDataWriter.j ava:220) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:130) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport(DataLoaderService.jav a:463) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPull(DataLoaderService.java:273 ) at org.jumpmind.symmetric.service.impl.PullService.execute(PullService.java:132) at org.jumpmind.symmetric.service.impl.NodeCommunicationService$2.run(NodeCommunicationService.java: 396) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) [store-001] - PullService - There was a failure while pulling data from corp:000:000. 1 rows and 1 batches | ||||
Steps To Reproduce | Corp node: Oracle Store node: MySQl | ||||
Additional Information | The only departure from you instruction that I did was, I used upper case Table names. The create scripts provided in your example created table names within double quotes in Oracle database. To avoid this I had change the script to use the Upper case table names. | ||||
Tags | ddl/schema, dialect: oracle | ||||
|
I attempted to reproduce this issue using SymmetricDS 3.14.1, Oracle 21.3, and MySQL 8.0.30. I imported create_sample.xml using the --alter-case option to make the table names uppercase. I successfully sent a load from Oracle to MySQL which created the tables in the target database and sent the data. It's possible that this issue has been resolved since version 3.7.30. Can you upgrade SymmetricDS to the latest version and check whether the issue still occurs? If it does still occur, is there any additional information you can provide that would help me reproduce the issue, such as your Oracle and MySQL versions? |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-03-22 15:51 | prem.kumar@nabors.com | New Issue | |
2019-04-23 23:38 | elong | Tag Attached: ddl/schema | |
2019-04-23 23:38 | elong | Tag Attached: dialect: oracle | |
2022-09-01 19:45 | emiller | Note Added: 0002178 | |
2022-09-01 19:45 | emiller | Status | new => feedback |
2023-09-13 17:25 | emiller | Status | feedback => closed |