"TableData 2000000001 does not exist."
ramon_nav
Member Posts: 25
When I open the NAV 7 database on my local NAV Development Client I get the error above. The only way to avoid this error seems to be granting db-owner rights to my account.
Does anyone know how to avoid this error without granting dbo rights to the user?
Does anyone know how to avoid this error without granting dbo rights to the user?
0
Comments
-
Hmm, before anything else, I would take a coffee break while the client Recompiles all objects.Best regards / Venlig hilsen
Johannes Sebastian
MB7-840,MB7-8410 -
I have setup NAV 2013 databases for quite a few different clients.
However, there is one client where I am getting this error when accessing a database in the Dev Environment. This happens for all users and all NAV 2013 databases.
The NAV build is 34664, Italian localization, no application hotfixes applied
Client and NAV Server are on the same machine, SQL Server 2008 R2 is on a different machine. Both machines are Win 2008 R2 64-bit.
There is a Navison 4.02 database on the same SQL Server, but the NAV 4.02 client is not installed on 64-bit machines. Could the NAV 4.02 database be causing this problem, and what can we do about it?
I setup a user with public server role (in SQL), and assigned it to the database in SQL with public role.
User is setup in NAV with SUPER role, and can login to RTC without problem
On opening database in Dev Environment (using Windows authentication) the error below comes up. There are no messages in the Event Viewer.
TableData 2000000001 does not exist.
I recompiled all objects, and it made no difference. There were just 5 codeunits that did not compile, the error for all 5 being “Could not load the selected type library.”
If I assign the db-owner role, or the sysadmin server role, then I can open the database without problem in the Dev. Env.
Of course, I would not like to give users those roles, but for now it’s the only alternative.Alastair Farrugia0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions