Submitted by 335 on
Symptom

Installation:   conv2014.exe error “Incorrect syntax near ' \'  ”  

table coverage_lookup1 start - 1/24/2014 3:28:31 PM
Preparing table coverage_lookup1 for create/modify
Create Default Constraints coverage_lookup1
Create Check Constraints coverage_lookup1
Grants on table coverage_lookup1
102 - 37000 - [Microsoft][ODBC SQL Server Driver][SQL Server]
Incorrect syntax near '\'.
Drop/Create Primary Keys Table, coverage_lookup1
Create Primary/Unique Key coverage_lookup1

Cause
A user group in Millennium had a "/" in the group name which is not permitted. This data may have come from customer's original data conversion.
Resolution
  • Go to Tools > System Upkeep > User Security
  • Delete a group with ‘\’ in a group name (e.g. OFFICE\group1) if there are no users in this group  This issue has been solved by deleting OFFICE\millsql1svc group under User's Maintenance.
Article Type
Product Issue
Product Line
Millennium
Product Module/Feature
Installation
Product Version
2014.0
Ranking
No votes yet