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 data 50000 does not exsist
help me guys i have to send DB Tommarow
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
... 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" from the View menu after the compilation is finished). By the way, a recommendation, rather don't do this in the live db, but in a restored local backup, compiling objects will reset the user zup files....
SaludosNils
Could it be, that table 50000 is based on a SQL View? If the View does not exist, this error message would be raised ...
Jörg A. StrykSTRYK System ImprovementPerformance Optimization & Troubleshootinghttp://www.stryk.info
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 ID" > 0 AND "Object Name" = ''
4. This will be all references to objects that do not exist. Delete these entries
5. Make a new backup and restore
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 import the fob or fbk.