-
We are using Navision 4.0(SP3). I am new to Navision and Database Administartion. I got restored the Navision production database backup (SQL Server 2005) in to our testing environment. Everything works fine from when I setup the application from the restored database but I am not able to execute any...
-
The given error can also occur when trying to change the property DatabasePerCompany to "No" by importing a fob or fbk SQL puts the Companyname in front of the tablename, that causes the problem. This can be solved by first changing the property DatabasePerCompany of the table50000 and then...
-
The Navision restore into SQL does a security sync at the end. The error you are getting is because you have a role configured that refers to Table 50000 and that table does not exist. To solve: 1. Go back to you native DB 2. Run the Permission table from object designer 3. Filter where "Object...
Posted to
Dynamics NAV / Navision - Microsoft SQL Server Forum
(Forum)
by
babrown
on
Nov 30, 2007
Filed under: Restore, SQL Server 2005 SP2, SQL Server 2005, NAV 4.0, SQL Server, NAV 4.0 SP3, SQL vs Native, NAV 4.0 SP2, Errors, ErrorsRestore
-
... another option to find the object with the problem is within the Object Designer, Select All objects and then compile them all (F11). This might take a while, but will find all compilation errors within all objects (the objects with errors will get "marked" - so select "Marked Only"...
-
Table ID 50000 is the first number available for customization. So somewhere in another table, report or codeunit there is a reference to this tableid. Obviously this table does not exist anymore. Check reports or codeunits starting with ID 50000 up to 99999, if there is areference to table 50000
-
dear friends i have to convert the navision 4.0 database to SQL DataBase (i have run max test in navision and took a back up in Navision) then i tried to restore the Navision DB to SQL Database(wich i have created using SQL sever option in Navision) then i am getting the following error massage. Table...
-
Could it be, that table 50000 is based on a SQL View? If the View does not exist, this error message would be raised ...