View Issue Details

IDProjectCategoryView StatusLast Update
0003905SymmetricDSBugpublic2019-05-08 14:59 Assigned Toelong  
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.1Fixed in Version3.10.1 
Summary0003905: Table sym_extract_request not found when using different prefix
DescriptionOur symmetric tables use a prefix "P001_sym_extract_request" etc. But the logs aren't using the prefix.

Additional InformationFailed to execute EXTRACT for node Merge and channel default StackTraceKey.init [SqlException:3735487048]
org.jumpmind.db.sql.SqlException: Invalid object name 'sym_extract_request'.
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(
    at org.jumpmind.db.sql.JdbcSqlTemplate.queryForObject(
    at org.jumpmind.db.sql.AbstractSqlTemplate.queryForInt(
    at org.jumpmind.symmetric.service.impl.DataExtractorService.releaseMissedExtractRequests(
    at org.jumpmind.symmetric.service.impl.DataExtractorService.execute(
    at org.jumpmind.symmetric.service.impl.NodeCommunicationService$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$ Source)
    at Source)
Caused by: Invalid object name 'sym_extract_request'.
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
    at org.jumpmind.db.sql.JdbcSqlTemplate$1.execute(
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(
    ... 8 more
TagsNo tags attached.


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 580bf327

2019-04-09 08:26:56


Details Diff
0003905: table sym_extract_request not found, missing table prefix Affected Issues
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/ Diff File

Issue History

Date Modified Username Field Change
2019-04-09 00:41 New Issue
2019-04-09 12:27 elong Assigned To => elong
2019-04-09 12:27 elong Status new => assigned
2019-04-09 12:28 elong Status assigned => resolved
2019-04-09 12:28 elong Resolution open => fixed
2019-04-09 12:28 elong Fixed in Version => 3.10.1
2019-04-09 12:28 admin Target Version => 3.10.1
2019-04-09 13:00 admin Changeset attached => SymmetricDS 3.10 580bf327
2019-04-23 15:41 elong Status resolved => closed
2019-05-08 14:59 admin Summary MSSQL: table sym_extract_request not found. => Table sym_extract_request not found when using different prefix