View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005300 | SymmetricDS Pro | Bug | public | 2022-05-16 16:44 | 2022-06-06 12:37 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.13.4 | ||||
| Target Version | 3.13.5 | Fixed in Version | 3.13.5 | ||
| Summary | 0005300: Oracle Log Mining issue with deletes when no primary keys defined | ||||
| Description | When Oracle log mining is defined, and it encounters a table that has no primary keys defined, nothing is populated in the pk_data column of sym_data when a delete occurs. This causes problems with the target node when it expects all of the column values to be populated in the pk_data column. | ||||
| Steps To Reproduce | 1. Define Oracle log mining 2. Create table with no primary keys. 3. Add to configuration. 4. Insert record into source table. 5. Allow sync to target. 6. Delete record from source. 7. Failure will occur at target data writer. | ||||
| Tags | dialect: oracle, log miner | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-05-16 16:44 | pmarzullo | New Issue | |
| 2022-05-16 16:44 | pmarzullo | Status | new => assigned |
| 2022-05-16 16:44 | pmarzullo | Assigned To | => pmarzullo |
| 2022-05-16 16:44 | pmarzullo | Tag Attached: dialect: oracle | |
| 2022-05-16 16:44 | pmarzullo | Tag Attached: log-miner | |
| 2022-05-16 18:04 | pmarzullo | Status | assigned => resolved |
| 2022-05-16 18:04 | pmarzullo | Resolution | open => fixed |
| 2022-05-16 18:04 | pmarzullo | Fixed in Version | => 3.13.5 |
| 2022-06-06 12:37 | admin | Status | resolved => closed |
| 2022-08-09 17:57 | admin | Tag Renamed | log-miner => log miner |