Key problem after upgrading to Sql S 2005 and 3.70 to 4.1

bluecat

I've upgraded a company to Sql Server 2005 and to Nav 4.1 from 3.70 in one go.

The database was fine for about five hours but then I got the following error:

Message Start:
The following Sql Server error(s) while accessing the Item Ledger Table:

208,"42S02",[Microsoft][ODBC Sql server Driver[SQL Server]Invalid object name Database name.Company Ltd$32$0'.
8180,"42000",",[Microsoft][ODBC Sql server Driver[SQL Server]Statements(s) could not be prepared.
Message End:

It occurs when I'm trying to access the item table and this tries to calculate the inventory flowfield using the Item Ledger entry.

If anybody can get back to me ASAP i would be very grateful

P.S Tried importing the Item Ledger entry table again but still didn't work [/i]

kriki

A long shot:
Delete all secondary keys from table 32 and then re-import the object again to recreate the secondary keys.
I have the idea it is some problem with the SIFT-fields-tables Navision creates in SQL.

kine

When upgrading to the 4.00SP1 on MS SQL, it is good to do it through Backup/Restore and not using the upgrade by opening in new version.

Waldo

Try navision backup / create new db / restore the backup.