View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004967SymmetricDS ProBugpublic2021-04-26 18:192021-05-28 20:40
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.10Fixed in Version3.12.10 
Summary0004967: Oracle log miner SQL parser exception from functional index
Description2021-04-26 03:13:35,768 WARN [primary-000] [eG] [primary-000-job-9] Failed to parse insert. sql='insert into "SYMDS_ADMIN"."TEST_EMP_ACC_TBL"("EMP_ACC","") values ('B112233445566',NULL)' collectionSch
ema=com.jumpmind.symmetric.console.impl.em@5ef0095 StackTraceKey.init [eL:3117868016] com.jumpmind.symmetric.console.impl.eL: Failed to parse insert. sql='insert into "SYMDS_ADMIN"."TEST_EMP_ACC_TBL"(
"EMP_ACC","") values ('B112233445566',NULL)' collectionSchema=com.jumpmind.symmetric.console.impl.em@5ef0095
        at com.jumpmind.symmetric.console.impl.eK.a(OracleStatementParser.java:171)
        at com.jumpmind.symmetric.console.impl.eK.a(OracleStatementParser.java:73)
        at com.jumpmind.symmetric.console.impl.eC.a(LogRowConverter.java:57)
        at com.jumpmind.symmetric.console.impl.eG.a(OracleLogMiner.java:387)
        at com.jumpmind.symmetric.console.impl.eG.b(OracleLogMiner.java:376)
        at com.jumpmind.symmetric.console.impl.ed.b(TransactionMiner.java:146)
        at com.jumpmind.symmetric.console.service.impl.LogMinerService.mineDataForTables(LogMinerService.java:131)
        at com.jumpmind.symmetric.console.service.impl.LogMinerService.mineData(LogMinerService.java:68)
        at org.jumpmind.symmetric.job.LogMinerJob.doJob(LogMinerJob.java:45)
        at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:227)
        at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:298)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: net.sf.jsqlparser.JSQLParserException
        at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:55)
        at com.jumpmind.symmetric.console.impl.eK.a(OracleStatementParser.java:140)
        ... 17 more
Caused by: net.sf.jsqlparser.parser.TokenMgrException: Lexical error at line 1, column 57. Encountered: "\"" (34), after : "\""
        at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:3563)
        at net.sf.jsqlparser.parser.CCJSqlParser.getToken(CCJSqlParser.java:18489)
        at net.sf.jsqlparser.parser.CCJSqlParser.Column(CCJSqlParser.java:2321)
        at net.sf.jsqlparser.parser.CCJSqlParser.Insert(CCJSqlParser.java:1266)
        at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:139)
        at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:81)
        at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:53)
        ... 18 more
Steps To ReproduceCREATE TABLE SYMDS_ADMIN.TEST_EMP_ACC_TBL
(EMP_ACC VARCHAR2(13 BYTE) NOT NULL)
TABLESPACE EMP_DEFAULT_TBL;

CREATE UNIQUE INDEX SYMDS_ADMIN.PK_TEST_EMP_ACC_TBL
ON SYMDS_ADMIN.TEST_EMP_ACC_TBL(EMP_ACC)
LOGGING TABLESPACE EMP_DEFAULT_TBL;

CREATE INDEX SYMDS_ADMIN.TEST_EMP_ACC_10D_IDX ON SYMDS_ADMIN.TEST_EMP_ACC_TBL
(SUBSTR("EMP_ACC",1,10))
LOGGING TABLESPACE EMP_DEFAULT_TBL;
Tagslog miner

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2021-04-26 18:19 elong New Issue
2021-04-26 18:19 elong Tag Attached: log-miner
2021-04-26 18:19 elong Project SymmetricDS => SymmetricDS Pro
2021-04-29 12:14 elong Assigned To => elong
2021-04-29 12:14 elong Status new => resolved
2021-04-29 12:14 elong Resolution open => fixed
2021-04-29 12:14 elong Fixed in Version => 3.12.10
2021-04-29 12:14 elong Target Version 3.13.0 => 3.12.10
2021-05-28 20:40 admin Status resolved => closed
2022-08-09 17:57 admin Tag Renamed log-miner => log miner