Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Invalid object name 'XXXX.dbo.company$xxxxx'
rcverbeek
Member Posts: 32
Hi,
We just ran into an interesting problem with one of our clients, on a Nav 2015 environment. In a newly created company the users received the following error message:
The following SQL error was unexpected
Invalid object name 'xxx.dbo.company$xxxxx'
We spent some time finding the problem and would like to explain what went wrong, so if you receive the same error you may find this post useful.
It appeared that the newly created company had a trailing space in its name, so 'company '. All the SQL tables had this space as well, however Dynamics Nav generates the SQL statement WITHOUT space. Hence the error. It couldn't find any of the Nav tables.
We ended up renaming the company via PS:
Rename-NAVCompany –ServerInstance 'DynamicsNAV90' -CompanyName 'Name with space' -NewCompanyName 'Name without space' -Verbose
We just ran into an interesting problem with one of our clients, on a Nav 2015 environment. In a newly created company the users received the following error message:
The following SQL error was unexpected
Invalid object name 'xxx.dbo.company$xxxxx'
We spent some time finding the problem and would like to explain what went wrong, so if you receive the same error you may find this post useful.
It appeared that the newly created company had a trailing space in its name, so 'company '. All the SQL tables had this space as well, however Dynamics Nav generates the SQL statement WITHOUT space. Hence the error. It couldn't find any of the Nav tables.
We ended up renaming the company via PS:
Rename-NAVCompany –ServerInstance 'DynamicsNAV90' -CompanyName 'Name with space' -NewCompanyName 'Name without space' -Verbose
2