error while trying to expand the sql database in navision

sagarppadamati

Dear,

Can anybody tell me the reason for the error i am getting while trying to expand my sql database from navision.
Each time i click the Alter button it was showing the following error.
YOU CANNOT ENTER "2147483648 KB" IN INTEGER. THE CURSOR IS INFRONT OF THE INVALID CHARACTER.

I do thank in advance if anyone let me know the solution.

ara3n

When you click on alter NAV runs the following sql statement.

select 	name,  fileid, filename,
	filegroup = filegroup_name(groupid),
	'size' = convert(nvarchar(15), convert (bigint, size) * 8) + N' KB',
	'maxsize' = (case maxsize when -1 then N'Unlimited'
			else
			convert(nvarchar(15), convert (bigint, maxsize) * 8) + N' KB' end),
	'growth' = (case status & 0x100000 when 0x100000 then
		convert(nvarchar(15), growth) + N'%'
		else
		convert(nvarchar(15), convert (bigint, growth) * 8) + N' KB' end),
	'usage' = (case status & 0x40 when 0x40 then 'log only' else 'data only' end)
	from sysfiles
	order by fileid

run this query in SQL Server Management Studio (SMS) for your database and see which value is greater 2147483648 and fix that from SMS.

shjel

Why do you have to expand the size of your SQL database?

Normally this is done automatically.

FDickschat

For performance reasons you should not set the DB to autogrow. Just imagine that in a db of several 100GB the autogrow kicks in and wants to increase size by e.g. some GB. During that time no user can do anything.

kriki

And also to avoid fragmentation of the DB-file. A heavily fragmented DB-file (and also log-file) can hinder performance a lot!

David_Singleton

shjel wrote:

Why do you have to expand the size of your SQL database?

Normally this is done automatically.

[-X [-X [-X [-X [-X [-X [-X [-X [-X [-X [-X [-X [-X

Noooooooooooooooooo! Never do this Please. And especially never advise others to do this.

kine

sagarppadamati wrote:

Dear,

Can anybody tell me the reason for the error i am getting while trying to expand my sql database from navision.
Each time i click the Alter button it was showing the following error.
YOU CANNOT ENTER "2147483648 KB" IN INTEGER. THE CURSOR IS INFRONT OF THE INVALID CHARACTER.

I do thank in advance if anyone let me know the solution.

For me it looks like you are using NAV 4.00SP2 with SQL 2005/2008, am I right?

jpelaho

kine wrote:

sagarppadamati wrote:

Dear,

Can anybody tell me the reason for the error i am getting while trying to expand my sql database from navision.
Each time i click the Alter button it was showing the following error.
YOU CANNOT ENTER "2147483648 KB" IN INTEGER. THE CURSOR IS INFRONT OF THE INVALID CHARACTER.

I do thank in advance if anyone let me know the solution.

For me it looks like you are using NAV 4.00SP2 with SQL 2005/2008, am I right?

Hello,

I have the same problem when I want to set the lock timeout.

Can I simply update the locktimeoutperiod column of the "$ndo$dbproperty" table in the database ?

Thanks to all.