Navision 4.0 upgrade to SP1

jungleboy

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

ara3n

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.

jungleboy

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

ara3n

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.