View Issue Details

IDProjectCategoryView StatusLast Update
0003967SymmetricDSBugpublic2019-05-17 19:52
ReporterhanesAssigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.10.2 
Target VersionFixed in Version 
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

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-05-15 15:37 hanes New Issue
2019-05-17 19:52 elong Tag Attached: data type
2019-05-17 19:52 elong Tag Attached: dialect: oracle