BUG: Navision 4.0 SP2 on SQL 2005

Sorcerer

Hello there,

it may be that i've found a bug in the sql integration of navision 4.0 sp2

after you create a new database and you try to alter it the following error occurs:

"You cannot enter '2147483648 KB' in Integer. The cursor is in front of the invalid character."

Seems like microsoft has not tested their implementation of topic P1) from the changes list.

Alex_Chow

what exactly were you trying to alter?

Sorcerer

if you try to alter the database settings (File, Database, Alter) you will get the error message.

bbrown

The valid range of data type "Integer" is -2,147,483,648 to 2,147,483,647.

The number 2,147,483,648 is outside this range.

kine

but in Changelog is that the maxsize is S32_MAX = 2147483647 - it means that there is one byte difference...

kine

I tested the bug and yes, there is no problem on MS SQL 2000. On MS SQL 2005 you have problems with this no. if Max Size is Unrestricted for the change log. If you change it, you will have same error but for example with string "512000 KB". It seems that the " KB" is the problem... ;-)

Thomas_Hviid_Thorn

Hi Kine,

Just to clarify my understanding:

When you write "change log" is it
- the internal Navision "Change Log" functionality or
- the SQL Server's Transaction Log, you're talking about.

Out of context, I read it as the internal Navision "Change Log" functionality, but that has been questioned - therefore my question.

kine

It is my fault... sorry. I mean the transaction log...

bobnavision

Hi,

Have we resolved this issue? what the best way to get over this problem because I cannot alter the database because of this error and I can not upload the license getting error for Per-Database system permission.

How shall we proceed?

regards,

kine

The bug will be solved in Update for SP2... release date for this update is unknown right now (some sources are talking about few weeks).

If you want to change settings for Per Database license, you can do it directly in dbproperty table on SQL.

bobnavision

Hi kine,

what (which field) we have to amend on the db property table to make it work?

Regards

kine

Sorry, my fault... there is no such a field, but it seems that you just need fill the field "license" with appropriate data (for example by creating new DB, turning the per DB license, import license into it and transfer the data from this DB into your DB) - but this is not tested...

MrWho

Hello!
The integer problem where solved with the SP2 Rollup downloaded from partnersource. GREAT

But the UPLOAD of license file is not fixed. Still getting the error
"You do not have permission to start 'Per databaselicense' System."

But uploading and changing between my companys different license files is not a problem at all. So I'm thinking perhaps I need to order some specific granule to the customers license. Granule ID 2010 and 2120 is already included, but perhaps Microsoft SQL Server Runtime Edition granules must be included also. Granule ID 98010..98100 ??

PROBLEM SOLVED
I went into "FILE" --> "DATABASE" --> "CHANGE" --> "INTEGRATION" and checked away the "Save license to database"
Then I tried uploading the clients license and it work like a charm

bobnavision

To resolver per database license system, you have to alter the database setting through file -- database -- alter which was not possible earlier but with update1 it is.

MrWho

I just downloaded the price liste, and there is a granule id 2020 whith name Per Database License, who perhaps need to be bought if you have the "Save license in database" propertie checked?

kine

Exactly... ;-)

defiant701

Sorcerer wrote:

Hello there,

it may be that i've found a bug in the sql integration of navision 4.0 sp2

after you create a new database and you try to alter it the following error occurs:

"You cannot enter '2147483648 KB' in Integer. The cursor is in front of the invalid character."

Seems like microsoft has not tested their implementation of topic P1) from the changes list.

Hi there

Was the issue finally fixed? I have the same problem with several 4.0 SP2 versions (IN,GR,SG different instances) running on SQL 2005 Ent. Ed. SP1 and W2K3 R2 Ent. Ed. on a SAN. Was there any Hotfix from partnersource? I didn't find a suitable. ](*,) The answers to the topic were also a bit vague to me.

Regards

kine

If you are using SP2 + update, you can alter the database, you just needs to recalculate the value from KB to MB.

defiant701

kine wrote:

If you are using SP2 + update, you can alter the database, you just needs to recalculate the value from KB to MB.

Well. Sounds great, but which "update" exactly? Do you have the name(like Critical update for Microsoft Dynamics NAV 4.0 Service Pack 2 e.g.)? The bloody hell "Partnersource" is such a mess, you'll rather find a single grain of sand in the sahara than a correct solution. #-o

Regards

P.S. the Partnerguide was much better

kine

The rollup update which is on the SP2 download page on PS. (see the header of the download page...)

defiant701

kine wrote:

The rollup update which is on the SP2 download page on PS. (see the header of the download page...)

Yeah, that's it. Thank's for your help.

Then let's extrem altering \:D/