View Issue Details

IDProjectCategoryView StatusLast Update
0003633SymmetricDS ProBugpublic2019-05-08 08:41
ReportermmichalekAssigned To 
Status acknowledgedResolutionopen 
Product Version3.9.0 
Target Version3.10.3Fixed in Version 
Summary0003633: MSSQL Server Pro Validation Query Fails with a hyphen in the DB Name
DescriptionHere is a database named: dbHMI-prod. Notice the message: Incorrect syntax near '-'.

2018-07-17 15:27:06,232 WARN [corp-000] [MsSqlDdlReader] [qtp1777443462-16] Failed to determine auto increment columns using this query: 'SELECT t.TEST_ID,t.TEST_VALUE FROM db-prod.dbo.SYM_PERMISSION_TEST t WHERE 1 = 0'. This is probably not harmful, but should be fixed.
Table [name=SYM_PERMISSION_TEST; 2 columns]
Column [name=TEST_ID; jdbcType=int; mappedType=INTEGER]
Column [name=TEST_VALUE; jdbcType=int; mappedType=INTEGER] (org.jumpmind.db.platform.AbstractJdbcDdlReader.determineAutoIncrementFromResultSetMetaData( Incorrect syntax near '-'.
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-07-17 15:31 mmichalek New Issue
2018-07-17 15:31 mmichalek Project SymmetricDS => SymmetricDS Pro
2018-10-10 14:06 hanes Target Version => 3.10.0
2018-10-17 14:37 hanes Status new => acknowledged
2019-05-08 08:41 admin Target Version 3.10.0 => 3.10.3