mibuso.com
Home› NAV/Navision Classic Client
Options

Upgrade to Navision 5.00 license error

krikikriki Member, Moderator Posts: 9,096
edited 2008-08-26 in NAV/Navision Classic Client
I have to do a technical upgrade of a DB from 3.10 to 5.00.

And I have a table in the range 39.000.000-range in which my developer-license has Execute-permission but NOT modify-permission.

If I convert that DB from 3.10 to 4.00SP3, I don't have a problem.

If I convert that DB (in a 3.10 or 4.00SP3-client) to 5.00, Navision 5.00 gives an error that I don't have permission the change the table.

I have the error both native as SQL.

Someone knows about this problem and how to fix it (apart from upgrading the license with the add-on)?
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Comments

  • Options
    ara3nara3n Member Posts: 9,255
    Hello Kriki
    The reason you are getting the error is because 5.0 sets the Cluster key on all the tables, this marks the tables as modified. which is causing the error.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    ara3nara3n Member Posts: 9,255
    I tried to preset the Clustered key in a 4.0 db, but when upgraded to 5.0, It still went through all the tables and modified them.

    There is no workaround, except getting a license that gives you modified permission, or call MS for a hotfix.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    davmac1davmac1 Member Posts: 1,283
    Good luck on the hotfix! I had the same error which according MS is caused by loading a Lanham object.
    My choice: wait on hotfix or do a Navision backup in v4, go to Nav 5, create new database, then restore Navision backup.
    Navision restore completed successfully - still waiting on hotfix!
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Options
    ara3nara3n Member Posts: 9,255
    what about the cluster index on PK are they all not set?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    krikikriki Member, Moderator Posts: 9,096
    davmac1 wrote:
    Good luck on the hotfix! I had the same error which according MS is caused by loading a Lanham object.
    My choice: wait on hotfix or do a Navision backup in v4, go to Nav 5, create new database, then restore Navision backup.
    Navision restore completed successfully - still waiting on hotfix!
    A Navision backup is not possible (150GB and the downtime-Window we have is only a few hours, not a few days).
    So let's hope for the hotfix.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    krikikriki Member, Moderator Posts: 9,096
    Well, for the moment we decided to upgrade to 4.00SP3.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    davmac1davmac1 Member Posts: 1,283
    I did receive the hotfix - so you can ask Microsoft for it now.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Options
    ara3nara3n Member Posts: 9,255
    is there a KB article for this?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    davmac1davmac1 Member Posts: 1,283
    KB 936885
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Options
    ara3nara3n Member Posts: 9,255
    can't find it. i guess it's not public
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    kriki wrote:
    I have to do a technical upgrade of a DB from 3.10 to 5.00.

    And I have a table in the range 39.000.000-range in which my developer-license has Execute-permission but NOT modify-permission.

    If I convert that DB from 3.10 to 4.00SP3, I don't have a problem.

    If I convert that DB (in a 3.10 or 4.00SP3-client) to 5.00, Navision 5.00 gives an error that I don't have permission the change the table.

    I have the error both native as SQL.

    Someone knows about this problem and how to fix it (apart from upgrading the license with the add-on)?

    Try this way :

    Dynamics User Group - Upgrade 4xx EXE to 5.00 with End User license
    David Singleton
  • Options
    davmac1davmac1 Member Posts: 1,283
    Your method looks interesting.
    The Lanham tables cause problem with doing upgrades with a developers license.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Options
    krikikriki Member, Moderator Posts: 9,096
    davmac1 wrote:
    KB 936885
    I requested this KB at MS and it works!
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    davmac1davmac1 Member Posts: 1,283
    Glad my pain, was your gain!
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Options
    teckpohteckpoh Member Posts: 271
    i go to partnersource website and look for hotfix KB 936885 but search result does not return any article about this hotfix.... :( how to get it? any idea?? thx ...
Sign In or Register to comment.