View Issue Details

IDProjectCategoryView StatusLast Update
0004018SymmetricDSBugpublic2019-06-25 14:05
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.0 
Target Version3.10.3Fixed in Version3.10.3 
Summary0004018: User table creation fails when table exists in another user's schema
DescriptionInitial load fails to create table and load data when the same table exists in another user's schema.

[store-001] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?> [...]
[store-001] - OracleDatabasePlatform - Tables up to date. No alters found for ITEM
[store-001] - ManageIncomingBatchListener - The incoming batch 000-52 failed: Could not find the target table 'ITEM'
[store-001] - PullService - Could not communicate with node 'corp:000:000' at http://localhost:31000/sync/corp-000 because of unexpected error
java.lang.NullPointerException
    at org.jumpmind.symmetric.model.Trigger.matches(Trigger.java:774)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1516)
    at org.jumpmind.symmetric.load.ConfigurationChangedDatabaseWriterFilter.syncEnded(ConfigurationChangedDatabaseWriterFilter.java:344)
    at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport(DataLoaderService.java:661)
    at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPull(DataLoaderService.java:302)
    at org.jumpmind.symmetric.service.impl.PullService.execute(PullService.java:142)
    at org.jumpmind.symmetric.service.impl.NodeCommunicationService$1.run(NodeCommunicationService.java:515)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Steps To Reproduce- On Oracle, create user1 and user2.
- Setup source node with user1 and target node with user2
- Create the item table for user1
- Grant select, insert, update, delete on user1.item to user2
- Send initial load with create table option
Tagsdialect: oracle

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 e4224716

2019-06-19 10:07:57

admin

Details Diff
0004018: User table creation fails when table exists in another user's
schema

0004018
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File

SymmetricDS: 3.10 d7f20e88

2019-06-19 10:08:22

admin

Details Diff
0004018: User table creation fails when table exists in another user's
schema

0004018
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

Issue History

Date Modified Username Field Change
2019-06-19 10:07 elong New Issue
2019-06-19 10:07 elong Status new => assigned
2019-06-19 10:07 elong Assigned To => elong
2019-06-19 10:07 elong Tag Attached: dialect: oracle
2019-06-19 10:10 elong Status assigned => resolved
2019-06-19 10:10 elong Resolution open => fixed
2019-06-19 10:10 elong Fixed in Version => 3.10.3
2019-06-19 11:00 admin Changeset attached => SymmetricDS 3.10 d7f20e88
2019-06-19 11:00 admin Changeset attached => SymmetricDS 3.10 e4224716
2019-06-25 14:05 admin Status resolved => closed