View Issue Details

IDProjectCategoryView StatusLast Update
0004464SymmetricDSBugpublic2020-07-20 14:50
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.2Fixed in Version3.12.2 
Summary0004464: Failed to load batch ORA-00932: inconsistent datatypes: expected - got CLOB
DescriptionThe default detection type of USE_CHANGED_DATA will put columns in the where clause of the update statement and bind the old values as a way to detect a conflict. On Oracle, if a LOB column is changed, it tries to put it in the where clause, but Oracle doesn't allow querying LOB columns.

2020-07-02 15:51:21,543 ERROR [server] [ManageIncomingBatchListener] [server-dataloader-44] Failed to load batch 1-18 org.jumpmind.db.sql.SqlException: ORA-00932: inconsistent datatypes: expected - got CLOB
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(
    at org.jumpmind.db.sql.JdbcSqlTransaction.addRow(
    at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(
Additional InformationWorkaround is to configure a conflict for all tables with detection using USE_PK_DATA.
Tagsconflict manager, dialect: oracle


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 3aab7444

2020-07-02 16:04:01


Details Diff
0004464: Failed to load batch ORA-00932: inconsistent datatypes:
expected - got CLOB
Affected Issues
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/ Diff File

Issue History

Date Modified Username Field Change
2020-07-02 20:02 elong New Issue
2020-07-02 20:02 elong Status new => assigned
2020-07-02 20:02 elong Assigned To => elong
2020-07-02 20:02 elong Tag Attached: conflict manager
2020-07-02 20:02 elong Tag Attached: dialect: oracle
2020-07-02 20:04 elong Status assigned => resolved
2020-07-02 20:04 elong Resolution open => fixed
2020-07-02 20:04 elong Fixed in Version => 3.12.2
2020-07-02 20:05 admin Changeset attached => SymmetricDS 3.12 3aab7444
2020-07-20 14:50 elong Status resolved => closed