View Issue Details

IDProjectCategoryView StatusLast Update
0002531SymmetricDSBugpublic2023-09-13 17:25
Reporterprem.kumar@nabors.com Assigned To 
Prioritynormal 
Status closedResolutionopen 
Product Version3.7.30 
Summary0002531: Error while starting Example Store Node
DescriptionI 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 ReproduceCorp node: Oracle
Store node: MySQl

Additional InformationThe 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.
Tagsddl/schema, dialect: oracle

Activities

emiller

2022-09-01 19:45

developer   ~0002178

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?

Issue History

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