View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004372 | SymmetricDS Pro | Bug | public | 2020-04-27 14:40 | 2020-05-26 16:37 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.11.9 | Fixed in Version | 3.11.9 | ||
| Summary | 0004372: Oracle log miner unable to parse SQL from AUDSYS | ||||
| Description | When Oracle 12c has enabled the unified auditing, the log miner cannot parse the SQL generated by the AUDSYS schema. Failed to mine the log StackTraceKey.init [OracleLogMinerException:3255137050] org.jumpmind.datasource.oracle.OracleLogMinerException: collectionSchema cannot be null -- while parsing sql insert into "AUDSYS"."CLI_SWP$99f5ac97$1$1"("INST#","BUCKET#","INST_LOB#","MAX_SEQ#","FLUSH_SCN","FLUSH_TIME","MIN_SCN","MAX_SCN","MIN_TIME","MAX_TIME","SID#","SERIAL#","STATUS","LOG_PIECE") values ('1','0','94','0','2578605',TO_DATE('2020-04-27 10:24:04', 'YYYY-MM-DD HH24:MI:SS'),'2578604','2578605',TO_DATE('2020-04-27 10:24:03', 'YYYY-MM-DD HH24:MI:SS'),TO_DATE('2020-04-27 10:24:03', 'YYYY-MM-DD HH24:MI:SS'),'1','16','2',EMPTY_BLOB()) at org.jumpmind.datasource.oracle.OracleStatementParser.checkValid(OracleStatementParser.java:273) at org.jumpmind.datasource.oracle.OracleStatementParser.parseInsert(OracleStatementParser.java:136) at org.jumpmind.datasource.oracle.OracleStatementParser.parseSql(OracleStatementParser.java:73) at org.jumpmind.datasource.oracle.LogRowConverter.convertToDataObject(LogRowConverter.java:59) at org.jumpmind.datasource.oracle.OracleLogMiner.convertRow(OracleLogMiner.java:370) at org.jumpmind.datasource.oracle.OracleLogMiner.readDataObject(OracleLogMiner.java:364) at com.jumpmind.symmetric.console.impl.dF.b(TransactionMiner.java:159) | ||||
| Tags | dialect: oracle, log miner | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-04-27 14:40 | elong | New Issue | |
| 2020-04-27 14:40 | elong | Status | new => assigned |
| 2020-04-27 14:40 | elong | Assigned To | => elong |
| 2020-04-27 14:40 | elong | Tag Attached: dialect: oracle | |
| 2020-04-27 14:40 | elong | Tag Attached: logmining | |
| 2020-04-27 14:46 | elong | Status | assigned => resolved |
| 2020-04-27 14:46 | elong | Resolution | open => fixed |
| 2020-04-27 14:46 | elong | Fixed in Version | => 3.11.9 |
| 2020-05-21 15:19 | admin | Tag Renamed | logmining => log-miner |
| 2020-05-26 16:37 | elong | Status | resolved => closed |
| 2022-08-09 17:57 | admin | Tag Renamed | log-miner => log miner |