Database upgrade fails and DB installation log shows multiple syntax errors

Error:

Your database upgrade fails. You see some or all of the syntax errors below in the DB installation log:

Error SQL72014: .Net SqlClient Data Provider: Msg 102, Level 15, State 1, Line 117 Incorrect syntax near 'RAI'.

Error SQL72014: .Net SqlClient Data Provider: Msg 102, Level 15, State 1, Line 172 Incorrect syntax near 'TRY'

The variable name '@ERROR_SEVERITY' has already been declared. Variable names must be unique within a query batch or stored procedure

 

Cause:

You have a value "Forced" for Parameterization in the setting shown below

Syntax.GIF

 

 

Resolution:

Change the setting to "Simple" and save. Now the upgrade should work.

Have more questions? Submit a request

0 Comments

Article is closed for comments.