View Issue Details

IDProjectCategoryView StatusLast Update
0003967SymmetricDSBugpublic2022-09-09 21:39
Reporterhanes Assigned To 
Prioritynormal 
Status confirmedResolutionopen 
Product Version3.10.2 
Summary0003967: Table with BFILE type in Oracle creates a trigger but unable to extract from the table
DescriptionFor the following sample table:

create table test18 (mybfile bfile,
    myId varchar(256), primary key (myId));

The trigger creates, but when you try to extract the following exception occurs:


[corp-000] - DataExtractorService - Batch 001-257 is not ready for delivery. It is currently scheduled for extraction.
[corp-000] - DataExtractorService - Starting request 37 to extract table TEST18 into batches 257 through 257 for node 001.
[corp-000] - DataExtractorService - Failed on request 37 to extract table TEST18 into batches 257 through 257 for node 001
[corp-000] - NodeCommunicationService - Failed to execute EXTRACT for node 001 and channel default
org.jumpmind.db.sql.SqlException: Failed to execute sql: select "MYID" as x__0,decode(t."MYBFILE", null, '', '"'||replace(replace(t."MYBFILE",'\','\\'),'"','\"')||'"') as x__1 from "HANES"."TEST18" t where 1=1
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302)
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:120)
    at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:150)
    at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:143)
    at org.jumpmind.db.sql.AbstractSqlTemplate.queryForCursor(AbstractSqlTemplate.java:107)
    at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromTableSource.startNewCursor(DataExtractorService.java:2933)
    at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromTableSource.selectNext(DataExtractorService.java:2844)
    at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromTableSource.next(DataExtractorService.java:2774)
    at org.jumpmind.symmetric.service.impl.DataExtractorService$SelectFromSymDataSource.next(DataExtractorService.java:2519)
    at org.jumpmind.symmetric.io.data.reader.ExtractDataReader.nextTable(ExtractDataReader.java:102)
    at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:169)
    at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:124)
    at org.jumpmind.symmetric.service.impl.DataExtractorService.extractOutgoingBatch(DataExtractorService.java:1049)
    at org.jumpmind.symmetric.service.impl.DataExtractorService.execute(DataExtractorService.java:2078)
    at org.jumpmind.symmetric.service.impl.NodeCommunicationService$1.run(NodeCommunicationService.java:519)
    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)
Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got FILE

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:866)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1281)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:104)
    ... 16 more
[
Tagsdata type, dialect: oracle

Relationships

related to 0002304 new Add support for the BFILE data type on Oracle 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-05-15 19:37 hanes New Issue
2019-05-17 23:52 elong Tag Attached: data type
2019-05-17 23:52 elong Tag Attached: dialect: oracle
2019-06-10 15:58 hanes Status new => confirmed
2022-09-09 21:39 elong Relationship added related to 0002304