View Issue Details

IDProjectCategoryView StatusLast Update
0005706SymmetricDSBugpublic2023-05-10 13:49
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionduplicate 
Product Version3.14.4 
Target Version3.14.7Fixed in Version3.14.7 
Summary0005706: "Data type unknown" error when updating sym_extract_request on Interbase
DescriptionWhen updating sym_extract_request on an Interbase node, the following error can occur:

org.jumpmind.db.sql.SqlException: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -804
[interclient][interbase]Data type unknown
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308)
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297)
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:377)
    at org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(JdbcSqlTransaction.java:344)
    at org.jumpmind.symmetric.service.impl.DataExtractorService.updateExtractRequestLoadTime(DataExtractorService.java:1422)
    at org.jumpmind.symmetric.service.impl.AcknowledgeService.ack(AcknowledgeService.java:184)
    at org.jumpmind.symmetric.service.impl.AbstractService.readAcks(AbstractService.java:415)
    at org.jumpmind.symmetric.service.impl.PushService.pushToNode(PushService.java:216)
    at org.jumpmind.symmetric.service.impl.PushService.execute(PushService.java:167)
    at org.jumpmind.symmetric.service.impl.NodeCommunicationService$1.run(NodeCommunicationService.java:523)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -804
[interclient][interbase]Data type unknown
    at interbase.interclient.PreparedStatement.remote_PREPARE_STATEMENT(Unknown Source)
    at interbase.interclient.PreparedStatement.<init>(Unknown Source)
    at interbase.interclient.Connection.prepareStatement(Unknown Source)
    at interbase.interclient.Connection.prepareStatement(Unknown Source)
    at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:696)
    at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:696)
    at org.jumpmind.db.sql.JdbcSqlTransaction$6.execute(JdbcSqlTransaction.java:349)
    at org.jumpmind.db.sql.JdbcSqlTransaction$6.execute(JdbcSqlTransaction.java:344)
    at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:375)
    ... 10 more
TagsNo tags attached.

Relationships

related to 0005803 closedpmarzullo Interbase fixes: failing to have prepared statement indicators in set and select portion of SQL statements 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2023-02-22 19:40 emiller New Issue
2023-02-22 19:40 emiller Status new => assigned
2023-02-22 19:40 emiller Assigned To => emiller
2023-03-17 17:00 elong Target Version 3.14.6 => 3.14.7
2023-05-10 13:48 emiller Relationship added related to 0005803
2023-05-10 13:49 emiller Status assigned => resolved
2023-05-10 13:49 emiller Resolution open => duplicate
2023-05-12 19:49 admin Status resolved => closed