View Issue Details

IDProjectCategoryView StatusLast Update
0003633SymmetricDS ProBugpublic2018-07-17 15:31
ReportermmichalekAssigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Product Version3.9.0 
Target VersionFixed 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