java.io.IOException

java.sql.SQLException: ORA-22922: nonexistent LOB value

Samebug tips1

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web413

  • java.sql.SQLException: ORA-22922: nonexistent LOB value
  • ORA-22922: nonexistent LOB value
  • ORA-22922: nonexistent LOB value
  • Stack trace

    • java.io.IOException: java.sql.SQLException: ORA-22922: nonexistent LOB value at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.fetch(StandardSource.java:631)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.fetch(StandardContext.java:191)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.execute(StandardContext.java:166)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.process(JDBCImporter.java:199)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:185)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:51)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:50)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:16)[elasticsearch-jdbc-2.3.1.0.jar:?] at java.util.concurrent.FutureTask.run(FutureTask.java:266)[?:1.8.0_91] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[?:1.8.0_91] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[?:1.8.0_91] at java.lang.Thread.run(Thread.java:745)[?:1.8.0_91] Caused by: java.sql.SQLException: ORA-22922: nonexistent LOB value at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:792)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4C8TTILob.freeTemporaryLob(T4C8TTILob.java:297)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CConnection.freeTemporary(T4CConnection.java:3429)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.sql.CLOB.freeTemporary(CLOB.java:1044)[ojdbc6-11.2.0.jar:11.2.0.3.0] at oracle.sql.CLOB.free(CLOB.java:1823)[ojdbc6-11.2.0.jar:11.2.0.3.0] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.parseType(StandardSource.java:1510)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.processRow(StandardSource.java:1102)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.nextRow(StandardSource.java:1065)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.merge(StandardSource.java:801)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.execute(StandardSource.java:689)[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.fetch(StandardSource.java:597)[elasticsearch-jdbc-2.3.1.0.jar:?] ... 11 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 2 months ago
    Once, 3 months ago
    10 times, 3 months ago
    6 times, 6 months ago
    2 times, 10 months ago
    45 more bugmates