Skip to main content
Planview Customer Success Center

Error "Incorrect syntax near '-'" when upgrading a database to CP 2017 SP2

Symptoms

When running the SQL Update Utility (SQLImport.exe) to upgrade a database to CP 2017 SP2, the following error occurs:

"!!! Incorrect syntax near '-'. Database Changepoint_CPExtended has been configured."

Reason

The SQL user name used for the Changepoint database includes a dash (-) character, which causes the script to fail.

This is a known issue. 

Workaround

Use a SQL user name that does not include a dash for the upgrade to CP 2017 SP2