Support
Login
Your Password

Sales
North America
Phone: +1 (905)-655-9262
Fax: +1 (905)-655-9395
Email: info@add-on.com

Europe
Phone: +45 7944 7000
Fax: +45 7944 7001

China
Phone: +86 (21) 2221 8396
Email: info-china@add-on.com
Support
Denmark
+45 7944 7002

Europe
+44 (0) 203 002 3889

North America
+1 (202)-536-4165
Knowledgebase: Resource Central
KB0054 - Error in upgrading database

 

Symptom

When trying to upgrade DB from RC 3.0 to 3.7, the upgrade process suddenly stops. And the error message logged in RC3.00.2012.0000 TO RC3.00.2012.0065_LOG is as follows:

Missing end comment mark '*/'.

....

....

Incorrect syntax near '*'.

 

Cause

The OSQL considers the GO as a reserved keyword. If GO statement appears in the commented code /* */. OSQL will fail to run.

 

Resolution

1. Manually remove the commented code in  RC3.00.2012.0000 To RC3.00.2012.0065.sql so that the remaining content is as follows:

--UPDATE DB VERSION

Update [DBVersion]  Set [Value] = '3.00.2012.0065' Where [Property]='dbVersion'

Go

2. Upgrade the database again.

 

Properties

Applies to: RC 3.7 HF_2

Fixed in: RC 3.7 HF 3

Reference: TFS #7578

Knowledge base ID: 0054

Last updated: Feb 23, 2016