4.0 to 4.0 SP1

admoretutsie

NOTE: These are my own ideas, from my own understanding, which could be wrong , so dont qoute me and tell your boss that you got this from a reliable source, [-X ,Correct me if l am wrong:

The best way to get all the benefits of Nav 4.0 SP1, from Nav 4.0 is to do a complete upgrade process, i.e use a compare and merge tool for the objects, and an upgrade toolkit for the data, and lots of testing thereafter, and an upgrade is time-consuming, and costly.

From the

ChangesInNav4.0SP1.doc

in CD1 of the Nav 4.0 SP1 CD, 289 errors/bugs were corrected by this SP1, ie errors A1...A273 PLUS P1..P9 PLUS T1..T7 errors were corrected. These corections were achieved by (i) providing new executables (fin, finsql etc) and by (ii)providing modified objects whose version list is "NAVW14.00.01", and these count up to 661 objects.

From the foregoing, l strongly believe that an upgrade is the way to go.

Is there anyone who has an official document that outlines the steps required to move to nav 4.0 SP from Nav 4.0?

[/quote]

ara3n

have you looked at the upgradetoolkit document. It will tell you the exact steps to upgrade from older version to current.

gjgarciasm

Hi,

I think If You want to go from Navision 4.00 to Navision 4.01 there is not standar data upgrade. Maybe I am wrong.

I mean that you only have to merge objects transfering customizations and change customer´s license.

Waldo

That's whay I could find on the partnersource ... in a really small corner ... on the bottom of a page ... .

Can anyone confirm this? I will do an upgrade on tuesday, so if no-one confirms, then I will on tuesday

ara3n

Hello
I recently upgraded a client from 4.0 to SP1. It's just objects that needs to be merged. Make sure the customer gets a new license for SP1.

hazem

I have a navision 4.0 database backup. I created a new database into navision 4.0 SP1 and i restored the backup into it. But that doesn't work correclty :x I think i have to merge some objects but how to do this?

Alex_Chow

hazem wrote:

I have a navision 4.0 database backup. I created a new database into navision 4.0 SP1 and i restored the backup into it. But that doesn't work correclty :x I think i have to merge some objects but how to do this?

You have to do this manually with a developer license.

Waldo

We've just done the merge ... just merg the objects, create the .fob and replace objects ... .

So, hereby ... confirmed.

Waldo

I have a navision 4.0 database backup. I created a new database into navision 4.0 SP1 and i restored the backup into it. But that doesn't work correclty I think i have to merge some objects but how to do this?

You can use Araxis Merge for this ... or the developers toolkit.

jazzyjess

I am confused about the "merge the objects" statement, do you mean "merge" using the import worksheet or using the Developer Toolkit?
Do i have to use the latest version of Developer Toolkit? The one i currently have is Developer Toolkit 2.0 SP1 and it wouldn't let me open the Nav 4.0 SP1 database....do i need a higher version of Developer Toolkit?

ara3n

By merge, It means you export the objects as text, and text compare them and upload the merged text file and compile them.

jazzyjess

ok thanks, i am using Developer Toolkit now.

kriki

jazzyjess wrote:

I am confused about the "merge the objects" statement, do you mean "merge" using the import worksheet or using the Developer Toolkit?
Do i have to use the latest version of Developer Toolkit? The one i currently have is Developer Toolkit 2.0 SP1 and it wouldn't let me open the Nav 4.0 SP1 database....do i need a higher version of Developer Toolkit?

You need Developer Toolkit 2.0 SP2. You can download it here.

jjanauskas

Stefano Demiliani found very huge bug with SP1 and clustered indexes on SQL.

Heres what he says:

The new Clustered property that Navision 4.0 SP1 now has (when you open the Keys window for a table) permits you to determine whether or not the index is clustered.

But seems that there's a terrible fact...

Navision, since its first versions for SQL Server, has always created clustered indexes on primary keys (exactly like SQL Server does by default). This was not changeable from Navision but (obviously) you could change this from SQL Enterprise Manager.

From the 4.0 SP1 version, with the new Clustered property you can decide which is the best key to be nominated as clustered, because in many cases the primary key is not the best candidate (the Clustered index determines the order of records).

Unfortunately a bug (or what???) in Navision 4.0 SP1 cause the primary keys to be set as "non clustered" if the Clustered property was not explicitly set.

This is terrible for performances: a table without a clustered index is just like a heap, where data are not inserted in any particular order onto data pages. This results in SQL Server having to work harder (more reads) to access the data when requested from disk (read operations).

Seems that this problem will be fixed with the SP2 for Navision, a collection of ONLY bug fixes (not major features) that will be released soon (the estimated date is end of March/April).

DenSter

This is a known issue. You can get a script from MS support for this that will create the clustered indexes.

ara3n

If it's a script, then it's a SQL script which goes and modifies the keys. I thought it was not suggested to Modify keys from SQL directly. Also If you modify the object in Navision, after the script is run, will it reset the Clustered property of the key?

Phenno

ara3n wrote:

If it's a script, then it's a SQL script which goes and modifies the keys. I thought it was not suggested to Modify keys from SQL directly. Also If you modify the object in Navision, after the script is run, will it reset the Clustered property of the key?

Can I change key properties through C/AL code?

Waldo

Can we download it from partnersource, or do wa have to ask our PAM?

Phenno

Waldo wrote:

Can we download it from partnersource, or do wa have to ask our PAM?

I checked at partnersource, your PAM (PAM?) or whoever who has access to PartnerSource has to start partner support request and aks for hotfix for this. In some circumstances it will be charged, afaik.

ara3n

Pheno yes you can change change the clustered property by in SP1 of 4.0 Edit the table go to the keys. Show column and there is a field called clustered.

DenSter

You shouldn't mess around with indexes manually directly on SQL Server. The ClusteredIndex property within Navision however, sets the clustered property of the index on SQL Server. I do believe MS has a hotfix that is a SQL Script (although I must admit that I think that because my instructor used the word 'script'). Anyway you get it, your PAM should know about it, and if they don't then you can ask MS support.

Waldo

A few days ago I got it from one of the mibuso-members. You think it's legal to post it on this forum?