4.01 / SQL bug ...?

Pidi
Member Posts: 35
Recently I was told, that there´s a new bug with 4.01 regarding primary Index key of all SIFT tables.
If you have a look at the tables of your Navision Database with the Enterprise Manager, you´ll realize, that all SIFT tables do have Clusteres PrimKeys, while all other tables don´t. I was told, that there is a hotfix from MBS which is a script to change this.
Since I´m currently migrating from 2.6 to 4.01, I cannot verify the behavior of 3.6 or 4.00
Does anyone know anything about that? Thanks in advance.
Pidi
If you have a look at the tables of your Navision Database with the Enterprise Manager, you´ll realize, that all SIFT tables do have Clusteres PrimKeys, while all other tables don´t. I was told, that there is a hotfix from MBS which is a script to change this.
Since I´m currently migrating from 2.6 to 4.01, I cannot verify the behavior of 3.6 or 4.00
Does anyone know anything about that? Thanks in advance.
Pidi
Michael Peters
Bos Fod GmbH Düsseldorf
+49 2132 139-0
Bos Fod GmbH Düsseldorf
+49 2132 139-0
0
Comments
-
Yes, there is a hotfix that addresses this and a few other issues. You must request it from support. It is build 21990. It should be installed in all SP1 installs regardless of database type. It also fixes at least one native DB issue I have seen.There are no bugs - only undocumented features.0
-
Thnaks a lot - I´ll try to get it from my NSC.
PidiMichael Peters
Bos Fod GmbH Düsseldorf
+49 2132 139-00
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions