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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Nav 2009 to Nav 2015 d...
Microsoft Dynamics NAV (Archived)

Nav 2009 to Nav 2015 data upgrade fails

(0) ShareShare
ReportReport
Posted on by edgeplay

Hi,

Upgrading from 2009 to 2015 all works ok until data upgrade step, fails with the following:

Codeunit : 104055

FunctionName : StartUpgrade

State : FailedPendingResume

Error : A call to System.Data.SQLCient.SQLCommand.ExecuteNonQuery failed with this message: Incorrect syntax near '*'

I think this has something to do with dimensions - I have made sure that all the ledger entry dimensions match the associated tables - I found some postings where the global dimensions in the main table did not have an associated entry in the dimension entry and corrected these, but still get the error. 

Anyone offer any help?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    in first step upgrade to nav2013. there is a lots of documentation about that step. the documentations contain also the dimension topic.

    after that upgrade to nav2015.

  • Verified answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Hi

    Can you check your company name, it seems be the problem with company name , check and let us know

    Best Regards

    Rajasekhar.Y

  • edgeplay Profile Picture
    edgeplay on at

    Hi Rajasekhar.Y,

    This was indeed the problem - the company name was 'XYZ **LIVE**'

    I first removed the * from the company name, but then got an error re incorect syntax near 'XYZ' - I found that I also had to remove the space from the company name, making it 'XYZ_LIVE' and the upgrade then ran through fine.

    Many thanks for your help with this.

    Regards,

    Derek

  • Community Member Profile Picture
    Community Member on at

    Hi Derek, I got the same problem in an update. Where did you change the comapnyname? In NAV table company information?

    br

    Uwe

  • edgeplay Profile Picture
    edgeplay on at

    Hi Uwe,

    I renamed the company inside NAV (File - Company - Rename).

    Hope this helps

    Derek

  • Community Member Profile Picture
    Community Member on at

    Thanks a lot Derek,

    I restarted the upgrade nwo. Will inform you if this resolved the problem

    br

    Uwe

  • Community Member Profile Picture
    Community Member on at

    Hi, today the dataupgrade finished after running aft 87 hours (7 GB database on vm ware with 8 gb ram). In NAV it is the same error message as before. But I have the error "The connection to SQL server was lost" in my windows logfile. On SQL server logfile there is no error shown. Does anybody have an idea what might cause the problem?

    br

    Uwe

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

News and Announcements

Season of Giving Solutions is Here!

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 NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans