mibuso.com
Home› NAV/Navision Classic Client

Navision 4.0 upgrade to SP1

jungleboyjungleboy Member Posts: 48
edited 2006-08-22 in NAV/Navision Classic Client
Hi all,

I have a problem when upgrading Nav4.0 to SP1. When I tested on my native DB, it doesn't give a problem. However, when I try to import those SP1 objects into SQL 2005 DB, it gives me error 'Table data 700 does not exist'.

Could it be that I didn't use the standard SP1 upgrade but filter from existing 4.0SP1 DB objects? I install Nav4.0 for my client and I would like to upgrade for them due to exisitng bugs in Nav4.0.



Thank you

Comments

  • ara3nara3n Member Posts: 9,257
    Table 700 is BA Database table. Are you getting the error when you import? Make sure you are dbowner when you import. Is table 700 part of your import? It's part of SP1.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • jungleboyjungleboy Member Posts: 48
    Hi,

    The login name is not the DB owner.

    Can I just ignore the BA database object. It seems like for business analytics which my client didn't purhcase it.


    TQ
  • ara3nara3n Member Posts: 9,257
    dbowner is a SQL Role. Make sure the user id you are using has that role assigned. Also you should load all the objects for SP1.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.