View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006731 | SymmetricDS Pro | Bug | public | 2025-02-24 13:29 | 2025-03-11 20:37 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.14 | Fixed in Version | 3.15.14 | ||
| Summary | 0006731: Failed to capture change from binary DB2 log because of the 0x00 byte incompatible with runtime tables in Postgres | ||||
| Description | When log mining changes on DB2 for i, with a runtime database of Postgres, a null character was encountered, which is not a valid UTF-8 character. [LogMinerService] [source-job-9] Failed to mine the log StackTraceKey.init [SqlException:1728308062] org.jumpmind.db.sql.SqlException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 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.insertWithGeneratedKey(JdbcSqlTransaction.java:507) at org.jumpmind.symmetric.service.impl.DataService.insertData(DataService.java:2068) at com.jumpmind.symmetric.console.service.impl.LogMinerService.mineDataForTables(LogMinerService.java:167) at com.jumpmind.symmetric.console.service.impl.LogMinerService.mineData(LogMinerService.java:89) at org.jumpmind.symmetric.job.LogMinerJob.doJob(LogMinerJob.java:44) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:202) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:268) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:840) Caused by: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:177) at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at org.jumpmind.db.sql.JdbcSqlTemplate.insertWithGeneratedKey(JdbcSqlTemplate.java:834) at org.jumpmind.db.sql.JdbcSqlTransaction.insertWithGeneratedKey(JdbcSqlTransaction.java:504) ... 13 more | ||||
| Tags | dialect: as/400, log miner | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-02-24 13:29 | elong | New Issue | |
| 2025-02-24 13:29 | elong | Status | new => assigned |
| 2025-02-24 13:29 | elong | Assigned To | => elong |
| 2025-02-24 13:29 | elong | Tag Attached: dialect: as/400 | |
| 2025-02-24 13:29 | elong | Tag Attached: log miner | |
| 2025-02-24 13:36 | elong | Status | assigned => resolved |
| 2025-02-24 13:36 | elong | Resolution | open => fixed |
| 2025-02-24 13:36 | elong | Fixed in Version | => 3.15.14 |
| 2025-02-24 13:44 | pbelov | Summary | Failed to mine log on DB2 for i because invalid byte sequence for encoding UTF8: 0x0x => Failed to capture change from binary DB2 log because of the 0x00 byte incompatible with runtime tables in Postgres |
| 2025-03-11 20:37 | pbelov | Status | resolved => closed |
| 2025-03-11 20:37 | pbelov | Note Added: 0002678 |