web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / MSRMS Upgrade Database...
Microsoft Dynamics RMS (Archived)

MSRMS Upgrade Database from V1.2 to V2.02 Completed OK, Upgrade Fails on Upgrade 2.02 to 2.03 or 2.04. or 2.05 - Incorrect syntax near 'C'

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Guys,

Any help on this matter is much appreciated.

I am in the process upgrading customer from version 1.2 to the latest.

I managed to upgrade from 1.2 to 2.02 using Store Operations Administrator No Problems.

However Operation Fails on Upgrade 2.02 to 2.03 or 2.04 or 2.05 - Incorrect syntax near 'C'

See screen shot below.

Does anyone have the SQL Statements for the upgrade, I am happy to go line by line and debug it .... I could not find it anywhere.

Any help will be appreciated.

Thanks

Eli

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Try running the SQL Profiler to see where exactly it stops, the Profiler will show you the SQL statements being executed, then u will be able to know the table having the problem, then u will need to check the different text fields for improper data. For example, if it stops at the Item table, then u might have a record that contains a single quote (') in the description field, the single quote as I think is most probably the reason for such error

  • Community Member Profile Picture
    Community Member on at

    SQL Profiler helped but now I found they had a syntax Error in the upgrade script.

    I fixed it and ran the script but it wont progress to next step ...

    Someone did a find and replace and Replaces ASC to C and that caused the script error.

    I am back to a stuck state.

    Any Help ?

  • Community Member Profile Picture
    Community Member on at

    I can connect remotely to check it, if this is ok with u, email me on ahmed.hassan@rmsleaders.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans