View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004018 | SymmetricDS | Bug | public | 2019-06-19 14:07 | 2019-06-25 18:05 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.10.3 | Fixed in Version | 3.10.3 | ||
| Summary | 0004018: User table creation fails when table exists in another user's schema | ||||
| Description | Initial 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 | ||||
| Tags | dialect: oracle | ||||
|
SymmetricDS: 3.10 e4224716 2019-06-19 10:07:57 Details Diff |
0004018: User table creation fails when table exists in another user's schema |
Affected Issues 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 Details Diff |
0004018: User table creation fails when table exists in another user's schema |
Affected Issues 0004018 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-06-19 14:07 | elong | New Issue | |
| 2019-06-19 14:07 | elong | Status | new => assigned |
| 2019-06-19 14:07 | elong | Assigned To | => elong |
| 2019-06-19 14:07 | elong | Tag Attached: dialect: oracle | |
| 2019-06-19 14:10 | elong | Status | assigned => resolved |
| 2019-06-19 14:10 | elong | Resolution | open => fixed |
| 2019-06-19 14:10 | elong | Fixed in Version | => 3.10.3 |
| 2019-06-19 15:00 | admin | Changeset attached | => SymmetricDS 3.10 d7f20e88 |
| 2019-06-19 15:00 | admin | Changeset attached | => SymmetricDS 3.10 e4224716 |
| 2019-06-25 18:05 | admin | Status | resolved => closed |