Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 295 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
ODBC error - too many indexes?
Rasmus_Torpe
Member Posts: 10
Hi
After upgrading the executables on a customer solution from version 3.60 to NAV 2009 SP1 (the code base is 3.60) we get the attached error when connecting through the ODBC driver. The message is in danish and translates roughly to
"The action did not succeed. There are too many indexes/keys in the table "SalesStatistiks". Delete some indexes and try again."
Now, the number of indexes/keys for the table is 40 and it has not changed. We have tried to delete a key but the error persists.. :-k
I have looked through the knowledge base on partner source and the documentation for 2009 SP1 but haven't found anything hinting changes to
ODBC in versions between 3.60 and 2009 SP1.
Please submit any information/hint/solution if you have encountered and solved this error before.
Merry Christmas to all
After upgrading the executables on a customer solution from version 3.60 to NAV 2009 SP1 (the code base is 3.60) we get the attached error when connecting through the ODBC driver. The message is in danish and translates roughly to
"The action did not succeed. There are too many indexes/keys in the table "SalesStatistiks". Delete some indexes and try again."
Now, the number of indexes/keys for the table is 40 and it has not changed. We have tried to delete a key but the error persists.. :-k
I have looked through the knowledge base on partner source and the documentation for 2009 SP1 but haven't found anything hinting changes to
ODBC in versions between 3.60 and 2009 SP1.
Please submit any information/hint/solution if you have encountered and solved this error before.
Merry Christmas to all
Regards
Rasmus Torpe
Rasmus Torpe
0
Comments
It seems that by reducing the number of indexes to below 32 makes the error go away. This makes sense in that Access 2007 has a limit of 32 indexes per table (http://blogs.msdn.com/access/archive/2006/06/05/access-2007-limits.aspx) however the 3.60 ODBC must have had some way arround this..
Any comments to this subject is still appreciated :-)
Rasmus Torpe